Event Id: 2990 once every minute ?

Hey all-

Im receiveing the folowing event in my Application log once every minute:

<NotificationServicesEvent>

<Description>

The SQLProvider event provider failed to submit a batch.

</Description>

<Context>

<EventParameters>

<ProviderName>AlertProvider</ProviderName>

<EventClassName>AlertEvent</EventClassName>

</EventParameters>

<SqlServerError>

Source: .Net SqlClient Data Provider

Number: 213

State: 7

Class: 16

Server: MONMxxx

Message: Insert Error: Column name or number of supplied values does not match table definition.

Procedure: spNWEventsQuery

Line Number: 131

</SqlServerError>

</Context>

<Description>

Insert Error: Column name or number of supplied values does not match table definition.

</Description>

<Instance>NotificationWorkflow</Instance>

<ApplicationName>NotificationWorkflowApp</ApplicationName>

<Component>Event collection</Component>

<Thread>145</Thread>

</NotificationServicesEvent>

For more information, see Help and Support Center at

Sorry for the long post but can anyone point me in the right direction for troubleshooting this. NS 2.0 SP1

Thanks!

-Brad

Looks like your EventsQuery has some errors in it. Check your EventClass schema and compare it to the SQL Statement in the EventsQuery argument of the SQL Server Event Provider.

Also try running the SQL Statement from QA to make sure it's valid.

HTH...

Joe|||

I had the same error, and I found the problem, with me it was a trigger that was updating another table and that table had changed, so I just had to fix the trigger.

HTH

Pieter