Forum Replies Created
-
AuthorPosts
-
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.
There is a third option, use an open source adapter: http://sftpadapter.codeplex.com/
Did you define the message parts properly?
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
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
If I select a Record in the xpath expression do I get the elements and there values under it .
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
is it possible to see what input msg Transform shape has recieved ?? i mean what multipart msg it has created with 2 inputs ?
Thanks, it worked.
Anderson
Post the sample files and schemas
nop [:(]
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);
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
March 11, 2009 at 2:04 AM in reply to: FlatFile Disassembler eats almost Everything (and that’s not what i want)…. #21888The 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.
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.
-
AuthorPosts