Forum Replies Created
-
Posts
-
Actually, what I want to do is to build a system that will take clients’ survey specifications (flat file), check and save to database. There will be another program which will build survey forms (Adobe) based on these specifications. The survey forms are then sent to respondents. Respondents fill out the forms and send back to the system where survey results are parsed and save to database. Finally survey results are converted to flat file or xml to send back to clients.
Biztalk and Adobe are chosen for this project. Biztalk acts like a parser, taking in specifiations, sending survey forms to respondents, parsing the results received from respondents and sending confirmations/reminders to respondents.
So do you think Biztalk is the right tool for this kind of project?
Hi JMan,
I was a little lost writing my first Business Rules .net class and implementing the IFactRetriever interface – but I found a great sample on this very site that helped me get started.
http://www.biztalkgurus.com/Samples/BizTalk-Business-Rules-In-Code.html
Basically you have to create your class(es) and then a fact retrievier class that implements the IFactRetriever interface so the Business Rules Engine can access the data in your class. You won’t need the interface when you move the business rules into your orchestration. I read descriptions like this many times and still didn’t understand what to do until I saw this sample. Hope this helps!
Regards,
CodyI don’t remember the error correctly, but it’s now working!
It was something to due with accessing permissions… on the internal folder that biztalk uses!
Deleted all files, and recompiled the project, it went ok!You can also manually load a PDB file. As soon as you attach, break into the process, then open the Modules window (from the Debug->Windows menu), select the assembly you’re interested in, right click and select Load Debug Symbols. It should let you select the PDB file to load.
You coiuld use a Dynamic send port on your orchestration to do this. There are several examples out there of using dynamic ports with the SMTP adapter. Here’s one:
http://www.winterdom.com/weblog/2005/08/15/SMTPAdapterInBTS2006AndHTMLFormattedMessages.aspxThat said, do realize that BizTalk is not the tool if all you want to do is extract a big bunch of email addresses from a DB and start doing a mass mailing. If this is what you want, since you already have the data in the DB, I’d look at maybe leveraging SQL Server Notification Service.
Dayo,
Are the web/biztalk server and the db server different machines? If so, is the account you’re using a domain account?
What I might reccommend is to maybe enable failed login auditing on the SQL Server, maybe that way you’ll see what account it is trying to connect as, and that should give you a clue as to what is configured incorrectly.
[quote=\”NISHIL\”]First let me know \”changes in source Sql table\” means what.
Did you meant changes in design…if so then biztalk cant help you.
If you meant changes in data…insertion or deletion or updation of data then you can easily reflect it in the other table using Sql adapter at both ends. See Sql adapter depends upon the Stored procedure you call. So if you stored procedure can sense the changes then you can reflect it or else youll have to handle it inside orchestration that what is to be done….So be clear with the requirements. In any scenario you need the primary key of one column…..and the operation to be performed…Just concentrate how would you get these 2 things.Regards
NISHIL
http://biztalkblogs.com/nishil/default.aspx%5B/quote%5Dlike this: testdb testtable(a int, b int, c char)(exp:(12,23, a))–>desdb destable(c int, d int, e char)(the result is (12, 23 + 10, ab))
maybe, jan want to get this example.
iwant to ask you how i should do : sql adapter -> select statement(port type)-> select a, b, c from testtable(how to write the statement in the window)Hi
I get the following 3 errors within the application event log:
An attempt to connect to \”BizTalkMgmtDbDev\” SQL Server database on server \”nsccorp1\” failed with error: \”Cannot open database requested in login ‘BizTalkMgmtDbDev’. Login fails.\”
——————————————————————————-
The Messaging Engine failed to register the adapter for \”BizTalk HTTP Receiver\” for the receive location \”/WebSiteRoot/BTSHTTPReceive.dll\”. Please verify that the receive location is valid, and that the isolated adapter runs under an account that has access to the BizTalk databases.
——————————————————————————-
BizTalk HTTP receive adapter failed to initialize itself. Possible reasons:
1) Receive location URL is not created/configured correctly
2) Receive location is not enabled
3) HTTP receive adapter is not running under a user that has access to management and message databases
4) Isolated host instance is not created for HTTP Receive adapter.
——————————————————————————–My site \”WebSiteRoot\”, is within an Application Pool whose identity is a member of both the \”BizTalk Isolated Host Users\” group and the \”IIS-WPG\”. So it should have access to the BizTalk databases on \”nsccorp1\”.
What do you think?
CheersHi,
I have created a c# class lib which has the attribute [DistinguishedFieldAttribute]. I have added
using Microsoft.XLANGs.BaseTypes;
I beleive I miss some assembly reference. Can any one help me out.
[Err]
The type or namespace name ‘XLANGs’ does not exist in the namespace ‘Microsoft’ (are you missing an assembly reference?)
The type or namespace name ‘DistinguishedFieldAttribute’ could not be found (are you missing a using directive or an assembly reference?)
[/Err]
Thanks for the information. Very helpful!
rseroter…we are preparing to go to Tools 8.95. Could you verify support?
Thanks!
Here’s one more chunk of info –
I display the message before after the delay (where I shutdown biztalk), and it’s actually ok there. This is all inside a loop, and it’s at the beginning of the loop where the message first appears bad.To complicate matters, I’m passing a message by ref to a called-orchestration. It adds to this message, but when we come back from the sub-orch and display the message it looks fine.
I added a two-minute delay, and also shut-down Biztalk during this delay.
Immediately after this delay, the message is wiped out – even when I did the following:
1) added a dummy atomic scope after displaying the message coming back from the sub-orch.
2) added a send shape and send the message to our dummy port (that we use to init. correlations). The message in the flat file looks fine.But after the delay and the loop, the same message is back to its previous state.
To everything I read in the doc. about \”persistence points\” doesn’t seem to be applying here.
Any suggestions? This has taken all day and is a serious problem for us.
Thanks,
Neal
