liquibase.exception.DatabaseException: ERROR: syntax error at or near "0" Position: 385 [Failed SQL: CREATE TABLE reporting.report (id BIGSERIAL NOT NULL, name VARCHAR(255) NOT NULL, description TEXT, filter_expression TEXT NOT NULL, out_components VARCHAR(255) NOT NULL, scope_id BIGINT NOT NULL, created_by VARCHAR(255) NOT NULL, created_on TIMESTAMP(29) WITHOUT TIME ZONE NOT NULL, deleted_on TIMESTAMP(29) WITHOUT TIME ZONE, deleted_by VARCHAR(255), is_deleted BPCHAR(1) DEFAULT ''0': :bpchar', is_shared BPCHAR(1) DEFAULT ''0'::bpchar' NOT NULL, CONSTRAINT report_pkey PRIMARY KEY (id))]

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Solutions on the web

via JIRA by Georgi Georgiev, 1 year ago
TIMESTAMP(29) WITHOUT TIME ZONE, deleted_by VARCHAR(255), is_deleted BPCHAR(1) DEFAULT ''0': :bpchar', is_shared BPCHAR(1) DEFAULT ''0'::bpchar' NOT NULL, CONSTRAINT report_pkey PRIMARY KEY (id))]
via JIRA by Georgi Georgiev, 1 year ago
TIMESTAMP(29) WITHOUT TIME ZONE, deleted_by VARCHAR(255), is_deleted BPCHAR(1) DEFAULT ''0': :bpchar', is_shared BPCHAR(1) DEFAULT ''0'::bpchar' NOT NULL, CONSTRAINT report_pkey PRIMARY KEY (id))]
via Stack Overflow by fillg1
, 2 years ago
VARCHAR2(100), activated NUMBER(1) NOT NULL, lang_key VARCHAR2(5), activation_key VARCHAR2(20), reset_key VARCHA R2(20), created_by VARCHAR2(50) NOT NULL, created_date TIMESTAMP DEFAULT sysdate NOT NULL, reset_date TIMESTAMP, last_modified_by VARCHAR2(50), last_modified_da te TIMESTAMP, CONSTRAINT PK_JHI_USER PRIMARY KEY (id), UNIQUE (email), UNIQUE (login))]
via GitHub by adam-ho
, 1 year ago
Table "COUNTRY" not found; SQL statement: ALTER TABLE PUBLIC.location ADD CONSTRAINT fk_location_country_id FOREIGN KEY (country_id) REFERENCES PUBLIC.country (id) [42102-191] [Failed SQL: ALTER TABLE PUBLIC.location ADD CONSTRAINT fk_location_country_id FOREIGN KEY (country_id) REFERENCES PUBLIC.country (id)]
liquibase.exception.DatabaseException: ERROR: syntax error at or near "0" Position: 385 [Failed SQL: CREATE TABLE reporting.report (id BIGSERIAL NOT NULL, name VARCHAR(255) NOT NULL, description TEXT, filter_expression TEXT NOT NULL, out_components VARCHAR(255) NOT NULL, scope_id BIGINT NOT NULL, created_by VARCHAR(255) NOT NULL, created_on TIMESTAMP(29) WITHOUT TIME ZONE NOT NULL, deleted_on TIMESTAMP(29) WITHOUT TIME ZONE, deleted_by VARCHAR(255), is_deleted BPCHAR(1) DEFAULT ''0': :bpchar', is_shared BPCHAR(1) DEFAULT ''0'::bpchar' NOT NULL, CONSTRAINT report_pkey PRIMARY KEY (id))]
at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:316)
at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:55)
at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:122)
at liquibase.database.AbstractJdbcDatabase.execute(AbstractJdbcDatabase.java:1243)
at liquibase.database.AbstractJdbcDatabase.executeStatements(AbstractJdbcDatabase.java:1226)
at liquibase.changelog.ChangeSet.execute(ChangeSet.java:548)

Users with the same issue

13 times, 1 year ago

Know the solutions? Share your knowledge to help other developers to debug faster.