Warning: Can't synchronize with repository "(default)" (/home/git/ome.git does not appear to be a Git repository.). Look in the Trac log for more information.
Notice: In order to edit this ticket you need to be either: a Product Owner, The owner or the reporter of the ticket, or, in case of a Task not yet assigned, a team_member"

Task #9077 (new)

Opened 12 years ago

Last modified 12 years ago

Bug: bd-pathway import 2 — at Initial Version

Reported by: jburel Owned by:
Priority: blocker Milestone: OMERO-4.4
Component: General Version: n.a.
Keywords: n.a. Cc: ux@…, jamoore, cxallan, mlinkert
Resources: n.a. Referenced By: n.a.
References: n.a. Remaining Time: n.a.
Sprint: n.a.

Description

Import the file
{{{bd-pathway/42_6_1_100208_BJWT_LOPAC_05_08_10nM_R1/201-02-19_000}}

Clean DB, nothing else imported. server howe user root.
error follow

java.lang.RuntimeException: omero.ApiUsageException
    serverStackTrace = "ome.conditions.ApiUsageException: PreparedStatementCallback; bad SQL grammar [insert into temp_ids (key, id) values (?, ?)]; nested exception is org.postgresql.util.PSQLException: ERROR: relation "temp_ids" does not exist
                          Position: 13
                        	at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:233)
                        	at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
                        	at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:602)
                        	at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:614)
                        	at org.springframework.jdbc.core.JdbcTemplate.batchUpdate(JdbcTemplate.java:883)
                        	at org.springframework.jdbc.core.BatchUpdateUtils.executeBatchUpdate(BatchUpdateUtils.java:32)
                        	at org.springframework.jdbc.core.simple.SimpleJdbcTemplate.batchUpdate(SimpleJdbcTemplate.java:257)
                        	at org.springframework.jdbc.core.simple.SimpleJdbcTemplate.batchUpdate(SimpleJdbcTemplate.java:253)
                        	at ome.util.SqlAction$Impl.createIdsTempTable(SqlAction.java:370)
                        	at ome.util.SqlAction$Impl.rewriteHql(SqlAction.java:354)
                        	at sun.reflect.GeneratedMethodAccessor263.invoke(Unknown Source)
                        	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
                        	at java.lang.reflect.Method.invoke(Method.java:597)
                        	at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307)
                        	at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
                        	at

This is part of #8587

Change History (0)

Note: See TracTickets for help on using tickets. You may also have a look at Agilo extensions to the ticket.

1.3.13-PRO © 2008-2011 Agilo Software all rights reserved (this page was served in: 0.85137 sec.)

We're Hiring!