How can I check how my message was responded in MS SQL target system ?

[Former Member]

Hi experts. Can anybody help me/

We have completely performed all steps described in this article http://scn.sap.com/docs/DOC-3813 but we used MSSQL instead of Oracle and we can see our message was executed successfully but we didn't see the inserted rows in MSSQL table.

I interested in - In wich area i can search why the row didn't inserted ?

[Former Member]

Hi to all.

We've solved this issue. We've installed the Oracle and reconfigurated our  PI bus to operate with Oracle not with MSSQL and we've got what we want. The message executed successfully and record inserted.

[Former Member]

Hello,

I hope you have created response structure to get back the count?

Thanks

Amit Srivastava

[Former Member]

Hello, Amit.

Response structure, how can i create it ?

[Former Member]

Hello,

Please discard my previous reply.....I misunderstood your thread, i thought you want to get back the inserted rows count.

>>>>I interested in - In wich area i can search why the row didn't inserted ?

It can be only done in DB as message has successfully processed from PI, so what u can do is

and suggested above also, log the statement which is created in PI.

Under "Advanced Mode" -> u have to type logSQLStatement (under Name) and its value as true and then re-run ur scenario and validate the statement which is created in PI.

Thanks

Amit Srivastava

[Former Member]

we've found such tool as PI Message Monitor and we saw this

in this log we can see this message:

Delivering the message to the application using connection JDBC_http://sap.comfti/XI;System failed, due to:  com .sap .engine.interf aces.messaging .api.exception .MessagingException: Error when attempting to get processing resources:  com .sap .aii.af Jib .util .concurrent .ResourcePoolException: Unable to create new pooled resource: DriverManagerException: Can not establish  connection:: SAPCIassNotFoundException: jbt.

previously we tested our jdbc adapeter by FTP_JDBC_ConnectionValidation_711 and we've get this result:

also we tested sql statement wich generated by PI and row was inserted

But we have no idea why our PI system can not insert row at the table

[naveen_chichili]

Hi Alex,

There might be some error in the Receiver JDBC comm Channel.

Please check in communication channel monitoring and fix the issue.

Thanks,

Naveen

[ambrish_mishra]

Hi Alexandr,

If you require the sql statement generated by the JDBC adapter for any error analysis, you can set logSQLStatement to true in "advanced mode" section of the communication channel. This will cause the generated statement to show in details page of the audit.

You can execute the same statement in the database and check if it inserts any rows or not.

Ambrish

[Former Member]

Hi Ambrish

i didn't see the logSQLStatement checkbox in settings tab of the communication channel

[ambrish_mishra]

Hi,

please type it under name

Message would be visible in RWB -> comm channel monitoring -> choose the channel -> click on the message -> third tab (Audit log)

Hope I was clear this time

Ambrish

[Former Member]

thanks Ambrish, you was so clear.

I reckon, we manage message monitoring, and we have analyze that the problem in this:

JDBC_http://sap.comfti/XI;System failed, due to:  com .sap .engine.interf aces.messaging .api.exception .MessagingException: Error when attempting to get processing resources:  com .sap .aii.af Jib .util .concurrent .ResourcePoolException: Unable to create new pooled resource: DriverManagerException: Can not establish  connection:: SAPCIassNotFoundException: jbt.

and we thinking about this error. Do you have any idea ?

[Former Member]

Message would be visible in RWB -> comm channel monitoring -> choose the channel -> click on the message -> third tab (Audit log)

Do you mean this tool ?

where "third tab (Audit log)" ?

[ambrish_mishra]

Hi Alexandr,

You need to do component monitoring -> Choose adapter engine -> press comm channel monitoring (button at bottom->

Check your channel, press on the message and the audit log will be visible there.

Having said that, the details of error given by you points to the fact that the SQL driver has not been installed or installed correctly.

Ambrish

[Former Member]

Ambrish, good morning.

We've turned on this component early enough, but we still have no idea what shall we do to make our message to insert row in the table.

the screenshot of green lights our adapter engine is

settings of our message:

test of our message is successful

message executed successfully:

but record  in the MSSQL table doesn't added:

and  we don't know why

[ambrish_mishra]

Hi Alexandr,

I meant the tool below:

Once your press this button highlighted, it will give a pop up:

Hope it helps.

Ambrish

Added the screenshots again Message was edited by: Ambrish Mishra

[ambrish_mishra]

Hi Alexandr,

You are using incorrect receiver JDBC format.

please check the link below:

http://help.sap.com/saphelp_nw04/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm

From the screenshots of RWB monitoring, your messages show as "To be delivered" from adapter engine. they show as successful only in Integration engine which does not mean that they are delivered.

In short, the messages are stuck.

Please sort out the receiver structure first.

Ambrish

[rajasekhar_reddy14]

Check JDBC receiver channel and monitor it,if JDBC channel status successfull then you could see audit log message clearly.

If JDBC channel has error then take action accordingly.

[Former Member]

Hi.

I checked JDBC channel status - it's successfull and i intrested in where i can see audit log message