I'm trying to insert rows into a labkey list named DASChemaObject and the schema is in the attachment, which are exactly the same as what I populated here. I kept getting api exception saying that the "org.labkey.remoteapi.CommandException: The existing row was not found." while the list is empty(attachment).
Annotation Logs:
2017-06-01 17:15:58 [OK] Processing file: SDD-2016-36.csv
2017-06-01 17:15:58 The first Row is {a=hasco:DASchemaObject, hasURI=chear-kb:DASO-dehp-1-2016-36, hasco:isPIConfirmed=false, hasco:hasRole=, sio:inRelationTo=chear-kb:DASO-mehp-1-2016-36, hasco:hasEntity=chear:DEHP, hasco:partOfSchema=chear-kb:DAS-SDD-2016-36, sio:Relation=sio:hasPart, hasco:isVirtual=true}
2017-06-01 17:15:59 [ERROR] CommitRows inside AutoAnnotator: org.labkey.remoteapi.CommandException: The existing row was not found.
Please help! Going crazy.
Thanks |
| |
| Jon (LabKey DevOps) responded: |
2017-06-02 14:03 |
Hello,
Is it possible for you to send us an export of the list archive for that one list and the sample CSV file you're using so we can properly reproduce the issue on our end?
I'm trying to construct the list myself, but I can't tell what you have listed as the Primary Key for your list. What field are you using as the Primary Key?
Also, can I assume you're using the UI to upload the data or are you using something else, like an API call?
Regards,
Jon |
| |
|
|
DASchemaObj-20170601172207.png