this message has been repeating for the last couple of days in the statesys.log not sure what it is trying to tell me. Anyone know?

[23000][515][Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot insert the value NULL into column 'CollectionID', table 'CM_P00.dbo.DeploymentSummary'; column does not allow nulls. INSERT fails. : pUpdateAppDeploymentSummaryByCollection

*** exec spTaskUpdateDeploymentSummaryByCollection 'App', 0x0000000000000000

*** [01003][8153][Microsoft][SQL Server Native Client 11.0][SQL Server]Warning: Null value is eliminated by an aggregate or other SET operation.

Task 'App Deployments Summary' failed after running for 15 seconds.

Based on the message, it looks like you have an orphaned deployment or a deployment targeting a collection that was deleted. Have you reviewed all of your deployments to ensure they are targeting a real collection?

Thank you for the reply Jason,

I have gone through all deployments and they are all assigned to existing collections.

total chucks loaded (1) SMS_STATE_SYSTEM 6/27/2013 11:20:33 AM 8588 (0x218C)
Started task 'App Statistics Summary' SMS_STATE_SYSTEM 6/27/2013 11:20:33 AM 6756 (0x1A64)
*** exec spTaskUpdateDeploymentSummaryByCollection 'App', 0x0000000000000000 SMS_STATE_SYSTEM 6/27/2013 11:20:33 AM 6756 (0x1A64)
*** [23000][515][Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot insert the value NULL into column 'CollectionID', table 'CM_P00.dbo.DeploymentSummary'; column does not allow nulls. INSERT fails. : spUpdateAppDeploymentSummaryByCollection SMS_STATE_SYSTEM 6/27/2013 11:20:33 AM 6756 (0x1A64)
*** exec spTaskUpdateDeploymentSummaryByCollection 'App', 0x0000000000000000 SMS_STATE_SYSTEM 6/27/2013 11:20:33 AM 6756 (0x1A64)
*** [01003][8153][Microsoft][SQL Server Native Client 11.0][SQL Server]Warning: Null value is eliminated by an aggregate or other SET operation. SMS_STATE_SYSTEM 6/27/2013 11:20:33 AM 6756 (0x1A64)
Task 'App Deployments Summary' failed after running for 12 seconds. SMS_STATE_SYSTEM 6/27/2013 11:20:33 AM 6756 (0x1A64)
total chucks loaded (0) SMS_STATE_SYSTEM 6/27/2013 11:20:33 AM 8588 (0x218C)

This is what the statesys.log says at the time of error. 

Do you have any other ideas that I can check out.

Time to CSS then. You got something orphaned somewhere that will probably need to be "ripped" out from the DB directly which only they can do in a supported fashion.

I hope you found the resolution and still remember what it was - I'm experiencing very similar issue:
From SMS_State_system status messages:

Microsoft SQL Server reported SQL message 515, severity 16: [23000][515][Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot insert the value NULL into column 'CollectionID', table 'CM_xxx.dbo.DeploymentSummary'; column does not allow nulls. INSERT fails. : spUpdateAppDeploymentSummaryByCollection

Please refer to your Configuration Manager documentation, SQL Server documentation, or the Microsoft Knowledge Base for further troubleshooting information.

From Statsys.log:

*** [23000][515][Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot insert the value NULL into column 'CollectionID', table 'CM_xxx.dbo.DeploymentSummary'; column does not allow nulls. INSERT fails. : spUpdateAppDeploymentSummaryByCollection