TWT relation does not exist
Posted: Fri Dec 15, 2017 9:47 am
Hi everyone,
We seem to have intermittent issues with jobs that write to our netezza using the standard netezza connector. The error looks something like the following:
ERROR: relation does not exist DATABASE.SCHEMA.NZCC_TT_20171215013049186962_4280_DESTINATION_TABLE_NAME (CC_NZAdapter::postRun, file CC_NZAdapter.cpp, line 336)
If I use the now deprecated netezza enterprise connector I don't typically see this error (I may have seen it once... or I was dreaming... not sure). Our jobs are all set to use Automatic as the TWT mode, and we do not use a separate connection for TWT. Does anyone have any ideas on this? Would using a separate connection for TWT benefit the process at all?
We seem to have intermittent issues with jobs that write to our netezza using the standard netezza connector. The error looks something like the following:
ERROR: relation does not exist DATABASE.SCHEMA.NZCC_TT_20171215013049186962_4280_DESTINATION_TABLE_NAME (CC_NZAdapter::postRun, file CC_NZAdapter.cpp, line 336)
If I use the now deprecated netezza enterprise connector I don't typically see this error (I may have seen it once... or I was dreaming... not sure). Our jobs are all set to use Automatic as the TWT mode, and we do not use a separate connection for TWT. Does anyone have any ideas on this? Would using a separate connection for TWT benefit the process at all?