locked
System.Data.SqlClient.SqlException: Could not find stored procedure 'bam_ID RRS feed

  • Question

  • Hi.  Using Biztalk Server 2006 R2 on Windows Xp SP3 with SQL Server 2005. I deployed a BAM activity and view, and set an alert using search condition, to email me a notification. During runtime, I am seeing the following error in the eventLog and not receieving the email notification (not getting generated).  Any thoughts?

    <<<<<<<<<<<

    Event Type: Error
    Event Source: Bam Event Provider
    Event Category: None
    Event ID: 14014
    Date:  3/23/2010
    Time:  2:22:38 PM
    User:  N/A
    Computer: GVXPPDEV114
    Description:
    Retrieving updated events from bam db. Encountered error: System.Data.SqlClient.SqlException: Could not find stored procedure 'bam_ID3F94261B9BF1465A8B1C6BB7082EFC25_ID931EFABBE363471FAFA4B87032FB9F0A_GetUpdated'.
       at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
       at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
       at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
       at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
       at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
       at System.Data.SqlClient.SqlDataReader.get_MetaData()
       at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
       at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
       at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
       at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
       at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
       at System.Data.SqlClient.SqlCommand.ExecuteReader()
       at Microsoft.BizTalk.Bam.InstanceEventProvider.GetNewEvents(DateTime lastPolled, Int64 lastRecID)
       at Microsoft.BizTalk.Bam.InstanceEventProvider.DoRun()

    For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
    >>>>>>>>>>

    and

    <<<<<<<<

    Event Type: Error
    Event Source: NotificationServices
    Event Category: None
    Event ID: 5501
    Date:  3/23/2010
    Time:  2:22:12 PM
    User:  N/A
    Computer: GVXPPDEV114
    Description:
    Description: The performance monitor failed to get event counter values to update the performance counters.
    EventParameters:
      Instance Name: BAMAlerts
      Application Name: Application
      Event Class Name: 1717755331191011513011441736678242117292474549523

    SqlServerError:
      Source: .Net SqlClient Data Provider
      Number: 2812
      State: 62
      Class: 16
      Server: GVXPPDEV114
      Message: Could not find stored procedure 'dbo.NS1717755331191011513011441736678242117292474549523EventPerfCounters'.
      Procedure:
      Line Number: 1

    Description: Could not find stored procedure 'dbo.NS1717755331191011513011441736678242117292474549523EventPerfCounters'.
    InstanceName: BAMAlerts
    ApplicationName: Application
    Component: Performance Monitor
    Thread: 18


    For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
    >>>>>>>>>>

    Tuesday, March 23, 2010 7:36 PM

Answers

  • Your performance counters might have become corrupt. In this case, stop the service, run NSControl Unregister to remove the counters, run NSControl Register to recreate the counters, and then restart the service.</performancequeryinterval>

    http://www.microsoft.com/technet/support/ee/transform.aspx?ProdName=SQL+Server+Notification+Services&ProdVer=2.0.9999.9&EvtID=5501&EvtSrc=NotificationServices&LCID=1033


    Thanks, Raja
    Tuesday, March 23, 2010 9:25 PM

All replies

  • Did you check your SQL Server BAM database running correctly? or has anybody made any changes on the database recently?  
    Please mark it as Answer if this answers your question
    Thanks.
    Mo
    Tuesday, March 23, 2010 7:42 PM
  • All DBs are up and running, and no change to the DBs.

    Tuesday, March 23, 2010 7:46 PM
  • Are other BizTalk application running? This still can be the database connection issue, Also check the permission to the user in the database? If you have just installed, configured your BizTalk make sure that you you have double checked the documents: http://www.microsoft.com/downloads/details.aspx?FamilyID=df2e8a88-fb23-49a4-9ac7-d17f72517d12&DisplayLang=en 


    Please mark it as Answer if this answers your question
    Thanks.
    Mo
    Tuesday, March 23, 2010 7:54 PM
  • All other features of this MS standard BAM portal OOTB are working fine, and yes I had reviewed the above documentation.
    Tuesday, March 23, 2010 8:08 PM
  • Your performance counters might have become corrupt. In this case, stop the service, run NSControl Unregister to remove the counters, run NSControl Register to recreate the counters, and then restart the service.</performancequeryinterval>

    http://www.microsoft.com/technet/support/ee/transform.aspx?ProdName=SQL+Server+Notification+Services&ProdVer=2.0.9999.9&EvtID=5501&EvtSrc=NotificationServices&LCID=1033


    Thanks, Raja
    Tuesday, March 23, 2010 9:25 PM