|
Home > Archive > BizTalk Server Orchestration > November 2005 > Biztalk problem with WebServices SOAP!!
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Biztalk problem with WebServices SOAP!!
|
|
| Francesco 2005-11-28, 6:02 pm |
| Hello,
I have a problem in Biztalk when I’ve tried to add a new WebServices in an
Orchestration.
After Compile and deploy the orchestration, and start all services, When I
call the WebServices (by an .aspx web page) I have these Warning from Biztalk:
The adapter "SOAP" raised an error message. Details "Exception has been
thrown by the target of an invocation.".
The adapter "SOAP" raised an error message. Details "Server was unable to
process request. --> SQL Server does not exist or access denied.".
The adapter failed to transmit message going to send port
"http://127.0.0.1/wsInteropa/wsInteropa.asmx". It will be retransmitted after
the retry interval specified for this Send Port. Details:"Server was unable
to process request. --> SQL Server does not exist or access denied.".
Seem that Biztalk can’t send the XML SOAP to WebServices WSInteropa. I don’t
know why I have this message (from windows event viewer) :
"Server was unable to process request. --> SQL Server does not exist or
access denied.".
What can I do?
This is the first time that I have this problem. All times that I have added
a WebServices is always works!!!
Thanks for all your response.
Regards,
Francesco
| |
| Marian Drumea 2005-11-28, 6:02 pm |
| Hi Francesco,
Can you call the service from a non-BizTalk project? What happens if
you access the URI in a browser and even try to call the method(s)?
As of now, it looks like a problem within the web service and it will
be clear if you try to call it from the browser or a distinct kind of
project. BizTalk is also heavily using the SQL Server databases, so I
would look there once the Web Services prove to be OK. There could be
havy load on your message box database or something, maybe some
deadlocks because of heavy load and tracking, etc.
Please try and post the answer here!
Thanks,
Marian Drumea
http://www.MarianDrumea.com/BizTalk
| |
| JGaska [http://www.IoniaSolutions.com] 2005-11-28, 6:02 pm |
|
Francesco;
The user the webservice is running as does not have rights to write to your
messagebox database. There are a few different ways to accomplish what you
are looking for. What OS are you running XP or win2k3?
Basically, You need to change who the user is for your virtual directory
which your webservice runs under. Depending on which OS you are running you
can accomplish this a few ways. You can create an application pool and
change the user (2003 Server), or you can change the anonymous user on the
virtual directory (both). Let me know if you have any questions with how to
do this.
Joe Gaska
Ionia Corporation
http://www.IoniaSolutions.com
Building your information pipelines - Ionia
"Francesco" wrote:
> Hello,
> I have a problem in Biztalk when I’ve tried to add a new WebServices in an
> Orchestration.
> After Compile and deploy the orchestration, and start all services, When I
> call the WebServices (by an .aspx web page) I have these Warning from Biztalk:
>
> The adapter "SOAP" raised an error message. Details "Exception has been
> thrown by the target of an invocation.".
>
> The adapter "SOAP" raised an error message. Details "Server was unable to
> process request. --> SQL Server does not exist or access denied.".
>
> The adapter failed to transmit message going to send port
> "http://127.0.0.1/wsInteropa/wsInteropa.asmx". It will be retransmitted after
> the retry interval specified for this Send Port. Details:"Server was unable
> to process request. --> SQL Server does not exist or access denied.".
>
>
> Seem that Biztalk can’t send the XML SOAP to WebServices WSInteropa. I don’t
> know why I have this message (from windows event viewer) :
>
> "Server was unable to process request. --> SQL Server does not exist or
> access denied.".
>
> What can I do?
>
> This is the first time that I have this problem. All times that I have added
> a WebServices is always works!!!
>
> Thanks for all your response.
>
> Regards,
> Francesco
>
| |
| Francesco 2005-11-29, 7:49 am |
| the SO is Win2000.
But, why in the other WebsErvices I don't have this problem, and in this new
I have the problem. I must control the IIS user on the single WebServices??
Thanks,
Francesco
"JGaska [http://www.IoniaSolutions.com]" wrote:
[vbcol=seagreen]
>
> Francesco;
>
> The user the webservice is running as does not have rights to write to your
> messagebox database. There are a few different ways to accomplish what you
> are looking for. What OS are you running XP or win2k3?
>
> Basically, You need to change who the user is for your virtual directory
> which your webservice runs under. Depending on which OS you are running you
> can accomplish this a few ways. You can create an application pool and
> change the user (2003 Server), or you can change the anonymous user on the
> virtual directory (both). Let me know if you have any questions with how to
> do this.
>
>
> Joe Gaska
> Ionia Corporation
> http://www.IoniaSolutions.com
>
> Building your information pipelines - Ionia
>
>
>
> "Francesco" wrote:
>
| |
| Francesco 2005-11-29, 5:55 pm |
| The other strange behaviour is that if I try to execute another method of
this WebServices, it works.
The method "GetData" instead, give me that error ("sql server access error").
So I don't think it's a problem of Sql server access, because the second
method works.
But, Biztalk can't send the xml to my WebServices. Why?
Can anyone help me?!
My webservices is in standard SOAP and don't receive a string as parameter,
so is difficult to test webservices for me!
thanks,
Francesco
"JGaska [http://www.IoniaSolutions.com]" wrote:
[vbcol=seagreen]
>
> Francesco;
>
> The user the webservice is running as does not have rights to write to your
> messagebox database. There are a few different ways to accomplish what you
> are looking for. What OS are you running XP or win2k3?
>
> Basically, You need to change who the user is for your virtual directory
> which your webservice runs under. Depending on which OS you are running you
> can accomplish this a few ways. You can create an application pool and
> change the user (2003 Server), or you can change the anonymous user on the
> virtual directory (both). Let me know if you have any questions with how to
> do this.
>
>
> Joe Gaska
> Ionia Corporation
> http://www.IoniaSolutions.com
>
> Building your information pipelines - Ionia
>
>
>
> "Francesco" wrote:
>
| |
| Marian Drumea 2005-11-29, 5:55 pm |
| Hi Francesco,
Please check the logs for your SQL Server and look for an access error,
just in case. Also, regarding my initial question, do you know what
happens inside your service and what kind of access based on what
connection string is there?
Then run a SQL Server profiler and see what happens when you make a WS
request, if anything. Of course, chances are that it is not much, but
you can see what happens before the actual failing call.
Also, can you step into your Web Services project in case you have
control over the source?
We'll get to the bottom of this, no worries!
Marian
http://www.MarianDrumea.com/BizTalk
|
|
|
|
|