Job throws fatal error but does not Abort
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 30
- Joined: Tue Sep 08, 2009 4:24 am
Job throws fatal error but does not Abort
Hi All,
There is an ETl job to populate data from oracle (oracle enterprise stage) to Sql server (ODBC stage).
The normal behaviour of an ETL job is to abort teh job in case of any fatal errors with status 'Aborted' and in case of any warnings with status 'Finished (see log)'
The job now prompts with a fatal error:
APT_CombinedOperatorController,0: [Microsoft][SQL Native Client]Invalid character value for cast specification
And the job completes with status 'Finished (see log)'
Can any one please let me know what are the probable reasons for this unusual behaviour about log.
Any specifc patch for this fix.
Thanks
Arpana
There is an ETl job to populate data from oracle (oracle enterprise stage) to Sql server (ODBC stage).
The normal behaviour of an ETL job is to abort teh job in case of any fatal errors with status 'Aborted' and in case of any warnings with status 'Finished (see log)'
The job now prompts with a fatal error:
APT_CombinedOperatorController,0: [Microsoft][SQL Native Client]Invalid character value for cast specification
And the job completes with status 'Finished (see log)'
Can any one please let me know what are the probable reasons for this unusual behaviour about log.
Any specifc patch for this fix.
Thanks
Arpana
-
- Premium Member
- Posts: 1735
- Joined: Thu Mar 01, 2007 5:44 am
- Location: Troy, MI
-
- Participant
- Posts: 62
- Joined: Sat Mar 07, 2009 4:59 am
- Location: Chicago
- Contact:
Data load
Is the data loaded into target database.
Try the following things , if not works any of the following .Think about the patches
1.The warning is mainly related to casting error. Means the datatype mismatch from Oracle to Sql server database.
2.If you used two stages in your job oracle enterprise stage ( for oracle) > ODBC stage (Sql server ),Use transformer stage in between this two stages.Import the metadata in both source oracle enterprise stage and target odbc stage,then match in transformer.Hope it will works.
Thanks :D
Try the following things , if not works any of the following .Think about the patches
1.The warning is mainly related to casting error. Means the datatype mismatch from Oracle to Sql server database.
2.If you used two stages in your job oracle enterprise stage ( for oracle) > ODBC stage (Sql server ),Use transformer stage in between this two stages.Import the metadata in both source oracle enterprise stage and target odbc stage,then match in transformer.Hope it will works.
Thanks :D
Suresh Reddy
ETL Developer
Research Operations
"its important to know in which direction we are moving rather than where we are"
ETL Developer
Research Operations
"its important to know in which direction we are moving rather than where we are"
-
- Participant
- Posts: 30
- Joined: Tue Sep 08, 2009 4:24 am
Unfortunately, we've all seen behaviour like that, some combination of things can result in fatals that don't abort. Open a case with your offiical support provider, perhaps you are missing a patch. Especially since you're still on 8.0 rather than 8.1. ![Confused :?](./images/smilies/icon_confused.gif)
![Confused :?](./images/smilies/icon_confused.gif)
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Premium Member
- Posts: 1735
- Joined: Thu Mar 01, 2007 5:44 am
- Location: Troy, MI
Its a known problem in Datastage 8.0.1. Hope below link helps.
http://www-01.ibm.com/support/docview.w ... wg1JR33966
http://www-01.ibm.com/support/docview.w ... wg1JR33966
Priyadarshi Kunal
Genius may have its limitations, but stupidity is not thus handicapped.![Wink :wink:](./images/smilies/icon_wink.gif)
Genius may have its limitations, but stupidity is not thus handicapped.
![Wink :wink:](./images/smilies/icon_wink.gif)
-
- Participant
- Posts: 30
- Joined: Tue Sep 08, 2009 4:24 am
Thanks for the information.
Actually I have found out that there is a field of type date in oracle but holds data in format '07/10/2004 09:56:20'; target SQL server has datatype timestamp
Tried modifying the datatype in oracle stage from Timestamp(23,3) to Timestamp(19) also Varchar(23,3)
But no change![Sad :(](./images/smilies/icon_sad.gif)
PLz guide
Actually I have found out that there is a field of type date in oracle but holds data in format '07/10/2004 09:56:20'; target SQL server has datatype timestamp
Tried modifying the datatype in oracle stage from Timestamp(23,3) to Timestamp(19) also Varchar(23,3)
But no change
![Sad :(](./images/smilies/icon_sad.gif)
PLz guide
Arpana
-
- Premium Member
- Posts: 1735
- Joined: Thu Mar 01, 2007 5:44 am
- Location: Troy, MI