Ok... I have proceeded forward with my migration.. I updated a test server to a snapshot 5.1.11 running on an embedded database. Exported the repository. Then I imported the repository with metadata and history checked... I get an error on the import that looks like the new database could not handle the length of some of the data that the old system could handle... Below is the error... How do you think I should proceed?
Code: Select all2012-11-20 13:11:06,574 [http-bio-0.0.0.0-8080-exec-4] WARN org.hibernate.util.JDBCExceptionReporter - SQL Error: 0, SQLState: 22001
2012-11-20 13:11:06,574 [http-bio-0.0.0.0-8080-exec-4] ERROR org.hibernate.util.JDBCExceptionReporter - ERROR: value too long for type character varying(2048)
2012-11-20 13:11:06,574 [http-bio-0.0.0.0-8080-exec-4] ERROR com.openkm.util.impexp.RepositoryImporter - Could not execute JDBC batch update
com.openkm.core.DatabaseException: Could not execute JDBC batch update
at com.openkm.util.impexp.metadata.DbMetadataAdapter.importWithMetadata(DbMetadataAdapter.java:449)
at com.openkm.util.impexp.RepositoryImporter.importDocumentsHelper(RepositoryImporter.java:164)
at com.openkm.util.impexp.RepositoryImporter.importDocumentsHelper(RepositoryImporter.java:192)
at com.openkm.util.impexp.RepositoryImporter.importDocumentsHelper(RepositoryImporter.java:192)
at com.openkm.util.impexp.RepositoryImporter.importDocumentsHelper(RepositoryImporter.java:192)
at com.openkm.util.impexp.RepositoryImporter.importDocuments(RepositoryImporter.java:87)
at org.apache.jsp.admin.repository_005fimport_jsp._jspService(repository_005fimport_jsp.java:168)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:432)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:390)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:334)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:311)
at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:116)
at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323)
at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:113)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323)
at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:101)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323)
at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:113)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323)
at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:54)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323)
at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:45)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323)
at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:182)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323)
at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:87)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323)
at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:173)
at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346)
at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:225)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:169)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:927)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407)
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:999)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:565)
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:309)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:662)
Caused by: org.hibernate.exception.DataException: Could not execute JDBC batch update
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:102)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:275)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:268)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:184)
at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321)
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:51)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1216)
at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:383)
at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:133)
at com.openkm.dao.HibernateUtil.commit(HibernateUtil.java:317)
at com.openkm.util.impexp.metadata.DbMetadataAdapter.importWithMetadata(DbMetadataAdapter.java:446)
... 51 more
Caused by: java.sql.BatchUpdateException: Batch entry 0 /* insert com.openkm.dao.bean.NodeNote */ insert into OKM_NODE_NOTE (NNT_AUTHOR, NNT_CREATED, NNT_PARENT, NNT_TEXT, NNT_UUID) values ('kevin', '2012-01-04 00:35:18.000000 -05:00:00', '59280bbc-b662-47ad-9415-158933b9eb67', '<span class="Apple-style-span" style="border-collapse: separate; color: rgb(0, 0, 0); font-family: ''Times New Roman''; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: -webkit-auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; font-size: medium; "><span class="Apple-style-span" style="font-family: sans-serif; font-size: 13px; text-align: -webkit-center; "><table class="boldtable" style="font-family: sans-serif; font-size: 12px; " align="center" border="1" cellpadding="5" cellspacing="0" width="600"><tbody><tr bgcolor="#eab060"><td style="font-family: sans-serif; font-size: 12px; "><div align="center"><font color="white" face="Arial, Helvetica, sans-serif"><b>Your request number is A105801WW</b></font></div></td></tr><tr><td style="font-family: sans-serif; font-size: 12px; "><br><b>Your reservation request has been received and is currently pending confirmation. Please make a record of this request number for future use. If you entered an email address, you should expect an email regarding the status of your reservation. To review the status of your reservation, please click "Check on a current Reservation" and enter your request number.<span class="Apple-converted-space"> </span><br><br><table class="boldtablewhite" style="font-family: sans-serif; font-size: 12px; color: rgb(255, 255, 255); " align="center" bgcolor="#ffffff" cellpadding="3" cellspacing="1" width="360"><tbody><tr><td class="boxoff" style="font-family: sans-serif; font-size: 12px; color: rgb(255, 255, 255); padding-top: 3px; padding-right: 3px; padding-bottom: 3px; padding-left: 3px; background-color: rgb(234, 176, 96); " width="60"><b>Room</b></td><td class="boxoff" style="font-family: sans-serif; font-size: 12px; color: rgb(255, 255, 255); padding-top: 3px; padding-right: 3px; padding-bottom: 3px; padding-left: 3px; background-color: rgb(234, 176, 96); " width="300">3 - No. 3 (King High Poster)</td></tr><tr><td class="boxoff" style="font-family: sans-serif; font-size: 12px; color: rgb(255, 255, 255); padding-top: 3px; padding-right: 3px; padding-bottom: 3px; padding-left: 3px; background-color: rgb(234, 176, 96); "><b>Dates</b></td><td class="boxoff" style="font-family: sans-serif; font-size: 12px; color: rgb(255, 255, 255); padding-top: 3px; padding-right: 3px; padding-bottom: 3px; padding-left: 3px; background-color: rgb(234, 176, 96); ">6/11/2012 - 6/13/2012</td></tr></tbody></table><br><table class="boldtablewhite" style="font-family: sans-serif; font-size: 12px; color: rgb(255, 255, 255); " align="center" bgcolor="#ffffff" border="0" cellpadding="3" cellspacing="1" width="360"><tbody><tr><td class="boxoff" style="font-family: sans-serif; font-size: 12px; color: rgb(255, 255, 255); padding-top: 3px; padding-right: 3px; padding-bottom: 3px; padding-left: 3px; background-color: rgb(234, 176, 96); " width="300"><div><font color="#FFFFFF"><b>Charge Type</b></font></div></td><td class="boxoff" style="font-family: sans-serif; font-size: 12px; color: rgb(255, 255, 255); padding-top: 3px; padding-right: 3px; padding-bottom: 3px; padding-left: 3px; background-color: rgb(234, 176, 96); " width="60"><div align="center"><font color="#FFFFFF"><b><font size="2" face="Arial, Helvetica, sans-serif">Price</font></b></font></div></td></tr><tr><td class="boxoff" style="font-family: sans-serif; font-size: 12px; color: rgb(255, 255, 255); padding-top: 3px; padding-right: 3px; padding-bottom: 3px; padding-left: 3px; background-color: rgb(234, 176, 96); ">Room Charge</td><td class="boxoff" style="font-family: sans-serif; font-size: 12px; color: rgb(255, 255, 255); padding-top: 3px; padding-right: 3px; padding-bottom: 3px; padding-left: 3px; background-color: rgb(234, 176, 96); "><div align="right">$638.00</div></td></tr><tr><td class="boxoff" style="font-family: sans-serif; font-size: 12px; color: rgb(255, 255, 255); padding-top: 3px; padding-right: 3px; padding-bottom: 3px; padding-left: 3px; background-color: rgb(234, 176, 96); " align="right"><b>Sub Total:</b></td><td class="boxoff" style="font-family: sans-serif; font-size: 12px; color: rgb(255, 255, 255); padding-top: 3px; padding-right: 3px; padding-bottom: 3px; padding-left: 3px; background-color: rgb(234, 176, 96); "><div align="right"><b>$638.00</b></div></td></tr><tr><td class="boxoff" style="font-family: sans-serif; font-size: 12px; color: rgb(255, 255, 255); padding-top: 3px; padding-right: 3px; padding-bottom: 3px; padding-left: 3px; background-color: rgb(234, 176, 96); " align="right">Lodging Tax:</td><td class="boxoff" style="font-family: sans-serif; font-size: 12px; color: rgb(255, 255, 255); padding-top: 3px; padding-right: 3px; padding-bottom: 3px; padding-left: 3px; background-color: rgb(234, 176, 96); "><div align="right">$38.28</div></td></tr><tr><td class="boxoff" style="font-family: sans-serif; font-size: 12px; color: rgb(255, 255, 255); padding-top: 3px; padding-right: 3px; padding-bottom: 3px; padding-left: 3px; background-color: rgb(234, 176, 96); " align="right">Sales Tax:</td><td class="boxoff" style="font-family: sans-serif; font-size: 12px; color: rgb(255, 255, 255); padding-top: 3px; padding-right: 3px; padding-bottom: 3px; padding-left: 3px; background-color: rgb(234, 176, 96); "><div align="right">$36.37</div></td></tr><tr><td class="boxoff" style="font-family: sans-serif; font-size: 12px; color: rgb(255, 255, 255); padding-top: 3px; padding-right: 3px; padding-bottom: 3px; padding-left: 3px; background-color: rgb(234, 176, 96); " align="right"><b><font size="2" face="Arial, Helvetica, sans-serif">Total Cost:</font></b></td><td class="boxoff" style="font-family: sans-serif; font-size: 12px; color: rgb(255, 255, 255); padding-top: 3px; padding-right: 3px; padding-bottom: 3px; padding-left: 3px; background-color: rgb(234, 176, 96); "><div align="right"><b><font size="2" face="Arial, Helvetica, sans-serif">$712.65</font></b></div></td></tr><tr><td class="boxoff" style="font-family: sans-serif; font-size: 12px; color: rgb(255, 255, 255); padding-top: 3px; padding-right: 3px; padding-bottom: 3px; padding-left: 3px; background-color: rgb(234, 176, 96); " align="right">Amount Paid:</td><td class="boxoff" style="font-family: sans-serif; font-size: 12px; color: rgb(255, 255, 255); padding-top: 3px; padding-right: 3px; padding-bottom: 3px; padding-left: 3px; background-color: rgb(234, 176, 96); "><div align="right"><b>$712.65</b></div></td></tr><tr><td class="boxoff" style="font-family: sans-serif; font-size: 12px; color: rgb(255, 255, 255); padding-top: 3px; padding-right: 3px; padding-bottom: 3px; padding-left: 3px; background-color: rgb(234, 176, 96); " align="right"><b><font size="2" face="Arial, Helvetica, sans-serif">Balance:</font></b></td><td class="boxoff" style="font-family: sans-serif; font-size: 12px; color: rgb(255, 255, 255); padding-top: 3px; padding-right: 3px; padding-bottom: 3px; padding-left: 3px; background-color: rgb(234, 176, 96); "><div align="right"><b><font size="2" face="Arial, Helvetica, sans-serif">$0.00</font></b></div></td></tr></tbody></table></b></td></tr></tbody></table></span></span>', '0871dc0d-b491-424f-a6a1-74a6adf23c87') was aborted. Call getNextException to see the cause.
at org.postgresql.jdbc2.AbstractJdbc2Statement$BatchResultHandler.handleError(AbstractJdbc2Statement.java:2746)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1887)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:405)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:2893)
at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:297)
at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:297)
at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:70)
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:268)
... 60 more