I am trying to populate my load table form Oracle (source) using TPT. My TPT job is failing due to "TPT12106: Cannot restart !!! Please resubmit the job" and getting completed after dropping and recreating table.
TPT Log :
spin_OPERATOR: connecting sessions
The information provided is not enough to suggest. Please provide the following information:
* TPT Script
* Oracle ODBC driver used and its version.
* Sample data (if possible).
Please NOTE: This script does not fail at every run.
I mean in 4-5 consecutive runs it will fail once or twice .
Workaround : I recreate the table and it runs fine then again for few of the run and fails again.
This is not only with this particular script but i have more scripts behave in same way.
ODBC Driver Information : Datadirect drivers
LOG FILE :
Adding more to above question : How many TPT loads we can run in parallel?
Is there any attribute that is used to limit this ? or does it depend on utility slots ?
It looks like something is out of sync.
For some reason the ODBC operator thinks the job is a restart job.
Start from the beginning, but before you run tbuild, try running:
$ twbrmcp is _edw
(I used "is_edw" because that looks like the user id used for the job that had the error.)
Reason : Checkpoint files are getting created of same name for all jobs.
Need to use jobname -j option.