community-content

Forum Replies Created

Viewing 15 posts - 3,091 through 3,105 (of 9,648 total)
  • Author
    Posts
  • in reply to: Oracle permissions in WCF Lob adapter #21916

    I answer myself, problem arises because WCF Lob adapter uses ODP.Net 10g, and we´re trying to connect with a Oracle 8i.

    ODP.Net 10g uses “ALL_PROCEDURES” view to list packages which it doesn’t exist in 8i.

    in reply to: FTPS/SFTP adapter #21914

    There is a third option, use an open source adapter:  http://sftpadapter.codeplex.com/

    in reply to: HL7 BTAHL72XPipelines.BTAHL72XSendPipeline error #21910

    Did you define the message parts properly?

     

    in reply to: Orchestration assembly size #21909

    Hi,

    So did you figure out that the performance was related to the large assembly size ?

    Are there any articles from MS that might validate this?

    thanks

    in reply to: debatching a schema into xml’s in expression shape #21901

    so if I do this will it work  to get the header record and the element values under it?

    Variable_1 = System.Convert.ToString(xpath(SQLMessage, “Count(/*[local-name()=’TEMS_SQL’ and namespace-uri()=’http://TEMSInt.Schemas.TEMS_SQL’%5D/*%5Blocal-name()=’Record’ and namespace-uri()=’http://TEMSInt.Schemas.TEMS_SQL’%5D/*%5Blocal-name()=’Header’ and namespace-uri()=’http://TEMSInt.Schemas.TEMS_SQL’%5D)”));

     

    Thanks

    in reply to: debatching a schema into xml’s in expression shape #21899

    If I select a Record in the xpath expression do I get the elements and there values under it .

    in reply to: Transform Shape :S #21898

    Yahooo !!! i resolved the issue, since it was a runtime exception and its source was Microsoft.XLANGs.Engine
    Target Site: System.Xml.XmlDocument AggregateXmlDocuments, i disassemble the dll and looked for this particular method and found that the exception will occur if  any of the input xml has the xml declearation and that is because it considers xml decleartion as a root and hence it says

    “Error:Invalid input/output document into/from the transform. Does not have a single root node..”

    So in my case i changed my custom xslt to exclude the xml declearation and here we go transform starts to working fine ….

    Thank you everyone for your time and thoughts.

    Thanks,

    Syed Abdullah AKhlaq

    in reply to: Transform Shape :S #21897

    is it possible to see what input msg Transform shape has recieved ?? i mean what multipart msg it has created with 2 inputs ?

    in reply to: Remote Administration Console #21896

    Thanks, it worked.

    Anderson

    in reply to: Transform Shape :S #21894

    Post the sample files and schemas

    in reply to: Transform Shape :S #21893

    nop [:(]

    in reply to: debatching a schema into xml’s in expression shape #21892

    you will have to create nLoopCount and nRecordCount as integer variables. sXPath as a string

    On the expression shape, get the number of records

    nRecordCount = System.Convert.ToInt32(xpath(msg, “count(//item)”));

    “msg” being the main message  and “item” being the record;

    drop the loop shape below the expression

    The loop expression should be: nLoopCount <= nRecordCount

    Drop the message assignment within the loop. create the single message and do what you want with it.

               sXPath = System.String.Format(“//Data[{0}]”,nLoopCount);

               SingleInput = xpath(Input, sXPath);

     

    in reply to: debatching a schema into xml’s in expression shape #21891

    Hi For me the project in the zip file is not working it say projects unavailable I just need the code in the expression shape on how to create a xml document for a record from the original message.

     

    Thanks

    The disassembler has no way of knowing how big the last element (VerkoopWijze) will be – you probably have it defined as a string with no restriction.

    If you know how long that element will be (say, it will always be 1 character long), you can select the element, and in the properties change the “Derived By” to be Restriction, then change the Maximum Length property to 1, then use an xml validator component on the same pipeline as the flat file disassembler. This way you would get a message like this from the xml validator:

    The ‘VerkoopWijze’ element is invalid – The value ‘V;-1114,00;QW’ is invalid according to its datatype ‘String’ – The actual length is greater than the MaxLength value.

    in reply to: BizTalk Installation #21887

    Hi there,

    There are a few guides out there for BizTalk high availability and load balancing. The BizTalk Operations Guide has a great section on high availability which at the same time gives you load balancing:

    http://msdn.microsoft.com/en-us/library/cc296682.aspx

    In a simple explanation, BizTalk load balanding is provided by having its server components installed on more than one server that are part of the same BizTalk group – the first BizTalk installation you create the group and the BizTalk databases, and on the other server(s) you just join that group. BizTalk then has a central SQL Server database (the message box database) that all the BizTalk servers in the group look at, and then any of the servers can pick up pick up work to do from the message box database. You don’t typically need to cluster BizTalk servers for it to be load balanced. You do cluster the SQL Server hosting the BizTalk server databases though for high availability. MIrroring isn’t supported for BizTalk database backups because BizTalk applies distributed transactions that span across multiple databases. For messages being received via HTTP you need to load balace IIS on the BizTalk servers involved as well, but it sounds like you already have the switch for it.

    What servers to use would depend a lot on the existing load of your servers – you could consider installing BizTalk on your 2 application servers, but only if they are very under utilized.

    I’d recommend contacting Microsoft or a Microsoft integrations partner for some input on your specific situation.

     

Viewing 15 posts - 3,091 through 3,105 (of 9,648 total)