Inserted value too large for column, row rejected.
Moderators: chulett, rschirm, roy
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?
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