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

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

Parents Reply
  • 0
    Certified Senior Developer
    in reply to gayathris0003

    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

Children
No Data