com.cenqua.crucible.hibernate.CruDBException

Problem with create tables script /Users/seb/dev/crucible/fe/output/dist/sql/HSQL/schema/tables_71.sql

Samebug tips1

Try downgrading PostgresSQL server to 9.5 or update your PostgresSQL driver to 9.4-1211 with the following command: <postgresql.version>9.4.1211</postgresql.version>


rafaelrafael

Don't give up yet. Our experts can help. Paste your full stack trace to get a solution.

Solutions on the web1553

  • via Unknown by Seb Ruiz,
  • via Unknown by Seb Ruiz,
  • via Unknown by Gurleen Anand [Atlassian],
  • Stack trace

    • com.cenqua.crucible.hibernate.CruDBException: Problem with create tables script /Users/seb/dev/crucible/fe/output/dist/sql/HSQL/schema/tables_71.sql at com.cenqua.crucible.hibernate.DefaultDBControl.createTables(DefaultDBControl.java:289) at com.atlassian.crucible.migration.item.DBImporter.importData(DBImporter.java:128) at com.cenqua.crucible.actions.admin.database.DBEditHelper$ImportRunner.call(DBEditHelper.java:80) at com.cenqua.crucible.actions.admin.database.DBEditHelper$ImportRunner.call(DBEditHelper.java:62) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) at java.util.concurrent.FutureTask.run(FutureTask.java:138) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:98) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:206) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) at java.lang.Thread.run(Thread.java:680) Caused by: com.cenqua.crucible.hibernate.CruDBException: SQL script error on line 1: "create table cru_base_star_model (cru_star_id integer not null, cru_item_type varchar(80) not null, cru_string_key1 varchar(255), cru_string_key2 varchar(255), cru_string_key3 varchar(255), cru_string_key4 varchar(255), cru_string_key5 varchar(255), cru_int_key1 integer, cru_int_key2 integer, cru_int_key3 integer, cru_int_key4 integer, cru_int_key5 integer, cru_text_key1 longvarchar, cru_text_key2 longvarchar, cru_user_name varchar(255), cru_date_created bigint, cru_label varchar(255), primary key (cru_star_id));" (ERROR: type "longvarchar" does not exist Position: 375), please contact http://www.atlassian.com/support/ at com.cenqua.crucible.hibernate.DefaultDBControl.executeScript(DefaultDBControl.java:468) at com.cenqua.crucible.hibernate.DefaultDBControl.executeScript(DefaultDBControl.java:411) at com.cenqua.crucible.hibernate.DefaultDBControl.createTables(DefaultDBControl.java:283) ... 10 more Caused by: org.postgresql.util.PSQLException: ERROR: type "longvarchar" does not exist Position: 375 at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2062) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1795) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:479) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:353) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:299) at com.cenqua.crucible.hibernate.DefaultDBControl.executeScript(DefaultDBControl.java:441) ... 12 more

    Write tip

    You have a different solution? A short tip here would help you and many other users who saw this issue last week.

    Users with the same issue

    jokesterjokester
    2 times, last one
    silexsilex
    25 times, last one
    Unknown visitor
    Unknown visitorOnce,
    Unknown visitor
    Unknown visitorOnce,
    Unknown visitor
    Unknown visitorOnce,
    92 more bugmates