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.
Fatal Error: Pos arg exceeds numFields()-1: 30
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 60
- Joined: Tue Jul 12, 2005 3:34 am
Looks like you have an extra 30th column in your metadata within DataStage while your table only has 29 defined.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 60
- Joined: Tue Jul 12, 2005 3:34 am
Fatal Error: Pos arg exceeds numFields()-1: 30
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.
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.
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)
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>