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?
Discussion posts and replies are publicly visible
Thanks Mike!
I got the issue in log file.
how did you solve it?
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.
Hello gayathris. How can i check the logs?
Logs can be found here:
Obviously there are a wide range of logs for different purposes. For the use case in this thread you're looking for the "stdOut" log, like this:
Thank you Stewart Burchell
Can you explain this a little bit? I have passed a CDT like this: = { { entity: cons!CSV_DATA, data: { pv!tmp_CsvData } }, { entity: cons!IMPORT_DOCUMENT, data: 'type!{urn:com:appian:types:RCP}Temp_ImportDocument'(ImportFk: pv!tmp_cdt_Import.id,DocIdNumber: pv!param_doc, fileExtension: document(pv!param_doc, "extension"), fileSize: document(pv!param_docu "size"), isActive: true(), createdBy: user(loggedInUser(), "firstName") & " " & user(loggedInUser(), "lastName"), createdOn: now(), modifiedOn: now() ) }}
What I am doing wrong on this? Also got this error in log file: "
com.appiancorp.process.runtime.activities.MultiWriteToDataStoreSmartService.writeToMultipleDataStoreEntities(MultiWriteToDataStoreSmartService.java:125)
"Please suggest