Hi

After upgrading to SP3 last week, we have been unable to backup the embeded sybase database. This is similar it would appear to this post https://forums.novell.com/showthread.php/477384-Backing-up-database-fails

The dbbackup command bombs out with erros - (please see below).

I have run ZDC on the database, resulting in a couple of errors (please see below) - but nothing that would necessarlily indicate an issue with the backup process - or so it looks to me.

I noted that 11.3.1 came out yesterday - looking at the defect list I can see an entry relating to the database backup:

872943 1.2x Section Backing Up the Embedded Sybase SQL Anywhere Database on a Windows or Linux, wrong commando But I'm not sure if this doesn't relate to a documentation error relating to the manual backup process noted in the SP3 documentation.

Any help/insights appreciated.

OS: Windows Server 2008 R2 64 bit
Database: Embedded Sybase
ZCM Version: 11.3.0

+ Verifying Database metadata.

[!] 1 error(s) found while verifying Constraints of Table zQuickTaskAssignment

[!] 1 error(s) found while verifying Columns of Table zSystemUpdateLocation

+ Database metadata verification complete.





[TRACE] [07/16/2014 09:35:59.390] [2564] [ZMAN] [1] [] [ZMan] [] [Command: database-backup \\XX.XX.XX.XX\ZENworks\dbbackup ] [] [] [] [ZENServer]
[TRACE] [07/16/2014 09:36:01.406] [2564] [ZMAN] [1] [] [DataModelConfiguration] [] [Intializing DataModelConfiguration: zdm.xml] [] [] [] [ZENServer]
[TRACE] [07/16/2014 09:36:07.968] [2564] [ZMAN] [1] [] [DataModelConfiguration] [] [Initialized DataModelConfiguration: zdm.xml] [] [] [] [ZENServer]
[TRACE] [07/16/2014 09:36:08.000] [2564] [ZMAN] [1] [] [DataModelConfiguration] [] [Intializing DataModelConfiguration: zenaudit.xml] [] [] [] [ZENServer]
[TRACE] [07/16/2014 09:36:10.234] [2564] [ZMAN] [1] [] [DataModelConfiguration] [] [Initialized DataModelConfiguration: zenaudit.xml] [] [] [] [ZENServer]
[TRACE] [07/16/2014 09:40:35.406] [2564] [ZMAN] [1] [] [ZMan] [] [Error:An internal error occurred. Please check the zman log for more information.] [] [] [] [ZENServer]
[TRACE] [07/16/2014 09:40:35.406] [2564] [ZMAN] [1] [] [CommandRunner] [] [java.lang.reflect.InvocationTargetException
at sun.reflect.NativeMethodAccessorImpl.invoke0(Nativ e Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Native MethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(De legatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at com.novell.zenworks.zman.CommandRunner.execute(Com mandRunner.java:94)
at com.novell.zenworks.zman.ZMan.executeRunner(ZMan.j ava:328)
at com.novell.zenworks.zman.ZMan.runCommand(ZMan.java :531)
at com.novell.zenworks.zman.ZMan.main(ZMan.java:465)
at com.novell.zenworks.zman.ZManExecutor.execute(ZMan Executor.java:101)
at com.novell.zenworks.zman.ZManExecutor.main(ZManExe cutor.java:41)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Nativ e Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Native MethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(De legatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at com.novell.zenworks.zman.ZManLoader.loadZMan(ZManL oader.java:59)
at com.novell.zenworks.zman.ZManLoader.main(ZManLoade r.java:143)
Caused by: com.novell.zenworks.zman.exceptions.ZManException: com.novell.zenworks.datamodel.exceptions.InternalD ataModelException: com.novell.zenworks.datamodel.exceptions.InternalD ataModelException: java.lang.OutOfMemoryError: Java heap space
at com.novell.zenworks.zman.exceptions.ZManExceptionH andler.handleException(ZManExceptionHandler.java:2 35)
at com.novell.zenworks.zman.exceptions.ZManExceptionH andler.handleException(ZManExceptionHandler.java:6 8)
at com.novell.zenworks.zman.commands.DatabaseHandler. backupEmbeddedDB(DatabaseHandler.java:189)
... 16 more
Caused by: com.novell.zenworks.datamodel.exceptions.InternalD ataModelException: com.novell.zenworks.datamodel.exceptions.InternalD ataModelException: java.lang.OutOfMemoryError: Java heap space
at com.novell.zenworks.datamodel.session.hibernate.Hi bernateInfo._buildInfo(HibernateInfo.java:310)
at com.novell.zenworks.datamodel.session.hibernate.Hi bernateInfo.buildInfo(HibernateInfo.java:157)
at com.novell.zenworks.datamodel.session.hibernate.Hi bernateAbstractSession.getHibernateInfo(HibernateA bstractSession.java:1814)
at com.novell.zenworks.datamodel.session.hibernate.Hi bernateAbstractSession.getHibernateInfo(HibernateA bstractSession.java:1808)
at com.novell.zenworks.datamodel.session.hibernate.Hi bernateAbstractSession._prePasswordValidationIniti alize(HibernateAbstractSession.java:439)
at com.novell.zenworks.datamodel.session.hibernate.Hi bernateAbstractSession.login(HibernateAbstractSess ion.java:348)
at com.novell.zenworks.datamodel.services.DirectServi ceStoreImpl.login(DirectServiceStoreImpl.java:214)
at com.novell.zenworks.zman.commands.DatabaseHandler. backupEmbeddedDB(DatabaseHandler.java:160)
... 16 more
Caused by: com.novell.zenworks.datamodel.exceptions.InternalD ataModelException: java.lang.OutOfMemoryError: Java heap space
at com.novell.zenworks.datamodel.session.hibernate.Hi bernateInfo$2.run(HibernateInfo.java:192)
at java.lang.Thread.run(Thread.java:724)
Caused by: java.lang.OutOfMemoryError: Java heap space
at java.util.Arrays.copyOf(Arrays.java:2367)
at java.lang.AbstractStringBuilder.expandCapacity(Abs tractStringBuilder.java:130)
at java.lang.AbstractStringBuilder.ensureCapacityInte rnal(AbstractStringBuilder.java:114)
at java.lang.AbstractStringBuilder.append(AbstractStr ingBuilder.java:415)
at java.lang.StringBuilder.append(StringBuilder.java: 132)
at org.hibernate.sql.SelectFragment.toFragmentString( SelectFragment.java:151)
at org.hibernate.persister.entity.AbstractEntityPersi ster.propertySelectFragment(AbstractEntityPersiste r.java:1409)
at org.hibernate.persister.entity.AbstractEntityPersi ster.selectFragment(AbstractEntityPersister.java:1 374)
at org.hibernate.loader.AbstractEntityJoinWalker.init StatementString(AbstractEntityJoinWalker.java:123)
at org.hibernate.loader.AbstractEntityJoinWalker.init StatementString(AbstractEntityJoinWalker.java:108)
at org.hibernate.loader.AbstractEntityJoinWalker.init All(AbstractEntityJoinWalker.java:90)
at org.hibernate.loader.entity.EntityJoinWalker.<init >(EntityJoinWalker.java:75)
at org.hibernate.loader.entity.EntityLoader.<init>(En tityLoader.java:108)
at org.hibernate.loader.entity.EntityLoader.<init>(En tityLoader.java:70)
at org.hibernate.loader.entity.EntityLoader.<init>(En tityLoader.java:53)
at org.hibernate.loader.entity.BatchingEntityLoader.c reateBatchingEntityLoader(BatchingEntityLoader.jav a:131)
at org.hibernate.persister.entity.AbstractEntityPersi ster.createEntityLoader(AbstractEntityPersister.ja va:2332)
at org.hibernate.persister.entity.AbstractEntityPersi ster.createEntityLoader(AbstractEntityPersister.ja va:2355)
at org.hibernate.persister.entity.AbstractEntityPersi ster.createLoaders(AbstractEntityPersister.java:36 50)
at org.hibernate.persister.entity.AbstractEntityPersi ster.postInstantiate(AbstractEntityPersister.java: 3620)
at org.hibernate.persister.entity.SingleTableEntityPe rsister.postInstantiate(SingleTableEntityPersister .java:1016)
at org.hibernate.internal.SessionFactoryImpl.<init>(S essionFactoryImpl.java:462)
at org.hibernate.cfg.Configuration.buildSessionFactor y(Configuration.java:1744)
at com.novell.zenworks.datamodel.session.hibernate.Hi bernateInfo.contructSessionFactory(HibernateInfo.j ava:469)
at com.novell.zenworks.datamodel.session.hibernate.Hi bernateInfo$2.run(HibernateInfo.java:188)
... 1 more
] [] [] [] [ZENServer]
[TRACE] [07/16/2014 09:40:35.406] [2564] [ZMAN] [1] [] [ZMan] [] [Command failed (partially or totally)] [] [] [] [ZENServer]
[TRACE] [07/16/2014 09:40:35.406] [2564] [ZMAN] [1] [] [ZMan] [] [Command completed in 276078 ms] [] [] [] [ZENServer]
[TRACE] [07/16/2014 09:40:35.406] [2564] [ZMAN] [1] [] [ZMan] [] [ERROR Code: 11] [] [] [] [ZENServer]