Task order in Database Transporter

I would like to import synchronization project but before that I have to run SQL statements. I've created transport with Run SQL statement before data import and Transport synchronization projects but during test I found that sql statement which should be executed at the beginning are not. First is imported sync project and after that SQL statements are executed.

I'm using OneIM 9.1.1

My question: is it correct behavior?

0 Markus Weiss-Ehlers 6 months ago

Did you add the PreSQL in the system part or the user part? The system part should be run before the shell import.
Cancel
Up 0 Down

Reply

Verify Answer

Cancel
0 Marek L 6 months ago in reply to Markus Weiss-Ehlers

I have added it to the system part
Cancel
Up 0 Down

Reply

Verify Answer

Cancel
0 Markus Weiss-Ehlers 6 months ago in reply to Marek L

I suggest contacting support then.
Cancel
Up 0 Down

Reply

Verify Answer

Cancel
0 Marek L 6 months ago in reply to Markus Weiss-Ehlers

OK, finally I got it and found where exactly is the problem.

Will create support ticket and some explanation for others.

When creating transport from template file from GUI Transporter order of the tasks (SQL, Sync, Object) is correct - checked in Transport.xml inside of zip file.

But transport created from template file from DBTransporterCmd.exe has wrong order - checked in Transport.xml inside of zip file.

And thus during import - tasks are processed in the order how they are in the Transport.xml inside of zip transport file.
Cancel
Up 0 Down

Reply

Verify Answer

Cancel