Forum Replies Created
-
AuthorPosts
-
Hi Anonymous,
I got the same problem in other scenario, i guess the file adapter makes this problem for not removing the file on error,
My solution was to check on the File Renaming under Advanced settings . That way (as i saw ) the file deleted .
Good luck
A&M IT
If your product line and serial number line are sibling records then you will need to use a custom Xslt and the xsl:key element.
However, an easier way may be to change the flat file schema.
Header record
Invoice A header record
Line
Product 1 for Invoice A record
Serial Number record for Product 1
Line
Product 2 for Invoice A record
Invoice B header record
Line
Product 3 for Invoice B record
Serial Number record for Product 3i.e. create a Line record which has a child Product record and an optional Serial number record.
In the map connect the Line record to the Looping functoid to the output record.
Reply to same post here .. http://www.biztalkgurus.com/forums/thread/7541.aspx.
Another solution that works is after the loop is over to have another loop with the same correlation set(following) to drain these instances for a certain amount of time ( DRAINING ). You can do this before or after you send out the final message . in the latter case you can send these drained ones as a second message or log them as errors .
The Oracle adater does not support User Defined Types or Reference Cursors.
You might want to consider querying a view.
I use the BizTalk 2006 plugin for MOM. You can setup notifications for Oracle Adapter Exceptions.
Reference cursors are not supported. Neither are User Defined Types.
Hi,
Did you find a solution.?
AddNoteRequest is a message that is being setup for a Web Service. ".text" is one the exposed properties for the Web Service call.
The NoteDto message refers to a simple flat file schema. There is only one "Note" node per NoteDto message. Neither of the messages are multi-part. AddNoteRequest.text is not a distinguished field since it is part of the Web Service call, but the "Narrative" attribute is a distinguished field at the moment.
When I dump the NoteDto message back out to a flat file after the construct message shape completes, the value of the attribute I'm trying to extract is there the same as at the start.
I've tried setting .text to some literal string and it works fine, so it has to be with the xpath query I'm using.
Thanks
Thanks, that took care of it.
Wait, what is "text" on AddNoteRequest? Is this a multi-part message? A distinguished field? Make sure you also provide a string/number conversion for the node you're extracting (see Stephen's post here .. http://www.geekswithblogs.net/sthomas/archive/2004/10/25/13269.aspx).
Description of them … http://msdn2.microsoft.com/en-us/library/ms965489.aspx. Examples in the SDK installed with BizTalk as well ..
Thank you for your help.
I am looking for documents or tutoirals about "Functoids in biztalk" with
exsamples. Do you know any site where I can learn about Functoids? I never
used Functoids before, I am new to Biztalk.Siva
Thanks for the tip on the Instance XPath property.
When I put the value from the Instance XPath property in my xpath query, I get the following error.
Inner exception: The part 'text' of message 'AddNoteRequest' contained a null value at the end of the construct block.
Exception type: NullPartException
Source: Microsoft.XLANGs.EngineHere is the line in my Message Assignment shape that generates the error.
AddNoteRequest.text = xpath(NoteDto,"/*[local-name()='Note' and namespace-uri()='http://FlatFileTest.Notes'%5D/*%5Blocal-name()='Narrative' and namespace-uri()='']");
I double-checked my file and found no null characters in it.
The Microsoft KB says that the NullPartException comes from one orchestration calling another. This is not the case in my scenario.
I appreciate this help, but I'm still stuck.
Thanks!
Also with the schema specified by greg, you can keep the max occurs to 1 so that it cycles everytime the delimeter is detected.
-
AuthorPosts