Invalid character value
Posted: Tue Sep 25, 2012 12:27 pm
This is know error to dsxchange, today I got this error. This is not the first time I am running the job, it ran almost from a year back everyday.
APT_CombinedOperatorController,0: [IBM (DataDirect OEM)][ODBC SQL Server Wire Protocol driver]Invalid character value. Error in parameter 7.
Recently, the table is dropped and recreated. There is no diff in the DDL. and also DSN as well. But I used user-defined SQL. In that.. i converted a column from Datetime2(7) into Varchar(27). Because of this it throws the above error.
I resolved by adding the null handling part.
Thanks, Sripathy.
APT_CombinedOperatorController,0: [IBM (DataDirect OEM)][ODBC SQL Server Wire Protocol driver]Invalid character value. Error in parameter 7.
Recently, the table is dropped and recreated. There is no diff in the DDL. and also DSN as well. But I used user-defined SQL. In that.. i converted a column from Datetime2(7) into Varchar(27). Because of this it throws the above error.
I resolved by adding the null handling part.
Thanks, Sripathy.