Customized file/Alteryx loader

[RafaelZincke]

Hi,

I am building a customized loader that reads in workflows from the shared drive and loads these to connect. In the last step when I push the data to connect, I receive the following error:

"Caused by: Unique index or primary key violation: "STD_XFORMS.PRIMARY_KEY_35 ON STD_XFORMS.AYX_WF(WORKFLOW_ID) VALUES 11273"; SQL statement:
insert into AYX_WF(LOAD_CODE,WORKFLOW_ID,WORKFLOW_NAME,STUDIO,OWNER_ID,OWNER_NAME,WORKFLOW_TYPE,DATE_UPLOADED,NUMBER_OF_RUNS,PUBLISHED_VERSION_ID,PUBLISHED_VERSION_NUMBER,COLLECTION,URL) values (?,?,?,?,?,?,?,?,?,?,?,?,?) [23505-200]"

Apparently, one of ten test entries was able to write to AYX_WF but I do not see why?

Any help is appreciated.

Best regards,

Rafael

[PetrH · Accepted solution]

Hi Rafael,

the primary key violation message means that you are inserting duplicate data somewhere where its not wanted.
On table AYX_WF there is just WF_ID as primary key. 

So it means that you are inserting duplicate workfliw to the stage table.

You need to avoid a duplicate, or maintain the cleaning of stage tables (based on LOAD_CODE)same way as the loaders does. 

Hope its helpful.

Petr

[RafaelZincke]

Thank you Petr!