Forum Replies Created
-
AuthorPosts
-
July 19, 2013 at 6:03 AM in reply to: Failed to connect to the SQL database SSODB on SQL Server #26104
Thanks!! [:)]
Looks like some issue with permissions. Even I face the same error.
Hi Praveen,
As i understand you get the error at the time of configuring BizTalk runtime itself.
Hello All,
Could you kindly help me on this?
Thanks,
Praveen
July 16, 2013 at 7:50 AM in reply to: BizTalk Mapper only returning first row to destination schema #26099Well, I deleted and re-made the source schema and now everything works with the straight 1 to 1 links. No functoids required. Not sure what the difference was or if it was just a bug but it's working now.
July 16, 2013 at 7:34 AM in reply to: BizTalk Mapper only returning first row to destination schema #26098That doesn't work, tried a table looping functoid as well. I'm kind of glad the looping functoids didn't work because that would have been a confusing solution since I've never needed to do that before in similar situations. I'm starting to think this is a mapper bug. I have no idea why it won't map the other records.
I've done countless 1 to 1 mappings and never needed to use a looping functoid. Also, I just created a quick test in another project and was able to do a 1 to 1 mapping with 2 very similar schemas and every record came over with no functoids.
Is this a mapper bug?
July 12, 2013 at 2:10 PM in reply to: BizTalk Mapper only returning first row to destination schema #26097You need to put a looping functoid on the parent records
That last part:
"When an ACK or NACK is published, all of the message context properties from the message that caused the ACK/NACK are demoted."
Was what I needed to know. Thanks for the help. I'll just have to accept every ack/nack from every port set to us it and then end the orchestration when certain criteria aren't met I suppose.
Hi,
See the following article for a list of properties from the BTS namespace that you can use to build a filter:
http://msdn.microsoft.com/en-us/library/aa559421(v=bts.10).aspx
I suspect that the reason why you cannot promote the property AckProcessOriginator comes from this statement:
“When an ACK or NACK is published, all of the message context properties from the message that caused the ACK/NACK are demoted.”
Good luck.
July 8, 2013 at 12:44 PM in reply to: Biztalk templates showing under Visual F# and not under Visual C#. #26089Hi,
Do the following actions below, to revert to C# development settings in your Visual Studio IDE (assuming you have VS 2010):
1. Open Visual Studio 2010, in the menu options, go to Tools -> Import and Export Settings…
2. On the first screen in the Import and Export Settings Wizard pop-up window, select the bottom option “Reset all settings” and hit the “Next >” button
3. On the second screen, choose the bottom option “No, just reset settings, overwriting my current settings”, and hit the “Next >” button
4. On the third and final screen, choose the option “Visual C# Development Settings” from the collection of settings in the listbox and hit the “Finish” button
You should be all set then. Good luck.
Hi,
Please see the following MSDN article on showing you a sample implementation of performing operations on tables with large data types:
http://msdn.microsoft.com/en-us/library/dd788326(v=bts.10).aspx
Also, be aware of the limitations of Oracle Adapter:
http://seenstechs.blogspot.com/2012/12/biztalk-oracle-adapter-limitations.html
I hope this helps.
Hi,
To fetch data from Oracle through the BRE, I suggest you go through the instructions laid out in this blog:
http://thirteendaysaweek.com/2010/06/15/using-oracle-data-in-the-business-rules-engine/
Regarding the messaging scenario without orchestration, you can look into using a MSMQ adapter with a custom receive pipeline component that calls your BRE policies. Here’s another blog that shows you an example of such an implementation:
I hope this information can get you started and heading in the right direction.
Good post from Rohitt Sharma on how to do this:
rohitt-sharma.blogspot.co.nz/…/how-to-initialize-correlation-set.html
June 21, 2013 at 6:53 PM in reply to: How to set a default value to an destination schema element in BizTalk Map #26081public string myScriptMethod(bool equalFunctoidValue, string sourceSchemaString)
{
if(equalFunctoidValue)
return sourceSchemaString;
else
return string.Empty;
}
June 21, 2013 at 6:32 PM in reply to: How to set a default value to an destination schema element in BizTalk Map #26080Yep!!! Awesome! Solved my problem too 🙂 Thanks Akabuilo!
-
AuthorPosts