Fatal Error: Pos arg exceeds numFields()-1: 30

khanparwaz · Post by **khanparwaz** » Wed Mar 08, 2006 6:09 am

Hi,

I have one parallel job which loads data into oracle table from a dataset using sql loader.
This job is failing and the error I am getting is "Fatal Error: Pos arg exceeds numFields()-1: 30".

Anyone knows what can be the reason.
Please help.
Thanks in advance.

ArndW · Post by **ArndW** » Wed Mar 08, 2006 7:43 am

Looks like you have an extra 30th column in your metadata within DataStage while your table only has 29 defined.

khanparwaz · Post by **khanparwaz** » Thu Mar 09, 2006 12:01 am

Thanks ArndW.

There is a mismatch between number of columns. But the number of columns are more in the target table. The source file has less number of columns.
Can this also create problem in case of Sql Loader ?

PLease help.
Thanks in advance.

ArndW · Post by **ArndW** » Thu Mar 09, 2006 1:49 am

The issue is not the number of columns in the table, but a mismatch in your Oracle stage between the number of columns you have defined and then number of columns the generated SQL statement is trying use. This can happen when you define your own SQL (and perhaps later on add a column, forgetting to change the command)