Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2005
    Posts
    19

    Unanswered: MS Best Practice Analyser - Exception;

    Hi All ,

    Im trying to use MS BPA for my SQL Server 2000 instance and getting the below error repeatedly.

    Exception MyServer Error while executing the Best Practice Group. See the log file Test_dev-chen-pc006_0001_DEV-CHEN-PC006_sqlbpa.log. Error message: Execution log not found in the repository

    It would be great if you anyone help me out to proceed using MS BPA and get the reports without any Exceptions.

    Thanks in Advance,

    regards,

    Hari Haran Arulmozhi

  2. #2
    Join Date
    Nov 2004
    Location
    on the wrong server
    Posts
    8,835
    Provided Answers: 6
    did you look at those log files? have you tried reinstalling?
    “If one brings so much courage to this world the world has to kill them or break them, so of course it kills them. The world breaks every one and afterward many are strong at the broken places. But those that will not break it kills. It kills the very good and the very gentle and the very brave impartially. If you are none of these you can be sure it will kill you too but there will be no special hurry.” Earnest Hemingway, A Farewell To Arms.

  3. #3
    Join Date
    Nov 2005
    Posts
    19
    Hi,

    Thanks for your response. Below is the text from the log file and I have reinstalled once.

    Hari Haran Arulmozhi

    ================================================== ========


    Microsoft.BPA.Server.JobCoordinatorComponent.JobCo ordinatorException: Execution log not found in the repository

    Server stack trace:
    at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.updateJobStatus(Int32 jobProgress, Status jobStatus, Boolean fExecutionComplete, Boolean fNoException)
    at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.ProgressHandler(Int32 progress)
    at System.Runtime.Remoting.Messaging.StackBuilderSink .PrivateProcessMessage(MethodBase mb, Object[] args, Object server, Int32 methodPtr, Boolean fExecuteInContext, Object[]& outArgs)
    at System.Runtime.Remoting.Messaging.StackBuilderSink .SyncProcessMessage(IMessage msg, Int32 methodPtr, Boolean fExecuteInContext)

    Exception rethrown at [0]:
    at System.Runtime.Remoting.Proxies.RealProxy.HandleRe turnMessage(IMessage reqMsg, IMessage retMsg)
    at System.Runtime.Remoting.Proxies.RealProxy.PrivateI nvoke(MessageData& msgData, Int32 type)
    at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.ProgressHandler(Int32 progress)
    at Microsoft.SqlBpa.Rules.BpaRuleBase.SetProgressHand ler(ProgressHandler bpProgressHandler)
    at Microsoft.BPA.Server.BPProxy.SetProgressHandler(Pr ogressHandler bpProgressHandler)
    at System.Runtime.Remoting.Messaging.StackBuilderSink .PrivateProcessMessage(MethodBase mb, Object[] args, Object server, Int32 methodPtr, Boolean fExecuteInContext, Object[]& outArgs)
    at System.Runtime.Remoting.Messaging.StackBuilderSink .SyncProcessMessage(IMessage msg, Int32 methodPtr, Boolean fExecuteInContext)

    Exception rethrown at [1]:
    at System.Runtime.Remoting.Proxies.RealProxy.HandleRe turnMessage(IMessage reqMsg, IMessage retMsg)
    at System.Runtime.Remoting.Proxies.RealProxy.PrivateI nvoke(MessageData& msgData, Int32 type)
    at Microsoft.BPA.Server.BPProxy.SetProgressHandler(Pr ogressHandler bpProgressHandler)
    at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueCollection bpInputParams, BPASQLServerInfo sqlServer)
    Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Execution log not found in the repository
    at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.executeJob(NameValueCollection bpInputParams, BPASQLServerInfo sqlServer)
    at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
    Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nnerException: Error in the application.
    at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()
    Microsoft.BPA.Server.JobCoordinatorComponent.JobCo ordinatorException: Execution log not found in the repository
    at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.updateJobStatus(Int32 jobProgress, Status jobStatus, Boolean fExecutionComplete, Boolean fNoException)
    at Microsoft.BPA.Server.JobCoordinatorComponent.JobRu nner.Run()


    ================================================== ========

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •