Skip to Content
avatar image
Former Member

Strange error in File-XI-JDBC scenario

Dear All,

I am working currently on File-XI-JDBC scenario and is facing with a stange problem.

I have writtern one simple query which is downloading the data from R/3 and is sending to XI Server local folder. From that folder File is getting picked by XI and is posted into SQL database.

Now, when I am generating the required file from R/3-DEV server then my scenario is getting executed successfully but if file is generated thru R/3-QAS Server then the scenario is giving the following error "Message processing failed. Cause: com.sap.aii.af.ra.ms.api.RecoverableException: Error processing request in sax parser: Error when executing statement for table/stored proc. 'MARA_UPDATE' (structure 'Statement'): java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Error converting data type nvarchar to smalldatetime."

Also, if I am copying the complete data from the error file and paste it into a new file and executing again then the scenario is executing correctly.

I have checked the payload and didn't find anything there.

Kindly help me in solving this error.

Regards,

N.J

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Former Member
    Sep 19, 2008 at 01:32 PM

    >>com.sap.aii.af.ra.ms.api.RecoverableException: Error processing request in sax parser: Error when executing statement for table/stored proc. 'MARA_UPDATE' (structure 'Statement'): java.sql.SQLException: MicrosoftSQLServer 2000 Driver for JDBCSQLServerError converting data type nvarchar to smalldatetime."

    The problem is arising when XI is trying to insert_update information in table MARA_UPDATE and this problem is not is related to the format of message that is finally going to database.

    >>converting data type nvarchar to smalldatetime

    check for this in your payload or mapping...if mapping is running does not mean JDBC insert this information successfully. It is very much dependent on the format of few database fields also. Check for all date fields in transformation logic. and check that format is acceptable in data base or not.

    Also read this : [DATE/TIME datatypes and Oracle Database|https://www.sdn.sap.com/irj/sdn/weblogs?blog=/pub/wlg/2002] [original link is broken] [original link is broken] [original link is broken];

    Thanks

    farooq

    Edited by: Farooq Farooqui on Sep 19, 2008 7:04 PM

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      >>Error converting data type nvarchar to smalldatetime

      I think it should be >>Error converting data type varchar to smalldatetime.

      So just have a look on this Error, take help from Google engine or SQL forums...I am sure the problem is arising during insertion in SQL database due to some invalid data.

      Thanks

      Farooq.

  • avatar image
    Former Member
    Sep 24, 2008 at 09:34 AM

    Thanx for ur reply. Database was not accepting any special characters so it was throwing error.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 18, 2010 at 02:41 PM

    Hi,

    Can u provide me the Full scenario (JDBC to FILE / File to JDBC) aong with the Prerequisite, that is with Querry Language (where we will write that query and wat are all the Connections related t JDBC required)?

    Regards

    KArthi SP

    karthispatyahoo.co.in

    Add comment
    10|10000 characters needed characters exceeded