DSXchange

Hi ray.wurlod, thanks for your attention i have asked the teradata DBA. For teradata, there was no change. The only change is to move the DS server from one room to another room. ray.wurlod, do you mean that this error was related with teradata not datastage? thanks,I'll keep trailing. What's change...

In my job, I use teradata enterprise stage to append data to an exist table.it used to run successfully. but these days, it always aborted.

the prompt error:
TeraSync: waitOnState(1) timed out.
Cannot start the control daemon.

How to solve it?

thanks!

thank you, ray.wurlod and throbinson

Many thanks for your help！

i have searched for the sentence"....maximum of 256" in my teammate's computer. Maybe the client version i have installed is to low. i didn't find the information about the limitaion in my DS documentation.

hi ray.wurlod, thanks for your answer. our old method is throuth BTEQ. now we try to load data through TD enterprise stage.Thus,we can complete data transformation by DS not in Teradata. if we still want to use DS-tool to load data to Teradata,how to solve the probelm? To answer your final question,...

i met a problem:
when the number of a table's columns is more than 256,TD enterprise stage will throw out the error：

Teradata_Enterprise_3: Cannot create Teradata table more than 256 columns. Please check input schema

how to solve the problem?
is it a limit of the DS7.5?

Thank you!

JoshGeorge, i very appreciate your help :) i will test the job. my job just has one TD enterprise stage that load data to TD database in create mode. Thank U ! [quote="JoshGeorge"]Depends on the number of TD Enterprise stages you have in your job. So you can count the utility slot by count...

JoshGeorge,thanks for your answer. I know the fastload limit in Teradata Database. Now i want to know how many fastloads will be invoked when the TD enterprise is running. Thus,I can control the number of the job that is going to be invoked. by test, i find that when an ETL job is running, there are...

when i tested an ETL job, I got the error: ------------------- Cannot connect slave sessions Error(success check) Info = 0, Code = 2633, Message = Too many load/unload tasks running: try again later ---------------------------------- who tell me: how many fastloads will be invoked when an ETL job is...