An error occurred while trying to write to the data store. No values have been written. Details: could not insert: (APNX-1-4208-004)

Question

The "write to datastore entity" is failing in below scenario. 
 
 The table in which I am inserting data has more than 50 columns and two of its columns are BLOB field. 
 
 When I am inserting 40 rows , I am not getting error. 
 However, on inserting more than that the "write to datastore entity" is failing giving error: An error occurred while trying to write to the data store. No values have been written. Details: could not insert: (APNX-1-4208-004) 
 
 Please suggest me what could be the root cause for this and solution which I am thinking of is to insert data in batches. 
 Is there any such limit on data which gets inserted?

Mike Schmitt · Accepted Answer

I believe you will find more detail (including the specific column(s) that are failing to insert and usually the reason why) in the Appian System Logs , specifically tomcat-stdout.log .

gayathris0003 · Answer

https://docs.appian.com/suite/help/21.3/Logging.html For Cloud Appian installation, once you reproduced the error immediately look for the file with name of today's date tomcat-stdOut.log.2021-09-08 in https://environment/suite/logs .

gayathris0003 · Answer

In my experience so far I've had this issue come up when we try to write the empty cdt in write to DB .It can be solved by passing not null cdt to write to DB. Also as suggested please look for log for more details, I know this doesn't assist much, but it's a place to start.

An error occurred while trying to write to the data store. No values have been written. Details: could not insert: (APNX-1-4208-004)

Top Replies