1
Vote

Data in database

description

I have downloaded the relevant files. However my SSIS package fails with
ource: Get MaxJobHistoryId Execute SQL Task
Description: Executing the query "EXEC dbo.SaveMaxMSSQLSchedJobHistoryId @SrvrInstnc..."
failed with the following error:
"Cannot insert the value NULL into column 'ParameterId', table 'DBAObjects.dbo.SrvrInstncEAV';
column does not allow nulls.
INSERT fails.".

From my investigation it appears that it is trying to get some data from the dbo.parameter file.
This file is empty
How and with what is this populated.

Danie Swart

comments

novaconceptsltd wrote Mar 20, 2014 at 3:56 PM

Danie,
Thank you for the issue, I will look into soon.

novaconceptsltd wrote Mar 24, 2014 at 2:57 AM

Dan,
Is this at the first run? Have you added the server to the system?