topic Fail to Add Feature in ArcGIS REST APIs and Services Questions

Fail to Add Feature

Muhammad_SaqibChaudhry — Sat, 11 Dec 2021 20:21:56 GMT

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.

Re: Fail to Add Feature

RamunasKraujutis — Tue, 06 Feb 2018 15:08:01 GMT

Adjust table structure and register it with the geodatabase.

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

Re: Fail to Add Feature

Muhammad_SaqibChaudhry — Wed, 07 Feb 2018 08:13:08 GMT

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?