Backup SDP kann nicht ausgeführt werden
Hi,
we're using SDP 9.1 Build 9117. If i try to make a backup by using the backUpData.bat i will get an error. (See below)
Can someone tell me where the problem is or point me in the right direction to resolve this issue?
I have attached my backUpdata.bat
Any help would be great.
Thanks & Regards
Kurt Brugger
(Hallo,
wir benutzen SDP 9.1 Build 9117. Beim ausführen des Backups per backUpData.bat erhalten wir immer einen Fehler. Siehe unten.
Was könnte hier die Ursache sein und wie können wir das Problem beheben?
Im Anhang backUpData.bat
Bin für jede Hilfe dankbar.
Mit freundlichen Grüßen
Kurt Brugger)
C:\ManageEngine\ServiceDesk\bin>backUpData.bat
Starting....
29.06.2016 10:14:11 com.adventnet.servicedesk.server.utils.SDDataManager setStan
dAlone
INFO: Going to set the standAlone param as : true
29.06.2016 10:14:11 com.adventnet.servicedesk.server.utils.SDDataManager setStan
dAlone
INFO: Going to reset rootDir using server.dir
29.06.2016 10:14:11 com.adventnet.servicedesk.server.utils.SDDataManager <init>
INFO: rootDir :: ..
29.06.2016 10:14:11 com.adventnet.servicedesk.server.utils.SDDataManager <init>
INFO: netutilsData :: {RELEASE={version=9.1}, BUILD={number=9117}}
29.06.2016 10:14:11 com.adventnet.servicedesk.server.utils.SDDataManager <init>
INFO: rebrandData :: {ADSELFSERVICE={name=ADSelfService Plus}, OPMANAGER={name=O
pManager}, PRODUCT={name=ManageEngine ServiceDesk Plus}, ADMANAGER={name=ADManag
er Plus}}
Active DB Server = postgres
Database connectionProp : null
Error while trying to instantiate SQLGeneratir com.adventnet.db.adapter.SQLGener
ator java.lang.InstantiationException: com.adventnet.db.adapter.SQLGenerator
29.06.2016 10:14:12 com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializ
er <init>
INFO: db.home ::: C:\ManageEngine\ServiceDesk\bin\\..\pgsql
29.06.2016 10:14:12 com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializ
er <init>
INFO: dataDirectory :: C:\ManageEngine\ServiceDesk\pgsql\data
Database started
*************************************************************
Number of tables found : 1348
-------------------------------------------------------------
Build number : 9117
-------------------------------------------------------------
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(%)
===================org.postgresql.util.PSQLException: Nicht gen├╝gend Speicher b
eim Abholen der Abfrageergebnisse.
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutor
Impl.java:1817)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.ja
va:257)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Stat
ement.java:500)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(Abstract
Jdbc2Statement.java:388)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc
2Statement.java:273)
at com.adventnet.servicedesk.tools.SDBackUp.dumpTableUsingCriteria(SDBac
kUp.java:1419)
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)
Caused by: java.lang.OutOfMemoryError: Java heap space
at org.postgresql.core.PGStream.ReceiveTupleV3(PGStream.java:364)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutor
Impl.java:1814)
... 9 more
java.io.IOException: Write error
at java.io.FileOutputStream.writeBytes(Native Method)
at java.io.FileOutputStream.write(Unknown Source)
at sun.nio.cs.StreamEncoder.writeBytes(Unknown Source)
at sun.nio.cs.StreamEncoder.implWrite(Unknown Source)
at sun.nio.cs.StreamEncoder.write(Unknown Source)
at java.io.OutputStreamWriter.write(Unknown Source)
at java.io.BufferedWriter.flushBuffer(Unknown Source)
at java.io.BufferedWriter.close(Unknown Source)
at com.adventnet.servicedesk.tools.SDBackUp.dumpTableUsingCriteria(SDBac
kUp.java:1474)
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)
org.postgresql.util.PSQLException: Nicht gen├╝gend Speicher beim Abholen der Abf
rageergebnisse.
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutor
Impl.java:1817)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.ja
va:257)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Stat
ement.java:500)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(Abstract
Jdbc2Statement.java:388)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc
2Statement.java:273)
at com.adventnet.servicedesk.tools.SDBackUp.dumpTableUsingCriteria(SDBac
kUp.java:1419)
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)
Caused by: java.lang.OutOfMemoryError: Java heap space
at org.postgresql.core.PGStream.ReceiveTupleV3(PGStream.java:364)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutor
Impl.java:1814)
... 9 more
stopping DB Server >>>>> false
org.postgresql.util.PSQLException: Nicht gen├╝gend Speicher beim Abholen der Abf
rageergebnisse.
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutor
Impl.java:1817)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.ja
va:257)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Stat
ement.java:500)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(Abstract
Jdbc2Statement.java:388)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc
2Statement.java:273)
at com.adventnet.servicedesk.tools.SDBackUp.dumpTableUsingCriteria(SDBac
kUp.java:1419)
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)
Caused by: java.lang.OutOfMemoryError: Java heap space
at org.postgresql.core.PGStream.ReceiveTupleV3(PGStream.java:364)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutor
Impl.java:1814)
... 9 more
C:\ManageEngine\ServiceDesk\bin>