Forum Replies Created
-
AuthorPosts
-
Hi
You can put your vendor info on C:\Program Files\Microsoft BizTalk Server 2006\BTSNTSvc.exe.config and easily access it from anywhere in your biztalk apps.
I have added a connection string on this config under the AppSetting node, like
add key=“DATACONN“ value=“Data Source=Server1;Initial Catalog=database1;uid=sa;pwd=sa“/>
and then accessed it on the Orchestrations expression as follow:
strConn = System.Configuration.ConfigurationSettings.AppSettings.Get(“DATACONN”);
Or you can declare an XmlDocument variable on the Orchestration View and put the following on the expression:
xmlDoc.Load(“config.xml”);
then traverse the xmlDoc to get the info you need.
I used the customized XSL. Seems to be working like magic
Thank you
Wonder Andile Hlongwane
Thank you Russell,
Since i never work with BRE, I am going to learn now and trying to apply to this project.
Once again, Thank you for your help.
Siva
Microsoft says the BRE is highly optimized and can support lots of users. I’ve never had any performance problems with it. Plus, it is going to be much easier to manage than config files because everything is in one place. If you use config files, you need a copy of the file on each BizTalk server.
Thank you for your reply Russell,
I can not modify the DB. so it is not possible to store vendor info in DB.
User may click this app more than 100/sec. Do you think BRE would be better in runtime? Or is it better to call .NET from orchestration to return config msg each time?
Siva
I think it seems to be a straight forward mapping. Try the below and see if it works.
Create the source and destination schemas with value of max occurs for “address” element under “addresses” to unbounded. Map the elements “to”, “country” and “address” in source schema to “to”, “country” and “addr” in destination schema. (Assuming that value of maxOccurs for “to” and “country” in source schema is 1).
So you are looking up the vendor ID from a DB? Why not store all of the vendor info in the DB and get it in a single lookup? If that’s not feasible, then the BRE would probably be a good model. You could send in an XML containing the vendor ID, and write a rule to fill in all the vendor details based on the ID.
Thank you for your quick reply,
I am working on price and availabilty project. I will get the item number from back end system. Then i use the item# to find out who have it from our DB. These parts are done and work fine.
I have a config file. Which have all of our vendors who support with XML Transaction and their posting url, userid and password. now i need to create vendorRequset using previous input file and config file. If the DB out file and config file have the vendor name, then create request using DB out put file and config file.
Is there any easy way to do? Can i use BRE? or I need to use some .NET component to access the config file?
Siva
The short answer is yes. You can call an external assembly that uses the System.Configuration API and do whatever configuration tasks you want. The BRE would be a good choice if you wanted to dynamically configure something based on an incoming message. Can you give some more details on what you want to accomplish? What do you mean by “use them at mapping time”?
Hi,
Would it be possible to call “config.xml” file from orchestration?
I will get item details from input file. I will have vendor info in a config file. I need to access the config file from orchestration to use for mapping. Would it be possible to access some xml file from orch?
Does this do anything wtih Business Rule Eng? I am wondering can i create these config info in business rule eng and use them at mapping time.
Siva
You can do this in ways.
1. Use Inline XSLT
2. or use Table loop funtoid. Functoid first param will be addresses node and connect that to “Addresses” node at destination. “address” will be the 2nd param, “to” theird param and “country” forth param. use 3 Extract funtoid to ge the values from table loop and point to destination.
I hope 2nd will be the easy way.
Let me know how it goes.
siva
Are any other assemblies referencing the assembly you are deploying? If so, you may need to either include those assemblies in the deployment, or remove them prior to deploying. For example, if you have a maps project and a schemas project (maps references schemas), and you try to deploy just the schemas project, Visual Studio will try to undeploy the maps project because there could potentially be version conflicts. If the maps are referenced anywhere in BizTalk, such as on a port, the deploy will fail.
<p> I am having an orchestration which is set to atomic and the scope transaction is set to none. variables are declared outside the scope. I call a custom.dll from the orchestration where the methods are marked as serializable.
</p>
<p> [Error Message] Uncaught exception (see the ‘inner exception’ below) has suspended an instance of service ‘HandshakeInt.handShakeOrch(a95b4c47-850a-53c6-127a-e5cefeda643b)’. The service instance will remain suspended until administratively terminated. InstanceId: 7a7deabe-e559-4016-b233-4f1afe10177a ShapeId: 00000000-0000-0000-0000-000000000000 Exception thrown from: segment 1, progress 0 Inner exception: Exception occurred when persisting state to the database. Exception type: PersistenceException Source: Microsoft.XLANGs.BizTalk.Engine Target Site: Void Commit() Help Link: The following is a stack trace that identifies the location where the exception occured at Microsoft.BizTalk.XLANGs.BTXEngine.BTXXlangStore.Commit() at Microsoft.BizTalk.XLANGs.BTXEngine.BTXXlangStore.ScheduleComplete(Boolean terminate) at Microsoft.BizTalk.XLANGs.BTXEngine.BTXService.ScheduleComplete(Context ctx, Boolean finalPersisting, Boolean terminate) at Microsoft.XLANGs.Core.Service.Persist(Boolean dehydrate, Context ctx, Boolean idleRequired, Boolean finalPersist, Boolean bypassCommit, Boolean terminate) at Microsoft.XLANGs.Core.TransactionalContext.OnCommit() at Microsoft.XLANGs.Core.AtomicTransaction.OnCommit() at HandshakeInt.handShakeOrch.segment1(StopConditions stopOn) at Microsoft.XLANGs.Core.SegmentScheduler.RunASegment(Segment s, StopConditions stopCond, Exception& exp) Additional error information: A batch item failed persistence Item-ID 83efbe3c-e795-4217-bcf8-8b3b0a0b1cc2 OperationType MAIO_CommitBatch Status -1061151998 ErrorInfo The published message could not be routed because no subscribers were found. Please use the Health and Activity Monitoring (HAT) tool to diagnose this situation. . Exception type: PersistenceItemException Source: Target Site: Help Link: The following is a stack trace that identifies the location where the exception occured Additional error information: A batch item failed persistence Item-ID 7a7deabe-e559-4016-b233-4f1afe10177a OperationType MAIO_InstanceComplete Status 12589892 ErrorInfo . Exception type: PersistenceItemException Source: Target Site: Help Link: The following is a stack trace that identifies the location where the exception occured Additional error information: Failed to publish (send) a message in the batch. This is usually because there is no one expecting to receive this message. The error was The published message could not be routed because no subscribers were found. Please use the Health and Activity Monitoring (HAT) tool to diagnose this situation. with status -1061151998. Exception type: PublishMessageException Source: Target Site: Help Link: The following is a stack trace that identifies the location where the exception occured Additional error information: [/Error Message]
Anon, which CRM database do you mean – can you offer a little more information?
How to update the CRM database using Biztalk?????????
-
AuthorPosts