xDM template: unique constraint violation in ETL_PROCESSES table when trying to get many LoadID on the same process
X
Xavier Meunier
started a topic
almost 2 years ago
The 'Get LoadID' tool enables to get a load ID from the Semarchy xDM repository, which is useful (required, actually) to load data into Semarchy xDM data location.
But, you can only use this tool once in a execution session. Otherwise, you will get a duplicate error from the database where the LoadID is stored for the second execution of the tool in the same session.
This is because the LoadID is linked to the session ID, that is to the process being executed.
Best Answer
X
Xavier Meunier
said
almost 2 years ago
To be able to get many LoadID, you have to get each from another sub-process. Such sub-processes might be launched by an "Execute a Delivery" action.
This way, every LoadID will belong to different sessions, preventing duplicate value error from the database.
In the example below, both "Person_Data_Load" and "Person_Char_Lineage_Link_Load" load a LoadID, run a mapping and then proceed to a submit action.
Therefore, they have to be separated in deferent sessions, as done thanks to the ExecuteDelivery action.
1 Comment
X
Xavier Meunier
said
almost 2 years ago
Answer
To be able to get many LoadID, you have to get each from another sub-process. Such sub-processes might be launched by an "Execute a Delivery" action.
This way, every LoadID will belong to different sessions, preventing duplicate value error from the database.
In the example below, both "Person_Data_Load" and "Person_Char_Lineage_Link_Load" load a LoadID, run a mapping and then proceed to a submit action.
Therefore, they have to be separated in deferent sessions, as done thanks to the ExecuteDelivery action.
Xavier Meunier
The 'Get LoadID' tool enables to get a load ID from the Semarchy xDM repository, which is useful (required, actually) to load data into Semarchy xDM data location.
But, you can only use this tool once in a execution session. Otherwise, you will get a duplicate error from the database where the LoadID is stored for the second execution of the tool in the same session.
This is because the LoadID is linked to the session ID, that is to the process being executed.
To be able to get many LoadID, you have to get each from another sub-process. Such sub-processes might be launched by an "Execute a Delivery" action.
This way, every LoadID will belong to different sessions, preventing duplicate value error from the database.
In the example below, both "Person_Data_Load" and "Person_Char_Lineage_Link_Load" load a LoadID, run a mapping and then proceed to a submit action.
Therefore, they have to be separated in deferent sessions, as done thanks to the ExecuteDelivery action.
Xavier Meunier
To be able to get many LoadID, you have to get each from another sub-process. Such sub-processes might be launched by an "Execute a Delivery" action.
This way, every LoadID will belong to different sessions, preventing duplicate value error from the database.
In the example below, both "Person_Data_Load" and "Person_Char_Lineage_Link_Load" load a LoadID, run a mapping and then proceed to a submit action.
Therefore, they have to be separated in deferent sessions, as done thanks to the ExecuteDelivery action.
-
File external resolver with encrypted value
-
Timeout on Mapping/Webservice call
-
UNIQUE TEMP TABLE NAMES
-
Previous step name from a sub-process of execute delivery
-
Dropping multiple tables at once in XDI
-
Freeze Designer and corrupted workspace
-
FileWait/Move/Copy: FileInclude with space
-
Loop excel files
-
Change SVN user in the Designer
-
How to Specify the JVM used by the Designer?
See all 64 topics