Source Data Truncated
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 503
- Joined: Wed Jun 29, 2005 8:14 am
Source Data Truncated
I have a job which reads from a SQL Server and writes to a Oracle Database. Its one to one job with IPCs in it.
When Irun the job all the character fields from teh source are truncated to length 1 (without any errors) and are loaded in the target liek that.
When I say view data I see the same result. There is no substrings , no logic involved in the complete job.
Let me know if anyone has seen such a kidn of behavior before.
When Irun the job all the character fields from teh source are truncated to length 1 (without any errors) and are loaded in the target liek that.
When I say view data I see the same result. There is no substrings , no logic involved in the complete job.
Let me know if anyone has seen such a kidn of behavior before.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Version 8 is still very new. Bounce it off your support provider, supply a reproducible case, and let us know the outcome.
Have you specified Char with no length in the table definition? Some databases interpret that as Char(1).
Have you specified Char with no length in the table definition? Some databases interpret that as Char(1).
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Premium Member
- Posts: 503
- Joined: Wed Jun 29, 2005 8:14 am
-
- Charter Member
- Posts: 822
- Joined: Sat Sep 17, 2005 5:25 pm
- Location: USA
-
- Premium Member
- Posts: 232
- Joined: Fri Aug 04, 2006 1:20 am
- Location: Bangalore
-
- Premium Member
- Posts: 503
- Joined: Wed Jun 29, 2005 8:14 am
-
- Participant
- Posts: 32
- Joined: Fri Dec 02, 2005 10:44 pm
- Location: Chicago,IL
Try this,DeepakCorning wrote:I removed all the stages in the job and directly sourced the data from the source SQL table in to a Seq file.
I get the same result. Every character field is of lenght 1 in the file , so if a NAME = Mike , then in the file NAME = M.
Go to the source stage(SQL Server), outputs tab,columns tab,
Derivationtab and remove all the column derivations if it has any.
Thanks,
Pradeep
(Ten Hugs And Nine KisseS - THANKS)......is that true?
In GOD we trust,for all others we take cash.
Pradeep
(Ten Hugs And Nine KisseS - THANKS)......is that true?
In GOD we trust,for all others we take cash.
-
- Participant
- Posts: 132
- Joined: Wed Mar 01, 2006 11:12 pm
- Location: Pune
Re: Source Data Truncated
Have u checked the job log in director. see if it gives some warning message and if that message is helpfulDeepakCorning wrote:I have a job which reads from a SQL Server and writes to a Oracle Database. Its one to one job with IPCs in it.
When Irun the job all the character fields from teh source are truncated to length 1 (without any errors) and are loaded in the target liek that.
When I say view data I see the same result. There is no substrings , no logic involved in the complete job.
Let me know if anyone has seen such a kidn of behavior before.
SMB
FYI, I had a similar issue connecting to SQL Server 2005, on DSEE 7.5.1A on RHEL. IBM has issued me a patch, which resolved the issue.
Please contact IBM:
Scase:473187
Ecase: 74157
The patch contains updated versions of the following files:
libdsplugin.so, liborpheus.so, dscapiop.so
-rob
good luck! btw, now I have a strangely similar issue when extracting from SAP R/3, using the ABAP Extract stage. Still working with IBM on this one...
Please contact IBM:
Scase:473187
Ecase: 74157
The patch contains updated versions of the following files:
libdsplugin.so, liborpheus.so, dscapiop.so
-rob
good luck! btw, now I have a strangely similar issue when extracting from SAP R/3, using the ABAP Extract stage. Still working with IBM on this one...