Forum Replies Created
-
AuthorPosts
-
[quote user="bizCT"]hi I have following flat file and trying to create schema out of it.. HEADER123456 ——> header info 123444 test1 test2 test3 ——-> Child records seprated by null value , observer there is not tag identifier 323445 test2 test4 test5 423446 test3 test6 test7 I created schema with root records Strurcture : Delimited Child delimiter: 0x0D 0x0A ( CRLF) Child delimiter Type: Hex Child Order: Infix Header record properties Sturcture : positional Detail record: Sturcture : positional After above all properties set , when try to validate input file give following error: error BEC2004: Unexpected data found while looking for: Positional data (length is 23) Can some please throw some light where i’m doing wrong… Thanks [/quote]
Can you please repost your message with some formatting. It is too hard to decipher your message structure
A BizTalk messages are effectively multipart messages. The have the following structure
Message
MessagePart: data
MessagePart: data
MessagePart: dataThe data elements are totally separate. You can have a multipart message with Xml in the first part, an image file in the second part and a flat file stream in the third part. These parts are NOT aggregated into a single Xml.
In your orchestration you create a multipart message as I described above, then in your custom pipeline component you can create a new message part for your zip stream. Then iterate over the attachment message parts add them to your zip stream and remove them from the message, finally add you zip stream message part to the message.
You forgot to add prefix in template name line.
Check post "mapping" from yesterday
Hi Greg,
As you described aboove. I dont want to aggregate multiple messages into a single message. Just to add all the incomming messages as it is to a zip file. I am using one custom pipeline to for zipping at the send port. At the begening i thought of using multi part messages. but i know multipart messages will aggregate all incomming messages to a single message, which i dont want. And all the incomming messages are of same message type but contains different error messages.
Thanks for your reply. And waiting for a suggestion on this.
Regards,
Ram
August 17, 2010 at 12:23 AM in reply to: Passing Hardcoded values and manipulate data b4 passing it on to database table #25652Please suggest something guys.
Have you tried xcopy: http://en.wikipedia.org/wiki/XCOPY
I wouldn’t use a long running orchestration. You would need to implement some message at an interval to start this orchestration, you never know when it may stop. You might as well use this trigger to initiate a short running orchestration to down load the file.
There are a number of scheduling patterns available: http://geekswithblogs.net/michaelstephenson/archive/2008/05/16/122203.aspx
I use the Scheduled Task Adapter here: http://biztalkscheduledtask.codeplex.com/Another consideration is the Http method being used. Are you using a GET or a POST? If you can browse to the file using a browser then it is probably a GET. The HTTP adapter does not support Http GET only Http POST. The scheduled task adapter has an HttpDownload task that will perform an Http GET to download a file.
Hi,
As for me – I prefer to call external assembly as much as possible. Don’t like to see “strange” code in orchestrations.
Hi,
One I was working at one of my customer’s site – I saw such an error:
This was happening in a case if one of parameters of incoming message wwas empty (is I remember correct) or null, the SQL statement which should be executed – was “shortening”. i.e. the parameter is null = the field didn’t appear in message sent to DB2.
The solution to problem was scripting functoid: if field in incoming message is empty – pass to outgoing message empty string or default value.
I need to poll the URL at regular intervals to receive XML docs that will contain multiple messages.
Would the best solution be to create a long running orchestration looping at a set time interval, and receiving the XML documents for processing by another orchestration? Probably with a solicit-response port by passing a dummy XML document to the URL, enabling me to receive the partners XML?
Any response appreciated.
Thanks Greg. It’s working great. You are the best!
August 16, 2010 at 8:06 AM in reply to: How to handle large size attachment in Biztalk while consuming SOAP request #25641Hi,
If your purpose is to just send these two files to the FTP server, why not just send them directly to the FTP site (from your web application) and bypass BizTalk altogether?
If you use BizTalk to split the SOAP message into 2 parts, there’s going to be processing involved, unless you use the PassThruReceive pipeline, but then you would have to send those two parts separately anyway.
You might want to reconsider the design of your scenario,
Daniel.
Hi Yonathan.
Yes, I used the exact Xpath copy of the field property of the schema. I think the best way will be to use an external assembly. But first I will give it one more try to programm it in an expression shape. Just to see how I have to programm in it. 🙂
Thanks so far.
Wolfgang
August 15, 2010 at 8:40 PM in reply to: Double calling of Web Service in Active-Active Clustering of BizTalk 2006 R2 #25636Hi Daniel,
Thanks for the link. But I think it doesn’t really help my case. Anybody experience the same issue?
Regards,
AH
Hi dungan,
You can’t change that setting in the flat file schema wizard, so your best bet is to use an instance file that is smaller in size, less than 1 MB.
Daniel.
-
AuthorPosts