DSXchange

Posted: **Wed Aug 17, 2016 12:44 pm**

Hi All,
Post upgrade from v11.3 to v11.5 parallel jobs that have an ODBC Connector as either a source or a target and that writes or reads using Netezza Connector stage have started failing due to TWT issues.

Log says it cannot find the intermediate table for the final insert into Netezza where Source is SQL Server and Target is Netezza

NZ connector is automatically creating, naming and then deleting these intermediate tables so there is no manual intervention

These same jobs that fail in DEV (v 11.5) run successfully on Prod (v 11.3, not yet upgraded)

Has any one seen similar issue or can provide some pointers?

We have already engaged IBM but is not going anywhere and it is already 4 week since opening a PMR

Thanks,
NV

Posted: **Thu Aug 18, 2016 1:27 pm**

1. Try to use User-defined SQL:

Code: Select all

truncate table [[table]];
insert into [[table]] (col1, col2) select col1, col2 from [[twt]];

2. Try to create a temporary table and use in existing mode:

3. Insert Transformer stage between the source connector and the target connector.

Share the error message, you probably interpreted it incorrectly.

DSXchange

V 11.5 Netezza TWT Issue

V 11.5 Netezza TWT Issue