Forum Replies Created
-
Posts
-
Hi
I am trying to configure the biztalk 2004, while conifguring i get the error message stating \”[b:322c065054]failed to create management database “BiztalkMgmtDb” on server “SAU”. The version of biztalkserver requires Microsoft Sql Server 2000 with service pack 3 or later server[/b:322c065054]\” what could be the reason for this error. can anyone help on this errorOk, I got you now.
No, a subscription is not created when you expose a Schema as a Web Service. All this does is create the Receive Side of things by making a nice web service for you.
You need to create a Send Port with a Filer. You can set the filter property BTS.ReceivePortName to your port name or set BTS.InboundTransportType = SOAP (I think). Then, make sure it’s enlisted and started. You can just test it by writing it to file.
A note, if you had exposed an Orchestration you would have a subscription (i.e. the Orchestration).
Best of luck.
Hi Stephen,
Thanks for your reply. Based on your comments I did some testing again.
I still encounter the problem however. I have everything undeployed on my test box (except for the scenario 2 interface).I am also not sure what you mean by ‘Next, make sure your 2nd Orchestration is returning the message.’ because I am not using an orchestration. I only use messaging. Or at least I try to :D. So I am only exposing the schema as a webservice.
When I look in HAT I see a routing failure. The error indicates ‘This service instance exists to help debug routing failures. The context of the message associated with this instance contains all the promoted properties at the time of the routing failure.’
Also when using the subscription viewer there is no subscription.
So my actual question is:
[i:fe7060b7a1][b:fe7060b7a1]Why isn’t there a subscription created when I expose a schema as a webservice (without orchestration, 2nd option in wizard)?[/b:fe7060b7a1][/i:fe7060b7a1]
Thanks in advance,
R vS
hi it seems that the transformation of a message went wrong. i don’t know why it just mapping elements. do i need to initialize value for those mapped elements?
however it works now, when i use the same schema that adapter created without any transformation.
There are two ways of doing this:
Create a SubmitDirect service or custom adapter that will generate a trigger message every minute. This trigger message will initiate your orchestration that will call the web service.Create a custom polling web service adapter
The standard Web Service adapter will not poll, so you cannot start an orchestration with a request/response web service.
Denis,
VMWare is not freeware but you can obtain a evaluation copy of vmware workstation5.0 for 30days free trial.I’ve played with it some more and no luck :). I have a receive ftp location which looks for a file on an ftp site which activates the orchestration. I want the orchestration to grab data from sql server table, mix the data with the data from the flatfile gotten on the ftp and then insert into another sql table. I dont know enough about biztlak to know where to start. I tried to create a paralell process which has two receive shapes which are connected to FTP Receive Loc and SqlServer respectively. Now It seems that i need to combine two messages into one and then try to map this 3rd composite message into a 4th one thats going to be sent to an SqlServer port? Do i need to create a schema which can hold both files separate under a root node and then MAP that schema into final result? Pretty confusing. By the way, i’ve used paralell process because it said that Two Receive Shapes in a convoy require them to have the same port….pretty weird. What’s a good way to procede? Obviously I am confused……Thanks
Mostly I need help with the second part. I was infact trying to do this using an orchestration but honestly I don’t know how the process would go, what shapes to use. Do I somehow load ID’s from database using one port and then load the flatfile using another port, then using some kind of map i crease the result i need and then using a send port I insert the records? how would it go, can you give a more detail if possible. Thanks
I have not tried what you are talking about.
But, I would guess as long as you can install SQL 2000 MSDE and SQL 2005 (under a named instance probably since default is probably taken) on the same server BizTalk should be fine.
I don’t know if that is possible.
Running BizTalk with SQL 2000 is a great option though. As far as I know, BT 2006 does not take advantage of many of the new features of SQL 2005. Sure, it will run “better” on 2005, but I would guess unless you are under high load you wouldn’t notice a difference.
Just my thoughts on this.
Your first part, it is not possible using the FTP Adapter. At least not that I know of. The FTP Adapter will pick up and remove the file from the location. If you needed more then this, you would need a custom adapter or some other type of business process.
Once you get your file into BizTalk, I think you should be able to have logic inside your Orchestration for your ID’s.
Hope this helps.
Hi, this is my first post here so please be easy on me 🙂
I am polling an ftp site for a file (ie MyFile.txt), that file is a delimited flat file which i was able to get biztlak to parse. How to setup biztlak that it polls for changes to the file, not just if the file exists?
So what I need to do, is select bunch of ID’s from a database table, then i need to insert the data in the file per each ID. So for example if the file contains 100 records and there are 5 ID’s in my SqlServer table, I want to insert 500 records into a table.
To complicate this just a little further, the flat file has two columns and the table with ID’s also has two columns. Depending on the 2nd column from the database table, I either want to insert all records (DBTable.ID,File.ColumnA) or (DBTable.ID, File.ColumnB) from the flat file (for each ID i retreive from the databse)….Not sure if that makes sense, i hope it does.
Hoping someone knows how to proceed with this sorta thing. Thanks for all the help in advance
The message has not reached the Oracle Adapter yet.
The error from the XmlAssembler in the send pipeline indictaes the message is empty.You need to look to where the message has come from, is there a map somewhere that is producing no output?
When do you want to start the orchestration?
Do you want this to happen every minute, every hour, once a day, once a week or once a month?
