I have loaded ZAM 7.5 and everything was working ok until a week back! It just stopped submitting the network discovery tasks. I have patched to SR 18 and SP3 for the MSSQL.

It is the exact error as mentioned in TID 3899685.

This in the entry in my TSCMgrEvent20090430.log file:

<EVENT AT="4/30/2009 12:24:28 PM" SEVERITY="Severe">
Application Object Error at 4/30/2009 12:24:28 PM on AGRI-IQUAL by AGRI-IQUAL
Object Store Error
[2.4.104] An error occurred while storing the object.

Class:"Task"

Name:"Netw Disc Task - Ghmtown CB (10.218.215.160/224)"

Application Object Error at 4/30/2009 12:24:28 PM on AGRI-IQUAL by AGRI-IQUAL
Unexpected Exception
[2.4.3] Unexpected exception [2.5.11]... operation failed.

Database Persistence Layer Info in DBSQLServerErrorHandler::serverError at 4/30/2009 12:24:28 PM
Validation Error
[2.5.602] validation failed with message .

Database Persistence Layer Error in DBSQLServerErrorHandler::serverError at 4/30/2009 12:24:28 PM

Database Persistence Layer Error in DBSQLServerErrorHandler::serverError at 4/30/2009 12:24:28 PM
Database Error
[2.5.3] Error: '[5] [SERVERERROR] Cannot insert the value NULL into column 'SendLogsOnError', table 'ZENworks.dbo.NC_Task'; column does not allow nulls. INSERT fails.
[SERVERMESSAGE] The statement has been terminated.'

Message 1: '[515] AGRI-IQUAL'

Message 2: '[515]'
</EVENT>


Thanks

Colin