i want to test SQL adapter, so i have a very simple project by using "add ge
nerated 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 on
e 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 rebu
ild 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

[ Post a follow-up to this message ]

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
>
>

[ Post a follow-up to this message ]

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
>
>

[ Post a follow-up to this message ]