Forum Replies Created
-
Posts
-
Joe –
There is a default value property of the Schema that you can fill in. I don't like to use it because it is not visible unless you know it is there.
For greater visibility to others, you can wire the value into a scriptoid and test if it is an empty string "" and then set the default if it is empty.
-wa
Joe,
Try using Logical Existence Functiod.
It checks whether the node exist or not in the Source Schema.
Hope u find it useful.
I supposeu shoud not use Envelope Debatching.
Better u use Orchestration and use any one of the debaching methods.
Nodelist,Xpath,Component.
The trick here is assembling the ouput and sending it to source.
You can use xml document to club all outputs and load it in a message and send it bck.
thank you guys for the replies. i still have not found the downloadable package though….but at least i know from where to start now.
If you're running BizTalk Server 2004.
You need the same components from DEV installed in QA and PROD. The microsoft site describes all the components required to install BizTalk Server 2004. You will also need VS in QA and PROD, ofcourse you wont be doing development, and the developers will not have access to these two environments.
When you deploy an interface from DEV to QA, all you need to move is the CurrentVersion folder, and deploy the assemblies using the Deployment Wizard.
That's pretty much how we have it, and it is rock solid. Production and QA never break. DEV is always broken thanks to my developer friends. 🙂
Also, do you know anyone who has installed SP2 for BTS2K4? We want to install it, but we want to make sure it doesn't bring our environments down. I tried a virtual, and I'm not sure if the results I'm seeing are because of the SP2 or just the Virtual Build.
Thanks,
Rene
I want to install SP2 also, but I need to make sure it is not going to bring down my environment. I'm running SAP Adapter 2.0, WSE 2.0, Covast EDI Acelerator, SQL, and File adapters.
I tried installing it on a virtual, and I started getting memory dumps everytime the machine reboots or shuts off among other things. The problem is that I'm not sure if it is the SP that caused this, the actual virtual, or what.
How did it go with your installation?
Thanks,
Rene
Do you have administrative rights on that box? Looks like it's failing when installing the assembly into the GAC, which requires elevated privileges.
Siva –
I understand the multiple requirements here.
Consider this thought – even if you reject a batch file there is a still a big workflow problem; what were you going to do – edit out the duplicate PO by hand and rerun the file each time?
What I have seen is this: load the batch files into temp tables and then do the work of weeding out the duplicate transactions in the database; simply don't propagate those to the production tables and drop them with the temp table. Or keep them as a history of errors.
In this scenario we queried the database for the next available index number from the map.
I recommend against creating a system where a file fails and someone has to manually do something with it.
-wa
[quote user="hedidin"]
The adapter doesn't support UDT's. You might want to consider using a view.
Alternatively, you could use return a Ref Cursor using NativeSQL. You can find more info and samples in the Documentation.
[/quote]
Hi,
Thank you for your help.
I am sorry, I think I didnt explain u the situation clearly. Let me tell u clearly in this post.
We get POs from customers. Each PO will have Header, Detal and Serial information. It is possible to get duplicate PO and/or more than one PO in each batch file. So we want to create our own unique ID for each PO and store with the data into 3 tables, Header, Detail and SerialInfo. I have two option to create this ID.Use script in the map to create ID or make the ID could as Identity in the Parent table then use the at-identity atributes to pass the value to child tables.
Eg PO
H po 1
D
D
S
H po2
D
S
SThe problem I am faicing :
If I put all records in to one after node as u said in the last reply then the parent table will get the unique ID for the new records but all the newly insert records in the child table get the last ID value of the parent table. That is wrong
For this example Lest say po1 have ID 1 and po2 has ID 2 then all of the D and S of po1 should have ID 1 and others 2.If I use one after block then all the D and S have ID 2. That is why I decide to put a loop for each PO with after.
Let me know if you need more info.
[quote user="Siva"]
Hi,
Thank you for your help.
If I connect to the parent, which is sync here, then I will get multiple sync in the out put for one input. If I have multiple sync in the out put then SQL Adapter will handle each sync as a single transaction so I will end up with multiple transaction for one input. If one transaction fails rest of the sync will commit and only the failed one will roll back. I dont want that. If one record failed for one input then I want all of them to roll back. So I want to keep one synce for one input.
If I create a parent for after and before and put that as child for sync then I can solve this problem. but it is not working.I am getting following error.
"HRESULT="0x80004005" Description="The specified XML namespace is invalid"
%ufeff<Root xmlns:ns00="urn:schemas-microsoft-com:xml-updategram"><?MSSQLError HResult="0x80004005" Source="Microsoft XML Extensions to SQL Server" Description="The specified XML namespace is invalid"?></Root>".
So the new node, which i create as a child for Sync and parent for after and before is invalid.
How can I solve this? Please help me to fix this issue.
Thank you in advace,
[/quote]
Ok, I can see here the specific convention you are working with.
http://support.microsoft.com/kb/316018
The updategram is a specific convention of SQL server and thus you must to conform to the structure of this schema. You are not free to just modify it as I had originally suggested.
Looks like you really one one Before node and one After node, with all of the updates inside that; so it looks like you might want to connect looping functoid to "information to insert" node. It would seem that this makes all of the db operations into a single transaction which would rollback like you intend. Let us know if this works.
sync
before /
after
information to insert 1
information to insert 2
information to insert 3/after
/sync– wa
Hi,
Thank you for your help.
If I connect to the parent, which is sync here, then I will get multiple sync in the out put for one input. If I have multiple sync in the out put then SQL Adapter will handle each sync as a single transaction so I will end up with multiple transaction for one input. If one transaction fails rest of the sync will commit and only the failed one will roll back. I dont want that. If one record failed for one input then I want all of them to roll back. So I want to keep one synce for one input.
If I create a parent for after and before and put that as child for sync then I can solve this problem. but it is not working.I am getting following error.
"HRESULT="0x80004005" Description="The specified XML namespace is invalid"
%ufeff<Root xmlns:ns00="urn:schemas-microsoft-com:xml-updategram"><?MSSQLError HResult="0x80004005" Source="Microsoft XML Extensions to SQL Server" Description="The specified XML namespace is invalid"?></Root>".
So the new node, which i create as a child for Sync and parent for after and before is invalid.
How can I solve this? Please help me to fix this issue.
Thank you in advace,
