|
Home > Archive > BizTalk Server General > March 2006 > Updating SQL tables
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 |
Updating SQL tables
|
|
| Jason 2006-03-25, 11:37 am |
| I'm having a problem updating a column in a SQL table. I import some data
into an orchestration, write it out to another database, and all that is
successful. I simply want to update a flag on the record I was working on to
change 'Imported' to true.
Here is my error. Any ideas?:
The adapter failed... It will be retransmitted....
Details:"HRESULT="0x80004005"
Description="All updategram/diffgrams nodes with siblings must have ids,
either user specified ones or mapping schema based key field id"
<Root xmlns:ns00="urn:schemas-microsoft-com:xml-updategram"><?MSSQLError
HResult="0x80004005" Source="Microsoft XML Extensions to SQL Server"
Description="All updategram/diffgrams nodes with siblings must have ids,
either user specified ones or mapping schema based key field id"?></Root>".
| |
| Greg Forsythe 2006-03-25, 11:37 am |
| Can you explain the process in a bit more detail.
You use a SQL receive adapter to receive data from database A.
You map this into an updategram and use SQL Send adapter to insert this into
database B.
Now you wish to update the Imported flag.
Is this in the database A or B
Are you using an new updategram to perform thhis update?
You you using one table or a number of tables?
Greg
"Jason" <Jason@discussions.microsoft.com> wrote in message
news:C7CA6C05-75BA-48ED-A1E4-A2D1B4D25576@microsoft.com...
> I'm having a problem updating a column in a SQL table. I import some data
> into an orchestration, write it out to another database, and all that is
> successful. I simply want to update a flag on the record I was working on
> to
> change 'Imported' to true.
> Here is my error. Any ideas?:
>
> The adapter failed... It will be retransmitted....
> Details:"HRESULT="0x80004005"
> Description="All updategram/diffgrams nodes with siblings must have ids,
> either user specified ones or mapping schema based key field id"
> ?<Root xmlns:ns00="urn:schemas-microsoft-com:xml-updategram"><?MSSQLError
> HResult="0x80004005" Source="Microsoft XML Extensions to SQL Server"
> Description="All updategram/diffgrams nodes with siblings must have ids,
> either user specified ones or mapping schema based key field
> id"?></Root>".
>
| |
| WenJun Zhang[msft] 2006-03-25, 11:37 am |
| Hi Jason,
I think you should first ensure that the input document instance validates
fine in Visual Studio against the map
and the SQL adapter schema. You may drop a copy of the input document into
a folder via file send adapter and check it later in detail.
This a common error of submitting invalid document to SQL through biztalk
SQL adapter.
Thanks.
Best regards,
WenJun Zhang
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
This posting is provided "AS IS" with no warranties, and confers no rights.
|
|
|
|
|