on 12-07-2012 1:16 PM
Hi Gurus,
I have a strange problem with JDBC Receiver Channel.
Actually the channel is working before converting the scenario to Integrated Configuration. After Converting the Scenario to Integrated Configuration it's not processing any messages and not giving any error as well.
I can see the sender channel working without any issues. I have checked cahces also, it it's in green status.
Waiting for your valuable suggestions. Please suggest on this.
Thanks,
Satish.
Couple of suggestions...
Though you did not give enough error details, Please check receiver jdbc channel and see the status of the channel. Check do you see any error over there. The same query test it using toad and see what result you get from the database. If the adapter does not give errors, then your query might be the issue or data problems. Hopefully you dont see sxmb_moni for the testing. I have few interfaces in Integrated configuration and no issues..
Hope that helps. Elaborate more on your errors.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
What do you see in the adapter engine monitoring of RWB with respect to sender and receiver channels? Do you see outgoing and incoming messages are flowing ? If there is any configuration issue with respect to receiver channel you will find errors. I also want you to check with DBA whether any call comes from PI to database. Also do testing with TOAD or db client tool with the same query and data outside pi.
Hi,
My scenario is file to jdbc. Sender File channel is processing the messages and Receiver JDBC channel is not processing any messages and not giving any error also.
I have tested the configuration in ID and the error is showing Receiver Agreement not found.
I have double checked the configuration, I have configured correctly.
Thanks,
Hi Sreeni,
There is now objects locked. I have checked in Administration tab.
Hi Sen,
I have verified the link, it is saying that the test configuration not work for ICO.
I am doing the end to end test, the file channel is picking the files and processing but receiver JDBC channel is not processing any messages and not throwing any error.
Before converting the scenario to ICO it's working now.
Please provide your guidelines on this.
Thanks,
Satish.
What is the audit log status, is pipe line step call adapter called JDBC receiver adapter or not? There is a possibility that JDBC receiver 5 threads blocked .
You can check this by navigating to below path
RWB-->Component Monitoring---->AdapterEngine--->Engine Status--->Additional Data---->queueInformation->JDBC_http://sap.com/xi/XI/SystemRecv.
If threads assingned working 5/5 means then try to stop and start the channel and see results,if no luck then restart Java stack.
Regards,
Raj
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.