ODBC error
Moderators: chulett, rschirm, roy
ODBC error
ODBC_Connector_73,0: Fatal Error: Attempt to setIsNull() on the accessor interfacing to non-nullable field "unique_row_id"
The job was fine with input and output suddenly when I tried to run it again
I had this error,can anyone suggest me about this error?
The job was fine with input and output suddenly when I tried to run it again
I had this error,can anyone suggest me about this error?
Thanks,
Surya
Surya
-
- Participant
- Posts: 46
- Joined: Tue Jul 20, 2010 1:26 pm
- Location: USA
- Contact:
Re: ODBC error
Check the input table for the ODBC stage if any data has been updated in the second run.
If not please provide me with the stages you are using and also where ISNull() function is used.
If not please provide me with the stages you are using and also where ISNull() function is used.
Abhijit
IBM Certified Solution Developer Infosphere DataStage
IBM Certified Solution Developer Infosphere DataStage
-
- Premium Member
- Posts: 457
- Joined: Tue Sep 25, 2007 4:05 pm
-
- Participant
- Posts: 46
- Joined: Tue Jul 20, 2010 1:26 pm
- Location: USA
- Contact:
Re: ODBC error
In transformer use the derivation as......
If IsNull(%inputcol%) Then SetNull(%inputcol%) Else ''
If IsNull(%inputcol%) Then SetNull(%inputcol%) Else ''
Abhijit
IBM Certified Solution Developer Infosphere DataStage
IBM Certified Solution Developer Infosphere DataStage
Actually I used SetNull() for dummy columns to use funnel for the other output.
there are two outputs and to make them as a single output
I used transformer to create same columns as of the other output.
and I used SetNull() for that.
I am also getting the below errors searched the forum but cannot find a single solution.
main_program: APT_PMsectionLeader(1, node1), player 1 - Unexpected exit status 1.
main_program: APT_PMsectionLeader(1, node1), player 3 - Unexpected exit status 1.
APT_PMsectionLeader(1, node1), player 8 - Unexpected exit status 1.
APT_PMsectionLeader(1, node1), player 9 - Unexpected exit status 1.
please suggest me!!!
there are two outputs and to make them as a single output
I used transformer to create same columns as of the other output.
and I used SetNull() for that.
I am also getting the below errors searched the forum but cannot find a single solution.
main_program: APT_PMsectionLeader(1, node1), player 1 - Unexpected exit status 1.
main_program: APT_PMsectionLeader(1, node1), player 3 - Unexpected exit status 1.
APT_PMsectionLeader(1, node1), player 8 - Unexpected exit status 1.
APT_PMsectionLeader(1, node1), player 9 - Unexpected exit status 1.
please suggest me!!!
Thanks,
Surya
Surya
-
- Participant
- Posts: 46
- Joined: Tue Jul 20, 2010 1:26 pm
- Location: USA
- Contact:
-
- Premium Member
- Posts: 1735
- Joined: Thu Mar 01, 2007 5:44 am
- Location: Troy, MI
The error is in ODBC Connector Stage, but is it during read or write?
is that column defined as not null in database?
are you performing cast on that field or any other function?
Which database?
is that column defined as not null in database?
are you performing cast on that field or any other function?
Which database?
This is not correct. Something must have changed, either Job or data or table metadata.The job was fine with input and output suddenly when I tried to run it again
Priyadarshi Kunal
Genius may have its limitations, but stupidity is not thus handicapped.
Genius may have its limitations, but stupidity is not thus handicapped.
Any answer would be a guess as there are too many factors that could be involved. You are assuming it is a DataStage problem, however, it could be a problem with the database, or it could have been another developer changing your file definition inside the database.
Since the problem is gone away, I'd say wait until it comes back and then repost.
Since the problem is gone away, I'd say wait until it comes back and then repost.