org.apache.ddlutils.DatabaseOperationException

org.postgresql.util.PSQLException: ERROR: function temp\_findinarray(integer\[\], integer) does not exist

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>

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

Solutions on the web17

  • via openbravo by mohamedkandil
    , 10 months ago
    org.postgresql.util.PSQLException: ERROR: function temp\_findinarray(integer\[\], integer) does not exist
  • Error while executing SQL -- ----------------------------------------------------------------------- -- musician -- ----------------------------------------------------------------------- CREATE TABLE musician ( id INTEGER IDENTITY, name VARCHAR(2147483647), PRIMARY KEY (id) )
  • Error while enabling triggers
  • Stack trace

    • org.apache.ddlutils.DatabaseOperationException: org.postgresql.util.PSQLException: ERROR: function temp\_findinarray(integer\[\], integer) does not exist at org.openbravo.ddlutils.task.AlterDatabaseDataMod.doExecute(AlterDatabaseDataMod.java:275) at org.openbravo.dal.core.DalInitializingTask.execute(DalInitializingTask.java:116) at org.openbravo.ddlutils.task.BaseDalInitializingTask.execute(BaseDalInitializingTask.java:79) at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:288) at sun.reflect.GeneratedMethodAccessor114.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106) at org.apache.tools.ant.Task.perform(Task.java:348) at org.apache.tools.ant.Target.execute(Target.java:357) at org.apache.tools.ant.Target.performTasks(Target.java:385) at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1337) at org.apache.tools.ant.helper.SingleCheckExecutor.executeTargets(SingleCheckExecutor.java:38) at org.apache.tools.ant.Project.executeTargets(Project.java:1189) at org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:416) Caused by: org.apache.ddlutils.DatabaseOperationException: org.postgresql.util.PSQLException: ERROR: function temp\_findinarray(integer\[\], integer) does not exist at org.apache.ddlutils.platform.PlatformImplBase.loadModelFromDatabase(PlatformImplBase.java:2255) at org.openbravo.ddlutils.task.AlterDatabaseDataMod.doExecute(AlterDatabaseDataMod.java:202) ... 15 more Caused by: org.postgresql.util.PSQLException: ERROR: function temp\_findinarray(integer\[\], integer) does not exist at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1512) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1297) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:430) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:332) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:278) at org.apache.commons.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:225) at org.apache.ddlutils.platform.postgresql.PostgreSqlModelLoader.closeMetadataSentences(PostgreSqlModelLoader.java:637) at org.apache.ddlutils.platform.ModelLoaderBase.getDatabase(ModelLoaderBase.java:165) at org.apache.ddlutils.platform.PlatformImplBase.loadModelFromDatabase(PlatformImplBase.java:2251) ... 17 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

    2 times, 1 month ago
    25 times, 7 months ago
    Unknown user
    Once, 10 months ago
    Unknown user
    Once, 11 months ago
    Unknown user
    Once, 1 year ago
    92 more bugmates