[Anthill-pro] Error during database migration - 3.4.6
Ryan Smith
rws at urbancode.com
Tue Jan 22 09:52:33 CST 2008
Mladen,
That's seems a bit odd. We haven't seen this reported in this version. Perhaps some SQL files were mixed during the migration. To fix this, you can edit the com.urbancode.anthill3.domain.profile.BuildProfile.sql.xml file in the server's conf/sql directory.
In each of the RESTORE_* entries, you will see this:
S.CLASS AS SOURCE_CONFIG_CLASS
You can remove the AS SOURCE_CONFIG_CLASS so that it is just:
S.CLASS
If this is different in any way, just send support the file and we will get it fixed.
Ryan Smith
Mladen Maravić wrote:
> Hi all!
>
>
>
> I've tried migrating 3.4.6 from derby to mysql. The migration process
> finished ok and server started fine. After login, I got errors. It all
> boils down to this error in the server stdout file:
>
>
>
> Anybody have any clue as to what is going on? What is this CLASS column
> that doesn't exist.
>
>
>
> 2008-01-22 10:16:52,079 ERROR http-0.0.0.0-443-Processor25
> com.urbancode.anthill3.web.project.ProjectTasks - Error restoring object
> from database
>
> com.urbancode.anthill3.domain.persistent.PersistenceRuntimeException:
> Error restoring object from database
>
> at
> com.urbancode.anthill3.domain.persistent.Handle.dereference(Handle.java:162)
>
> at
> com.urbancode.anthill3.domain.workflow.Workflow.getBuildProfile(Workflow.java:194)
>
> at
> com.urbancode.anthill3.domain.project.Project.getOriginatingWorkflowArray(Project.java:691)
>
> at
> com.urbancode.anthill3.web.project.ProjectTasks.getProjectOriginatingWorkflowsAjax(ProjectTasks.java:458)
>
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native
> Method)
>
> at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
>
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>
> at java.lang.reflect.Method.invoke(Method.java:585)
>
> at
> com.urbancode.anthill3.web.controller.ControllerServlet.doPost(ControllerServlet.java:313)
>
> at
> javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
>
> at
> javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
>
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
>
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
>
> at
> com.urbancode.anthill3.web.util.LicenseFilter.doFilter(LicenseFilter.java:78)
>
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
>
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
>
> at
> com.urbancode.anthill3.web.util.SecurityFilter.doFilter(SecurityFilter.java:89)
>
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
>
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
>
> at
> com.urbancode.anthill3.web.util.AuthorityFilter.doFilter(AuthorityFilter.java:67)
>
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
>
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
>
> at
> com.urbancode.anthill3.web.security.DisableSessionUrlFilter.doFilter(DisableSessionUrlFilter.java:114)
>
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
>
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
>
> at
> com.urbancode.anthill3.web.security.SecureSessionFilter.doFilter(SecureSessionFilter.java:114)
>
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
>
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
>
> at
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
>
> at
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174)
>
> at
> org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:525)
>
> at
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
>
> at
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
>
> at
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
>
> at
> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:151)
>
> at
> org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:874)
>
> at
> org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
>
> at
> org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
>
> at
> org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
>
> at
> org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)
>
> at java.lang.Thread.run(Thread.java:595)
>
> Caused by:
> com.urbancode.anthill3.domain.persistent.PersistenceException: Error
> restoring object from database
>
> at
> com.urbancode.anthill3.domain.profile.BuildProfileDaoSql.restore(BuildProfileDaoSql.java:264)
>
> at
> com.urbancode.anthill3.domain.persistent.DaoSql.restore(DaoSql.java:292)
>
> at
> com.urbancode.anthill3.persistence.UnitOfWorkDefault.restore0(UnitOfWorkDefault.java:211)
>
> at
> com.urbancode.anthill3.persistence.UnitOfWork.restore(UnitOfWork.java:503)
>
> at
> com.urbancode.anthill3.domain.persistent.Handle.dereference(Handle.java:159)
>
> ... 40 more
>
> Caused by: java.sql.SQLException: Column 'CLASS' not found.
>
> at
> com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1056)
>
> at
> com.mysql.jdbc.SQLError.createSQLException(SQLError.java:957)
>
> at
> com.mysql.jdbc.SQLError.createSQLException(SQLError.java:927)
>
> at
> com.mysql.jdbc.ResultSetImpl.findColumn(ResultSetImpl.java:1080)
>
> at
> com.mysql.jdbc.ResultSetImpl.getString(ResultSetImpl.java:5474)
>
> at
> com.p6spy.engine.spy.P6ResultSet.getString(P6ResultSet.java:260)
>
> at
> com.p6spy.engine.spy.P6ResultSet.getString(P6ResultSet.java:266)
>
> at
> org.apache.commons.dbcp.DelegatingResultSet.getString(DelegatingResultSet.java:174)
>
> at
> com.urbancode.anthill3.domain.profile.BuildProfileDaoSql.restore(BuildProfileDaoSql.java:240)
>
> ... 44 more
>
>
>
>
>
>
>
> svgroup_mail
>
> MLADEN MARAVIĆ
>
> V. RAVNICE 15, HR-10000 ZAGREB, CROATIA
>
> *PHONE:* +385 1 2958 747
>
> *FAX:* +385 1 2989 324
>
> *GSM:* +385 91 3841 397
>
> mladen.maravic at svgroup.hr <mailto:mladen.maravic at svgroup.hr>
>
> www.svgroup.hr <http://www.svgroup.hr/>
>
>
>
>
> ------------------------------------------------------------------------
>
> _______________________________________________
> Anthill-pro mailing list
> Anthill-pro at lists.urbancode.com
> http://lists.urbancode.com/mailman/listinfo/anthill-pro
--
===========================================================
Ryan Smith. 2044 Euclid Ave., Suite 600
Lead Developer Cleveland, Ohio 44115
Urbancode, Inc.
email: rws at urbancode.com
web: www.urbancode.com phone: 216-858-9000
web: www.anthillpro.com fax: 216-858-9602
===========================================================
More information about the Anthill-pro
mailing list