liquibase.exception.DatabaseException: Error executing SQL UPDATE file_metadata m SET toolbox_input_file = getglobalattribute(file_id, 'toolbox_input_file'): ERROR: function getglobalattribute(bigint, unknown) does not exist

GitHub | lbesnard | 8 months ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    getglobalattribute psql function not exist

    GitHub | 8 months ago | lbesnard
    liquibase.exception.DatabaseException: Error executing SQL UPDATE file_metadata m SET toolbox_input_file = getglobalattribute(file_id, 'toolbox_input_file'): ERROR: function getglobalattribute(bigint, unknown) does not exist
  2. 0

    wfs:imos:aatams_biologging_shearwater_data is not working

    GitHub | 1 year ago | danfruehauf
    liquibase.exception.DatabaseException: Error executing SQL ALTER TABLE aatams_biologging_shearwater_map ALTER COLUMN start_date TYPE timestamp with time zone, ALTER COLUMN end_date TYPE timestamp with time zone: ERROR: cannot alter type of a column used by a view or rule Detail: rule _RETURN on view report_test.aatams_biologging_all_deployments_view depends on column "start_date": Caused By: Error executing SQL ALTER TABLE aatams_biologging_shearwater_map ALTER COLUMN start_date TYPE timestamp with time zone, ALTER COLUMN end_date TYPE timestamp with time zone: ERROR: cannot alter type of a column used by a view or rule Detail: rule _RETURN on view report_test.aatams_biologging_all_deployments_view depends on column "start_date": Caused By: ERROR: cannot alter type of a column used by a view or rule Detail: rule _RETURN on view report_test.aatams_biologging_all_deployments_view depends on column "start_date"
  3. 0

    Talend: Write data to PostgreSQL database error

    Stack Overflow | 5 years ago | Tjekkles
    org.postgresql.util.PSQLException: ERROR: zero-length delimited identifier at or near """"
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    erro: MappedDouble is not mapped to 'double precision' datatype in PostgreSQL?

    Google Groups | 8 years ago | JanWillem Tulp
    org.postgresql.util.PSQLException: ERROR: type "double" does not exist

  1. silex 6 times, last 3 months ago
11 unregistered visitors
Not finding the right solution?
Take a tour to get the most out of Samebug.

Tired of useless tips?

Automated exception search integrated into your IDE

Root Cause Analysis

  1. org.postgresql.util.PSQLException

    ERROR: function getglobalattribute(bigint, unknown) does not exist

    at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse()
  2. PostgreSQL JDBC Driver
    AbstractJdbc2Statement.execute
    1. org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1592)
    2. org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1327)
    3. org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:192)
    4. org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:451)
    5. org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:336)
    6. org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:328)
    6 frames
  3. Liquibase Core
    Liquibase.update
    1. liquibase.executor.jvm.JdbcExecutor$1ExecuteStatementCallback.doInStatement(JdbcExecutor.java:92)
    2. liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:55)
    3. liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:104)
    4. liquibase.database.AbstractDatabase.execute(AbstractDatabase.java:1091)
    5. liquibase.database.AbstractDatabase.executeStatements(AbstractDatabase.java:1075)
    6. liquibase.changelog.ChangeSet.execute(ChangeSet.java:317)
    7. liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:27)
    8. liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:58)
    9. liquibase.Liquibase.update(Liquibase.java:114)
    9 frames
  4. anmn_metadata.anmn_metadata_harvester_0_1
    ANMN_metadata_harvester.main
    1. anmn_metadata.anmn_metadata_harvester_0_1.ANMN_metadata_harvester.iPostgresqlDbUpdate_1Process(ANMN_metadata_harvester.java:1393)
    2. anmn_metadata.anmn_metadata_harvester_0_1.ANMN_metadata_harvester.iUpdateIndex_2Process(ANMN_metadata_harvester.java:1091)
    3. anmn_metadata.anmn_metadata_harvester_0_1.ANMN_metadata_harvester.runJobInTOS(ANMN_metadata_harvester.java:4012)
    4. anmn_metadata.anmn_metadata_harvester_0_1.ANMN_metadata_harvester.main(ANMN_metadata_harvester.java:3840)
    4 frames