<div> </div>

<div>Imported commons successfully, but getting below error on importing springmanager.</div>

<div> </div>

<div>Using MySQL 5, Tomcat 5.0.28 and OpenCms_Workflow2_v0.4.1_full-package.zip</div>

<div> </div>

<div>Tried increasing size of " max_allowed_packet" to <19999744>, but no success.</div>

<div> </div>

<div>******************************* <strong>START ERROR</strong>***************************</div>

<div>( 14 / 22 ) Importing /system/modules/com.bearingpoint.opencms.commons.springmanager/lib/hibernate-entitymanager.jar ... o.k.<br>( 15 / 22 ) Importing /system/modules/com.bearingpoint.opencms.commons.springmanager/lib/hibernate3.jar ... Exception 

org.opencms.db.CmsDbSqlException: Error creating resource "/system/modules/com.bearingpoint.opencms.commons.springmanager/lib/hibernate3.jar" on path "/system/modules/com.bearingpoint.opencms.commons.springmanager/lib/hibernate3.jar".

<br>at org.opencms.db.CmsDbSqlException.createException(CmsDbSqlException.java:116)<br>at org.opencms.db.CmsDbContext.throwException(CmsDbContext.java:238)<br>at org.opencms.db.CmsDbContext.report(CmsDbContext.java:212)<br>

at org.opencms.db.CmsSecurityManager.importResource(CmsSecurityManager.java:2605)<br>at org.opencms.file.types.A_CmsResourceType.importResource(A_CmsResourceType.java:475)<br>at org.opencms.file.CmsObject.importResource(CmsObject.java

:2011)<br>at org.opencms.importexport.CmsImportVersion4.importResource(CmsImportVersion4.java:353)<br>at org.opencms.importexport.CmsImportVersion4.readResourcesFromManifest(CmsImportVersion4.java:516)<br>at org.opencms.importexport.CmsImportVersion4.importResources

(CmsImportVersion4.java:140)<br>at org.opencms.importexport.CmsImport.importResources(CmsImport.java:308)<br>at org.opencms.module.CmsModuleImportExportHandler.importModule(CmsModuleImportExportHandler.java:557)<br>at org.opencms.module.CmsModuleImportExportHandler.importData

(CmsModuleImportExportHandler.java:358)<br>at org.opencms.importexport.CmsImportExportManager.importData(CmsImportExportManager.java:694)<br>at org.opencms.workplace.threads.CmsDatabaseImportThread.run(CmsDatabaseImportThread.java

:90)<br>Caused by: org.opencms.db.CmsDbSqlException: An SQL error occurred when executing the following query: <a href="mailto:com.mysql.jdbc.PreparedStatement@1eb2473">com.mysql.jdbc.PreparedStatement@1eb2473</a>: INSERT INTO CMS_OFFLINE_CONTENTS (RESOURCE_ID,FILE_CONTENT) VALUES ('7c46f962-c98d-11dc-8e29-a99bc8653b57',** STREAM DATA **). 

<br>at org.opencms.db.generic.CmsVfsDriver.createContent(CmsVfsDriver.java:174)<br>at org.opencms.db.generic.CmsVfsDriver.createResource(CmsVfsDriver.java:622)<br>at org.opencms.db.CmsDriverManager.createResource(CmsDriverManager.java

:1679) at org.opencms.db.CmsSecurityManager.importResource(CmsSecurityManager.java:2603) ... 10 more Caused by: com.mysql.jdbc.PacketTooBigException: Packet for query is too large (2036199 > 1048576). You can change this value on the server by setting the max_allowed_packet' variable.

<br>at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2691)<br>at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1612)<br>at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723)<br>at com.mysql.jdbc.Connection.execSQL(Connection.java

:3256)<br>at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1313)<br>at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1585)<br>at com.mysql.jdbc.PreparedStatement.executeUpdate

(PreparedStatement.java:1500)<br>at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1485)<br>at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)

<br>at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)<br>at org.opencms.db.generic.CmsVfsDriver.createContent(CmsVfsDriver.java:172)<br>... 13 more<br>Exception org.opencms.db.CmsDbSqlException

: Error creating resource "/system/modules/com.bearingpoint.opencms.commons.springmanager/lib/hibernate3.jar" on path "/system/modules/com.bearingpoint.opencms.commons.springmanager/lib/hibernate3.jar".

<br>at org.opencms.db.CmsDbSqlException.createException(CmsDbSqlException.java:116)<br>at org.opencms.db.CmsDbContext.throwException(CmsDbContext.java:238)<br>at org.opencms.db.CmsDbContext.report(CmsDbContext.java:212)<br>

at org.opencms.db.CmsSecurityManager.importResource(CmsSecurityManager.java:2605)<br>at org.opencms.file.types.A_CmsResourceType.importResource(A_CmsResourceType.java:475)<br>at org.opencms.file.CmsObject.importResource(CmsObject.java

:2011)<br>at org.opencms.importexport.CmsImportVersion4.importResource(CmsImportVersion4.java:353)<br>at org.opencms.importexport.CmsImportVersion4.readResourcesFromManifest(CmsImportVersion4.java:516)<br>at org.opencms.importexport.CmsImportVersion4.importResources

(CmsImportVersion4.java:140)<br>at org.opencms.importexport.CmsImport.importResources(CmsImport.java:308)<br>at org.opencms.module.CmsModuleImportExportHandler.importModule(CmsModuleImportExportHandler.java:557)<br>at org.opencms.module.CmsModuleImportExportHandler.importData

(CmsModuleImportExportHandler.java:358)<br>at org.opencms.importexport.CmsImportExportManager.importData(CmsImportExportManager.java:694)<br>at org.opencms.workplace.threads.CmsDatabaseImportThread.run(CmsDatabaseImportThread.java

:90)<br>Caused by: org.opencms.db.CmsDbSqlException: An SQL error occurred when executing the following query: <a href="mailto:com.mysql.jdbc.PreparedStatement@1eb2473">com.mysql.jdbc.PreparedStatement@1eb2473</a>: INSERT INTO CMS_OFFLINE_CONTENTS (RESOURCE_ID,FILE_CONTENT) VALUES ('7c46f962-c98d-11dc-8e29-a99bc8653b57',** STREAM DATA **). 

<br>at org.opencms.db.generic.CmsVfsDriver.createContent(CmsVfsDriver.java:174)<br>at org.opencms.db.generic.CmsVfsDriver.createResource(CmsVfsDriver.java:622)<br>at org.opencms.db.CmsDriverManager.createResource(CmsDriverManager.java

:1679) at org.opencms.db.CmsSecurityManager.importResource(CmsSecurityManager.java:2603) ... 10 more Caused by: com.mysql.jdbc.PacketTooBigException: Packet for query is too large (2036199 > 1048576). You can change this value on the server by setting the max_allowed_packet' variable.

<br>at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2691)<br>at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1612)<br>at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723)<br>at com.mysql.jdbc.Connection.execSQL(Connection.java

:3256)<br>at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1313)<br>at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1585)<br>at com.mysql.jdbc.PreparedStatement.executeUpdate

(PreparedStatement.java:1500)<br>at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1485)<br>at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)

<br>at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)<br>at org.opencms.db.generic.CmsVfsDriver.createContent(CmsVfsDriver.java:172)<br>... 13 more<br>Skipping /system/modules/com.bearingpoint.opencms.commons.springmanager/lib/hibernate3.jar 

<br>( 16 / 22 ) Importing /system/modules/com.bearingpoint.opencms.commons.springmanager/lib/jta.jar ... o.k.<br>( 17 / 22 ) Importing /system/modules/com.bearingpoint.opencms.commons.springmanager/lib/spring-1.2.6.jar ... Exception 

org.opencms.db.CmsDbSqlException: Error creating resource "/system/modules/com.bearingpoint.opencms.commons.springmanager/lib/spring-1.2.6.jar" on path "/system/modules/com.bearingpoint.opencms.commons.springmanager/lib/spring-

1.2.6.jar".<br>at org.opencms.db.CmsDbSqlException.createException(CmsDbSqlException.java:116)<br>at org.opencms.db.CmsDbContext.throwException(CmsDbContext.java:238)<br>at org.opencms.db.CmsDbContext.report(CmsDbContext.java

:212)<br>at org.opencms.db.CmsSecurityManager.importResource(CmsSecurityManager.java:2605)<br>at org.opencms.file.types.A_CmsResourceType.importResource(A_CmsResourceType.java:475)<br>at org.opencms.file.CmsObject.importResource

(CmsObject.java:2011)<br>at org.opencms.importexport.CmsImportVersion4.importResource(CmsImportVersion4.java:353)<br>at org.opencms.importexport.CmsImportVersion4.readResourcesFromManifest(CmsImportVersion4.java:516)<br>at 

org.opencms.importexport.CmsImportVersion4.importResources(CmsImportVersion4.java:140)<br>at org.opencms.importexport.CmsImport.importResources(CmsImport.java:308)<br>at org.opencms.module.CmsModuleImportExportHandler.importModule

(CmsModuleImportExportHandler.java:557)<br>at org.opencms.module.CmsModuleImportExportHandler.importData(CmsModuleImportExportHandler.java:358)<br>at org.opencms.importexport.CmsImportExportManager.importData(CmsImportExportManager.java

:694)<br>at org.opencms.workplace.threads.CmsDatabaseImportThread.run(CmsDatabaseImportThread.java:90)<br>Caused by: org.opencms.db.CmsDbSqlException: An SQL error occurred when executing the following query: <a href="mailto:com.mysql.jdbc.PreparedStatement@1eb2473">

com.mysql.jdbc.PreparedStatement@1eb2473</a>: INSERT INTO CMS_OFFLINE_CONTENTS (RESOURCE_ID,FILE_CONTENT) VALUES ('7d119c66-c98d-11dc-8e29-a99bc8653b57',** STREAM DATA **). <br>at org.opencms.db.generic.CmsVfsDriver.createContent

(CmsVfsDriver.java:174)<br>at org.opencms.db.generic.CmsVfsDriver.createResource(CmsVfsDriver.java:622)<br>at org.opencms.db.CmsDriverManager.createResource(CmsDriverManager.java:1679)<br>at org.opencms.db.CmsSecurityManager.importResource

(CmsSecurityManager.java:2603) ... 10 more Caused by: com.mysql.jdbc.PacketTooBigException: Packet for query is too large (1980691 > 1048576). You can change this value on the server by setting the max_allowed_packet' variable.

<br>at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2691)<br>at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1612)<br>at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723)<br>at com.mysql.jdbc.Connection.execSQL(Connection.java

:3256)<br>at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1313)<br>at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1585)<br>at com.mysql.jdbc.PreparedStatement.executeUpdate

(PreparedStatement.java:1500)<br>at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1485)<br>at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)

<br>at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)<br>at org.opencms.db.generic.CmsVfsDriver.createContent(CmsVfsDriver.java:172)<br>... 13 more<br>Skipping /system/modules/com.bearingpoint.opencms.commons.springmanager/lib/spring-

1.2.6.jar <br>( 18 / 22 ) Importing /system/modules/com.bearingpoint.opencms.commons.springmanager/lib/spring-mock.jar ... Exception org.opencms.db.CmsDbSqlException: Error creating resource "/system/modules/com.bearingpoint.opencms.commons.springmanager/lib/spring-

1.2.6.jar" on path "/system/modules/com.bearingpoint.opencms.commons.springmanager/lib/spring-1.2.6.jar".<br>at org.opencms.db.CmsDbSqlException.createException(CmsDbSqlException.java:116)<br>at org.opencms.db.CmsDbContext.throwException

(CmsDbContext.java:238)<br>at org.opencms.db.CmsDbContext.report(CmsDbContext.java:212)<br>at org.opencms.db.CmsSecurityManager.importResource(CmsSecurityManager.java:2605)<br>at org.opencms.file.types.A_CmsResourceType.importResource

(A_CmsResourceType.java:475)<br>at org.opencms.file.CmsObject.importResource(CmsObject.java:2011)<br>at org.opencms.importexport.CmsImportVersion4.importResource(CmsImportVersion4.java:353)<br>at org.opencms.importexport.CmsImportVersion4.readResourcesFromManifest

(CmsImportVersion4.java:516)<br>at org.opencms.importexport.CmsImportVersion4.importResources(CmsImportVersion4.java:140)<br>at org.opencms.importexport.CmsImport.importResources(CmsImport.java:308)<br>at org.opencms.module.CmsModuleImportExportHandler.importModule

(CmsModuleImportExportHandler.java:557)<br>at org.opencms.module.CmsModuleImportExportHandler.importData(CmsModuleImportExportHandler.java:358)<br>at org.opencms.importexport.CmsImportExportManager.importData(CmsImportExportManager.java

:694)<br>at org.opencms.workplace.threads.CmsDatabaseImportThread.run(CmsDatabaseImportThread.java:90)<br>Caused by: org.opencms.db.CmsDbSqlException: An SQL error occurred when executing the following query: <a href="mailto:com.mysql.jdbc.PreparedStatement@1eb2473">

com.mysql.jdbc.PreparedStatement@1eb2473</a>: INSERT INTO CMS_OFFLINE_CONTENTS (RESOURCE_ID,FILE_CONTENT) VALUES ('7d119c66-c98d-11dc-8e29-a99bc8653b57',** STREAM DATA **). <br>at org.opencms.db.generic.CmsVfsDriver.createContent

(CmsVfsDriver.java:174)<br>at org.opencms.db.generic.CmsVfsDriver.createResource(CmsVfsDriver.java:622)<br>at org.opencms.db.CmsDriverManager.createResource(CmsDriverManager.java:1679)<br>at org.opencms.db.CmsSecurityManager.importResource

(CmsSecurityManager.java:2603) ... 10 more Caused by: com.mysql.jdbc.PacketTooBigException: Packet for query is too large (1980691 > 1048576). You can change this value on the server by setting the max_allowed_packet' variable.

<br>at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2691)<br>at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1612)<br>at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723)<br>at com.mysql.jdbc.Connection.execSQL(Connection.java

:3256)<br>at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1313)<br>at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1585)<br>at com.mysql.jdbc.PreparedStatement.executeUpdate

(PreparedStatement.java:1500)<br>at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1485)<br>at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)

<br>at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)<br>at org.opencms.db.generic.CmsVfsDriver.createContent(CmsVfsDriver.java:172)<br>... 13 more<br>o.k.<br>( 19 / 22 ) Skipping /system/workplace/ 

<br>( 20 / 22 ) Skipping /system/workplace/admin/ <br>( 21 / 22 ) Importing /system/workplace/admin/bptools/ ... o.k.<br>( 22 / 22 ) Importing /system/workplace/admin/bptools/spring_factory_reload.jsp ... o.k.<br>Parsing links ...

<br>( 1 / 1 ) Parsing links for "/system/workplace/admin/bptools/spring_factory_reload.jsp"... o.k.<br>... The parsing process is finished.<br>Publishing project ...<br>Publishing resources ...<br>Publishing folders ...

<br>( 1 / 6 ) Publishing folder /system/ ... o.k.<br>( 2 / 6 ) Publishing folder /system/modules/com.bearingpoint.opencms.commons.springmanager/ ... o.k.<br>( 3 / 6 ) Publishing folder /system/modules/com.bearingpoint.opencms.commons.springmanager/classes/ ... 

o.k.<br>( 4 / 6 ) Publishing folder /system/modules/com.bearingpoint.opencms.commons.springmanager/config/ ... o.k.<br>( 5 / 6 ) Publishing folder /system/modules/com.bearingpoint.opencms.commons.springmanager/lib/ ... o.k

.<br>( 6 / 6 ) Publishing folder /system/workplace/admin/bptools/ ... o.k.<br>... finished publishing folders<br>Publishing files ...<br>( 1 / 13 ) Publishing file /system/modules/com.bearingpoint.opencms.commons.springmanager/config/bearingpoint-

springmanager.xml ... o.k.<br>( 2 / 13 ) Publishing file /system/modules/com.bearingpoint.opencms.commons.springmanager/lib/antlr-2.7.5H3.jar ... o.k.<br>( 3 / 13 ) Publishing file /system/modules/com.bearingpoint.opencms.commons.springmanager/lib/asm-

attrs.jar ... o.k.<br>( 4 / 13 ) Publishing file /system/modules/com.bearingpoint.opencms.commons.springmanager/lib/asm.jar ... o.k.<br>( 5 / 13 ) Publishing file /system/modules/com.bearingpoint.opencms.commons.springmanager/lib/cglib-

2.1_2jboss.jar ... o.k.<br>( 6 / 13 ) Publishing file /system/modules/com.bearingpoint.opencms.commons.springmanager/lib/com.bearingpoint.opencms.commons.springmanager.jar ... o.k.<br>( 7 / 13 ) Publishing file /system/modules/com.bearingpoint.opencms.commons.springmanager/lib/hibernate-

annotations.jar ... o.k.<br>( 8 / 13 ) Publishing file /system/modules/com.bearingpoint.opencms.commons.springmanager/lib/hibernate-entitymanager.jar ... o.k.<br>( 9 / 13 ) Publishing file /system/modules/com.bearingpoint.opencms.commons.springmanager/lib/hibernate3.jar ... Error publishing file "/system/modules/com.bearingpoint.opencms.commons.springmanager/lib/hibernate3.jar". 

</div>

<div>Exception org.opencms.file.CmsDataAccessException: Unable to read file contents with resource ID "7c46f962-c98d-11dc-8e29-a99bc8653b57" (online=false).<br>at org.opencms.db.generic.CmsProjectDriver.publishFile

(CmsProjectDriver.java:996)<br>at org.opencms.db.generic.CmsProjectDriver.publishProject(CmsProjectDriver.java:1407)<br>at org.opencms.db.CmsDriverManager.publishJob(CmsDriverManager.java:5073)<br>at org.opencms.publish.CmsPublishThread.run

(CmsPublishThread.java:141)<br>Caused by: org.opencms.file.CmsVfsResourceNotFoundException: Unable to read file contents with resource ID "7c46f962-c98d-11dc-8e29-a99bc8653b57" (online=false).<br>at org.opencms.db.generic.CmsVfsDriver.readContent

(CmsVfsDriver.java:1424)<br>at org.opencms.db.generic.CmsProjectDriver.publishFileContent(CmsProjectDriver.java:1022)<br>at org.opencms.db.generic.CmsProjectDriver.publishNewFile(CmsProjectDriver.java:2903)<br>at org.opencms.db.generic.CmsProjectDriver.publishFile

(CmsProjectDriver.java:952)<br>... 3 more<br>Statistics: published files: 9, published folders: 6, deleted folders: 0, duration: 00:00:00<br>Exception org.opencms.file.CmsDataAccessException: Error publishing file "/system/modules/com.bearingpoint.opencms.commons.springmanager/lib/hibernate3.jar". 

<br>at org.opencms.file.CmsDataAccessException.createException(CmsDataAccessException.java:77)<br>at org.opencms.db.CmsDbContext.throwException(CmsDbContext.java:238)<br>at org.opencms.db.CmsDbContext.report(CmsDbContext.java

:212)<br>at org.opencms.db.generic.CmsProjectDriver.publishProject(CmsProjectDriver.java:1427)<br>at org.opencms.db.CmsDriverManager.publishJob(CmsDriverManager.java:5073)<br>at org.opencms.publish.CmsPublishThread.run(CmsPublishThread.java

:141)<br>Caused by: org.opencms.file.CmsDataAccessException: Unable to read file contents with resource ID "7c46f962-c98d-11dc-8e29-a99bc8653b57" (online=false).<br>at org.opencms.db.generic.CmsProjectDriver.publishFile

(CmsProjectDriver.java:996) at org.opencms.db.generic.CmsProjectDriver.publishProject(CmsProjectDriver.java:1407) ... 2 more Caused by: org.opencms.file.CmsVfsResourceNotFoundException: Unable to read file contents with resource ID "7c46f962-c98d-11dc-8e29-a99bc8653b57" (online=false).

<br>at org.opencms.db.generic.CmsVfsDriver.readContent(CmsVfsDriver.java:1424)<br>at org.opencms.db.generic.CmsProjectDriver.publishFileContent(CmsProjectDriver.java:1022)<br>at org.opencms.db.generic.CmsProjectDriver.publishNewFile

(CmsProjectDriver.java:2903)<br>at org.opencms.db.generic.CmsProjectDriver.publishFile(CmsProjectDriver.java:952)<br>... 3 more<br>... the resources have been published<br>Writing export points ...<br>Writing export point /system/modules/com.bearingpoint.opencms.commons.springmanager/classes/ ... 

o.k.</div>

<div>

<div>******************************* <strong>END ERROR</strong>******************************</div></div>