Operations Console EngAppMon Service Issue
Posted: Mon Apr 15, 2013 8:07 am
Hi All,
We are on Ds 8.7.0.1 on Windows 2008
We Installed Operations Console but had an issue in the EngAppMon service starting. It has been installed on SQl Server 2008 DB under the XMeta database as a seperate scheme (default schema of DSODB, we tried installing as a seperate database but it kept failing)
We found the SQL Error in the log file for EngAppMon, We had errors like below (we verified this column does exist in the table DSODB.JobRun where it is trying to Insert a record from the Event File)..
INSERT INTO DSODB.JobRun (RUNID,JOBID,InvocationId,CreationTimestamp,RunMajorStatus,RunMinorStatus,RunType,MasterPid,RunStartTimestamp,ISUsername,DSUsername,LastUpdateTimestamp) VALUES
(?,?,?,?,?,?,?,?,?,?,?,?). Values: [-818487466168701192, 5550974994427117468, -, Fri Apr 12 13:03:46 EDT 2013, SUB, STR, RUN, 12496, Fri Apr 12 13:03:46 EDT 2013, abc, xxxxxxx/abc, Fri Apr 12 13:03:46 EDT 2013]
java.sql.SQLSyntaxErrorException: [IBM][SQLServer JDBC Driver][SQLServer]Invalid column name 'ISUsername'.
So to try fix this, as per the manual I changed the property EMAAllowSQLErrors=1 (default 0) in the DSODBTuning.cfg configuration file..Now the service is running and I see the Operations Console but it is not providing any information and I see "Sorry, an Error Occured" under the JobActivity, Operating System Resources and Memory Pane..
I do see an error now in the odbqapp.log file as, although this table exists as well
java.sql.SQLSyntaxErrorException: [IBM][SQLServer JDBC Driver][SQLServer]Invalid object name 'DSODB.JOBRUN'.
**** All Services are showing as OK in the Operations Console ****
Has anyone seen something similar..any help would be highly appreciated
Thanks
NV
We are on Ds 8.7.0.1 on Windows 2008
We Installed Operations Console but had an issue in the EngAppMon service starting. It has been installed on SQl Server 2008 DB under the XMeta database as a seperate scheme (default schema of DSODB, we tried installing as a seperate database but it kept failing)
We found the SQL Error in the log file for EngAppMon, We had errors like below (we verified this column does exist in the table DSODB.JobRun where it is trying to Insert a record from the Event File)..
INSERT INTO DSODB.JobRun (RUNID,JOBID,InvocationId,CreationTimestamp,RunMajorStatus,RunMinorStatus,RunType,MasterPid,RunStartTimestamp,ISUsername,DSUsername,LastUpdateTimestamp) VALUES
(?,?,?,?,?,?,?,?,?,?,?,?). Values: [-818487466168701192, 5550974994427117468, -, Fri Apr 12 13:03:46 EDT 2013, SUB, STR, RUN, 12496, Fri Apr 12 13:03:46 EDT 2013, abc, xxxxxxx/abc, Fri Apr 12 13:03:46 EDT 2013]
java.sql.SQLSyntaxErrorException: [IBM][SQLServer JDBC Driver][SQLServer]Invalid column name 'ISUsername'.
So to try fix this, as per the manual I changed the property EMAAllowSQLErrors=1 (default 0) in the DSODBTuning.cfg configuration file..Now the service is running and I see the Operations Console but it is not providing any information and I see "Sorry, an Error Occured" under the JobActivity, Operating System Resources and Memory Pane..
I do see an error now in the odbqapp.log file as, although this table exists as well
java.sql.SQLSyntaxErrorException: [IBM][SQLServer JDBC Driver][SQLServer]Invalid object name 'DSODB.JOBRUN'.
**** All Services are showing as OK in the Operations Console ****
Has anyone seen something similar..any help would be highly appreciated
Thanks
NV