Skip to Content
0
Former Member
Dec 14, 2007 at 01:06 PM

Error in File-JDBC Scenario

10 Views

Dear All,

I am working on FILE to JDBC scenario in which I am facing with the following error:

- 2007-12-14 18:18:51 GMT+05:30: Error: TransformException error in xml processor class: Error processing request in sax parser: Error when executing statement for table/stored proc. 'TBL_SAP_PRODUCTS' (structure 'STATEMENTNAME1'): java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.

the payload at the JDBC adapter is :

- <ns0:MT_JDBC_MARA xmlns:ns0="urn:abc:mm">

- <STATEMENTNAME1>

- <DbTablename action="INSERT">

<TABLE>TBL_SAP_PRODUCTS</TABLE>

- <access>

<MATERIAL_CODE>000000000001002021</MATERIAL_CODE>

<DESCRIPTION>BASICS 7 FTBL.</DESCRIPTION>

<PRODUCT_HIERARCHY_CODE>00</PRODUCT_HIERARCHY_CODE>

<MATERIAL_GROUP_CODE>R1500</MATERIAL_GROUP_CODE>

<MATERIAL_GROUP_DESC>Basics-FG</MATERIAL_GROUP_DESC>

<BASE_UNIT>S07</BASE_UNIT>

<SAP_ADD_DATE>20051219</SAP_ADD_DATE>

<SAP_MODIFY_DATE>20051219</SAP_MODIFY_DATE>

<EXTRACT_DATE>20071214</EXTRACT_DATE>

</access>

Please guide me what is the error.

Warm Regards,

N.Jain