Forum Replies Created
-
Posts
-
There was a failure executing the receive pipeline: \”Microsoft.BizTalk.DefaultPipelines.XMLReceive\” Source: \”XML disassembler\” Receive Location: \”C:\\Labs\\KanbanSystem\\FileDrops\\Input\\*.xml\” Reason: Loading document specification <ReplenishmentSchemas.Envelope> from assembly <ReplenishmentSchemas, Version=1.0.0.0, Culture=neutral, PublicKeyToken=4d8b341742337627> failed. Verify that the schema is deployed properly and that the schema assembly implements the document spec.
i have another error …..any help?
Not sure what it is you mean there. I don’t think either example does exactly what you want, but if you modify the one tha captures the WMI instance suspended event with code similar to the one that extracts the message, you should be able to accomplish what you want. Did you try doing that, or did you simply used them as they were?
hi thx for your help but i allready did some changes.
now i have this.
database A has table: Artikelen
–> ID, Order_ID, Productnaam, Aantal, StatusDatabase B has table: ArtikelenMagazijn
–> ID, Order_ID, Productnaam, Aantalnow what i did is adding a status, so only the statusses with 1 would be updatet.
I made a stored procedure in the SQL Server 2005:
[quote:6ecbaaab3e]set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
goALTER PROCEDURE [dbo].[SP_ArtikelenSelect]
@Status varchar(1)
AS
select ID, Order_ID, Productnaam, Aantal, Status
from Artikelen
where Status = @Status
for xml auto, XMLDATA
[/quote:6ecbaaab3e]then i made a generated item again for the receive port with the stored procedure, where i put the value of status to \”1\”.
next i add a generated item again for the send port with all the database fields of database B. (artikelenMagazijn)
next i have a transformmap where i connect ID from receiveschema to the ID in the <BEFORE> from the SEND schema.
and i connect the Aantal from RECEIVE schema to the Aantal in the <AFTER> from the SEND Schema.Now this works again not like it has to be…
normally the status from database A should change to 0 so he wouldn’t be approached like every second.
and i have this error in my eventlog:
[quote:6ecbaaab3e]A message sent to adapter \”SQL\” on send port \”SendSQLOrderSysteem\” with URI \”SQL://AWS00401\\STAGE/Ordersysteem/\” is suspended.
Error 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> [/quote:6ecbaaab3e]any luck to solve this?
thx for everything
ThomasIt gives me the error which has blocked the source file to reach its destination.That is what i want.
In addition to that,i want my source file also to correct the mistakes manually and put in the input folder.I think the Xml you are sending to the SQL adapter is being interpreted as a stored procedure call rather than an updategram.
Can you email me a copy of the message and the updategram schema.
thank u for your reply.
I tried the exemple that u gave me in the lien.It gives me the error message but it does not give the the source file which has disappeared from the input folder.It gives the file in the format destination schema.is it possible to get the source file?
kavitha
thanx but i have been given this scenario to solve. just bcz i should know how to integrate b/w the two databases of SQL server. definitely the actual problem is not like that. it will be communicated to me later. so if u can just guide me how to integrate the two sql server database, i shall be thankful.
Regards,
Jan.thx that works.
but something doesn’t…
when add an send port also, and i also generate the send port message (it is to update another database with the same values)
i do everything ok, i map the two messages, i have in my send message this structure:
[quote:7e17e1b748]<sync>
<before>
<tablename>
<columns></columns>
</tablename>
</before>
<after>
<tablename>
<columns></columns>
</tablename>
</after>
</sync>[/quote:7e17e1b748]in my before and after i have all the columnnames.
so what do i do,
i connect the \”ID\” from the receive message to the \”ID\” from the BEFORE block of the send message.
i connect the \”Aantal\” from the receive message to the \”Aantal\” from the AFTER block of the send message.i build it, i deploy it, it all works.
but i start my host instance and then the only thing i’m getting is errors in my event log.this is my error message:
[quote:7e17e1b748]A message sent to adapter \”SQL\” on send port \”SendSQLOrderSysteem\” with URI \”SQL://AWS00401/Ordersysteem/\” is suspended. Error Details: HRESULT=\”0x80040e14\” Description=\”The request for procedure ‘Artikelen’ failed because ‘Artikelen’ is a table object.\”[/quote:7e17e1b748]The funny thing about it is i don’t use a procedure, i have a sql statement in my receive port and have used the updatagram on my send port…
How could i solve this?
Thx in advance
ThomasI am bizTalk server newbie too, but I know a lot about mssql server. I am not sure you really need to use biztalk server to solve your problem. Functionality you described is well supported by sql server itself.
If your databases are on the same server you can use a trigger. If they are on different servers you can use replication.
Try FOR XML AUTO or FOR XML AUTO, ELEMENTS if you want the output in elements rather than attributes
Hi,
I need to change unix line ending (LF) in a file into a windows line ending (CRLF). I know I could do this by FTPing in ASCII mode but I can’t I’ll explain to anyone who wants to know. Has anyone done this, it’s really the streaming of the file that concerns me the files I’m transferring are +50MB so I can run out of memory quite quickly.
Any thoughts on the best way of doing this?
Sl%u00e1n
Gar
