cancel
Showing results for 
Search instead for 
Did you mean: 

Problem in Webservice-XI-JDBC scenario

Former Member
0 Kudos

Hi Experts,

I am working on webservice - XI - JDBC Synchronous scenario. I have done with SLD, IR, ID, WSDL file creation.

When I tried to test the scenario thro' Webservice Studio, I am getting the following error. This error comes, once I give the request value.

See the end of this message for details on invoking

just-in-time (JIT) debugging instead of this dialog box.

                            • Exception Text **************

System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.InvalidOperationException: Client found response content type of 'text/html', but expected 'text/xml'.

The request failed with the error message:

--





td {font-family : Arial, Tahoma, Helvetica, sans-serif; font-size : 14px;}

A:link A:visited

A:active







401   Unauthorized

.

.

.

.

.

.

If you come across this type of issues, then please help me to solve it.

Regards

Sara

Message was edited by:

Sara D

Accepted Solutions (1)

Accepted Solutions (1)

prateek
Active Contributor
0 Kudos

Hi Sara,

Have a look here,

/people/krishna.moorthyp/blog/2006/07/23/http-errors-in-xi

Regards,

Prateek

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi Sara,

Have you resolved your query..?

I am facing the same problem..same error is displayed in my scenario too.

please guide me... how have you gone ahead...?

Regards,

Kevin

bhavesh_kantilal
Active Contributor
0 Kudos

Sara,

1. The issue is that the user id and password being used does not have the authotization. Make sure that you have the roles of XIAPPLUSER.

2. Also look into section 3.2.2 of this document and use the URL and the steps to create the WSDL as in this document,

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/d23cbe11-0d01-0010-5287-873a2202...

Regards

Bhavesh

Former Member
0 Kudos

Hi Bhavesh,

Thanks for your immedidate reply.

2nd point have done, because that was your earlier suggestion for my previous thread.

Let me check for the first point.

Regards

Sara

Former Member
0 Kudos

Hi,

I could able to login into the XI system with PIAPPLUSER Id, but when I give a display search for PIAPPLUSER with the transaction code SU01(SAP Logon)..I am getting "User PIAPPLUSER does not exist" error.

Could you please tell me/suggest me with some blogs for how to create the new user with roles? Apart from this user, do we need to have any roles for other XI users to do the scenarios?

Our Basis team done with the PI7 installation with both Java & ABAP stack, but I am the one starting with first sample scenario. So, please don't mistake me for these questions.

Regards

Sara

former_member189418
Participant
0 Kudos

Hi Sara,

PIAPPLUSER is a service user. all the service users are created during the time of the installation. you need not create it explicilty. As the scenario which you are currently working on is a sample one, give SAPALL role (Composite role) and also the J2EE_ADMIN role to the current user which is used in the currrent scenario.

Anil

bhavesh_kantilal
Active Contributor
0 Kudos

Sara,

Are you on XI3.0 or Pi 7.0?

If XI 3.0 the user will be XIAPPLUSER.

Regards

Bhavesh

bhavesh_kantilal
Active Contributor
0 Kudos

><i>Our Basis team done with the PI7 installation with both Java & ABAP stack, but I am the one starting with first sample scenario.</i>

failed to see this.

Ask your BASIS team if all the Post Installtion steps have been completed? I think they have missed some.

Regards

Bhavesh

prateek
Active Contributor
0 Kudos

Hi Sara,

<i>Could you please tell me/suggest me with some blogs for how to create the new user with roles?</i>

According to

http://help.sap.com/saphelp_nw04s/helpdata/en/d4/d12940cbf2195de10000000a1550b0/frameset.htm

<b>The user PIAPPLUSER is created during installation with the role SAP_XI_APPL_SERV_USER.</b>. After assigning this role try to login to your XI box with PIAPPLUSER. Provide the password for this user in CAPS

<i>Apart from this user, do we need to have any roles for other XI users to do the scenarios?</i>

http://help.sap.com/saphelp_nw04s/helpdata/en/9f/d12940cbf2195de10000000a1550b0/content.htm

Regards,

Prateek

Former Member
0 Kudos

Hi Bhavesh,

>>>Also look into section 3.2.2 of this document and use the URL and the steps to create the WSDL as in this document,

>>>https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/d23cbe11-0d01-0010-5287-873a2202...

In your response you have mentioned to follow the above points.

At the end of the 3.2.2 section, I could able to see the below statements.

" The sender SOAP Adapter does not require a SOAP action, <b>but you always have to apply logon data when using the SOAP Adapter.</b> In the central adapter engine or a PCK you must use one of the user names assigned to security role xi_adapter_soap_message for component XISOAPAdapter."

I am testing the webservice - XI - JDBC scenario using Webservice studio tool. Could you please where I have to mention the username & pwd ? Is it in the wsdl file?

Regards

Sara

bhavesh_kantilal
Active Contributor
0 Kudos

Sara,

Check this blog,

/people/community.user/blog/2006/09/19/xi-webservice-studio--a-plain-jane-soap-tool

Step 3 describes setting user id and password in Webservice Studio.

Regards

Bhavesh

Former Member
0 Kudos

Hi Bhavesh,

As per the blog, I have done the username & pwd setup..but still getting the "401 Unauthorized". Could you please tell me, what could be the problem?

Here is the full error trace.

                            • Exception Text **************

System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.InvalidOperationException: Client found response content type of 'text/html', but expected 'text/xml'.

The request failed with the error message:

--

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">

<html>

<head>

<title>Error Report</title>

<style>

td {font-family : Arial, Tahoma, Helvetica, sans-serif; font-size : 14px;}

A:link

A:visited

A:active

</style>

</head>

<body marginwidth="0" marginheight="0" leftmargin="0" topmargin="0" rightmargin="0">

<table width="100%" cellspacing="0" cellpadding="0" border="0" align="left" height="75">

<tr bgcolor="#FFFFFF">

<td align="left" colspan="2" height="48"><font face="Arial, Verdana, Helvetica" size="4" color="#666666"><b> 401 &nbsp Unauthorized</b></font></td>

</tr>

<tr bgcolor="#3F73A3">

<td height="23" width="84"><img width=1 height=1 border=0 alt=""></td>

<td height="23"><img width=1 height=1 border=0 alt=""></td>

<td align="right" height="23"><font face="Arial, Verdana, Helvetica" size="2" color="#FFFFFF"><b>SAP J2EE Engine/7.00 </b></font></td>

</tr>

<tr bgcolor="#9DCDFD">

<td height="4" colspan="3"><img width=1 height=1 border=0 alt=""></td>

</tr>

</table>

<br><br><br><br><br><br>

<table width="100%" cellspacing="0" cellpadding="0" border="0" align="left" height="75">

<tr bgcolor="#FFFFFF">

<td align="left" colspan="2" height="48"><font face="Arial, Verdana, Helvetica" size="3" color="#000000"><b> No login module succeeded.</b></font></td>

</tr>

<tr bgcolor="#FFFFFF">

<td align="left" valign="top" height="48"><font face="Arial, Verdana, Helvetica" size="2" color="#000000"><b> Details:</b></font></td>

<td align="left" valign="top" height="48"><font face="Arial, Verdana, Helvetica" size="3" color="#000000"><pre> No details available</pre></font></td>

</tr>

</body>

</html>

--.

at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)

at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)

at MI_OutboundService.MI_Outbound(DT_REQUEST MT_REQUEST)

--- End of inner exception stack trace ---

at System.RuntimeMethodHandle._InvokeMethodFast(Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner)

at System.RuntimeMethodHandle.InvokeMethodFast(Object target, Object[] arguments, Signature sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner)

at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean skipVisibilityChecks)

at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)

at WebServiceStudio.MainForm.InvokeWebMethod()

at WebServiceStudio.MainForm.buttonInvoke_Click(Object sender, EventArgs e)

at System.Windows.Forms.Control.OnClick(EventArgs e)

at System.Windows.Forms.Button.OnClick(EventArgs e)

at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)

at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)

at System.Windows.Forms.Control.WndProc(Message& m)

at System.Windows.Forms.ButtonBase.WndProc(Message& m)

at System.Windows.Forms.Button.WndProc(Message& m)

at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)

at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)

at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

Regards

Sara

Message was edited by:

Sara D

bhavesh_kantilal
Active Contributor
0 Kudos

Hi Sara,

The only issue i see is that the ,

1. Either the user does not have the roles of PIAPPLUSER

2. or the roles of this user have not been generated.

Another option wopuld be to use the URL as in Stefan 's Blog and give thinga a shot,

/people/stefan.grube/blog/2006/09/21/using-the-soap-inbound-channel-of-the-integration-engine

Regards

Bhavesh

Former Member
0 Kudos

Hi,

I could able to solve the 401 Unauthorized error, after hard coding the username and pwd in the wsdl file.

Now I am getting the following error in the Webservice studio testing tool under Request/Response tab.

Response : ResponseCode: 200 (OK)

x-xmb_ws_encoded:version=1%2e0&Receiver.Party=%3a%3a&Receiver.Service=WEB_ERVICE&To.Interface=http%3a%2f%2fatl%2ecom%2ftarpon%5eMI_Outbound&MessageClass=SE&ProcessingMode=S&ConversationId=&MessageId=155301AB-63F8-8C43-91AB-B039AA1BCAE2&RefToMessageId=B1EE0B42-3912-0944-A7FE-E20BD08E39C8&QualityOfService=BestEffort&TimeSent=2007-05-28T10%3a17%3a37Z

soapaction:'http://sap.com/xi/XI/Message/30'

content-id:<soap-68DB98BFDFA8BB4AAB046C08947D7E7B@sap.com>

Content-Length:447

Content-Type:text/xml;charset=utf-8

Set-Cookie:sap-usercontext=sap-client=100; path=/

Server:SAP Web Application Server (1.0;700)

<?xml version="1.0" encoding="utf-16"?>

<SOAP:Envelope xmlns:SOAP="http://schemas.xmlsoap.org/soap/envelope/">

<SOAP:Body>

<SOAP:Fault>

<faultcode>SOAP:Server</faultcode>

<faultstring>System Error</faultstring>

<detail>

<s:SystemError xmlns:s="http://sap.com/xi/WebService/xi2.0">

<context>

</context>

<code><b>INTERNAL.EXCHANGE_PROFILE_ACCESS</b></code>

<text><b>Error while reading exchange profile for system PI7 and client 100</b></text>

</s:SystemError>

</detail>

</SOAP:Fault>

</SOAP:Body>

</SOAP:Envelope>

Could you please tell me what could be the problem?

Regards

Sara

Former Member
0 Kudos

Hi Experts,

Any suggestions for this issue?

Regards

Sara

prateek
Active Contributor
0 Kudos

Hi Sara,

1. Try to test the connection with SLD with the transaction SLDCHECK.

2. Check the RFC LCRSAPRFC.

If in error, paste the error

Have a look at the following SAP Notes:

940309 Change PI default client after 2004s Installation

939592 PI Usage Configuration versus Central SLD

Regards,

Prateek