Forum Replies Created
-
AuthorPosts
-
Try this….
How to: Delete an Instance of Notification Services (Command Prompt)I dont have one, but you could construct these queries in HAT. Just click on the “Queries Menu” -> “Most recent 100 service instances” and then click on the “Show Query” button. In there you can modify the query to your liking. You can also run these queries from SQL Managment Studio (or SQL Query Analyzer). Just point your connection at the BizTalkDTADb and query against the dtav_FindMessageFacts view.
From there you will probably need to customize your query based on your business processes. For instance if you have messages that support your business process(like a DB Lookup) do you want to include these in your metrics? From within your query, you may want to include/neglect certain records based upon the Pipeline or Host that was used to process the message.
Something else that you may want to look at, albeit more effort, is BAM. You could definately get this type of info from there.
thats right. specifically you need to catch a SOAP exception
You have to use scope and add exception handler.
Sorry, I forgot:
Do you use the installation / deinstallation guides for BTS ? Otherwise you could run into some real trouble. They’re here:
http://go.microsoft.com/fwlink/?LinkId=81041
For instance, there are also a few SQL server agent jobs to be deleted etc.
Regards, Michael
Great ! Maybe my restarting the computer was a little drastical…
I stopped and started the SQL server, and then took database offline and online again.
Then I could delete it 🙂
I get this error message:
TITLE: Microsoft SQL Server Management Studio
——————————Drop failed for Database ‘BizTalkMsgBoxDb’. (Microsoft.SqlServer.Smo)
——————————
ADDITIONAL INFORMATION:An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
——————————
Cannot drop database “BizTalkMsgBoxDb” because it is currently in use. (Microsoft SQL Server, Error: 3702)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.3054&EvtSrc=MSSQLServer&EvtID=3702&LinkId=20476
——————————
BUTTONS:OK
——————————I’ve had this problem a couple of times. Mostly restarting the computer helped. If not: Is IIS still running ? Could there be another PC trying to connect to the database ?
I deleted all BTS tables except one:
BizTalkMsgBoxDb
Can not delete/drop it. (error 3702)
This is still used by some service(I think), anyone knows which one?
Thanx, I will do…
If you had deployed the application earlier using the trial version, the newer version of SSO cannot decrypt the data from SQL Server. If you have the backup of secret (the once that was created during installation of trial version), you may use it. However if you do not have it, then what you said is right, reinstall completely.
May 15, 2008 at 1:03 PM in reply to: Communicating back to WCF Service – Published Schema Req/Resp #19674Neal,
The messaging endgine uses a property to track request response message pairs = BTS.EpmRRCorrelationToken
You could try this: GetDataResp(BTS.EpmRRCorrelationToken) = GetDataReq(BTS.EpmRRCorrelationToken) before returning the message
I decided to spend a few minutes looking. It does look Microsoft’s wizard uses an underlying class in these two namespaces:
Microsoft.BizTalk.Adapter.Wcf.Publishing;
Microsoft.BizTalk.Adapter.Wcf.Publishing.Description;So in theory, one should be able to build a C# that does the same thing the wizard does. I googled this namespace, and the TopXML article is the only reference to it, so Microsoft did not decide to document it on MSDN.
I played around for a few minutes, and supposedly I could write some code like this (this was not tested at all, I was just trying to see what objects and methods existed):
WcfMessage myMessage =
new WcfMessage(“Message1”, WcfMessage.WcfMessageDirection.Input);WcfOperation oper =
new WcfOperation(“MyOperation1”);oper.WcfMessages.Add(myMessage);
oper.WcfService.WcfOperations.Add(oper);
Neal
Thanks Greg. It looks like that utility handles minor changes to schemas. So maybe if you changed the request parm or the response parms, this utility would refresht he schemas.
But if for example, you picked a wrong schema when you ran the wizard, it seems like you are kind of stuck. You either have to delete the IIS Virtual Directory, and start all over. Perhaps with a day or more of research and study, I could adapt their utility to fix such a problem, but right now I don’t think it’s worth that much time.
Ideally, when you ran the wizard, it would read the existing configuration, and allow you to make minor changes. Obviously Microsoft didn’t spend a lot of time on this wizard.
Neal
-
AuthorPosts