Hi,
I have a SAP-XI-AS/400 scenario and I have two issues with the same.
1. When I trigger an IDoc to the XI system, I get ack status(in SXMB_MONI) as: "Acknowledgement not possible". The message is : "Unable to convert the sender service to an ALE logical system"
2. While trying to do a DB insert I get the below Error and DB insert is not happening.
" Error Unable to execute statement for table or stored procedure. '<table_name>' (Structure 'Statement_<table_name>') due to java.sql.SQLException: [SQL7008] <table_name> in <lib> not valid for operation.
Error JDBC message processing failed; reason Error processing request in sax parser: Error when executing statement for table/stored proc. '<table_name>' (structure 'Statement_<table_name>'): java.sql.SQLException: [SQL7008] <table_name> in <lib> not valid for operation.
Error MP: Exception caught with cause com.sap.aii.af.ra.ms.api.RecoverableException: Error processing request in sax parser: Error when executing statement for table/stored proc. '<table_name>' (structure 'Statement_<table_name>'): java.sql.SQLException: [SQL7008] <table_name> in <lib> not valid for operation.
Error Exception caught by adapter framework: null
Error Delivery of the message to the application using connection JDBC_http://sap.com/xi/XI/System failed, due to: com.sap.aii.af.ra.ms.api.RecoverableException: Error processing request in sax parser: Error when executing statement for table/stored proc. ' ' (structure 'Statement_ '): java.sql.SQLException: [SQL7008] in not valid for operation.. "
I have been using the same kind of query we use for other succesful dB inserts.
Can you please give me a solution and suggest possible reasons and workarounds?
Thank you
Best Regards,
Smitha