[community-content]

[quote:5229962d2d=\”nickka\”]Covast is telling me that I don’t need the recipient and if I have only the sender it works for one document.

The failing document doesn’t work if I have both sender and recipient. I set:
Sender: EDI://619448418:01:
Recipient: EDI://MAGATT:ZZ:[/quote:5229962d2d]

That is strange, on the contact I’ve been having with EDI files (EDIFACT), I always need two parties configured. One as a receive and the other as a sender.

But, is your problem solved?

[community-content]

Hey Man,

It was much easier then i expected.

Inside vs.net, created a biztalk project, added new item, under the window that comes up, select – Pipeline Files, and then Send Pipeline

This will add a new file of type .btp to your project,
inside this file under the ‘Assemble’ Stage, I added a ‘Flat file assembler’ from the toolbox.

** Added a reference to my schema file.

In the Properites of the added ‘Flat file assembler’ – under Document schema, i selected the appropriate schema.

Changed the Target charset to be ASCII (20127),

built and deployed the application to my Biztalk application.
Inside BizTalk Application Console, under my Biztalk Application -> Send Port -> Send Pipelines -> I selected my newly created Pipeline.

Everything works and my outfile is now delimied as expected.

Thanks,
–Steven

[community-content]

Hello and thanks for any assistance.

I have a schema with an Attribute defined as such:

<xs:attribute name=\”FirstName\”>
<xs:simpleType final=\”restriction\”>
<xs:restriction base=\”xs:string\”>
<xs:maxLength value=\”10\” />
</xs:restriction>
</xs:simpleType>
</xs:attribute>

When i use biztalk map to map another schema to the schema with the above defined attribute (maxLength=10), if the length is greater then 10 NO error is generated and the value will be transformed over into the schema.

So in other words it’s like no validation occurs and any value can be mapped into the field regardless of size.

What gives? Why would this be allowed, am I missing something? Has anyone run into something like this before?

Thanks,
— Steven

[community-content]

I want to store an xml file into database.
I have created a message and assign it to a stored procedures input parameter.
the sample code is in message assignment is

vardoc = POMessage;// vardoc-xmlDocType variable..
and Pomessage is schema type

rawstring = varDoc.OuterXml(); //rawstring is string variable

OutDoc = \”<Xsd attrb=rawString>\” //Outdoc is xmlDocType variable.

ProcedureInParameter = OutDoc.
////———-
Here I get an Exception as

‘<‘ hexadecimal value 0x3c is an invalid attribute charactor.

Exception type :XmlException
Source: System.Xml
TargetSite : Boolean.scanLiteral()

Can anyone sort this out

1. First use an Ascii chart to find out what is 0x3c.
http://www.lookuptables.com/ – shows it is the less-than < sign.

2. I’m not sure why you are using the variable OutDoc.
Is OutDoc the name of your message?
I don’t understand the right side of your equal sign on the OutDoc statement at all. You don’t concatenate in \”rawString\” – you just have it as a literal. I don’t know why you have the xsd and attrb either.

Seems like you need something like this:
mySQLMessage.xmlString = rawstring;

where mySqlMessage is the message you are constructing, and xmlString is a distinguished field that will pass the xml string to the stored. proc.

Neal

[community-content]

Hi all,

I’m new in BizTalk 2006. I have the same problem. I need to convert simple XML file to delimeted Flat File. I will be very gratefull for any example or explanation how to do that.

Best regards,
Georg

[community-content]

Hello,

I’m playing with biztalk 2006. I create an orcherstration which receives xml files( infopath). In mij scenario i want to convert these files to an excel or word file. Is there an solution to perform this?

I think this is usefull for many people. For me it’s just playing. In excel 2003 is an option to import xml, but this isn’t i want. I want to create an excel doucment in biztalk and save it to an location. I think that’s the excel solution looks like word solution.

Thanks,

[community-content]

Hi All

I am a newbie using biztalk 2004 to develop a simple project. I have following inbound message..

<Orders>
<Order>
<ID>1</ID>
<Success></Success>
</Order>
.
.
.
<Order>
<ID>6</ID>
<Success></Success>
</Order>

</Orders>

I want loop the order node and send order id to a web service and put the modify the success node value. The final output should be like this:
<Orders>
<Order>
<ID>1</ID>
<Success>NoStock</Success>
</Order>
.
.
.
<Order>
<ID>6</ID>
<Success>OK</Success>
</Order>

</Orders>

Anyone has some similiar sample, could you email me at [email protected]

[community-content]

Thanks Stephen.

The problem is solved since the other application will pick the message.

One more question I have. How to check the message is stored in the MessageboxDB? which tables we have to check there?

Thanks

[community-content]

[quote:c78cf67f8f]2006-07-18 19:36:12.80 spid3 Warning: override, autoexec procedures skipped.
2006-07-18 19:36:30.58 spid3 SQL Server is terminating due to ‘stop’ request from Service Control Manager.

any idea how I fix this? I have already installed the analysis component and the sp3a for both. [/quote:c78cf67f8f]

I don’t know why you are getting this problem. Where do you see these errors, in the Event Log, or the Biztalk install Log?

[quote:c78cf67f8f]SSOADMIN userid? [/quote:c78cf67f8f]
Security can be very granular or very broad. I would suggest at minimum you have one separate userid for SSO on the install.

[quote:c78cf67f8f]I was wondering would I be able to accomplish what you suggested above on the windows XP platform? Do I need BAS for building an InfoPath form?[/quote:c78cf67f8f]

InfoPath works fine with flat files.

[community-content]

[quote:425b265e04=\”nwalters\”] So you will build a schema then start mapping (there is an example of a flat file schema on my videos). Yes, your example sounds similar (maybe the Bank/Loan Broker scenario?). Yes, you can do it all with flat file folders. Then later, if you want to be fancy you get build an InfoPath form.

Neal[/quote:425b265e04]

Hi,

I am still having loads of troubles with the windows server 2003 installation. I was wondering would I be able to accomplish what you suggested above on the windows XP platform? Do I need BAS for building an InfoPath form?

PP

[community-content]

My Receive Location is set to another server and I get this error. How do I correct this?

Event Type: Error
Event Source: BizTalk Server 2006
Event Category: BizTalk Server 2006
Event ID: 5753
Date: 7/19/2006
Time: 3:26:00 PM
User: N/A
Computer: GV-COMPUTER
Description:
A message received by adapter \”FILE\” on receive location \”VTNS_IN\” with URI \”\\\\myserver\\data\\processing\\vtns\\native\\*.*\” is suspended.
Error details: There was a failure executing the receive pipeline: \”Covast.BizTalk.Pipeline.EDI.CovastEDIReceivePipeline, Covast.BizTalk.Pipeline.EDI.Default, Version=5.0.0.0, Culture=neutral, PublicKeyToken=68bef120a46b49ad\” Source: \”Covast EDI Disassembler\” Receive Port: \”VTNS\” URI: \”\\\\myserver\\data\\processing\\vtns\\native\\*.*\” Reason: Attempted to read or write protected memory. This is often an indication that other memory is corrupt.
MessageId: {A1A77BE5-926C-475D-959D-2B155F8B42B9}
InstanceID: {9A7ACF1E-F769-45B5-9FD2-94FB3F5242AC}

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

[community-content]

You’ll want to make sure you use a \”Flat File Assembler\” component in an send pipeline so that your XML content can be converted into a flat file.

[community-content]

Covast is telling me that I don’t need the recipient and if I have only the sender it works for one document.

The failing document doesn’t work if I have both sender and recipient. I set:
Sender: EDI://619448418:01:
Recipient: EDI://MAGATT:ZZ:

[community-content]

You have to have two diferent parties configured. One with the receive identification, the other with the sender identification.

You probably have the sender id wrong.

[community-content]

That’s not possible. You need to have a subscriber in order to publish a message to the message box.

What are you trying to accomplish? Why do you just want the message inside the message box?

Hope this helps.

[Author]

Posts