Welcome Guest! Log in
×

Notice

The forum is in read only mode.
The Stambia User Community is moving to Semarchy! All the applicable resources have already been moved or are currently being moved to their new location. Read more…

Topic-icon Question Relation already exist

More
31 Oct 2016 17:27 #1 by MOUDEN_Kenza
Relation already exist was created by MOUDEN_Kenza
Hi,
I put a process in Stambia analytics and it gave me the error below, the things I didn't understood are :

* sometimes it works well without any error
* sometimes it works but after I delete the table 'I_eb_tracking_files_tni'
* most of the times it blocks and didn't work

The same goes for stambia designer.
Attachments:
More
31 Oct 2016 17:55 #2 by Cyril Dussud
Replied by Cyril Dussud on topic Relation already exist
Hi,

Can you check if any other Mapping using the same target table is executed at the same time?
It might me related to a conflict between several treatments using the same temporary objects (the pre-integration table I_...) in parallel.
If it is the case, you can parameterize the name of the temporary object in your Metadata to use the session id, for instance, to prevent any conflict.

The following article explains how to do it:
stambia.org/doc/77-development-hints-and...-of-temporary-tables
More
02 Nov 2016 10:21 #3 by MOUDEN_Kenza
Replied by MOUDEN_Kenza on topic Relation already exist
Thank you for your reply Cyril Dussud.