community-content

Forum Replies Created

Viewing 15 posts - 3,796 through 3,810 (of 9,648 total)
  • Author
    Posts
  • in reply to: can call xml from orchestration? #20750

     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.

    in reply to: Mapping #20749

     I used the customized XSL. Seems to be working like magic

    Thank you

     

    Wonder Andile Hlongwane

    in reply to: can call xml file in Orchestration? #20747

     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

    in reply to: can call xml file in Orchestration? #20746

    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.

    in reply to: can call xml file in Orchestration? #20745

    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

     

    in reply to: Mapping #20744

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

    in reply to: can call xml file in Orchestration? #20743

    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.

    in reply to: can call xml file in Orchestration? #20742

     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

    in reply to: can call xml file in Orchestration? #20741

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

    in reply to: can we decide Sender at Run time for send port? #20738

    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

    in reply to: Mapping #20737

     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

    in reply to: assembly deployment errors #20736

    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.

    in reply to: Persistence issue #20734

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

    in reply to: Using BizTalk for queing and database update #20728

    Anon, which CRM database do you mean – can you offer a little more information?

    in reply to: Using BizTalk for queing and database update #20727

    How to update the CRM database using Biztalk?????????

Viewing 15 posts - 3,796 through 3,810 (of 9,648 total)