DataStage Job 2270 Phantom 17275

nitin376 · Post by **nitin376** » Thu Oct 05, 2006 2:13 pm

Hi,
I got a new type of error , don't have any idea what it means. Please explain me how to resolve this isuue

Error details

main_program: Fatal Error: Pos arg exceeds numFields()-1: 3

DataStage Job 2270 Phantom 17275

The job aborts. Explain me please....

thanks,

Nitin

us1aslam1us · Post by **us1aslam1us** » Thu Oct 05, 2006 2:26 pm

Please post the more details and complete log. Seems to be the pos field exceeding its size.

Sam

kris007 · Post by **kris007** » Thu Oct 05, 2006 2:27 pm

Without giving a brief description of what you are doing in the job, it's always hard to give any suggestions. From your error message it looks like you have an extra column in one of your stages. Are you dealing with any database tables? If so, are you using any user-defined sql? Check the metadata within the stages. There might be a mismatch in the number of columns.

thumsup9 · Post by **thumsup9** » Thu Oct 05, 2006 2:35 pm

somewhere you are carrying addional columns either in Datastage or the target SQL code..

ray.wurlod · Post by **ray.wurlod** » Thu Oct 05, 2006 2:39 pm

"Pos arg" = "positional argument"

The message is telling you that some function you are using has more positional arguments than can be filled from your row, because there are fewer fields in your record schema than the number of arguments.

Now you have to do some detective work to figure out where this is occurring, and fix it.