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
V 11.5 Netezza TWT Issue
Moderators: chulett, rschirm, roy
1. Try to use User-defined SQL:
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.
Code: Select all
truncate table [[table]];
insert into [[table]] (col1, col2) select col1, col2 from [[twt]];
3. Insert Transformer stage between the source connector and the target connector.
Share the error message, you probably interpreted it incorrectly.