community-content

Forum Replies Created

Viewing 15 posts - 4,561 through 4,575 (of 9,648 total)
  • Author
    Posts
  • in reply to: BAM Alert service #19687

     Try this….

    How to: Delete an Instance of Notification Services (Command Prompt)
    in reply to: BizTalk Database queries to find the statistical data. #19686

     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.

    in reply to: How to catch exceptions in biztalk #19685

     thats right.  specifically you need to catch a SOAP exception

    in reply to: How to catch exceptions in biztalk #19684

     You have to use scope and add exception handler.

    in reply to: Uninstall on BTS and SQL tables #19683

    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

    in reply to: Uninstall on BTS and SQL tables #19682

    Great ! Maybe my restarting the computer was a little drastical…

    in reply to: Uninstall on BTS and SQL tables #19681

     I stopped and started the SQL server, and then took database offline and online again.

    Then I could delete it 🙂

    in reply to: Uninstall on BTS and SQL tables #19680

     I get this error message:

    TITLE: Microsoft SQL Server Management Studio
    ——————————

    Drop failed for Database ‘BizTalkMsgBoxDb’.  (Microsoft.SqlServer.Smo)

    For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Drop+Database&LinkId=20476

    ——————————
    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
    ——————————

    in reply to: Uninstall on BTS and SQL tables #19678

    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 ?

    in reply to: Uninstall on BTS and SQL tables #19677

    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?

    in reply to: Uninstall on BTS and SQL tables #19676

     Thanx, I will do…

    in reply to: Error on adding receive location #19675

     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.

     Neal,

    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

    in reply to: BizTalk WCF Publishing Wizard – manual vs automated? #19672

    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

     

     

    in reply to: BizTalk WCF Publishing Wizard – manual vs automated? #19671

     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

     

Viewing 15 posts - 4,561 through 4,575 (of 9,648 total)