Hmmm, not sure what else to say at this time.
Put simply when items are written to the notificationdistribution table I
pick those successfully delivered items using the SQLProvider and submit
them back through the system to a table via a storedprocedure delivery
channel. The error detailed below occurs from time to time. Will provide
more info when I get it in case the outcome is useful to someone.
I am not sure what causes the error. I thought that the system might be
attempting to submit events when the app was being updated but I always
(have to) disable the app during updates, so this is unlikely. I will be
keeping an eye on this. I have some time scheduled towards the end of the
week to refocus on this project.
Tony S.
[quoted text, click to view] "Joe Webb" <joew@webbtechsolutions.com> wrote in message
news:pan.2007.01.23.22.33.30.640625@webbtechsolutions.com...
> On Mon, 22 Jan 2007 23:34:32 +0000, TonyS wrote:
>
>> Can anyone comment on why the error below occurs?
>> If the SQL statement used by this hosted provider fails to give any rows
>> the
>> system disables the application.
>> There will be times when nothing is to be submitted to the system so I am
>> a
>> bit perturbed that SQLNS appears to disable the app so that when events
>> do
>> occur they cannot therefore be collected.
>>
>> Any ideas?
>>
>> "The SQLProvider event provider failed to submit a batch.
>> Provider Name: SQLChargeEventsProvider
>> Event Class Name: RegularChargeEvents
>> SqlServerError:
>> Source: .Net SqlClient Data Provider
>> Number: 50000
>> State: 1
>> Class: 16
>> Server: SCDEV7
>> Message: 9076: This application is disabled.
>> Procedure: NSEventSubmitBatchRegularChargeEvents
>> Line Number: 23
>>
>> 9076: This application is disabled.
>> Instance: MyInstance
>> ApplicationName: MessageChargeApp
>> Component: Event collection
>> Thread: 21"
>>
>> TIA
>> Tony S.
>
> Hi Tony -
>
> This is not normal behavior. Can you share more information?
>
> Joe
>
>
> --
> Joe Webb
> SQL Server MVP
>
http://www.sqlns.com >
>
>
>
