./StartOpManagerServer.sh
Java Home /opt/AdventNet/ME/OpManager/jre
cp: cannot stat `/opt/AdventNet/ME/OpManager/apache/ssl/backup/ssl.conf': No such file or directory
The File: /opt/AdventNet/ME/OpManager/apache/ssl/ssl.conf does not exist
inside addon check
Exception in creating table
Statement being executed was :create table Schedule ( S_SCHEDULEID BIGINT NOT NULL, S_SCHEDULENAME VARCHAR(250) NOT NULL UNIQUE, S_DESCRIPTION TEXT, S_ADMINSTATUS VARCHAR(20) NOT NULL, PRIMARY KEY ( S_SCHEDULEID )) TYPE=InnoDB
general error, message from server: "can't create table './opmanagerdb/schedule.frm' (errno: 121)"
java.sql.SQLException: General error, message from server: "Can't create table './OpManagerDB/Schedule.frm' (errno: 121)"
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1822)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1017)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1106)
at com.mysql.jdbc.MysqlIO.sqlQuery(MysqlIO.java:1067)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2024)
at com.mysql.jdbc.Connection.execSQL(Connection.java:1981)
at com.mysql.jdbc.Statement.execute(Statement.java:893)
at jdbc.CreateSchema.createTables(CreateSchema.java:353)
at jdbc.CreateSchema.init(CreateSchema.java:86)
at com.adventnet.nms.startnms.NmsMainBE.main(NmsMainBE.java:370)
at com.adventnet.me.opmanager.server.OpManagerMainBE.main(OpManagerMainBE.java:93)
Created table ObjectTypes
Created table ManagedObject
Created table MapViewConfig
Created table ProxyServerConfig
Created table UrlObject
Created table MapContainer
Created table TopoObject
Created table Node
Created table Network
Created table IpAddress
Created table SnmpNode
Created table SnmpInterface
Created table TL1Node
Created table TL1Interface
Created table TOPOUSERPROPS
Created table ALERTUSERPROPS
Created table EVENTUSERPROPS
Created table USERTABLE
Created table HOSTS
Created table PORTS
Created table ENGINES
Created table USERS
Created table POLLUSERPROPS
Created table ANNOTATION
Created table Alert
Created table MapDB
Created table MapSymbol
Created table MapLink
Created table MAPUSERPROPS
Created table Event
Created table PolledData
Created table ALERTLOGGER
Created table EVENTLOGGER
Created table CUSTOMMAPS
Created table DBINTERFACES
Created table DEFAULTMAPS
Created table TrapDisabledMO
Created table CHILDRENSTATUS
Created table CUSTOMPROPS
Created table OBJECTSTOLINK
Created table TOPODBSPECIALKEY
Created table DBMAP
Created table DBEVENT
Created table DBALERT
Created table DBPOLL
Created table ObjectSchedulerRUNNABLE
Created table MapGroup
Created table ManagedGroupObject
Created table GroupTable
Created table TaskAudit
Created table DeviceAudit
Created table AttributeAudit
Created table ConfigTasks
Created table ConfigTaskDetails
Created table ConfigAttributes
Created table PendingTasks
Created table PendingDevices
Created table DeviceList
Created table DeviceListDetails
Created table DeviceUserProps
Created table TaskToDeviceListMap
Created table PollingObjects
Created table ConfigProvider
Exception in creating table
Statement being executed was :create table PollingAttributes( NAME varchar(50), TYPE varchar(10), PROPERTY varchar(20), CONDITION varchar(50), VALUE varchar(100))
syntax error or access violation, message from server: "you have an error in your sql syntax; check the manual that corresponds to your mysql server version for the right syntax to use near 'condition varchar(50), value varchar(100))' at line 1"
java.sql.SQLException: Syntax error or access violation, message from server: "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CONDITION varchar(50), VALUE varchar(100))' at line 1"
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1822)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1017)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1106)
at com.mysql.jdbc.MysqlIO.sqlQuery(MysqlIO.java:1067)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2024)
at com.mysql.jdbc.Connection.execSQL(Connection.java:1981)
at com.mysql.jdbc.Statement.execute(Statement.java:893)
at jdbc.CreateSchema.createTables(CreateSchema.java:353)
at jdbc.CreateSchema.init(CreateSchema.java:86)
at com.adventnet.nms.startnms.NmsMainBE.main(NmsMainBE.java:370)
at com.adventnet.me.opmanager.server.OpManagerMainBE.main(OpManagerMainBE.java:93)
Created table Providers
Created table StatsTables
Created table ThresholdObjects
Created table CustomView
Created table CustomViewProps
Created table CustomViewColumns
Created table PanelTree
Created table PanelProps
Created table PollFilters
Created table GenericFaultTable
Created table TrapFilter
Created table TrapEventParser
Created table EventAlertFilter
Created table Reports
Created table DataCollectionAttributes
Created table UserPasswordTable
Created table UserGroupTable
Created table ViewPropertiesTable
Created table ViewsToGroupTable
Created table ViewToOperationsTable
Created table OperationsTreeTable
Created table NamedViewToAuthorizedViewTable
Created table AuthAudit
Created table NotificationLog
Created table VarBindLog
Created table AgentDefValObject
Created table PolicyObject
Created table PolicyActionCondition
Created table POLICYUSERPROPS
Created table DBPOLICY
Created table PolicyScheduleTime
Created table AlertPolicyObject
Created table ENGINETABLE
Created table USMTABLE
Created table SwitchObject
Created table PortObject
Created table Printer
Created table OperationsTable
Created table BEFailOver
Created table PollIDToKeyMap
Created table ProvisioningVariantProps
Created table ProvisioningVariant
Created table UserConfTable
Created table CORBANode
Created table NetworkInventory
Exception in creating table
Statement being executed was :create table TableSpaceStatus ( RESOURCENAME VARCHAR(100) NOT NULL, COMPONENTNAME VARCHAR(50) NOT NULL, TABLESPACENAME VARCHAR(25), STATUS VARCHAR(50), FREEBYTES INTEGER, FREEBLOCKS INTEGER, READS INTEGER, WRITES INTEGER, READTIME BIGINT, WRITETIME BIGINT, COLLECTIONTIME BIGINT)
syntax error or access violation, message from server: "you have an error in your sql syntax; check the manual that corresponds to your mysql server version for the right syntax to use near 'reads integer, writes integer, readtime bigint, writetime bigint, collec' at line 1"
java.sql.SQLException: Syntax error or access violation, message from server: "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'READS INTEGER, WRITES INTEGER, READTIME BIGINT, WRITETIME BIGINT, COLLEC' at line 1"
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1822)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1017)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1106)
at com.mysql.jdbc.MysqlIO.sqlQuery(MysqlIO.java:1067)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2024)
at com.mysql.jdbc.Connection.execSQL(Connection.java:1981)
at com.mysql.jdbc.Statement.execute(Statement.java:893)
at jdbc.CreateSchema.createTables(CreateSchema.java:353)
at jdbc.CreateSchema.init(CreateSchema.java:86)
at com.adventnet.nms.startnms.NmsMainBE.main(NmsMainBE.java:370)
at com.adventnet.me.opmanager.server.OpManagerMainBE.main(OpManagerMainBE.java:93)
Created table CollectData
Created table HostDataCollected
Created table InetService
Created table TableSpaceDetails
Created table RollbackData
Created table HostDetails
Created table InstanceDetails
Exception in creating table
Statement being executed was :create table InstanceStatus ( RESOURCENAME VARCHAR(100) NOT NULL, COMPONENTNAME VARCHAR(50) NOT NULL, DBSIZE BIGINT, AVGEXECS INTEGER, AVGUSERS INTEGER, READS INTEGER, WRITES INTEGER, BLOCKSIZE INTEGER, COLLECTIONTIME BIGINT)
syntax error or access violation, message from server: "you have an error in your sql syntax; check the manual that corresponds to your mysql server version for the right syntax to use near 'reads integer, writes integer, blocksize integer, collectiontime bigint)' at line 1"
java.sql.SQLException: Syntax error or access violation, message from server: "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'READS INTEGER, WRITES INTEGER, BLOCKSIZE INTEGER, COLLECTIONTIME BIGINT)' at line 1"
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1822)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1017)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1106)
at com.mysql.jdbc.MysqlIO.sqlQuery(MysqlIO.java:1067)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2024)
at com.mysql.jdbc.Connection.execSQL(Connection.java:1981)
at com.mysql.jdbc.Statement.execute(Statement.java:893)
at jdbc.CreateSchema.createTables(CreateSchema.java:353)
at jdbc.CreateSchema.init(CreateSchema.java:86)
at com.adventnet.nms.startnms.NmsMainBE.main(NmsMainBE.java:370)
at com.adventnet.me.opmanager.server.OpManagerMainBE.main(OpManagerMainBE.java:93)
Created table SgaStatus
Created table SessionInfo
Created table SgaDetails
Created table RedoLogs
Created table OracleCollectData
Created table RegionalServerToMOMap
Exception in creating table
Statement being executed was :create table DataFiles ( RESOURCENAME VARCHAR(100) NOT NULL, COMPONENTNAME VARCHAR(50) NOT NULL, FILE_NAME VARCHAR(100), TABLESPACENAME VARCHAR(25), STATUS VARCHAR(50), CREATEBYTES INTEGER, READS INTEGER, WRITES INTEGER, AVGRDTIME INTEGER, AVGWRTIME INTEGER, COLLECTIONTIME BIGINT)
syntax error or access violation, message from server: "you have an error in your sql syntax; check the manual that corresponds to your mysql server version for the right syntax to use near 'reads integer, writes integer, avgrdtime integer, avgwrtime integer, col' at line 1"
java.sql.SQLException: Syntax error or access violation, message from server: "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'READS INTEGER, WRITES INTEGER, AVGRDTIME INTEGER, AVGWRTIME INTEGER, COL' at line 1"
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1822)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1017)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1106)
at com.mysql.jdbc.MysqlIO.sqlQuery(MysqlIO.java:1067)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2024)
at com.mysql.jdbc.Connection.execSQL(Connection.java:1981)
at com.mysql.jdbc.Statement.execute(Statement.java:893)
at jdbc.CreateSchema.createTables(CreateSchema.java:353)
at jdbc.CreateSchema.init(CreateSchema.java:86)
at com.adventnet.nms.startnms.NmsMainBE.main(NmsMainBE.java:370)
at com.adventnet.me.opmanager.server.OpManagerMainBE.main(OpManagerMainBE.java:93)
Created table OpManagerObject
Created table MailServer
Created table HRDetails
Created table CLIDetails
Created table availability_statistics
Created table NTServicesDefinition
Created table NTServices
Created table EventLogFile
Created table EventLogRule
Created table EventLogDeviceInfo
Created table DeviceToEventLogRuleMap
Created table EventLogRunnable
Created table InterfacesToNotify
Created table STATSDATA_DAILY
Created table STATSDATA_HOURLY
Created table STATSDATA_HTML
Exception in creating table
Statement being executed was :create table PeriodicSchedule ( PS_SCHEDULEID BIGINT NOT NULL, PS_STARTDATE DATETIME, PS_ENDDATE DATETIME, PS_TIMEPERIOD BIGINT NOT NULL, PS_UNITOFTIME VARCHAR(20) NOT NULL, PRIMARY KEY ( PS_SCHEDULEID ), CONSTRAINT PS_FK1 FOREIGN KEY (PS_SCHEDULEID) REFERENCES Schedule(S_SCHEDULEID) ON DELETE CASCADE) TYPE=InnoDB
general error, message from server: "can't create table './opmanagerdb/periodicschedule.frm' (errno: 121)"
java.sql.SQLException: General error, message from server: "Can't create table './OpManagerDB/PeriodicSchedule.frm' (errno: 121)"
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1822)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1017)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1106)
at com.mysql.jdbc.MysqlIO.sqlQuery(MysqlIO.java:1067)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2024)
at com.mysql.jdbc.Connection.execSQL(Connection.java:1981)
at com.mysql.jdbc.Statement.execute(Statement.java:893)
at jdbc.CreateSchema.createTables(CreateSchema.java:353)
at jdbc.CreateSchema.init(CreateSchema.java:86)
at com.adventnet.nms.startnms.NmsMainBE.main(NmsMainBE.java:370)
at com.adventnet.me.opmanager.server.OpManagerMainBE.main(OpManagerMainBE.java:93)
Created table DCObject
Created table FEED_URL
Created table FEED_PROXY_PARAMS
Exception in creating table
Statement being executed was :create table CalendarSchedule ( CS_SCHEDULEID BIGINT NOT NULL, CS_REPEAT_FREQUENCY VARCHAR(50) NOT NULL, CS_TIME_OF_DAY BIGINT NOT NULL, CS_UNIT_OF_TIME VARCHAR(20) NOT NULL, CS_DAY_OF_WEEK INTEGER NOT NULL, CS_WEEK_OF_MONTH INTEGER NOT NULL, CS_DATE_OF_MONTH INTEGER NOT NULL, CS_MONTH_OF_YEAR INTEGER NOT NULL, CS_YEAR_OF_LEAP_YEAR INTEGER NOT NULL, CS_YEAR_OF_DECADE INTEGER NOT NULL, PRIMARY KEY ( CS_SCHEDULEID ), CONSTRAINT CS_FK1 FOREIGN KEY (CS_SCHEDULEID) REFERENCES Schedule(S_SCHEDULEID) ON DELETE CASCADE) TYPE=InnoDB
general error, message from server: "can't create table './opmanagerdb/calendarschedule.frm' (errno: 121)"
java.sql.SQLException: General error, message from server: "Can't create table './OpManagerDB/CalendarSchedule.frm' (errno: 121)"
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1822)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1017)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1106)
at com.mysql.jdbc.MysqlIO.sqlQuery(MysqlIO.java:1067)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2024)
at com.mysql.jdbc.Connection.execSQL(Connection.java:1981)
at com.mysql.jdbc.Statement.execute(Statement.java:893)
at jdbc.CreateSchema.createTables(CreateSchema.java:353)
at jdbc.CreateSchema.init(CreateSchema.java:86)
at com.adventnet.nms.startnms.NmsMainBE.main(NmsMainBE.java:370)
at com.adventnet.me.opmanager.server.OpManagerMainBE.main(OpManagerMainBE.java:93)
Exception in creating table
Statement being executed was :create table CompositeSchedule ( COS_SCHEDULEID BIGINT NOT NULL, COS_SUB_SCHEDULEID1 BIGINT NOT NULL, COS_OPERATOR VARCHAR(150) NOT NULL, COS_SUB_SCHEDULEID2 BIGINT NOT NULL, COS_PARENT_SCHEDULEID BIGINT NOT NULL, PRIMARY KEY ( COS_SCHEDULEID ), INDEX COS_INDEX1(COS_SUB_SCHEDULEID1), INDEX COS_INDEX2(COS_SUB_SCHEDULEID2), INDEX COS_INDEX3(COS_PARENT_SCHEDULEID), CONSTRAINT COS_FK1 FOREIGN KEY (COS_SUB_SCHEDULEID1) REFERENCES Schedule(S_SCHEDULEID) ON DELETE CASCADE, CONSTRAINT COS_FK2 FOREIGN KEY (COS_SUB_SCHEDULEID2) REFERENCES Schedule(S_SCHEDULEID) ON DELETE CASCADE, CONSTRAINT COS_FK3 FOREIGN KEY (COS_PARENT_SCHEDULEID) REFERENCES Schedule(S_SCHEDULEID) ON DELETE CASCADE) TYPE=InnoDB
general error, message from server: "can't create table './opmanagerdb/compositeschedule.frm' (errno: 121)"
java.sql.SQLException: General error, message from server: "Can't create table './OpManagerDB/CompositeSchedule.frm' (errno: 121)"
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1822)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1017)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1106)
at com.mysql.jdbc.MysqlIO.sqlQuery(MysqlIO.java:1067)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2024)
at com.mysql.jdbc.Connection.execSQL(Connection.java:1981)
at com.mysql.jdbc.Statement.execute(Statement.java:893)
at jdbc.CreateSchema.createTables(CreateSchema.java:353)
at jdbc.CreateSchema.init(CreateSchema.java:86)
at com.adventnet.nms.startnms.NmsMainBE.main(NmsMainBE.java:370)
at com.adventnet.me.opmanager.server.OpManagerMainBE.main(OpManagerMainBE.java:93)
Created table SERVICEDESK_CONFIG
Created table SMS_OUT
Created table SMS_IN
Created table UPSObject
Created table MIBDETAILS
Created table FEED_LOGIN_PARAMS
Exception in creating table
Statement being executed was :create table MaintenanceTask ( MS_INSTANCEID BIGINT NOT NULL, MS_NAME VARCHAR(250) NOT NULL UNIQUE, MS_DESCRIPTION TEXT, MS_STATUS VARCHAR(10), MS_MANAGE_SCHEDULEID BIGINT NOT NULL, MS_UNMANAGE_SCHEDULEID BIGINT NOT NULL, PRIMARY KEY ( MS_INSTANCEID )) TYPE=InnoDB
general error, message from server: "can't create table './opmanagerdb/maintenancetask.frm' (errno: 121)"
java.sql.SQLException: General error, message from server: "Can't create table './OpManagerDB/MaintenanceTask.frm' (errno: 121)"
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1822)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1017)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1106)
at com.mysql.jdbc.MysqlIO.sqlQuery(MysqlIO.java:1067)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2024)
at com.mysql.jdbc.Connection.execSQL(Connection.java:1981)
at com.mysql.jdbc.Statement.execute(Statement.java:893)
at jdbc.CreateSchema.createTables(CreateSchema.java:353)
at jdbc.CreateSchema.init(CreateSchema.java:86)
at com.adventnet.nms.startnms.NmsMainBE.main(NmsMainBE.java:370)
at com.adventnet.me.opmanager.server.OpManagerMainBE.main(OpManagerMainBE.java:93)
Created table LoginContactDetails
Exception in creating table
Statement being executed was :create table TaskInput ( TI_INSTANCEID BIGINT NOT NULL, TI_SCHEDULEID BIGINT NOT NULL, TI_SCHEDULETIME DATETIME, TI_EXECUTION_START_TIME DATETIME, TI_EXECUTION_FINISH_TIME DATETIME, TI_ADMIN_STATUS INTEGER, TI_OPERATIONAL_STATUS INTEGER, PRIMARY KEY ( TI_INSTANCEID ), INDEX TI_INDEX1(TI_SCHEDULEID), CONSTRAINT TI_FK1 FOREIGN KEY (TI_SCHEDULEID) REFERENCES Schedule(S_SCHEDULEID) ON DELETE CASCADE) TYPE=InnoDB
general error, message from server: "can't create table './opmanagerdb/taskinput.frm' (errno: 121)"
java.sql.SQLException: General error, message from server: "Can't create table './OpManagerDB/TaskInput.frm' (errno: 121)"
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1822)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1017)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1106)
at com.mysql.jdbc.MysqlIO.sqlQuery(MysqlIO.java:1067)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2024)
at com.mysql.jdbc.Connection.execSQL(Connection.java:1981)
at com.mysql.jdbc.Statement.execute(Statement.java:893)
at jdbc.CreateSchema.createTables(CreateSchema.java:353)
at jdbc.CreateSchema.init(CreateSchema.java:86)
at com.adventnet.nms.startnms.NmsMainBE.main(NmsMainBE.java:370)
at com.adventnet.me.opmanager.server.OpManagerMainBE.main(OpManagerMainBE.java:93)
Exception in creating table
Statement being executed was :create table MaintenanceDevices ( MD_INSTANCEID BIGINT NOT NULL , MD_NAME VARCHAR (100) NOT NULL , MD_OWNERNAME VARCHAR (25) NOT NULL , MD_DISPLAYNAME VARCHAR (100) NOT NULL , PRIMARY KEY ( MD_INSTANCEID , MD_NAME , MD_OWNERNAME ) , CONSTRAINT MD_FK1 FOREIGN KEY (MD_INSTANCEID) REFERENCES MaintenanceTask (MS_INSTANCEID) ON DELETE CASCADE) TYPE=InnoDB
general error, message from server: "can't create table './opmanagerdb/maintenancedevices.frm' (errno: 121)"
java.sql.SQLException: General error, message from server: "Can't create table './OpManagerDB/MaintenanceDevices.frm' (errno: 121)"
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1822)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1017)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1106)
at com.mysql.jdbc.MysqlIO.sqlQuery(MysqlIO.java:1067)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2024)
at com.mysql.jdbc.Connection.execSQL(Connection.java:1981)
at com.mysql.jdbc.Statement.execute(Statement.java:893)
at jdbc.CreateSchema.createTables(CreateSchema.java:353)
at jdbc.CreateSchema.init(CreateSchema.java:86)
at com.adventnet.nms.startnms.NmsMainBE.main(NmsMainBE.java:370)
at com.adventnet.me.opmanager.server.OpManagerMainBE.main(OpManagerMainBE.java:93)
Created table StatsPolledData
All The Tables were not created properly.
Exiting OpManager