RFC to JDBC Synchronous Scenario with Action "EXECUTE"

[Former Member]

Hello All

     I am working on RFC to JDBC Synchronous Scenario with Action "EXECUTE". I am executing stored procedure in the third party system through PI and the result set is sent to SAP RFC. For some reason the results for the stored procedure are different in third party system compared to the results that are received in PI. How can this be possible? Please let me know if anybody has any ideas?

Thanks

Naga

[gagandeep_batra]

Hi Naga,

I think you can consider the user-name also by which you are querying 

Regards

gagan

[Former Member]

Hi Naga,

When you send the request through your JDBC channel, I believe in the audit log you can see what query is going and hence will hit your third part database. Try and execute the same query separately in your third party database and see what happens.

Best Luck,

V J

[baskar_gopalakrishnan2]

>For some reason the results for the stored procedure are different in third party system compared to the results that are received in PI. How can this be possible? Please let me know if anybody has any ideas?

Not possible.  Check whether your environment type(dev, test, prod) same in both pi side and target system.