History | Log In     View a printable version of the current page.  
Issue Details (XML | Word | Printable)

Key: UP-1984
Type: Bug Bug
Status: Closed Closed
Resolution: Duplicate
Priority: Major Major
Assignee: Eric Dalquist
Reporter: Eric Dalquist
Votes: 0
Watchers: 0
Operations

If you were logged in you would be able to see more operations.
uPortal

Channel Export fails with SQLException

Created: 28/Mar/08 03:14 PM   Updated: 18/Apr/08 10:52 AM
Component/s: Import / Export
Affects Version/s: 3.0.0-M5, 3.0.0-RC2, 3.0.0-RC3
Fix Version/s: 3.0.0

Original Estimate: Unknown Remaining Estimate: Unknown Time Spent: Unknown


 Description  « Hide
Exporting a channel using crn-export results in the following stack trace:

     [java] Caused by: org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [SELECT updp.*, uppv.value FROM up_portlet_definition_prefs updp, up_portlet_pref_values uppv WHERE updp.pref_id = uppv.portlet_pref_id AND updp.chan_id = ?]; nested exception is java.sql.SQLException: Table not found in statement [SELECT updp.*, uppv.value FROM up_portlet_definition_prefs updp, up_portlet_pref_values uppv WHERE updp.pref_id = uppv.portlet_pref_id AND updp.chan_id = ?]
     [java] at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.translate(SQLErrorCodeSQLExceptionTranslator.java:276)
     [java] at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:582)
     [java] at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:616)
     [java] at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:645)
     [java] at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:661)
     [java] at org.danann.cernunnos.sql.QueryTask.perform(QueryTask.java:118)
     [java] at org.danann.cernunnos.runtime.RuntimeTaskDecorator.perform(RuntimeTaskDecorator.java:58)
     [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:123)
     [java] at org.danann.cernunnos.flow.IfTask.perform(IfTask.java:62)
     [java] at org.danann.cernunnos.runtime.RuntimeTaskDecorator.perform(RuntimeTaskDecorator.java:58)
     [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:123)
     [java] at org.danann.cernunnos.flow.IfTask.perform(IfTask.java:62)
     [java] at org.danann.cernunnos.flow.ChooseTask.perform(ChooseTask.java:110)
     [java] at org.danann.cernunnos.runtime.RuntimeTaskDecorator.perform(RuntimeTaskDecorator.java:58)
     [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:123)
     [java] at org.danann.cernunnos.core.SetAttributeTask.perform(SetAttributeTask.java:66)
     [java] at org.danann.cernunnos.runtime.RuntimeTaskDecorator.perform(RuntimeTaskDecorator.java:58)
     [java] at org.danann.cernunnos.AbstractContainerTask.performSubtasks(AbstractContainerTask.java:123)
     [java] at org.danann.cernunnos.core.SetAttributeTask.perform(SetAttributeTask.java:66)
     [java] at org.danann.cernunnos.runtime.RuntimeTaskDecorator.perform(RuntimeTaskDecorator.java:58)
     [java] at org.danann.cernunnos.runtime.ScriptRunner$TaskDecorator.perform(ScriptRunner.java:310)
     [java] at org.danann.cernunnos.runtime.ScriptRunner.run(ScriptRunner.java:264)
     [java] at org.danann.cernunnos.flow.CernunnosTask.perform(CernunnosTask.java:87)
     [java] ... 65 more
     [java] Caused by: java.sql.SQLException: Table not found in statement [SELECT updp.*, uppv.value FROM up_portlet_definition_prefs updp, up_portlet_pref_values uppv WHERE updp.pref_id = uppv.portlet_pref_id AND updp.chan_id = ?]
     [java] at org.hsqldb.jdbc.Util.throwError(Unknown Source)
     [java] at org.hsqldb.jdbc.jdbcPreparedStatement.<init>(Unknown Source)
     [java] at org.hsqldb.jdbc.jdbcConnection.prepareStatement(Unknown Source)
     [java] at org.apache.commons.dbcp.DelegatingConnection.prepareStatement(DelegatingConnection.java:185)
     [java] at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.prepareStatement(PoolingDataSource.java:278)
     [java] at org.springframework.jdbc.core.JdbcTemplate$SimplePreparedStatementCreator.createPreparedStatement(JdbcTemplate.java:1262)
     [java] at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:560)
     [java] ... 86 more


 All   Comments   Work Log   Change History      Sort Order:
Eric Dalquist [08/Apr/08 10:57 AM]
Resolved by commit 43459 / UP-1986