Skip to content

Instantly share code, notes, and snippets.

@paulomcnally
Created April 2, 2014 23:03
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save paulomcnally/9945097 to your computer and use it in GitHub Desktop.
Save paulomcnally/9945097 to your computer and use it in GitHub Desktop.
[ERROR] Failed to execute goal org.liquibase:liquibase-maven-plugin:2.0.5:update (default) on project libreplan-business: Error setting up or running Liquibase: Migration failed for change set src/main/resources/db.changelog-1.2.xml::change-mapping-order-element-and-sum-charged-effort-postgresql::mrego:
[ERROR] Reason: liquibase.exception.DatabaseException: Error executing SQL CREATE OR REPLACE FUNCTION chageMappingBetweenOrderElementAndSumChargedEffort() RETURNS VOID AS $$
[ERROR] DECLARE
[ERROR] sce RECORD;
[ERROR] BEGIN
[ERROR] FOR sce IN SELECT sum_charged_effort_id AS id FROM order_element
[ERROR] LOOP
[ERROR] EXECUTE 'UPDATE sum_charged_effort '
[ERROR] || 'SET order_element '
[ERROR] || ' = (SELECT id FROM order_element '
[ERROR] || 'WHERE sum_charged_effort_id '
[ERROR] || ' = '
[ERROR] || quote_literal(sce.id)
[ERROR] || ') '
[ERROR] || 'WHERE id '
[ERROR] || ' = '
[ERROR] || quote_literal(sce.id);
[ERROR] END LOOP;
[ERROR] END;
[ERROR] $$ LANGUAGE plpgsql;: ERROR: language "plpgsql" does not exist
[ERROR] Hint: Use CREATE LANGUAGE to load the language into the database.:
[ERROR] Caused By: Error executing SQL CREATE OR REPLACE FUNCTION chageMappingBetweenOrderElementAndSumChargedEffort() RETURNS VOID AS $$
[ERROR] DECLARE
[ERROR] sce RECORD;
[ERROR] BEGIN
[ERROR] FOR sce IN SELECT sum_charged_effort_id AS id FROM order_element
[ERROR] LOOP
[ERROR] EXECUTE 'UPDATE sum_charged_effort '
[ERROR] || 'SET order_element '
[ERROR] || ' = (SELECT id FROM order_element '
[ERROR] || 'WHERE sum_charged_effort_id '
[ERROR] || ' = '
[ERROR] || quote_literal(sce.id)
[ERROR] || ') '
[ERROR] || 'WHERE id '
[ERROR] || ' = '
[ERROR] || quote_literal(sce.id);
[ERROR] END LOOP;
[ERROR] END;
[ERROR] $$ LANGUAGE plpgsql;: ERROR: language "plpgsql" does not exist
[ERROR] Hint: Use CREATE LANGUAGE to load the language into the database.:
[ERROR] Caused By: ERROR: language "plpgsql" does not exist
[ERROR] Hint: Use CREATE LANGUAGE to load the language into the database.
[ERROR] -> [Help 1]
[ERROR]
[ERROR] To see the full stack trace of the errors, re-run Maven with the -e switch.
[ERROR] Re-run Maven using the -X switch to enable full debug logging.
[ERROR]
[ERROR] For more information about the errors and possible solutions, please read the following articles:
[ERROR] [Help 1] http://cwiki.apache.org/confluence/display/MAVEN/MojoExecutionException
[ERROR]
[ERROR] After correcting the problems, you can resume the build with the command
[ERROR] mvn <goals> -rf :libreplan-business
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment