DSXchange

While sending a text file content to a sybase table, i got the below warning message.

ALRT_Q..t_df: At row 1, link "ALRT_F"
Sybase Server warning 3814 (severity 16): The parameter of type 111 did not have a valid value.

Thing is, Job executed successfully..But the corresponding rows didn't transferred into the table.

Hmmm... you actually got a 3814 warning over a parameter of "type 111". Perhaps you can ask your Sybase DBA what that be. Also would be curious if you are using the SybaseOC stage or something else.

chulett wrote:Hmmm... you actually got a 3814 warning over a parameter of "type 111". Perhaps you can ask your Sybase DBA what that be. Also would be curious if you are using the SybaseOC stage or something else.

It is related to sybase datatype. I have resolved this issue. Anyway Thanks for your hint.

Could you post the resolution, please? That and marking your post as Resolved would be helpful as well.

chulett wrote:Could you post the resolution, please? That and marking your post as Resolved would be helpful as well. ...

Sure...

The table has some datetime columns.

I used 'Date' datatype for those columns in Sequential File Stage & SybaseOC stage.

The text file looks like

20090529

Since it was varchar,i got the above mentioned error message. After i changed the datatype from 'Date' to 'Varchar' in both the stages, the problem was resolved.

For this kind of issue, we need to check the table datatype , how we declared it in the stage and the value we pass.

Resolved.

karthi_gana wrote:Resolved.

:D There's actually a big button at the top of the screen for that.