multiload error

[nani1974]

Hi,
My source is seqel server and target is teradata,i am connecting sequel server through ODBC and doing some small transformations and loading it into teradata multiload this is simple job i am getting these errors when i run the job.....can anyone please help me out from this..

ODBC_PROCESS: When checking operator: When binding output interface field "CSR_ID" to field "CSR_ID": Implicit conversion from
source type "decimal[19,0]" to result type "int64": Possible range limitation.
TDM,0: Info: TEST1.TDM: MultiLoad process 15868 has started
TDM,0: Failure during execution of operator logic.
TDM,0: Input 0 consumed 0 records.
TDM,0: Fatal Error: Fatal: Unable to start MultiLoad process : MultiLoad failed:
Check MultiLoad report /apps/opt/aedw/staging1/X5C/CSR_SUP_RPT for details
node_dreamG1: Player 2 terminated unexpectedly.
TRANSFORM,0: Failure during execution of operator logic
TRANSFORM,0: Input 0 consumed 624 records.
main_program: Unexpected exit status 1
TRANSFORM,0: Fatal Error: Unable to allocate communication resources
TRANSFORM,1: Failure during execution of operator logic.
main_program: Unexpected exit status 1
Unexpected exit status 1
Unexpected exit status 1
Unexpected exit status 1
main_program: Step execution finished with status = FAILED.

Thanks in advance
Kumar

[chulett]

Help us out here - is this your first attempt at a multiload target, i.e. you've never tried to make it work before? Or you've done this thousands of times already and is it just this one that you are having a problem with? Did you check the "MultiLoad Report" as it noted you should do?

[nani1974]

Hi,
To be frank,this is first time i am using multi load,we used enterprise satge but multi load is first time,so can you please give me some suggestions about the error....it will be helpfull for me...

Thanks
Kumar

[nani1974]

Hi,
I had gone through multi load report, it looks fine to me...

Thanks
Naveen.

[chulett]

Perhaps you should post it and let others who know Teradata and multiload take a look and see if it looks fine or not? Unfortunately, that's not me, I am just trying to help you with your problem solving.

You also have another issue that you should resolve as well. I don't believe that is related to your primary concern, more than likely it's just an additional issue. An exact search for "possible range limitation" or "implicit conversion from source type" should turn up the other conversations and solutions for that particular issue that are here. Oddly enough, you're not the first person to see that particular message.