|
Home > Archive > BizTalk Server Orchestration > September 2005 > Problem about SQL adapter, help me.
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 |
Problem about SQL adapter, help me.
|
|
|
| i want to test SQL adapter, so i have a very simple project by using "add generated items".
in my orchestration, i have one receive shape to receive xml file, one send shape to send query to sqlserver, one receive shape to receive result and one send shape to send result to xml file.
i create input xml file by generate from schema.
when i run this orchestration, it works.
but after stored procedure is modified to have a intput parameter and i rebuild new project in the same way as the first time, but it doesnt work
i found this orchestration is suspend in HAT
Here an error message i capture from EventViewer:
Event Type: Error
Event Source: XLANG/s
Event Category: None
Event ID: 10001
Date: 9/13/2005
Time: 11:48:45 PM
User: N/A
Computer: LONDON
Description:
Failed while creating a First.Orchestration_1 service.
Exception type: ServiceCreationException
Source:
Target Site:
Help Link:
Additional error information:
The parameter is incorrect.
Exception type: ArgumentException
Source: Microsoft.XLANGs.BizTalk.Engine
Target Site: Int32 GetCapabilities(System.Guid ByRef)
p.s. i already use xml auto, xmldata
p.s.2 sorry for my english skill
help me please, thanks in advance | |
| Lakshmi Murthy 2005-09-22, 8:58 pm |
| Are you using Updategram or Stored procedure?
It would be better if you go for Stored Procedure option and write a stored
procedure for this.
HTH
regards
Lakshmi
http://techsavygal.blogspot.com
"Boo" wrote:
>
> i want to test SQL adapter, so i have a very simple project by using
> "add generated items".
>
> in my orchestration, i have one receive shape to receive xml file, one
> send shape to send query to sqlserver, one receive shape to receive
> result and one send shape to send result to xml file.
>
> i create input xml file by generate from schema.
>
> when i run this orchestration, it works.
>
> but after stored procedure is modified to have a intput parameter and i
> rebuild new project in the same way as the first time, but it doesnt
> work
>
> i found this orchestration is suspend in HAT
>
> Here an error message i capture from EventViewer:
>
> Event Type: Error
> Event Source: XLANG/s
> Event Category: None
> Event ID: 10001
> Date: 9/13/2005
> Time: 11:48:45 PM
> User: N/A
> Computer: LONDON
> Description:
> Failed while creating a First.Orchestration_1 service.
>
>
> Exception type: ServiceCreationException
> Source:
> Target Site:
> Help Link:
> Additional error information:
>
> The parameter is incorrect.
>
> Exception type: ArgumentException
> Source: Microsoft.XLANGs.BizTalk.Engine
> Target Site: Int32 GetCapabilities(System.Guid ByRef)
>
> p.s. i already use xml auto, xmldata
> p.s.2 sorry for my english skill
>
> help me please, thanks in advance
>
>
>
> --
> Boo
> ------------------------------------------------------------------------
> Posted via http://www.webservertalk.com
> ------------------------------------------------------------------------
> View this thread: http://www.webservertalk.com/message1197902.html
>
>
| |
| Lakshmi Murthy 2005-09-22, 8:58 pm |
| oops..
check the datatype of the input parameter in the source schema.i guess you
got this error because biztalk engine is not able to send this value to the
input parameter in sql server.
"Boo" wrote:
>
> i want to test SQL adapter, so i have a very simple project by using
> "add generated items".
>
> in my orchestration, i have one receive shape to receive xml file, one
> send shape to send query to sqlserver, one receive shape to receive
> result and one send shape to send result to xml file.
>
> i create input xml file by generate from schema.
>
> when i run this orchestration, it works.
>
> but after stored procedure is modified to have a intput parameter and i
> rebuild new project in the same way as the first time, but it doesnt
> work
>
> i found this orchestration is suspend in HAT
>
> Here an error message i capture from EventViewer:
>
> Event Type: Error
> Event Source: XLANG/s
> Event Category: None
> Event ID: 10001
> Date: 9/13/2005
> Time: 11:48:45 PM
> User: N/A
> Computer: LONDON
> Description:
> Failed while creating a First.Orchestration_1 service.
>
>
> Exception type: ServiceCreationException
> Source:
> Target Site:
> Help Link:
> Additional error information:
>
> The parameter is incorrect.
>
> Exception type: ArgumentException
> Source: Microsoft.XLANGs.BizTalk.Engine
> Target Site: Int32 GetCapabilities(System.Guid ByRef)
>
> p.s. i already use xml auto, xmldata
> p.s.2 sorry for my english skill
>
> help me please, thanks in advance
>
>
>
> --
> Boo
> ------------------------------------------------------------------------
> Posted via http://www.webservertalk.com
> ------------------------------------------------------------------------
> View this thread: http://www.webservertalk.com/message1197902.html
>
>
|
|
|
|
|