*ERROR: relation "servicereq_901" does not exist
Good day.
I need help.
We testing ServiceDesk on Unbuntu + Mysql 9106 release
After good test we want make ServiceDesk at general work system
Create virtual host and install on Windows 7 + default postgre base with 9106 release
After recovery base from mysql to postgre we have problem - "BackUP" don't work..
Wats wrong we do?
In command line sign:
- "cd c:\ManageEngine\ServiceDesk\bin"
- "backUpData.bat"
Starting....
03.09.2015 16:24:00 com.adventnet.servicedesk.server.utils.SDDataManager setStandAlone
INFO: Going to set the standAlone param as : true
03.09.2015 16:24:00 com.adventnet.servicedesk.server.utils.SDDataManager setStandAlone
INFO: Going to reset rootDir using server.dir
03.09.2015 16:24:00 com.adventnet.servicedesk.server.utils.SDDataManager <init>INFO: rootDir :: ..
03.09.2015 16:24:00 com.adventnet.servicedesk.server.utils.SDDataManager <init>
INFO: netutilsData :: {RELEASE={version=9.1}, BUILD={number=9106}}
03.09.2015 16:24:00 com.adventnet.servicedesk.server.utils.SDDataManager <init>
INFO: rebrandData :: {ADSELFSERVICE={name=ADSelfService Plus}, OPMANAGER={name=OpManager}, PRODUCT={name=ManageEngine ServiceDesk Plus}, ADMANAGER={name=ADManager Plus}}
Active DB Server = postgres
Database connectionProp : null
Error while trying to instantiate SQLGeneratir com.adventnet.db.adapter.SQLGenerator java.lang.InstantiationException:com.adventnet.db.adapter.SQLGenerator
03.09.2015 16:24:01 com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer <init>
INFO: db.home ::: c:\ManageEngine\ServiceDesk\bin\\..\pgsql
03.09.2015 16:24:01 com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer <init>
INFO: dataDirectory :: C:\ManageEngine\ServiceDesk\pgsql\data
Database started
*************************************************************
Number of tables found : 1384
-------------------------------------------------------------
Build number : 9106
-------------------------------------------------------------
backup_info.xml : true
-------------------------------------------------------------
Ignored Table List
-------------------------------------------------------------
AaaAccSessionAudit
AaaAccHttpSession
AaaAccSessionProp
AaaAccSession
AuditRecord
OperationAuditRecord
AuditResultProperty
AuditResourceProp
AuditOperProperty
RecentItems
-------------------------------------------------------------
Going to take full backup with file attachments
-------------------------------------------------------------
deleting duplicate entries in WordMap table : 0
*************************************************************
Please wait ! backup in Progress...................
0-----------------------50------------------------100(%)
============================================ERROR = *ERROR: relation "servicereq
_901" does not exist
╨Я╨╛╨╖╨╕╤Ж╨╕╤П: 30* Query = SELECT max(WORKORDERID) FROM ServiceReq_901
java.lang.Exception: Unable to get the data from [ServiceReq_901] table
at com.adventnet.servicedesk.tools.SDBackUp.dumpTableUsingLimit(SDBackUp
.java:1485)
at com.adventnet.servicedesk.tools.SDBackUp.dumpTableUsingLimit(SDBackUp
.java:1506)
at com.adventnet.servicedesk.tools.SDBackUp.dumpTableUsingCriteria(SDBac
kUp.java:1125)
at com.adventnet.servicedesk.tools.SDBackUp.dumpTable(SDBackUp.java:1096
)
at com.adventnet.servicedesk.tools.SDBackUp.startBackup(SDBackUp.java:36
9)
at com.adventnet.servicedesk.tools.SDBackUp.process(SDBackUp.java:104)
at com.adventnet.servicedesk.tools.SDBackUp.main(SDBackUp.java:2425)
stopping DB Server >>>>> false
java.lang.Exception: Unable to get the data from [ServiceReq_901] table
at com.adventnet.servicedesk.tools.SDBackUp.dumpTableUsingLimit(SDBackUp
.java:1485)
at com.adventnet.servicedesk.tools.SDBackUp.dumpTableUsingLimit(SDBackUp
.java:1506)
at com.adventnet.servicedesk.tools.SDBackUp.dumpTableUsingCriteria(SDBac
kUp.java:1125)
at com.adventnet.servicedesk.tools.SDBackUp.dumpTable(SDBackUp.java:1096
)
at com.adventnet.servicedesk.tools.SDBackUp.startBackup(SDBackUp.java:36
9)
at com.adventnet.servicedesk.tools.SDBackUp.process(SDBackUp.java:104)
at com.adventnet.servicedesk.tools.SDBackUp.main(SDBackUp.java:2425)