[Anthill-pro] Error during database migration - 3.4.6
Ryan Smith
rws at urbancode.com
Fri Jan 25 03:12:43 CST 2008
Mladen,
Another customer was having the exact same problem on MySQL. They were using the MySQL 5.1.5 JDBC driver which appears to have some bugs in it. They switched to the 5.0.8 driver and things worked correctly. Can you switch the driver jar file in the server's lib/ext directory and restart the server. This should fix the issues.
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