While performing a fresh installation of Insight, you may experience the following error while running the create-tables sql:
Msg 208, Level 16, State 1, Procedure JOBSTATUSRULEHISTORY_VW, Line 5
Invalid object name 'JOBDETAILSTATUSRULEHISTORY_VW'.
This is due to a procedure that references a view that isn't created until the next procedure in the SQL. To resolve the issue, simply rerun the procedure that failed.
SQL Server:
CREATE VIEW "JOBSTATUSRULEHISTORY_VW"
AS
SELECT JDSV.*,'DETAIL' AS TYPE
FROM JOBDETAILSTATUSRULEHISTORY_VW JDSV
UNION
SELECT JSSV.*,'SUMMARY' AS TYPE
FROM JOBSUMMSTATUSRULEHISTORY_VW JSSV
GO
Oracle:
CREATE OR REPLACE VIEW JOBSTATUSRULEHISTORY_VW
AS
SELECT JDSV.*,'DETAIL' AS TYPE
FROM JOBDETAILSTATUSRULEHISTORY_VW JDSV
UNION
SELECT JSSV.*,'SUMMARY' AS TYPE
FROM JOBSUMMSTATUSRULEHISTORY_VW JSSV;
COMMIT;
Comments
0 comments
Please sign in to leave a comment.