Stored Procedures - Sybase

[Former Member]

Hi,

I have a nasty problem. I like to do works within a stored procedure. I have 2 SP calls an 1 SQL Query in one BPM. So far it works fine. But since Service Pack 14 it seems to be buggy.

My BPM flows without any errors. But when I look into Database Audit Login I only see my Select (of SQL Query) but no "exec" statements.

If I change procedures name to something stupid - XI runs on an error - so it seems to me he communicate with DB.

But anyhow he never goes in my procedure.

Thanks for help...

Matt

[Former Member]

Hi,

Could you pls check & make sure that the 3 calls made it past the adapter engine (from RWB)?

one more question - are these asynchronous calls ?

Thanks & Regards,

Renjith

[Former Member]

Hi Renjith,

thanks for your quick response, these all are synchronous calls.

In my Message Monitoring it looks all correct.

Regards

Matt

[Former Member]

Hi Matt,

Can you do the following and check whether it helps...

In the Receiver JDBC adapter configuration, pls set the additional parameter "logSQLStatement" and value "true" in the "Advanced Mode" table...

using this the generated SQL statement will be shown in the details page (audit protocol) of the message monitor for each message directly....

this is from the OSS note - 801367.

and you might want to execute this statement from your sql query tool directly in your db...

Thanks & Regards,

Renjith.