Need Help JDBC Adapter

[Former Member]

Hi,

I have scenerio called MRI_OUTBOUND in which I am sending the data from SAP to MRI[SQL Server] and getting the status back to SAP.

That is SAP Document Posted through PROXY TO SAP XI and then XI Sending the data to MRI and Getting the status of the document back to SAP using XI and JDBC Adapter .

As I am doing testing in QA server as my testing in DEV goes fine I had transported all the related objects from Development to Quality using CMS.

Now I am getting the below error while posting the document from SAP to MRI

  <SAP:Stack>HTTP response contains status code 401 with the description Unauthorized Error when sending by HTTP (error code: 401, error text: Unauthorized)</SAP:Stack>

Can anybody let me know the solution for this.

Thanks

Sudharshan

[Former Member · Accepted solution]

Hi Sudharshan,

Can u check in SXMB_MONI of R/3 as well as XI. Check whether it has reached XI or not. Also, check the sender and receiver service for this error. I guess u might not be able to get into XI from R/3 b'coz 401 is unauthorized error.

Regards,

Akshay

[Former Member · Accepted solution]

The message I had sent was from SXMB_MONI from R3 side I am not getting any message in XI SXMB_MONI

[justin_santhanam · Accepted solution]

Sudharshan,

U can't check anything on SXMB_MONI on R/3 side. SXMB_MONI is to check in SAP XI system.

I think its related to user that u are using while posting to XI ,can u check which user u are trying to post to XI. I think it must be XIISUSER.

Best regards,

raj.

[Former Member · Accepted solution]

Hi,

I am getting the following error message from R3 Side does this help in getting the solution to the problem.

SAP R/3 SXMB_MONI MESSAGE from Error Tab

body { font-family:tahoma,helvetica,sans-serif;color:#333333;background-color:#FFFFFF; }td { font-family:tahoma,helvetica,sans-serif;font-size:70%;color:#333333; }h1 { font-family:tahoma,helvetica,sans-serif;font-size:160%;font-weight:bold;margin-top:15px;margin-bottom:3px;color:#003366; }h2 { font-family:verdana,helvetica,sans-serif;font-size:120%;font-style:italic;font-weight:bold;margin-top:6px;margin-bottom:6px;color:#999900; }p { font-family:tahoma,helvetica,sans-serif;color:#333333;margin-top:4px;margin-bottom:4px; }ul { font-family:tahoma,helvetica,sans-serif;color:#333333;list-style-type:square;margin-top:8px;margin-bottom:8px; }li { font-family:tahoma,helvetica,sans-serif;color:#33333;margin-top:4px; }.emphasize .note a { font-family:tahoma,helvetica,sans-serif;text-decoration:underline;color:#336699; }a:visited a:hover { text-decoration:none; }

h1. Anmeldung fehlgeschlagen h2. Was ist passiert ? Der Aufruf der URL http://fcrny4sapxiq1.fc.enterprise.local:8080/sap/xi/engine wurde aufgrund fehlerhafter Anmeldedaten abgebrochen.

Hinweis

[justin_santhanam · Accepted solution]

Sudharshan,

Which user you are using while posting data?

Best regards,

raj.

[Former Member · Accepted solution]

Hey

<b>go to transaction sproxy and check with the test reports whether you see any error here.

If while calling the transaction you get a pop up asking for user and password, then it means that your user piappluser or xiappluser is incorrectly set , and you should set the passwords everywhere to the same word - using the same case. I suggest using lower case.

Additionally see the tips provided in the troubleshooting guide, section proxies -

you can find details how to download the guide in note 806546.

Then, please check in the integration directory, whether the data you entered in the communication channels is correct, that is the servers etc, and make sure that these are accessible.</b>

source:sdn.sap.com

Thanx

Ahmad

[Former Member · Accepted solution]

I am using xiexternuser[HTTP] and xiuser[JDBC].Is this related to authentication problem ?

[justin_santhanam · Accepted solution]

Sudharshan,

Thats y i asked u? U need to use XIISUSER or XIAPPLUSER i'm not sure!! Try with this user and let us know the results.

The error clearly states that its related to authentication.

best regards,

raj.

[Former Member · Accepted solution]

The same scenerio works fine in development environment with the same users and settings.Currently I am in QA environment where I am getting this problem.

Thanks

Sudharshan

[Former Member · Accepted solution]

Hey

>>The same scenerio works fine in development environment with the same users and settings

user authorization varies in dev,QA or Prd,its possible that the user has sufficient privileges in Dev box but not in QA.

use xiappluser and it should solve ur problem.

Thanx

Ahmad

[Former Member · Accepted solution]

Sudarshan,

To post data from SAP through proxy to XI, you need to use the user X(P)IAPPLUSER. You can use any user Id, provided it has the roles of XIAPPLUSER. Just make sure in QA, the user Id exists and with the correct roles.

Regards,

Jai Shankar

[Former Member · Accepted solution]

Can I get the stepwise method to verify the test connection,as now I am not able to get the message in XI from R3 side I would like to know how do we test proxy connection to XI where I can see the test connection between the proxy and XI.

I am using XI adapters at senders[R3] and JDBC adapters at receiver[SQL] respectively.

My interface is [SAP R3]PROXYXI Adapters>XIJDBC Adapters->SQL

Thanks

Sudharshan