Error pstmt_tDBOutput_1 cannot be resolved

[Anonymous]

Hi,

I'm trying to migrate data from SQL to PostgreSQL using Talend Open Studio 7.0.1

I created the empty tables at the destination.

Instead creating static components I created a metadata table with "list of tables" to be migrated from source to destination. The table also contains source table name and destination table name.

I used 'tFlowToIterate' to fetch source and destination table names to global variables and next used these global variable names in the 'tDBInput' and 'tDBOutput' but throws the below generic error and could not understand the issue.

However, it works when I try to hardcode the table names without using global variable but fails when using global variables.

Am I missing any step here?

Error:

Error in the component's propertiesstmt_tDBOutput_1 cannot be resolved
pstmt_tDBOutput_1 cannot be resolved
pstmt_tDBOutput_1 cannot be resolved
pstmt_tDBOutput_1 cannot be resolved to a variable
pstmt_tDBOutput_1 cannot be resolved
pstmt_tDBOutput_1 cannot be resolved to a variable
pstmt_tDBOutput_1 cannot be resolved

[fdenis]

add tLog to check the query result.

[Anonymous]

Job shows '1 rows in 0.01s' and succeeded but the console has no result set.

[statistics] connecting to socket on port 3952
[statistics] connected

[statistics] disconnected

Job dataobjects ended at 10:39 18/09/2018. [exit code=0]

[fdenis]

"Select concat(('Insert into Table1 (field1,field2) values (',sid,',''',studentname,''')') from students"

in mssql db must contain a table named students within atleast 2 fields sid and studentname.
result of the query mus be like:
Insert into Table1 (field1,field2) values (0001,'Francois Denis')
destination db must contain a table named Table1 within 2 fields field2 and field2.

[Anonymous]

Yes, source and destination tables exist but the nothing is being shown in the tLogRow.
Source table has almost 3000 records and destination table is empty.

The query is correct because if I change the column name it fails hence I guess there is some configuration missing which is not retrieving the data.

[fdenis]

run the query into tMssqlInput

[Anonymous]

There is some progress.

The job shows 1302 records fetched but the console printed blank lines of 1302 i.e. without data.
To be sure, I just reconfirmed that there is data in table but not being fetched to tLogRow.

[fdenis]

did you add column type String on output row?

[Anonymous]

I did not add explicitly and upon checking, I see row1 has no columns.

[fdenis]

add column type String

[Anonymous]

Hi,

My apologies for the late response, I was on leave and not accessing the work environment.

It is working as expected and now I see 'tLogRow' shows all the insert queries.
Now, I tried to replace the 'tLogRow' with 'tDBRow' which is connected to destination database, so that the data will be inserted at destination.
But I see the below error when executing the job.
Error in the component's propertiesyntax error on token ";", delete this token

Am I missing any step?