DSXchange

kirankota79 wrote:3. Employee: When checking operator: When binding output interface field "USER_ID" to field "USER_ID": Implicit conversion; from source type "string[max=20]" to result type "string[max=19]": Possible truncation of variable length string

Thats your culprit right there.

THen what should be the length? Reimport the table definition again. And what unicode field do you want to get rid off? Need more information.

Your updating the key itself?
Your sending Code as the column and specifying it as a key. How will that work? What is it that your trying to do, can you lay it out for us in plain words.

WHat is the key? Is it USER_ID? IF yes then it is getting truncated as your error message indicates and no way it will be able to find the key to update if its getting truncated. Fix the length in the table and run your job again.

Is REQ_NOTES a nullable column? Try to send one record with some data in that column. See if the job hangs again. Just a shot in the dark. If that does not help either, then you can get in touch with support. Did you ask your dba what exactly the thread, originated by your id, is doing at the databa...

As sud already noted, stick to your design. Make the job multiple instance and send the table name as a parameter. Within the transformer use the instance name to filter the records and send the correct records for a particular table.

FTP stage really makes a person suffer. Go for a .bat or .cmd batch script that ftps the file over to your server. THen read it with sequential file stage.

-jobstatus is a perfectly valid option. I dont know why your getting 0 as return code. What does the job status show in the log? I dont know if they changed the return codes in version 8.x. You will have to dig it up in the manual. Make the job finish with warning and then make it abort. Check thei...

What is your target database? What is the scale and precision set for this field?
When you load with CurrentTimeStamp() and view data, what is the format you see?

Are you clear on what you want to do? THe filter command will execute a command on the file and the sysout will be read by the stage. Is that what your script is doing?
The script can sit anywhere as long as your id has execute permission to it. Provide the fully qualified path to it.

Lets wait for him to come back and clear our understanding.

Thats what I told him, yes it is possible. Just pass the dsjob command from the java module and it will fire the job off.

Been switching back and forth between server and px questions so much that this time the switch couldnt happen. For some reason I thought you were on px. Anywho, my bad. Get together with your dba, and ask him to monitor the number of connections that hit the database at a particular time. If your ...

Great. Time to mark it "Resolved".