[Anthill-pro] Error during database migration - 3.4.6
Ryan Smith
rws at urbancode.com
Thu Jan 24 12:05:42 CST 2008
Mladen,
What version of MySQL are you using and which JDBC driver?
Ryan
Mladen Maravić wrote:
> Ryan,
> this solved the dashboard issue. But now I have other problems:
>
> com.urbancode.anthill3.dashboard.DashboardDaoSql.getMostRecentSummaryForEach
> Status(DashboardDaoSql.java:283)
>
> Column 'ID' not found!
>
>
>
> -----Original Message-----
> From: anthill-pro-bounces at lists.urbancode.com
> [mailto:anthill-pro-bounces at lists.urbancode.com] On Behalf Of Ryan Smith
> Sent: Tuesday, January 22, 2008 4:53 PM
> To: AnthillPro user and support list.
> Subject: Re: [Anthill-pro] Error during database migration - 3.4.6
>
> 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.jav
> a:194)
>> at
>>
> com.urbancode.anthill3.domain.project.Project.getOriginatingWorkflowArray(Pr
> oject.java:691)
>> at
>>
> com.urbancode.anthill3.web.project.ProjectTasks.getProjectOriginatingWorkflo
> wsAjax(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(ControllerSer
> vlet.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(Application
> FilterChain.java:269)
>> at
>>
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
> ain.java:188)
>> at
>>
> com.urbancode.anthill3.web.util.LicenseFilter.doFilter(LicenseFilter.java:78
> )
>> at
>>
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application
> FilterChain.java:215)
>> at
>>
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
> ain.java:188)
>> at
>>
> com.urbancode.anthill3.web.util.SecurityFilter.doFilter(SecurityFilter.java:
> 89)
>> at
>>
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application
> FilterChain.java:215)
>> at
>>
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
> ain.java:188)
>> at
>>
> com.urbancode.anthill3.web.util.AuthorityFilter.doFilter(AuthorityFilter.jav
> a:67)
>> at
>>
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application
> FilterChain.java:215)
>> at
>>
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
> ain.java:188)
>> at
>>
> com.urbancode.anthill3.web.security.DisableSessionUrlFilter.doFilter(Disable
> SessionUrlFilter.java:114)
>> at
>>
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application
> FilterChain.java:215)
>> at
>>
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
> ain.java:188)
>> at
>>
> com.urbancode.anthill3.web.security.SecureSessionFilter.doFilter(SecureSessi
> onFilter.java:114)
>> at
>>
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application
> FilterChain.java:215)
>> at
>>
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
> ain.java:188)
>> at
>>
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.ja
> va:213)
>> at
>>
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.ja
> va: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.processC
> onnection(Http11BaseProtocol.java:665)
>> at
>>
> org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.jav
> a:528)
>> at
>>
> org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWo
> rkerThread.java:81)
>> at
>>
> org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.jav
> a: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(BuildProfil
> eDaoSql.java:264)
>> at
>> com.urbancode.anthill3.domain.persistent.DaoSql.restore(DaoSql.java:292)
>>
>> at
>>
> com.urbancode.anthill3.persistence.UnitOfWorkDefault.restore0(UnitOfWorkDefa
> ult.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.ja
> va:174)
>> at
>>
> com.urbancode.anthill3.domain.profile.BuildProfileDaoSql.restore(BuildProfil
> eDaoSql.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