Warning while loading into Sybase table.
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 37
- Joined: Wed Mar 23, 2005 5:20 am
Warning while loading into Sybase table.
Hi
I am reading a seq file, applying business rules, inserting the correct records into the sybase correct data table, creating an exception data seq file(by using the rejects option in the transformer) and also inserting the source row, load dtm and exception error message into the sybase log table.
I am unable to insert the warning message given out by the director into the error message column of sybase log table.
my design is as follows:
SeqFile--->Transfr---->Exceptional data Seq file
------->Sybase log table
---------->Sybase correct data table
I am getting the following warning in the director for the column
SEQREAD1.DRG_MEME_MEMBER: At row 1, link "lnLoadMeme", while processing column "MEME_CK"
Value treated as NULL
Attempt to convert String value "A6200301" to Long type unsuccessful
MEME_CK column type is Integer in all the files which I am reading and writing.
Due to this error I am thrown with another error in the Director
SEQREAD1.DRG_MEME_MEMBER: At row 1, link "lnLoadMeme"
Sybase Server message 3621 (severity 10) from stored procedure 'Input_0', line 1: Command has been aborted.
At row 1, link "lnLoadMeme"
Sybase Server warning 515 (severity 16) from stored procedure 'Input_0', line 1: Attempt to insert NULL value into column 'MEME_CK', table 'DEV100.dbo.DRG_MEME_MEMBER'; column does not allow nulls. Update fails.
Your assistance is greatly appreciated.
Thanks,
Nari.
I am reading a seq file, applying business rules, inserting the correct records into the sybase correct data table, creating an exception data seq file(by using the rejects option in the transformer) and also inserting the source row, load dtm and exception error message into the sybase log table.
I am unable to insert the warning message given out by the director into the error message column of sybase log table.
my design is as follows:
SeqFile--->Transfr---->Exceptional data Seq file
------->Sybase log table
---------->Sybase correct data table
I am getting the following warning in the director for the column
SEQREAD1.DRG_MEME_MEMBER: At row 1, link "lnLoadMeme", while processing column "MEME_CK"
Value treated as NULL
Attempt to convert String value "A6200301" to Long type unsuccessful
MEME_CK column type is Integer in all the files which I am reading and writing.
Due to this error I am thrown with another error in the Director
SEQREAD1.DRG_MEME_MEMBER: At row 1, link "lnLoadMeme"
Sybase Server message 3621 (severity 10) from stored procedure 'Input_0', line 1: Command has been aborted.
At row 1, link "lnLoadMeme"
Sybase Server warning 515 (severity 16) from stored procedure 'Input_0', line 1: Attempt to insert NULL value into column 'MEME_CK', table 'DEV100.dbo.DRG_MEME_MEMBER'; column does not allow nulls. Update fails.
Your assistance is greatly appreciated.
Thanks,
Nari.
-
- Premium Member
- Posts: 503
- Joined: Wed Jun 29, 2005 8:14 am
Re: Warning while loading into Sybase table.
Well is the value correct?? Because from what I understood is an alphanumeric value is getting inserted in an integer field which of course will throw a warning.Attempt to convert String value "A6200301" to Long type unsuccessful
MEME_CK column type is Integer in all the files which I am reading and writing.
-
- Premium Member
- Posts: 37
- Joined: Wed Mar 23, 2005 5:20 am
Log message in the Director
SEQREAD1.DRG_MEME_MEMBER: At row 1, link "lnLoadMeme"
Sybase Server message 3621 (severity 10) from stored procedure 'Input_0', line 1: Command has been aborted.
At row 1, link "lnLoadMeme"
Sybase Server warning 515 (severity 16) from stored procedure 'Input_0', line 1: Attempt to insert NULL value into column 'MEME_BIRTH_DT', table 'DEV100.dbo.DRG_MEME_MEMBER'; column does not allow nulls. Update fails.
There is no special character in the log.But when I read using the (DSGetLinkInfo(DSJ.ME, DSJ.ME,'lnLoadMeme', DSJ.LINKLASTERR))command to get the link error info I am getting inserted with that special character. It is inserted into that sequential file only when it starts with a newline character.
i.e immediately after the "lnLoadMeme" word which is occuring twice we get the two special characters inserted just before the "Sybase Server warning" word starts.
Thanks for all the effort.
Regards,
Nari.
SEQREAD1.DRG_MEME_MEMBER: At row 1, link "lnLoadMeme"
Sybase Server message 3621 (severity 10) from stored procedure 'Input_0', line 1: Command has been aborted.
At row 1, link "lnLoadMeme"
Sybase Server warning 515 (severity 16) from stored procedure 'Input_0', line 1: Attempt to insert NULL value into column 'MEME_BIRTH_DT', table 'DEV100.dbo.DRG_MEME_MEMBER'; column does not allow nulls. Update fails.
There is no special character in the log.But when I read using the (DSGetLinkInfo(DSJ.ME, DSJ.ME,'lnLoadMeme', DSJ.LINKLASTERR))command to get the link error info I am getting inserted with that special character. It is inserted into that sequential file only when it starts with a newline character.
i.e immediately after the "lnLoadMeme" word which is occuring twice we get the two special characters inserted just before the "Sybase Server warning" word starts.
Thanks for all the effort.
Regards,
Nari.
-
- Premium Member
- Posts: 37
- Joined: Wed Mar 23, 2005 5:20 am
-
- Premium Member
- Posts: 503
- Joined: Wed Jun 29, 2005 8:14 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Re: Warning while loading into Sybase table.
String value "A6200301" can not be converted to a Long (int64) since it contains at least one non-numeric character.narayana_382 wrote:Hi
I am reading a seq file, applying business rules, inserting the correct records into the sybase correct data table, creating an exception data seq file(by using the rejects option in the transformer) and also inserting the source row, load dtm and exception error message into the sybase log table.
I am unable to insert the warning message given out by the director into the error message column of sybase log table.
my design is as follows:
SeqFile--->Transfr---->Exceptional data Seq file
------->Sybase log table
---------->Sybase correct data table
I am getting the following warning in the director for the column
SEQREAD1.DRG_MEME_MEMBER: At row 1, link "lnLoadMeme", while processing column "MEME_CK"
Value treated as NULL
Attempt to convert String value "A6200301" to Long type unsuccessful
MEME_CK column type is Integer in all the files which I am reading and writing.
Due to this error I am thrown with another error in the Director
SEQREAD1.DRG_MEME_MEMBER: At row 1, link "lnLoadMeme"
Sybase Server message 3621 (severity 10) from stored procedure 'Input_0', line 1: Command has been aborted.
At row 1, link "lnLoadMeme"
Sybase Server warning 515 (severity 16) from stored procedure 'Input_0', line 1: Attempt to insert NULL value into column 'MEME_CK', table 'DEV100.dbo.DRG_MEME_MEMBER'; column does not allow nulls. Update fails.
Your assistance is greatly appreciated.
Thanks,
Nari.
The error about attempting to insert a null into a non-null column is probably unrelated to this, and results from a second bad thing in your job design.
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: 37
- Joined: Wed Mar 23, 2005 5:20 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
What don't you get? I pointed out that you can't violate the data type and nullability rules.
If you can't read my entire message because you haven't yet purchased premium membership, this can be corrected for less than $1 per week.
If you can't read my entire message because you haven't yet purchased premium membership, this can be corrected for less than $1 per week.
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.