Welcome Guest! Log in
×

Notice

The forum is in read only mode.
Due to some maintenance operations, stambia.org will be switched to read-only mode during the 13th November. It will be possible to read and download, but impossible to post on the forums or create new accounts. For any question please contact the support team.

Topic-icon Question Relation already exist

More
31 Oct 2016 17:27 #1 by MOUDEN_Kenza
MOUDEN_Kenza created the topic: Relation already exist
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
Cyril Dussud replied the 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
MOUDEN_Kenza replied the topic: Relation already exist
Thank you for your reply Cyril Dussud.