Forum Replies Created
-
AuthorPosts
-
Hi,
Kindly provide biztalk interview questions. This interview is for BizTalk Developers with 6mths – 2 years of exp.
Thanks
Or if you declared the method static e.g. static void ToRun(parameter1) you will not need an instance of the class in the orchestration.
You can also do this in the orchestration.
Declare a orchestration variable of type XmlDocument
Assign the message you wish to store to this variable.
Then assign the OuterXml string of this variable to the nText field in the SQLMessagexmlDocVar = MessageToStore;
SQLUpdateMessage.nTextColumnField = xmlDocVar.OuterXml;Make the nTextColumnField a distinguished field or you can use the xpath function to assign the value. Do not make nTextColumnField a promoted property as this limits the size to 256 bytes.
I’d probably use a helper .net class and call it inside the Orchestration. This way, I’d just use pure .net to insert the Xml into any column type you like in SQL.
Thanks Greg for your reply.
Let say I set my db column to ntext and I use the standard sql adapter, how can I store the whole xml in a column?
From what I have seen, the sql adapter send port is normally used to match a message field with a table field. In my case I want to match a whole message with a table field. Do you have an example or a description of the process to achieve that?
Thanks
I don’t know if this was the best method.. but I did it as follows.
Read in via SQL Adapter.
Send via pipeline the content to a flat file schema.
Retrieve via pipeline the flat file and parse to new schema.Probably not optimal.. but only way given my skill set to get it completed.
pull the ports out of the group and they will work fine
you could try creating a pipeline with a ffdasm and call it from your orchestration.
That is exactly how you would do it. There are of course a few things you need to do in order to get this working fine in your solution.
first, declare a orchestration variable of the type of your class, This takes place of the declaration in a C# app. (ie. string something;)
Then, in an expression shape, simple create a new instance and use as you would normally.make sure that your class is serializable or you will need to put this expression shape in a scope
I am new to BizTalk. I have BizTalk installed on a server via our IT department. I have RDP access and I am developing on it directly (its RD box not production). I want to install compnents on my local machine so I can develop in VS 2005 to the remote biztalk.
When I installed what I thought off the CDs it installed a BizTalk server on my machine. Is there just client tools to add into VS 2005?
Thanks.
hi
i created the dummy send shape, initialized the correlation in that shape and i was able to build the solution without any error. Now i have another after deployment. When i resend the request, the orchestration is not able to identify the response message from the MQ. It gives me a subscription error. I get this error.
\”The Messaging engine failed to process a message submitted by adapter MQSeries Source Details:
Could not find a matching subscription for the message.This error occurs if the subscribed orchestration schedule or send port has not been started, or if some of the message properties necessary for subscription evaluation have not been promoted\”
Have you faced this problem?
Thanks
SajI’m using BizTalk 2006 final version!!! Not an option!! :p
I’m not really understand your problem (going to read it again), but for indentation use the \”[code] [\\code]\” tags, without the quotes!
Read the Microsoft article!!! 🙂
It’s not an SQL table, it’s a simple MS Access database table.
It’s location by default is:
C:\\Program Files\\Microsoft BizTalk Server 2006\\EDI\\Adapter\\CodeLists\\EDICodeLists.mdbI forgot to mention that on the schema file you have to configure it and say that the codelist database is located at the path I referred.
To do this click on the <Schema> node and on the properties under Biztalk you have a field named \”codelist database\”.[quote:4809a0cffb=\”myPFerreira\”]I have a D96A (EDIFACT), but as you figure I’m not allowed to make it \”public\”.
But the Microsoft article is very clear.
1 – New project with an Ochestration with a receive (set to receive a file) and a send shape (set to send XML)
2 – configure the two parties (one with the sender and other receiver id codes)
3 – Create the schema (use an existing standard and modify it, see the stylusstudio page to see the structure you want, or if it’s !your own structure build it according to the rules on the article apge)
4 – Build the a table with you codes and values on the codelist database
5 – configure ports,and you are good to go.I think I’m not missing nothing.[/quote:4809a0cffb]
A question on point number 4… what’s the a table? and where to find it? Is is in the BizTalkEDIDb database…
thx
-
AuthorPosts