Inserted value too large for column, row rejected.
Moderators: chulett, rschirm, roy
The more likely cause is that your data contains more characters than the table allows; i.e. you have a char(10) definition but are inserting 11 characters into that column. DataStage server will let you get away with that, but the database won't and issues an error.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
I tried to check the length of the field, and it is still within the normal length range for the field. The record could not pass through Datasatage transformer being used. I have tried to remove some of the characters in the field but I am still getting the same problem.
The warning message is from Datasatage and not Oracle.
I also compared the lenth of the field in SQL Server and Oracle to be sure that there is no mismatch any where.
Tai
The warning message is from Datasatage and not Oracle.
I also compared the lenth of the field in SQL Server and Oracle to be sure that there is no mismatch any where.
Tai
-
- Premium Member
- Posts: 503
- Joined: Wed Jun 29, 2005 8:14 am
Re: Inserted value too large for column, row rejected.
Simple thing to do will be to try to insert this record in a Sequential File and then view data in it. I am pretty sure you will catch the problem then and there itself.
DataStage Server transform stages do not limit the length (or even contents) of columns; the error message is being generated when DS tries to output to SQL Server. As DeepakCorning has recommended, if you redirect the output to a sequential file you will not only be able to see the actual contents of the column(s) in question but the error message will also go away.taazeez wrote:... The record could not pass through Datasatage transformer being used...The warning message is from Datasatage and not Oracle...
I'm a bit confused, you mention both "SQL Server 2005" and "Oracle" in your original post - which one are you using?
Also, what is the datatype for the column in question both in DS and also in the database?
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
Then it is the Oracle definition for the column is the one you want. Is it different from the SQL Server one?
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
Re: Inserted value too large for column, row rejected.
Tai,
Change that column data type in DS input and output stage to VARBINARY.
Thanks
Solai.K
Change that column data type in DS input and output stage to VARBINARY.
Thanks
Solai.K