DSXchange

Does your job happen to contain a lookup? I have seen this error before when a lookup maps a key column from the reference link to the output link instead of from the main input link. Check with IBM support to see if there is a patch.

You should report the problem to IBM support. That error is not normal. The connector should have reported the error code retrieved from error table 1. Look in error table 1 to see what rows could not be loaded and what their errors were. If error table 1 was dropped, try setting the connector's Cle...

Sounds like your source stage is using an NLS map of UTF-16, but your target stage is using a project default of ISO-8859-1. Your source stage is emitting a xFF0C character which apparently has no represenation in ISO-8859-1. Try setting the job NLS map to UTF-8, and set the Client character set in ...

In the case of the bulk access method (TPT), you don't need to worry about the warning. Although the TPT has a hard limit of 64260 on its internal buffer, realistically you don't need to worry about overflowing that buffer. The connector sends each row to the TPT individually, and the TPT will flush...

Hmm, sounds more like a memory leak to me. Running in parallel allowed you to work around the issue since the export is now distributed over more processes, so the memory leak did not exhaust each process's heap. You should still open a case with IBM and have the problem investigated.

The select list specifies what columns to load in the target table, not what columns to use from the input link. If you use a select list to specify a subset of target columns, you'd need to have defined the other columns with a DEFAULT clause. Specifying a select list does not imply the drop option...

Add the following entry to your /etc/hosts file:

x.x.x.x sdmcum sdmcumcop1

where x.x.x.x is the IP address of the host sdmcum.

If you're on Windows, you can find the hosts file here:

C:\WINDOWS\system32\drivers\etc

Be sure to add the entry with the cop1 suffix.

By default Teradata Enterprise assumes that you intended every input link column to get loaded into the target table. If there is a descrepancy between your input link columns and your target schema (whether you use the table option or select list), the default behavior is to abort. The whole purpos...

Yes, the Teradata Connector is a new stage that became available in 8.0.1 FP1. In combines the functionality of the other Teradata stages, but it does require the TPT. If you raise enough of a fuss with IBM, it's possible you could get an enhancement made to the Teradata Enterprise stage to support ...

Here's the description of error 3538 in the Teradata Messages manual. The problem is that you are trying to update the primary index which is not supported by MultiLoad. For future reference, you can find the Teradata Messages manual for each release here: http://www.info.teradata.com/DataWarehouse/...

That is normal behavior for Teradata Enterprise. You must specify the drop option if you have input link columns that are not to be loaded into the target table. When you use the replace option, the schema of the target table is determined by the input link columns and the schema of whatever table e...

Although DS 8.0.1 supports TTU 8.2, it is supported in upward compatibility only. That is, no support was added for new TTU 8.2 features such as BIGINT and large DECIMAL. It only means that compatibility testing was done to ensure that old jobs continue to work with TTU 8.2. Most stages will allow y...

Try setting the requestedsessions option to a smaller value. It defaults to the number of AMPs on your server, and the number of player processes is computed by requestedsessions divided by the sessionsperplayer. If you have a lot of AMPs, it results in too many player processes all competing to upd...

It appears that your UPDATE statement is trying to change the value of the primary key. Perhaps MultiLoad does not support such an operation?

I suggest you report the issue through your IBM support channel. Be sure to include the DDL of the table from which you are extracting.