Message Reference > T Message Codes > TPTWR Messages
  

TPTWR Messages

TPTWR_11001 Plug-in failed to create the TPTLogging class object.

Explanation:
The system does not have enough memory to allocate to the logging object.
User Response:
Make sure that there is enough memory on the machine where the PowerCenter Integration Service is running.

TPTWR_11002 Plug-in failed to convert Code Page to Unicode.

Explanation:
Internal error.
User Response:
Contact Informatica Global Customer Support.

TPTWR_11003 Plug-in failed to convert Unicode to Code Page.

Explanation:
Internal error.
User Response:
Contact Informatica Global Customer Support.

TPTWR_31101 Plug-in failed to retrieve Trace level from session.

Explanation:
Internal error.
User Response:
Contact Informatica Global Customer Support.

TPTWR_31201 Plug-in failed to set ILog logger.

Explanation:
The system does not have enough memory to allocate to the ILog logging object.
User Response:
Make sure that there is enough memory on the machine where the PowerCenter Integration Service is running.

TPTWR_31202 Plug-in failed to set TPTLogging logger.

Explanation:
The system does not have enough memory to allocate to the logging object.
User Response:
Make sure that there is enough memory on the machine where the PowerCenter Integration Service is running.

TPTWR_31203 Plug-in failed to set System Operator.

Explanation:
The system does not have enough memory to allocate to the System operator.
User Response:
Make sure that there is enough memory on the machine where the PowerCenter Integration Service is running.

TPTWR_31204 Plug-in failed to set TDPID.

Explanation:
The system does not have enough memory to allocate to the host name.
User Response:
Make sure that there is enough memory on the machine where the PowerCenter Integration Service is running.

TPTWR_31205 Plug-in failed to set User Name.

Explanation:
The system does not have enough memory to allocate to the user name.
User Response:
Make sure that there is enough memory on the machine where the PowerCenter Integration Service is running.

TPTWR_31206 Plug-in failed to set Password.

Explanation:
The system does not have enough memory to allocate to the password.
User Response:
Make sure that there is enough memory on the machine where the PowerCenter Integration Service is running.

TPTWR_31207 Plug-in failed to set Working Database.

Explanation:
The system does not have enough memory to allocate to the Working database.
User Response:
Make sure that there is enough memory on the machine where the PowerCenter Integration Service is running.

TPTWR_31208 Plug-in failed to set Table Name.

Explanation:
The system does not have enough memory to allocate to the table name.
User Response:
Make sure that there is enough memory on the machine where the PowerCenter Integration Service is running.

TPTWR_31209 Plug-in failed to set Error Database Name.

Explanation:
The system does not have enough memory to allocate to error database name.
User Response:
Make sure that there is enough memory on the machine where the PowerCenter Integration Service is running.

TPTWR_31210 Plug-in failed to set Error Table 1 Name.

Explanation:
The system does not have enough memory to allocate to Error Table 1 name.
User Response:
Make sure that there is enough memory on the machine where the PowerCenter Integration Service is running.

TPTWR_31211 Plug-in failed to set Error Table 2 Name.

Explanation:
The system does not have enough memory to allocate to Error Table 2 name.
User Response:
Make sure that there is enough memory on the machine where the PowerCenter Integration Service is running.

TPTWR_31212 Plug-in failed to set Log Database Name.

Explanation:
The system does not have enough memory to allocate to the log database name.
User Response:
Make sure that there is enough memory on the machine where the PowerCenter Integration Service is running.

TPTWR_31213 Plug-in failed to set Log Table Name.

Explanation:
The system does not have enough memory to allocate to the log table name.
User Response:
Make sure that there is enough memory on the machine where the PowerCenter Integration Service is running.

TPTWR_31214 Plug-in failed to set Insert DML Statement.

Explanation:
The system does not have enough memory to allocate to the INSERT statement.
User Response:
Make sure that there is enough memory on the machine where the PowerCenter Integration Service is running.

TPTWR_31215 Plug-in failed to set Update DML Statement.

Explanation:
The system does not have enough memory to allocate to the UPDATE statement.
User Response:
Make sure that there is enough memory on the machine where the PowerCenter Integration Service is running.

TPTWR_31216 Plug-in failed to set Delete DML Statement.

Explanation:
The system does not have enough memory to allocate to the delete DML statement.
User Response:
Make sure that there is enough memory on the machine where the PowerCenter Integration Service is running.

TPTWR_31217 Plug-in failed to set Truncate Table DML Statement.

Explanation:
The system does not have enough memory to allocate to the TRUNCATE TABLE statement.
User Response:
Make sure that there is enough memory on the machine where the PowerCenter Integration Service is running.

TPTWR_31218 Plug-in failed to create Teradata database connection object.

Explanation:
The system does not have enough memory to allocate to the Teradata Parallel Transporter connection object.
User Response:
Make sure that there is enough memory on the machine where the PowerCenter Integration Service is running.

TPTWR_31219 Plug-in failed to create Schema for Table <table_name>.

Explanation:
Schema defined in the mapping is incorrect.
User Response:
Validate or re-create the mapping. Verify that the column names, precision, and scale match the table definition.

TPTWR_31220 Plug-in failed to create DML Group <DML group name>.

Explanation:
The system does not have enough memory to allocate to the DML group.
User Response:
Make sure that there is enough memory on the machine where the PowerCenter Integration Service is running.

TPTWR_31221 Plug-in failed to Initiate Teradata database connection.

Explanation:
Initiate method of Teradata Parallel Transporter connection object failed.
User Response:
Check the error message returned by Teradata CLI or DBS.
Contact Informatica Global Customer Support.

TPTWR_31222 Plug-in failed to allocate memory to Connection object.

Explanation:
The system does not have enough memory to allocate to the connection object.
User Response:
Make sure that there is enough memory on the machine where the PowerCenter Integration Service is running.

TPTWR_31223 Plug-in failed to allocate memory to Schema object.

Explanation:
The system does not have enough memory to allocate to the schema object.
User Response:
Make sure that there is enough memory on the machine where the PowerCenter Integration Service is running.

TPTWR_31224 Plug-in failed to allocate memory to DML Group <DML group name>.

Explanation:
The system does not have enough memory to allocate to the DML group.
User Response:
Make sure that there is enough memory on the machine where the PowerCenter Integration Service is running.

TPTWR_31225 Plug-in failed to commit the Connection object.

Explanation:
The PowerCenter Integration Service cannot commit the connection object.
User Response:
Check the DBS/CLI error message for more information.

TPTWR_31226 Plug-in failed in End Acquisition.

Explanation:
The PowerCenter Integration Service failed in end acquisition.
User Response:
Check the DBS/CLI error message for more information.

TPTWR_31227 Plug-in failed to Apply rows.

Explanation:
The PowerCenter Integration Service cannot apply rows.
User Response:
Check the DBS/CLI error message for more information.

TPTWR_31228 Plug-in failed to set DML Group <DML group name> to connection object.

Explanation:
DML group built is invalid.
User Response:
Contact Informatica Global Customer Support.

TPTWR_31229 Plug-in failed to put row in Teradata database.

Explanation:
Sending row data request for insert, update, or delete to the Teradata database failed.
User Response:
Drop the error and log tables if they exist in database, and restart the session.

TPTWR_31230 Plug-in failed to put buffer in Teradata database.

Explanation:
Sending a buffer data for the insert operation to Teradata database failed.
User Response:
Drop the error and log tables if they exist in database, and restart the session.

TPTWR_31231 Plug-in failed to retrieve buffer layout for PutBuffer method.

Explanation:
Unable to get information about buffer size, row header, row length, and row trailer in LOAD system operator.
User Response:
Drop the error and log tables if they exist in database, and restart the session.

TPTWR_31232 Plug-in failed to retrieve affected rows.

Explanation:
Unable to get the number of affected rows and number of rejected rows from Teradata database.
User Response:
Drop the error and log tables if they exist in database, and restart the session.

TPTWR_31233 Truncate Table: Plug-in failed to create Teradata database connection object.

Explanation:
When there is no sufficient memory to allocate to the Teradata database connection object.
User Response:
Make sure that there is enough memory on the machine where the PowerCenter Integration Service is running.

TPTWR_31234 Truncate Table: Plug-in failed to create Schema for Table <table_name>.

Explanation:
Memory is not sufficient to allocate.
User Response:
Make sure that there is enough memory on the machine where the PowerCenter Integration Service is running.

TPTWR_31235 Truncate Table: Plug-in failed to create DML Group <DML_Group_name>.

Explanation:
Memory is not sufficient to allocate.
User Response:
Make sure that there is enough memory on the machine where the PowerCenter Integration Service is running.

TPTWR_31236 Truncate Table: Plug-in failed to Initiate Teradata database connection.

Explanation:
Unable to create a connection with Teradata database in Update drive for truncate table.
User Response:
Drop the error and log tables if they exist in database, and restart the session.

TPTWR_31237 Plug-in failed to set Update Recovery_Table DML Statement.

Explanation:
Internal error.
User Response:
Contact Informatica Global Customer Support.

TPTWR_31238 Plug-in failed to set Insert Recovery_Table DML Statement.

Explanation:
Internal error.
User Response:
Contact Informatica Global Customer Support.

TPTWR_31239 Plug-in failed to set Delete Recovery_Table DML Statement.

Explanation:
Internal error.
User Response:
Contact Informatica Global Customer Support.

TPTWR_31240 Unable to support multiple group.

Explanation:
Internal error.
User Response:
Contact Informatica Global Customer Support.

TPTWR_31301 Plug-in failed to initialize Teradata PT Writer Plug-in.

Explanation:
Writer plug-in initialization failed.
User Response:
Make sure that there is enough memory on the machine where the PowerCenter Integration Service is running.

TPTWR_31302 Plug-in failed to create Target Drivers.

Explanation:
The system does not have enough memory to allocate to the target drivers.
User Response:
Make sure that there is enough memory on the machine where the PowerCenter Integration Service is running.

TPTWR_31303 Plug-in failed to retrieve Target Instance.

Explanation:
Internal error.
User Response:
Contact Informatica Global Customer Support.

TPTWR_31304 Invalid Target Index <target_index>.

Explanation:
Internal error.
User Response:
Contact Informatica Global Customer Support.

TPTWR_31401 Plug-in failed to initialize Teradata PT Writer Target Driver.

Explanation:
Writer target driver initialization failed.
User Response:
Make sure that there is enough memory on the machine where the PowerCenter Integration Service is running.

TPTWR_31402 Plug-in failed to create Group Drivers.

Explanation:
The system does not have enough memory to allocate to the group drivers.
User Response:
Make sure that there is enough memory on the machine where the PowerCenter Integration Service is running.

TPTWR_31403 Plug-in failed to retrieve Group list.

Explanation:
Internal error.
User Response:
Contact Informatica Global Customer Support.

TPTWR_31404 Invalid Group Index <group index>.

Explanation:
Internal error.
User Response:
Contact Informatica Global Customer Support.

TPTWR_31501 Plug-in failed to initialize Teradata PT Writer Group Driver.

Explanation:
Writer Group driver initialization failed.
User Response:
Make sure that there is enough memory on the machine where the PowerCenter Integration Service is running.

TPTWR_31502 Plug-in failed to create Partition Drivers.

Explanation:
The system does not have enough memory to allocate to the partition drivers.
User Response:
Make sure that there is enough memory on the machine where the PowerCenter Integration Service is running.

TPTWR_31503 Invalid Partition Index <partition_index>.

Explanation:
Internal error.
User Response:
Contact Informatica Global Customer Support.

TPTWR_31601 Plug-in failed to initialize Teradata PT Writer Partition Driver.

Explanation:
Writer partition driver initialization failed.
User Response:
Validate the mapping, and then run the session again.

TPTWR_31602 Plug-in failed to retrieve Row statistics information.

Explanation:
Failure in Teradata PT API call.
User Response:
Contact Informatica Global Customer Support.

TPTWR_31603 Plug-in failed to retrieve Teradata Parallel Transporter connection and session level attributes.

Explanation:
Connection object has some invalid parameters.
User Response:
Check whether all attributes in the connection object are correct.

TPTWR_31604 Plug-in failed to retrieve table information.

Explanation:
Internal error.
User Response:
Contact Informatica Global Customer Support.

TPTWR_31605 Plug-in failed to build DML statements on table <table name> for system operator <system operator name>.

Explanation:
The system does not have enough memory to allocate to the DML statement.
User Response:
Make sure that there is enough memory on the machine where the PowerCenter Integration Service is running.

TPTWR_31606 Plug-in failed to build Truncate Table DML statement.

Explanation:
The system does not have enough memory to allocate to the Truncate Table DML statement.
The PowerCenter Integration Service cannot read target table information from vector.
User Response:
Make sure that there is enough memory on the machine where the PowerCenter Integration Service is running.

TPTWR_31607 Plug-in failed to build INSERT DML statement.

Explanation:
The system does not have enough memory to allocate to the Insert statement.
The PowerCenter Integration Service cannot read target table information from vector.
User Response:
Make sure that there is enough memory on the machine where the PowerCenter Integration Service is running.

TPTWR_31608 Plug-in failed to build UPDATE DML statement.

Explanation:
The system does not have enough memory to allocate to the Update DML statement.
The PowerCenter Integration Service cannot read target table information from vector.
User Response:
Make sure that there is enough memory on the machine where the PowerCenter Integration Service is running.

TPTWR_31609 Plug-in failed to build DELETE DML statement.

Explanation:
The system does not have enough memory to allocate to the Delete DML statement.
The PowerCenter Integration Service cannot read target table information from vector.
User Response:
Make sure that there is enough memory on the machine where the PowerCenter Integration Service is running.

TPTWR_31610 Primary Key is not defined for any of the fields of table <table_name>. Cannot build DELETE DML Statement.

Explanation:
Row type is deleted and no primary key is defines in the target table.
User Response:
Define a primary key in the target table and restart the session.

TPTWR_31611 Primary key is defined for all fields of table <table_name>. Cannot build UPDATE DML Statement.

Explanation:
The entire field in target table is primary key and no other column exists for update.
User Response:
Make sure you have at least one column for update.

TPTWR_31612 Primary Key is not defined for any of the fields of table <table_name>. Cannot build UPDATE DML Statement.

Explanation:
Row type is update and no primary key is defined in the target table.
User Response:
Define a primary key in the target table and restart the session.

TPTWR_31613 Plug-in failed to retrieve Truncate Table attribute.

Explanation:
Internal error.
User Response:
Contact Informatica Global Customer Support.

TPTWR_31614 Plug-in failed to retrieve Update Else Insert attribute.

Explanation:
Internal error.
User Response:
Contact Informatica Global Customer Support.

TPTWR_31615 Plug-in failed to retrieve connection reference associated with particular partition...

Explanation:
Internal error.
User Response:
Contact Informatica Global Customer Support.

TPTWR_31616 Plug-in failed to retrieve connection object associated with a connection reference...

Explanation:
Internal error.
User Response:
Contact Informatica Global Customer Support.

TPTWR_31617 Plug-in failed to retrieve Working Database.

Explanation:
Internal error.
User Response:
Contact Informatica Global Customer Support.

TPTWR_31618 Plug-in failed to retrieve TDPID.

Explanation:
Internal error.
User Response:
Contact Informatica Global Customer Support.

TPTWR_31619 Plug-in failed to Retrieve System Operator.

Explanation:
Internal error.
User Response:
Contact Informatica Global Customer Support.

TPTWR_31620 Plug-in failed to retrieve Log Table Name.

Explanation:
Internal error.
User Response:
Contact Informatica Global Customer Support.

TPTWR_31621 Plug-in failed to retrieve Log Database Name.

Explanation:
Internal error.
User Response:
Contact Informatica Global Customer Support.

TPTWR_31622 Plug-in failed to retrieve Error Database Name.

Explanation:
Internal error.
User Response:
Contact Informatica Global Customer Support.

TPTWR_31623 Plug-in failed to retrieve Error Table 1 Name.

Explanation:
Internal error.
User Response:
Contact Informatica Global Customer Support.

TPTWR_31624 Plug-in failed to retrieve Error Table 2 Name.

Explanation:
Internal error.
User Response:
Contact Informatica Global Customer Support.

TPTWR_31625 Plug-in failed to retrieve Max Sessions.

Explanation:
Internal error.
User Response:
Contact Informatica Global Customer Support.

TPTWR_31626 Plug-in failed to retrieve Tenacity.

Explanation:
Internal error.
User Response:
Contact Informatica Global Customer Support.

TPTWR_31627 Plug-in failed to retrieve Sleep.

Explanation:
Internal error.
User Response:
Contact Informatica Global Customer Support.

TPTWR_31628 Plug-in failed to retrieve Base Address for each field.

Explanation:
Internal error.
User Response:
Contact Informatica Global Customer Support.

TPTWR_31629 Plug-in failed to retrieve commit Teradata database connection object.

Explanation:
Teradata internal error.
User Response:
Contact Informatica Global Customer Support.

TPTWR_31630 Plug-in failed while Data Manipulation.

Explanation:
See the additional error message for more information.
User Response:
Contact Informatica Global Customer Support.

TPTWR_31631 Plug-in failed to allocate Memory.

Explanation:
The system does not have enough memory to allocate to an object.
User Response:
Make sure that there is enough memory on the machine where the PowerCenter Integration Service is running.

TPTWR_31632 Plug-in failed to retrieve data indicator.

Explanation:
Internal error.
User Response:
Contact Informatica Global Customer Support.

TPTWR_31633 Update Operation is not allowed for LOAD system operator.

Explanation:
As system operator is LOAD and row type is Update.
User Response:
Update operation is not allowed in LOAD system operator.

TPTWR_31634 Delete Operation is not allowed for LOAD system operator.

Explanation:
As system operator is LOAD and row type is Update.
User Response:
Delete operation is not allowed in LOAD system operator.

TPTWR_31635 Plug-in failed to truncate table.

Explanation:
The PowerCenter Integration Service cannot delete all rows of the target table.
User Response:
Review the session log and Teradata PT log tables for related messages. Drop the error and log tables, and restart the session.

TPTWR_31636 Number of Max Sessions must be greater than 0.

Explanation:
The Max Sessions attribute for a Teradata PT connection object is set to an illegal value.
User Response:
Update the Max Sessions attribute and then restart the session.

TPTWR_31637 Sleep must be greater than 0.

Explanation:
The Sleep attribute for a Teradata PT connection object is set to an illegal value.
User Response:
Update the Sleep attribute and then restart the session.

TPTWR_31638 TENACITY must be greater than or equal to 0.

Explanation:
The Tenacity attribute for a Teradata PT connection object is set to an illegal value.
User Response:
Update the Tenacity attribute and then restart the session.

TPTWR_31639 Block size must be greater than 0.

Explanation:
The Block Size attribute for a Teradata PT connection object is set to an illegal value.
User Response:
Update the Block Size attribute and then restart the session.

TPTWR_31640 Failed to register TPTRecStorageFactory, recovery will not be supported.

Explanation:
Internal error.
User Response:
Contact Informatica Global Customer Support.

TPTWR_31641 Failed to initiate TPTRecStorageFactory, recovery will not be supported.

Explanation:
Internal error.
User Response:
Contact Informatica Global Customer Support.

TPTWR_31642 Failed to initiate TPTConnectionManager.

Explanation:
An error occurred when the PowerCenter Integration Service tried to initiate the connection with Teradata PT. For example, the Teradata user name or password might be incorrect.
User Response:
Review the session log and Teradata PT log tables for related messages.

TPTWR_34701 Failed to initialize TPTWriterConnection.

Explanation:
An error occurred when the PowerCenter Integration Service tried to initialize the connection with the Teradata PT writer. For example, a network problem might have occurred during initialization.
User Response:
Review the session log and Teradata PT log tables for related messages.

TPTWR_34702 Failed to deinitialize TPTConnectionManager.

Explanation:
An error occurred when the PowerCenter Integration Service tried to deinitialize the connection with the Teradata PT writer. For example, a network problem might have occurred during deinitialization.
User Response:
Review the session log and Teradata PT log tables for related messages.

TPTWR_34703 Failed to commit for target <name> and partition <number>.

Explanation:
An error occurred when Teradata PT tried to issue a commit against the Teradata database. For example, a connection might have been dropped due to a network problem or fatal database error.
User Response:
Review the session log and Teradata PT log tables for related connection errors.

TPTWR_34704 Rollback is not supported for Teradata Parallel Transporter writer.

Explanation:
The Teradata framework requested a rollback for a failed transaction, but Teradata PT does not support rollback for failed transactions.
User Response:
Review the session log and Teradata PT log tables to find the failed transaction. Check the target tables for data discrepancies.

TPTWR_34723 Initialization of TPT connection for reading recovery information failed.

Explanation:
An error occurred when the PowerCenter Integration Service tried to initialize the connection with Teradata PT for reading recovery information.
User Response:
Review the session log and Teradata PT log tables for related connection errors.

TPTWR_34725 Termination of TPT connection for reading recovery information failed.

Explanation:
An error occurred when the PowerCenter Integration Service tried to terminate the connection with Teradata PT for reading recovery information.
User Response:
Review the session log and Teradata PT log tables for related connection errors.

TPTWR_34727 Initialization of TPT connection for deleting recovery information failed.

Explanation:
An error occurred when the PowerCenter Integration Service tried to initialize the connection with Teradata PT for deleting recovery information.
User Response:
Review the session log and Teradata PT log tables for related connection errors.

TPTWR_34729 Termination of TPT connection for deleting recovery information failed.

Explanation:
An error occurred when the PowerCenter Integration Service tried to terminate the connection with Teradata PT for deleting recovery information.
User Response:
Review the session log and Teradata PT log tables for related connection errors.

TPTWR_34730 Selection of DML statement failed in connection for deleting recovery information.

Explanation:
A connection error occurred when the PowerCenter Integration Service tried to delete recovery information.
User Response:
Review the session log and Teradata PT log tables for related connection errors.

TPTWR_34731 Acquisition failed in connection for deleting recovery information.

Explanation:
A connection error occurred when the PowerCenter Integration Service tried to delete recovery information.
User Response:
Review the session log and Teradata PT log tables for related connection errors.

TPTWR_34732 PutRow call failed in connection for deleting recovery information.

Explanation:
A connection error occurred when the PowerCenter Integration Service tried to delete recovery information.
User Response:
Review the session log and Teradata PT log tables for related connection errors.

TPTWR_35001 ODBC Connection failed to create INFARecoveryTable.

Explanation:
The target ODBC connection could not create the recovery table in the Teradata target database due to a connection error.
User Response:
Review the session log for related connection errors.

TPTWR_35002 ODBC Connection failed to truncate target table <name> in load mode.

Explanation:
The target ODBC connection could not truncate the target table due to an error.
User Response:
Review the session log for related messages.

TPTWR_35003 ODBC Connection failed to drop error table.

Explanation:
The target ODBC connection could not drop the error table due to an error.
User Response:
Review the session log for related messages.

TPTWR_35004 ODBC Connection failed to drop log table.

Explanation:
The target ODBC connection could not drop the log table due to an error.
User Response:
Review the session log for related messages.

TPTWR_35061 The following system error occurred when the PowerCenter Integration Service tried to get the values of some session attributes: <error message>.

Explanation:
The PowerCenter Integration Service could not get the values of some session-level properties. A system error might have occurred or the repository might have inconsistencies.
User Response:
Fix the operating system error. Contact Informatica Global Customer Support.

TPTWR_36001 Connectivity license key for Teradata database is not valid.

Explanation:
The license key in the Administrator tool is invalid or does not contain Teradata PT connectivity option.
User Response:
Contact Informatica Global Customer Support to get a valid license key.

TPTWR_36002 The session uses a deprecated connection object. Replace it with a valid connection object.

Explanation:
The session uses a connection object of type “Teradata Parallel Transporter Connection,” which is deprecated.
User Response:
Replace the deprecated connection object with a connection object of type “Teradata PT Connection.”