Forum Replies Created
-
AuthorPosts
-
Hi Daniel,
After schemas and binding files generated – also creted an empty orchestration. That orchestration has definitions for multpart messages, which are look like “SomeLongName_Input” an “SomeLongName_Output”. Their parts defined of type one of schemas which were generated.
For not keeping dosens of objects – I created one empty orchestration for definition of multipart types and port types for all my WCF services. And every such “SomeLongName_Input” and “SomeLongName_Output” defined according to WCF request schema. (Actually what WCF expects to “see on request”).
Those multipart types have in my case only one part, and except mapping which I hope to solve soon – all other stuff – works.
Maybe it has connection to type in schema definitions, cause I have three different projects – Schemas, Maps and Orchestrations, which are referenced to each other.
May 21, 2010 at 1:49 PM in reply to: Microsoft.XLANGs.Core.XlangSoapException: Server was unable to process request. —> The event log file is full #24772Hi,
See if this Eggheadcafe thread helps you with resolving this issue:
http://www.eggheadcafe.com/software/aspnet/30641849/cannot-configure-biztalk.aspx
Daniel.
Hi,
The error message “The EXECUTE permission was denied on the object… ” tells you that the account you are using, to connect to the BizTalkMgmtDb and run SQL statements, does not have permissions to run stored procedures. What is the context and scenario that you are in to cause this error message? Are you running a WMI script, a console application, etc.? If you make that account a member of the BizTalk Administrators and Operators groups, that should solve your issue.
Daniel.
Hi Yonathan,
How did you define your multi-part message in your orchestration in step 5? If each part’s type is defined with an actual schema, not a .NET type, then you will be able to select that message in a Transform shape in your orchestration.
In any case, you will not be able to pick that multi-part message as a source or destination schema in a BizTalk map.
Hope this information helps,
Daniel.
Hi,
Yes, you can use BizTalk in that scenario to pass data (coming from a call to Web Service 1) to Web Service 2, but it’s an overkill for that scenario, unless you do some transformation on that data (this is where BizTalk comes in handy). If there’s no mapping involved on that data, I would suggest just building a console application to consume both web services, that would be simpler.
Daniel.
The agent was not runing. I started it and soon after they were gone. Thanks.
I want to show the incoming file url and once user clicks it should take to that place
May 20, 2010 at 4:07 PM in reply to: Polling Oracle procedures with the Biztalk Adapter Pack V2 #24763I eventually found a solution to my question.
VS generates 3 schema’s for a package. One is the response, one is the request (“polling statement”) and the other contains the “polling action”
Once you’ve put in your statement and action, the adapter will recieve the data as if you are running the procedure directly, though you cannot just use “exec package.procedure()”
Hi,
Look up my bio on BizTalkGurus and under “My Files” section, there is an image named “mapsample.png”, click on it and see if this example of a BizTalk map can accomplish what you are looking for…
Daniel.
You could look at the new Query Notification capability with the WCF SQL Adapter:
http://seroter.wordpress.com/2009/01/12/query-notification-capability-in-wcf-sql-adapter/
Rather than OpenXML you should check out XQuery functionality: http://articles.techrepublic.com.com/5100-10878_11-6140404.html
Hi Sir,
Because current design requires Biztalk consuming WCF service. On WCF service, I implement one function to insert single DTO to database. So If I insert multiple records a time, I must design WCF again. I think should I use OpenXML to insert muntiple records?
Thank you so much
One issue which I just discovered in work with this.
Order number ( <Item Value=”ORDER NUMBER” CtrlID=”18″
SectionID=”15″ /> it is mapped with <Order_id>) exists only
one in Input file and it is not problem with the mapping for
OrderHeader.The problem starts with OrderLines, in that case namely I must
mapped this Order Number which showed only one in Input file into every
row of OrderLine because every order line also have a tag
<Order_id>.Can somebody maybe also help with this issue.
Thanks in advance.
I think that I am on good way to find solution and figoured out how this can work.
Namely I did next :
Added a looping functiod with an incoming link from Item, then an outgoing link to each of the elements (Order\OrderNo, Order\CustomerNo, etc). Then for each unique CtrlID, added an Equal functoid and a Value Mapping functoid. The Equal functoid have an incoming link of the Item\CtrlID and a static value. The Value Mapping functoid have an incoming linke of the Equal functiod (this must be first), and then the Item\Value element link. The Value Mapping functoid then map to the Order\OrderNo element on the outgoing schema. This repeat for all outgoing elements that need to map.
Namely this works fine for Order Header when I have only one row but the problem is with the Orders Line when I should to have more than one rows.
When I apply the same solution for the OrderLine part than I got this error message :The adapter failed to transmit message going to send port “SendPortOrder” with URL “C:\Documents and Settings\Administrator\Desktop\PROJECTS\Solution_4_29-09_11-00\out\%MessageID%.CSV”. It will be retransmitted after the retry interval specified for this Send Port. Details:”Unable to read the stream produced by the pipeline. Details: Cannot find definition for the input: LINE_ID “.
It means that I have more Items with the same CtrlID in input.
Do maybe have idea how this can work with the OrderLines where I have more than one lines.Once again thanks.
Thanks Greg. Encoding works great!
-
AuthorPosts