Fail to Add Feature

1254
2
02-04-2018 11:52 PM
Muhammad_SaqibChaudhry
New Contributor

I am trying to add feature into feature table using REST API call but facing the following error, both from online interface as well as Postman client.

{  "error": {   "code": 400,   "message": "Unable to complete operation.",   "details": [    "Rowbuffer creation failed."   ]  } }

My table structure is as following:
CREATE TABLE [dbo].[Table_1](
 [Col_1] [int] IDENTITY(1,1) NOT NULL,
 [Col_2] [varchar](255) NOT NULL,
 [Col_3] [geometry] NOT NULL,
 [Col_4] [varchar](255) NULL,
 [Col_5] [varchar](255) NOT NULL,
 [Col_6] [varchar](255) NOT NULL,
 [Col_7] [varchar](255) NULL,
 [Col_8] [int] NULL,
PRIMARY KEY CLUSTERED 
(
 [Col_1] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY],
 CONSTRAINT [UK_1] UNIQUE NONCLUSTERED 
(
 [Col_2] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

ALTER TABLE [dbo].[Table_1] WITH CHECK ADD CONSTRAINT [FK1] FOREIGN KEY([Col_8])
REFERENCES [dbo].[Table_2] ([Col_1])
GO

ALTER TABLE [dbo].[Table_1] CHECK CONSTRAINT [FK1]
GO

I am attaching snapshot of online interface as well as Postman.
0 Kudos
2 Replies
RamunasKraujutis
New Contributor III

Adjust table structure and register it with the geodatabase.

See Register a table or view with the geodatabase—ArcGIS Help | ArcGIS Desktop 

Muhammad_SaqibChaudhry
New Contributor

I have figure out the problem. The issue is when we send the "addfeature" request to ArchGIS, its first create the dummy row and then update the values.

In my case one of my column has unique index so its not possible to insert two rows with empty data. So this is the issue when ArchGIS try to insert dummy row with empty value, it throws the Row creation buffer failed error.

Can someone explains me the this behavior of ArchGIS? 

0 Kudos