DSXchange

Are you able to login to Designer and see the jobs?

Do have a look at this page and let us know if it resolves the error.

Well, I asked you to check -lprojects with long syntax, does it list the projects?

Now please try

"dsjob -ljobs projectname"

and make sure you are added to requierd data stage groups.


Also try

dsjob -domain domainname:port -server servername:31538 -user youruser -password yourpassword -lprojects

First of all, remove those sever details from your post.

All the ports and all looks like default. Did you just try running "dsjob -lprojets" ?

Its normal to have this warning when the job abended and could not perform necessary clean-up. It should come in the subsequent run after the abort. And yes it can be safely demoted to informational message as the message id is different for each type of warning and error in data stage however do a ...

Seems its already late but if its solved please post the answer for future searchers.

Are you getting any warning? does your NLS map matches the one in teradata and the source?

PS:
Unicode is not UTF-8.
8859-P1 is US ASCII

A few questions first,

Is it the complete derivation?
does it fail even if you do null handling properly?

I would atleast use len(svZoneId) as a derivation for length though.

yes, available for parallel jobs only.

Sad to hear that. Rest in peace MamuKim.

i think I have processed a bigger file than that, but not sure if there is a limit to it. Definitely a questions for support.

Welcome Aboard, There are many things which should be taken in consideration for server sizing. Such as data volumes to be processed which you have mentioned but at the same time you may need if there is any SLA attached to the processing such as it should finish in 2 hrs? Also the complexity of rul...

with limited information you have provided, i think if fullPath is a parameter, you are passing that incorrectly.

well, I haven't heard If or Index function getting phased out, so I believe it should work in 11.3 as well. You may need to check you syntax if it isn't working for you.

I have been told by support earlier that the hostname should not be changed as it is used at so many places inside the server. IBM support may be able to do it but not so sure unless their engineering dept gets involved. Be ready for a long waits in responses though.