DSXchange

What is the datatype and lenght that you had given for desc_gesti?
Sometimes, datastage just tricks for Veiw data and allows to run the job.
Just try runnding the job and see, if you are getting the same error.
What is your current record delimiter?

Format both the input to the meet the SecondsSinceFromTimestamp() standards and subtract.

Did you try searching??

Try this.

viewtopic.php?t=128292&postdays=0&posto ... 11&start=0

Just a random pick.

Looks like the record delimiter is not set right. What is the record delimiter in the current file? Is that a normal Windows file? How did you transfer from one server to another? Any chances for the delimter to get changed? What is the data type of the last column? Try making the last field to Varc...

You never described your job desing.
Search for "Fault type is 11" you ll get similar issues been resolved.

Check if there is a space in your input string.
Hope know that you are trying to get the second part of your input string based on the delimiter as space.
Try the getting one number. Try using the double qoute.

Field(SRC_JOINING_DT," " ,2,1)

You can explore the User Variable activity in Job sequence too.

What is you job design.
Reset your job. And lookup for "from previous run..." in your log and post the same.

Check for the NLS settings. Refer your prevoius environment.
Is the column desc_gesti the last one?
If not, check for the value accross the column, might be bigger than the prescribed limit.

Or you can do this in single lookup stage and three lookup dataset.
Do lookup against all the three reference with the corresponding key.
With "Keep" option on Lookup failure.
And use transformer to find the lookup match in the order you need and do the business later.

Parameter specified but not used in flow: DSPXWorkingDir

Did you try setting up the PWD Environmental variable?
If now try settting to current project directory or '.'.
Is your compiler path set up right?

Though it will let you import, you will find dificulties in compiling and running the job. Since many stages and functionalies that are available in 8 are not in 7.5.

How about the answer to my other questioon?
Is this the first job thats been compiled in the environment?
Just to make sure, wheather the issue is with your code or with the environment.

Is this the first time you compiling this job in this environment? Does the other job compile without any issue?
Have you compiled this job in any other environment?

Hi,

Wont it be good to start a new topic for you new issue with proper title.