DB Migration: Last table data is blank (Output DB)

[Anonymous]

Hi,

Using the following job and settings, I was able to dynamically migrate a whole database from MSSQL to MySQL.

However, I noticed that the last table's data is blank (only the table structure and column is migrated).

Please refer to the screenshots and attached job file below.

**The table and its schema is migrated, but no data inside the table. // I'm using a dynamic schema.

Job Design and DBInput

dbinput

DBOutput

DBOutput

When I tried to logged each component, I found that the last table's data is loaded and pass on from tDBInput to tMap and also from tMap to tDBOutput, as the last table's data showed up in the log.

However, when I check the actual output database, only the last table contains no data at all.

Output DB's 1st Table - Have data

2nd (last) table - No Data

==============================================================

[manodwhb]

For the last table, is there any error from log?

[Anonymous]

@manodwhb
do you mean the whole run log??
If yes, only the tables' data are printed (both).

[manodwhb]

What has printed for the last table?

[Anonymous]

@manodwhb 

This is the log for the job run...

and here is single table job run.

the table data is logged here, however, no data is imported to the database. (only schema and column headings)

[manodwhb]

As per the log there is no error right and even it has printed to console that last table data right? If yes it bit confusing. Can you try to run the had last table hard-coded one for testing to see that why it is not inserting data?

[Anonymous]

@manodwhb 

yes, there is no error in the console.
can you elaborate more about 'hard-coded one'?

Here I tried to do a debug run

and somehow nothing shows up in row5?

can you tried importing this job? please check the attached file.

Migration_DB_Parent_Job.zip

[Anonymous · Accepted solution]

@manodwhb 

I figured out the reason why the last table data is not inserted.

Now that I change tDBOutput_1's setting,, from use existing connection (tDBConnection_2) to manual setup in tDBOutput and it work now.

Do you happened to know why? Does it have something to do with the trigger 'OnComponentOK'?

dbinput

[manodwhb]

one thing could be it might rollback? But not sure how it could have triggered.

[manodwhb]

use the on component trigger from tdboutput.