OpManger MySQL To PGSQL Migration
Gooday,
We are planning to migrate MySQL db to PGSQL db..We are trying to run backupdb.bat command below the message shown. Unable to create backup zip file.. Same as shown
BackupDB.bat -targetdb -pgsql
OpManager Build Number
: 11100
Any solution pls!!
file:C:\Program Files\ManageEngine\OpManager\conf\ui.properties
Please wait ! Reading tables from configuration .....
May 11, 2017 4:29:28 PM com.adventnet.db.persistence.metadata.parser.DataDiction
aryParser getPrimaryKey
WARNING: The PKName :: TempDependentUnavailableHourly_PK of tableName :: TempDep
endentUnavailableHourly has 33 characters.
May 11, 2017 4:29:28 PM com.adventnet.db.persistence.metadata.parser.DataDiction
aryParser getPrimaryKey
WARNING: The PKName :: ProcessInstanceCountThreshold_PK of tableName :: ProcessI
nstanceCountThreshold has 32 characters.
May 11, 2017 4:29:28 PM com.adventnet.db.persistence.metadata.parser.DataDiction
aryParser getForeignKey
WARNING: The FKName :: ProcessInstanceCountThreshold_FK of tableName :: ProcessI
nstanceCountThreshold has 32 characters.
May 11, 2017 4:29:28 PM com.adventnet.db.persistence.metadata.parser.DataDiction
aryParser getPrimaryKey
WARNING: The PKName :: DefaultVOIPJitterSettingsTemplate_PK of tableName :: Defa
ultVOIPJitterSettingsTemplate has 36 characters.
May 11, 2017 4:29:28 PM com.adventnet.db.persistence.metadata.parser.DataDiction
aryParser getForeignKey
WARNING: The FKName :: DefaultVOIPJitterSettingsTemplate_FK of tableName :: Defa
ultVOIPJitterSettingsTemplate has 36 characters.
May 11, 2017 4:29:28 PM com.adventnet.db.persistence.metadata.parser.DataDiction
aryParser getPrimaryKey
WARNING: The PKName :: VirtualDeviceMonitorRuleList_PK1 of tableName :: VirtualD
eviceMonitorRuleList has 32 characters.
May 11, 2017 4:29:28 PM com.adventnet.db.persistence.metadata.parser.DataDiction
aryParser getForeignKey
WARNING: The FKName :: VirtualDeviceMonitorRuleList_FK1 of tableName :: VirtualD
eviceMonitorRuleList has 32 characters.
May 11, 2017 4:29:28 PM com.adventnet.db.persistence.metadata.parser.DataDiction
aryParser getPrimaryKey
WARNING: The PKName :: CalendarScheduleSingleEntry_PK1 of tableName :: CalendarS
cheduleSingleEntry has 31 characters.
May 11, 2017 4:29:28 PM com.adventnet.db.persistence.metadata.parser.DataDiction
aryParser getForeignKey
WARNING: The FKName :: CalendarScheduleSingleEntry_FK1 of tableName :: CalendarS
cheduleSingleEntry has 31 characters.
May 11, 2017 4:29:28 PM com.adventnet.db.persistence.metadata.parser.DataDiction
aryParser getPrimaryKey
WARNING: The PKName :: CalendarScheduleMultipleEntry_PK1 of tableName :: Calenda
rScheduleMultipleEntry has 33 characters.
May 11, 2017 4:29:28 PM com.adventnet.db.persistence.metadata.parser.DataDiction
aryParser getForeignKey
WARNING: The FKName :: CalendarScheduleMultipleEntry_FK1 of tableName :: Calenda
rScheduleMultipleEntry has 33 characters.
May 11, 2017 4:29:28 PM com.adventnet.db.persistence.metadata.parser.DataDiction
aryParser getPrimaryKey
WARNING: The PKName :: DISCOVERYRULESACTIONMAPPING_PK1 of tableName :: DISCOVERY
RULESACTIONMAPPING has 31 characters.
May 11, 2017 4:29:28 PM com.adventnet.db.persistence.metadata.parser.DataDiction
aryParser getForeignKey
WARNING: The FKName :: DISCOVERYRULESACTIONMAPPING_FK1 of tableName :: DISCOVERY
RULESACTIONMAPPING has 31 characters.
May 11, 2017 4:29:28 PM com.adventnet.db.persistence.metadata.parser.DataDiction
aryParser getForeignKey
WARNING: The FKName :: DISCOVERYRULESACTIONMAPPING_FK2 of tableName :: DISCOVERY
RULESACTIONMAPPING has 31 characters.
May 11, 2017 4:29:28 PM com.adventnet.db.persistence.metadata.parser.DataDiction
aryParser getPrimaryKey
WARNING: The PKName :: RecurringNotificationDetails_PK1 of tableName :: Recurrin
gNotificationDetails has 32 characters.
May 11, 2017 4:29:28 PM com.adventnet.db.persistence.metadata.parser.DataDiction
aryParser getForeignKey
WARNING: The FKName :: RecurringNotificationDetails_FK1 of tableName :: Recurrin
gNotificationDetails has 32 characters.
May 11, 2017 4:29:28 PM com.adventnet.db.persistence.metadata.parser.DataDiction
aryParser getPrimaryKey
WARNING: The PKName :: HardwareSensorStatisticsHourly_PK of tableName :: Hardwar
eSensorStatisticsHourly has 33 characters.
May 11, 2017 4:29:28 PM com.adventnet.db.persistence.metadata.parser.DataDiction
aryParser getPrimaryKey
WARNING: The PKName :: HardwareSensorStatisticsDaily_PK of tableName :: Hardware
SensorStatisticsDaily has 32 characters.
May 11, 2017 4:29:28 PM com.adventnet.db.persistence.metadata.parser.DataDiction
aryParser getPrimaryKey
WARNING: The PKName :: FUNCTIONALEXPRESSIONMAPPING_PK1 of tableName :: FUNCTIONA
LEXPRESSIONMAPPING has 31 characters.
May 11, 2017 4:29:28 PM com.adventnet.db.persistence.metadata.parser.DataDiction
aryParser getForeignKey
WARNING: The FKName :: FUNCTIONALEXPRESSIONMAPPING_FK1 of tableName :: FUNCTIONA
LEXPRESSIONMAPPING has 31 characters.
May 11, 2017 4:29:28 PM com.adventnet.db.persistence.metadata.parser.DataDiction
aryParser getForeignKey
WARNING: The FKName :: FUNCTIONALEXPRESSIONMAPPING_FK2 of tableName :: FUNCTIONA
LEXPRESSIONMAPPING has 31 characters.
May 11, 2017 4:29:28 PM com.adventnet.db.persistence.metadata.parser.DataDiction
aryParser getForeignKey
WARNING: The FKName :: FUNCTIONALEXPRESSIONMAPPING_FK3 of tableName :: FUNCTIONA
LEXPRESSIONMAPPING has 31 characters.
May 11, 2017 4:29:28 PM com.adventnet.db.persistence.metadata.parser.DataDiction
aryParser getPrimaryKey
WARNING: The PKName :: TempDependentUnavailableHourly_PK of tableName :: TempDep
endentUnavailableHourly has 33 characters.
May 11, 2017 4:29:28 PM com.adventnet.db.persistence.metadata.parser.DataDiction
aryParser getPrimaryKey
WARNING: The PKName :: ProcessInstanceCountThreshold_PK of tableName :: ProcessI
nstanceCountThreshold has 32 characters.
May 11, 2017 4:29:28 PM com.adventnet.db.persistence.metadata.parser.DataDiction
aryParser getForeignKey
WARNING: The FKName :: ProcessInstanceCountThreshold_FK of tableName :: ProcessI
nstanceCountThreshold has 32 characters.
May 11, 2017 4:29:28 PM com.adventnet.db.persistence.metadata.parser.DataDiction
aryParser getPrimaryKey
WARNING: The PKName :: DefaultVOIPJitterSettingsTemplate_PK of tableName :: Defa
ultVOIPJitterSettingsTemplate has 36 characters.
May 11, 2017 4:29:28 PM com.adventnet.db.persistence.metadata.parser.DataDiction
aryParser getForeignKey
WARNING: The FKName :: DefaultVOIPJitterSettingsTemplate_FK of tableName :: Defa
ultVOIPJitterSettingsTemplate has 36 characters.
May 11, 2017 4:29:28 PM com.adventnet.db.persistence.metadata.parser.DataDiction
aryParser getPrimaryKey
WARNING: The PKName :: VirtualDeviceMonitorRuleList_PK1 of tableName :: VirtualD
eviceMonitorRuleList has 32 characters.
May 11, 2017 4:29:28 PM com.adventnet.db.persistence.metadata.parser.DataDiction
aryParser getForeignKey
WARNING: The FKName :: VirtualDeviceMonitorRuleList_FK1 of tableName :: VirtualD
eviceMonitorRuleList has 32 characters.
May 11, 2017 4:29:28 PM com.adventnet.db.persistence.metadata.parser.DataDiction
aryParser getPrimaryKey
WARNING: The PKName :: CalendarScheduleSingleEntry_PK1 of tableName :: CalendarS
cheduleSingleEntry has 31 characters.
May 11, 2017 4:29:28 PM com.adventnet.db.persistence.metadata.parser.DataDiction
aryParser getForeignKey
WARNING: The FKName :: CalendarScheduleSingleEntry_FK1 of tableName :: CalendarS
cheduleSingleEntry has 31 characters.
May 11, 2017 4:29:28 PM com.adventnet.db.persistence.metadata.parser.DataDiction
aryParser getPrimaryKey
WARNING: The PKName :: CalendarScheduleMultipleEntry_PK1 of tableName :: Calenda
rScheduleMultipleEntry has 33 characters.
May 11, 2017 4:29:28 PM com.adventnet.db.persistence.metadata.parser.DataDiction
aryParser getForeignKey
WARNING: The FKName :: CalendarScheduleMultipleEntry_FK1 of tableName :: Calenda
rScheduleMultipleEntry has 33 characters.
May 11, 2017 4:29:28 PM com.adventnet.db.persistence.metadata.parser.DataDiction
aryParser getPrimaryKey
WARNING: The PKName :: DISCOVERYRULESACTIONMAPPING_PK1 of tableName :: DISCOVERY
RULESACTIONMAPPING has 31 characters.
May 11, 2017 4:29:28 PM com.adventnet.db.persistence.metadata.parser.DataDiction
aryParser getForeignKey
WARNING: The FKName :: DISCOVERYRULESACTIONMAPPING_FK1 of tableName :: DISCOVERY
RULESACTIONMAPPING has 31 characters.
May 11, 2017 4:29:28 PM com.adventnet.db.persistence.metadata.parser.DataDiction
aryParser getForeignKey
WARNING: The FKName :: DISCOVERYRULESACTIONMAPPING_FK2 of tableName :: DISCOVERY
RULESACTIONMAPPING has 31 characters.
May 11, 2017 4:29:28 PM com.adventnet.db.persistence.metadata.parser.DataDiction
aryParser getPrimaryKey
WARNING: The PKName :: RecurringNotificationDetails_PK1 of tableName :: Recurrin
gNotificationDetails has 32 characters.
May 11, 2017 4:29:28 PM com.adventnet.db.persistence.metadata.parser.DataDiction
aryParser getForeignKey
WARNING: The FKName :: RecurringNotificationDetails_FK1 of tableName :: Recurrin
gNotificationDetails has 32 characters.
May 11, 2017 4:29:28 PM com.adventnet.db.persistence.metadata.parser.DataDiction
aryParser getPrimaryKey
WARNING: The PKName :: HardwareSensorStatisticsHourly_PK of tableName :: Hardwar
eSensorStatisticsHourly has 33 characters.
May 11, 2017 4:29:28 PM com.adventnet.db.persistence.metadata.parser.DataDiction
aryParser getPrimaryKey
WARNING: The PKName :: HardwareSensorStatisticsDaily_PK of tableName :: Hardware
SensorStatisticsDaily has 32 characters.
May 11, 2017 4:29:28 PM com.adventnet.db.persistence.metadata.parser.DataDiction
aryParser getPrimaryKey
WARNING: The PKName :: FUNCTIONALEXPRESSIONMAPPING_PK1 of tableName :: FUNCTIONA
LEXPRESSIONMAPPING has 31 characters.
May 11, 2017 4:29:28 PM com.adventnet.db.persistence.metadata.parser.DataDiction
aryParser getForeignKey
WARNING: The FKName :: FUNCTIONALEXPRESSIONMAPPING_FK1 of tableName :: FUNCTIONA
LEXPRESSIONMAPPING has 31 characters.
May 11, 2017 4:29:28 PM com.adventnet.db.persistence.metadata.parser.DataDiction
aryParser getForeignKey
WARNING: The FKName :: FUNCTIONALEXPRESSIONMAPPING_FK2 of tableName :: FUNCTIONA
LEXPRESSIONMAPPING has 31 characters.
May 11, 2017 4:29:28 PM com.adventnet.db.persistence.metadata.parser.DataDiction
aryParser getForeignKey
WARNING: The FKName :: FUNCTIONALEXPRESSIONMAPPING_FK3 of tableName :: FUNCTIONA
LEXPRESSIONMAPPING has 31 characters.
jdbc.BackupException: Exception reading dynamic tables.
at jdbc.BackupDBUtil.getDynamicTablesFromMetaTable(BackupDBUtil.java:758
)
at jdbc.AbstractBackupDB.getAllTableNames(AbstractBackupDB.java:131)
at jdbc.AbstractBackupDB.backupDB(AbstractBackupDB.java:79)
at jdbc.AbstractBackupDB.doBackup(AbstractBackupDB.java:438)
at jdbc.BackUpImpl.backupDB(BackUpImpl.java:72)
at jdbc.BackUpImpl.main(BackUpImpl.java:167)
Caused by: java.lang.NullPointerException
at jdbc.BackupDBUtil.getTableProps(BackupDBUtil.java:771)
at jdbc.BackupDBUtil.getDynamicTablesFromMetaTable(BackupDBUtil.java:749
)
... 5 more
Rgds
Kamalanathan