Skip to Content
0
Former Member
May 06, 2008 at 09:39 PM

Scenario:SAP-XI-AS/400; Ack not possible and DB insert issues.

38 Views

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