- tbuild-based warnings
- job script-based warnings
Unnecessary tbuild Command Option
Teradata PT returns a warning message when the tbuild -s option, normally used to start a job from an intermediate step, directs the job to start at the first step (where the job would start without the -s option). The message is issued in case you had not meant to start at step one.
Cause: Unnecessary tbuild command option
- Do not use tbuild -s unless you intend to start a job from an intermediate step.
- If the job was supposed to start at an intermediate step, and starting at step one was an accident, examine the job logs to see if starting at step one caused any problems.
Invalid Value for a tbuild Command Option
If the tbuild -h option specifies an invalid value for shared memory size, Teradata PT issues a warning identifying the size of shared memory it will actually use.
Cause: The tbuild command specified an invalid value for -h.
Corrective Action: For suggestions on how to correctly specify shared memory size the Teradata Tools and Utilities installation guide for your platform.
Truncated Data
If the values of source CHAR or VARCHAR columns can be truncated when applied to the corresponding target columns, Teradata PT returns a warning message for each such column.
Cause: Possible mismatched source and target schema definitions in the job script.
Corrective Action: If the truncation is not acceptable, examine and adjust the source and target schemas to eliminate the mismatch that caused the truncations. Normally this requires ensuring that the schema for the target column (maximum) length is at least as large as the schema for the source column (maximum) length.
Bad Source Data
The DataConnector operator may encounter bad data in the source file. If the RecordErrorFileName attribute (previously known as "RowErrFileName") specifies a file name, the bad data is sent to the file and the job allowed to proceed.
Cause: Bad Source data.
Corrective Action: Clean up the data and enter it manually in target table to complete the job.
Delete Task with More than One Row
This error depends on the following job scenario: The Update operator is set to delete data from the database, with the DeleteTask attribute is set to a Y[es] value, but the deletion is triggered by a WHERE clause in the DELETE statement that is incomplete without some external data. The source of this data must be a single row on the source data stream.
In this case, the Update operator is only looking for one row as the trigger. If it sees more than one row in the data stream, Teradata PT will issue a warning.
Cause: More than one row exists in the data stream.
Corrective Action: Check to see why the Producer operator is sending more than one row to the data stream, as it may result in a more serious problem in a later run of the job.
Paused Job
When the PauseAcq attribute for the Load or Update operator is set to a Yes value, the job is paused after the completion of the acquisition phase, that is, when all the data in the file has been read. This protocol is often used for scripts that empty a data file periodically, for instance, once a day. The warning is only a reminder that the job has paused. Re-launch the job again when the file contains more data.
Cause: User requested the job to pause after the completion of the acquisition phase.
Corrective Action: None.
Unsupported Query Band in Vantage
When a value is specified for the QueryBandSessInfo attribute, the job proceeds even if the Query Band feature is not supported.
- DDL
- Export
- Load
- SQL Inserter
- SQL Selector
- Stream
- Update
Cause: The database version does not support the Query Band feature.
Corrective Action: If you want to use the Query Band feature, change the TdpId attribute value to version of Vantage or Teradata Database that supports the Query Band feature.