Problems sometimes arise when attempting to connect to a Teradata database. This is almost always due to a misconfiguration in the user’s environment.
The following suggestions can often help detect and overcome such problems.
- If given the wrong schema to write to an existing table, the TPT API will fail to initialize the connection and put the target table in a waiting state. To resume, the right schema needs to be specified and the database lock released, or the table needs to be dropped.
- When writing to a table, the TPT API and FME will create working tables (<table>_WT, <table>_ET, <table>_UV, <table>_log#) to perform the load operation. These tables will be cleared at the end of the operation, unless it is interrupted for some reason. In this case, FME will be able to recover from the error by dropping the table.