IDOC---JDBC scenario error: "INTERNAL">HTTP_RESP_STATUS_CODE_NOT_OK

[Former Member]

i have a IDOC-XI--JDBC scenario,

the scenario fails at the Call Adpater Pipeline step............giving following error:

<SAP:Category>XIServer</SAP:Category>

<SAP:Code area="INTERNAL">HTTP_RESP_STATUS_CODE_NOT_OK</SAP:Code>

<SAP:P1>401</SAP:P1>

<SAP:P2>Unauthorized</SAP:P2>

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

pls help me.....

Message was edited by:

sudeep dhar

[agasthuri_doss]

Hi,

>>IDOC-XI--JDBC scenario,

Is the Receiver and sender in the same network.

Kindly check the autorization from Receiver side .

Regards

Agasthuri Doss

[Former Member]

Hey

this means the user id or password you are using to connect to JDBC system is not correct.

please cross check them.

Thanx

Ahmad

[Former Member]

Ahmad, i think if that would have been the problem .... it would have shown it in the communication channel monitoring and no error in the MONI....

am i right?

......and i have cross checked.....pls help

[Former Member]

Hi sudeep,

IF SXMB_MONI says that it fails in the call adapter step.

check whether you have any messages in the queue in SMQ1 and SMQ2.

Regards

Arun

[Former Member]

Hey

Did you maintain Client, userid, password, and lang information in SICF transaction -> sap/xi/engine ? Double click on service and check whether you have entered correct information.

Thanx

Ahmad

[Former Member]

yes arunkumar....

there are lot of entries in the queue.....SMQ2...

what can i do.......whats the problem....

Is that particular message lost

[Former Member]

R u working on the development system or the production system.

[Former Member]

production

[Former Member]

Hey

>>there are lot of entries in the queue.....SMQ2..

your scenarios wont work if the queues are stuck,release/delete all the objects from queue and then test your scenario again.

also look at my earlier reply about passwords

Thanx

Ahmad

[Former Member]

can you afford to delete those messages in the queue????

[Former Member]

hi ahmad, the entries in the queue is like 2.5 Laks (IDOC),

and are processing, i cant delete them,

this error occurs sometimes....

see the scenario is like .....about 4.75 lak IDOCs come from R/3 and is inserted into database through JDBC, hence the system is so slow.... and after processing some messges correctly ..it gives this HTTP error

[agasthuri_doss]

Hi,

This might happen because the PIAFUSER has been locked.

Make sure the same password in Su01 & Exchange Profile

Regards

Agasthuri Doss

[Former Member]

but this error occurs after few message pass successfully.....

means at an interval this error happens...then again few messgae pass successfully,

This is the error which i get in MONI:

ERROR_CATEGORY: INTERNAL

ERROR_ID: HTTP_RESP_STATUS_CODE_NOT_OK

and in the pipeline step i can see the error:

<?xml version="1.0" encoding="UTF-8" standalone="yes" ?>

- <!-- Call Adapter

-->

- <SAP:Error xmlns:SAP="http://sap.com/xi/XI/Message/30" xmlns:SOAP="http://schemas.xmlsoap.org/soap/envelope/" SOAP:mustUnderstand="">

<SAP:Category>XIServer</SAP:Category>

<SAP:Code area="INTERNAL">HTTP_RESP_STATUS_CODE_NOT_OK</SAP:Code>

<SAP:P1>401</SAP:P1>

<SAP:P2>Unauthorized</SAP:P2>

<SAP:P3 />

<SAP:P4 />

</SAP:AdditionalText>

<SAP:ApplicationFaultMessage namespace="" />

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

<SAP:Retry>M</SAP:Retry>

</SAP:Error>

[bhavesh_kantilal]

Would suggest checking the Logs from the Visual Admin as this error occurs when the load is high. That should give you the required reasons to trace the problem out.

Regards

Bhavesh

[moorthy]

Hi,

Check out the all PI Service Users are correct i.e not locked... Probably the problem with some of the Service users getting locked..

Are you getting any error in SM58 of SAP R/3 system ??

Hope this helps

Rgds,

Moorthy