com.liferay.portal.kernel.events.ActionException: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: org.postgresql.util.PSQLException: FEHLER: Operator existiert nicht: character varying = integer_ Hinweis: Kein Operator stimmt mit dem angegebenen Namen und den Argumenttypen überein. Sie müssen möglicherweise ausdrückliche Typumwandlungen hinzufügen._ Position: 50 [Sanitized]

Liferay Issues | Christian Richter | 3 years ago
tip
Click on the to mark the solution that helps you, Samebug will learn from it.
As a community member, you’ll be rewarded for you help.
  1. 0

    Hello, When I try to upgrade my liferay from 6.1.2 to 6.2 I got the following error: {code} 21:12:21,925 INFO [localhost-startStop-1][UpgradeProcess:175] Upgrading com.liferay.portal.upgrade.v6_2_0.UpgradeJournal 21:12:22,313 ERROR [localhost-startStop-1][UpgradeJournal:364] Unable to update journal structure with structure ID 95948 21:12:22,316 ERROR [localhost-startStop-1][MainServlet:209] com.liferay.portal.kernel.events.ActionException: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: org.postgresql.util.PSQLException: FEHLER: Operator existiert nicht: character varying = integer_ Hinweis: Kein Operator stimmt mit dem angegebenen Namen und den Argumenttypen überein. Sie müssen möglicherweise ausdrückliche Typumwandlungen hinzufügen._ Position: 50 [Sanitized] com.liferay.portal.kernel.events.ActionException: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: org.postgresql.util.PSQLException: FEHLER: Operator existiert nicht: character varying = integer_ Hinweis: Kein Operator stimmt mit dem angegebenen Namen und den Argumenttypen überein. Sie müssen möglicherweise ausdrückliche Typumwandlungen hinzufügen._ Position: 50 [Sanitized] at com.liferay.portal.events.StartupAction.run(StartupAction.java:74) at com.liferay.portal.servlet.MainServlet.processStartupEvents(MainServlet.java:1238) at com.liferay.portal.servlet.MainServlet.init(MainServlet.java:206) at javax.servlet.GenericServlet.init(GenericServlet.java:160) at org.apache.catalina.core.StandardWrapper.initServlet(StandardWrapper.java:1280) at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1193) at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:1088) at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:5176) at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5460) at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150) at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901) at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877) at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:633) at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:656) at org.apache.catalina.startup.HostConfig$DeployDescriptor.run(HostConfig.java:1635) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) at java.util.concurrent.FutureTask.run(FutureTask.java:138) 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:662) Caused by: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: org.postgresql.util.PSQLException: FEHLER: Operator existiert nicht: character varying = integer_ Hinweis: Kein Operator stimmt mit dem angegebenen Namen und den Argumenttypen überein. Sie müssen möglicherweise ausdrückliche Typumwandlungen hinzufügen._ Position: 50 [Sanitized] at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:181) at com.liferay.portal.upgrade.UpgradeProcessUtil._upgradeProcess(UpgradeProcessUtil.java:162) at com.liferay.portal.upgrade.UpgradeProcessUtil.upgradeProcess(UpgradeProcessUtil.java:114) at com.liferay.portal.upgrade.UpgradeProcessUtil.upgradeProcess(UpgradeProcessUtil.java:94) at com.liferay.portal.events.StartupHelper.upgradeProcess(StartupHelper.java:138) at com.liferay.portal.events.StartupHelperUtil.upgradeProcess(StartupHelperUtil.java:61) at com.liferay.portal.tools.DBUpgrader.upgrade(DBUpgrader.java:143) at com.liferay.portal.events.StartupAction.doRun(StartupAction.java:160) at com.liferay.portal.events.StartupAction.run(StartupAction.java:68) ... 20 more Caused by: com.liferay.portal.kernel.upgrade.UpgradeException: org.postgresql.util.PSQLException: FEHLER: Operator existiert nicht: character varying = integer_ Hinweis: Kein Operator stimmt mit dem angegebenen Namen und den Argumenttypen überein. Sie müssen möglicherweise ausdrückliche Typumwandlungen hinzufügen._ Position: 50 [Sanitized] at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:181) at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:195) at com.liferay.portal.upgrade.UpgradeProcess_6_2_0.doUpgrade(UpgradeProcess_6_2_0.java:75) at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:178) ... 28 more Caused by: org.postgresql.util.PSQLException: FEHLER: Operator existiert nicht: character varying = integer_ Hinweis: Kein Operator stimmt mit dem angegebenen Namen und den Argumenttypen überein. Sie müssen möglicherweise ausdrückliche Typumwandlungen hinzufügen._ Position: 50 [Sanitized] at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2103) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1836) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:512) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:273) at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:116) at com.liferay.portal.upgrade.v6_2_0.UpgradeJournal.updateStructure(UpgradeJournal.java:323) at com.liferay.portal.upgrade.v6_2_0.UpgradeJournal.addDDMStructure(UpgradeJournal.java:127) at com.liferay.portal.upgrade.v6_2_0.UpgradeJournal.updateStructures(UpgradeJournal.java:404) at com.liferay.portal.upgrade.v6_2_0.UpgradeJournal.doUpgrade(UpgradeJournal.java:217) at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:178) ... 31 more Stopping the server due to unexpected startup errors {code} Sorry I have a german server. The translation of the error is: {code} ERROR: operator does not exist: character varying = integer_ Hint: No operator matches the given name and argument type(s). You might need to add explicit type casts. {code} I searched for the part in the UpgradeJournal.java and I found this: {panel} ps = con.prepareStatement("select * from JournalStructure where structureId = " + structureId); {panel} If i do a sql query with this statement and my structureID, i'll got the same error: select * from JournalStructure where structureId = 95948 I think the problem is simelar to this issue: https://issues.liferay.com/browse/LPS-35240

    Liferay Issues | 3 years ago | Christian Richter
    com.liferay.portal.kernel.events.ActionException: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: org.postgresql.util.PSQLException: FEHLER: Operator existiert nicht: character varying = integer_ Hinweis: Kein Operator stimmt mit dem angegebenen Namen und den Argumenttypen überein. Sie müssen möglicherweise ausdrückliche Typumwandlungen hinzufügen._ Position: 50 [Sanitized]
  2. 0

    Apply patch in liferay

    Stack Overflow | 3 years ago | Sai Gowthami
    com.liferay.portal.kernel.events.ActionException: com.liferay.portal.verify.VerifyException: com.liferay.portal.verify.VerifyException: java.sql.SQLException: ORA-24005: Inappropriate utilities used to perform DDL on AQ table SYSMAN.AQ$_MGMT_LOADER_QTABLE_G
  3. 0

    [LPS-44699] Upgrade process from 6.2 to 7.0 fails for postgres - Liferay Issues

    liferay.com | 10 months ago
    com.liferay.portal.kernel.events.ActionException: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: org.postgresql.util.PSQLException: ERROR: syntax error at or near "="_ Position: 37 [Sanitized]
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    [LPS-28393] SQL Server 2005/2008 DB upgrade - 6.0.11 to 6.1.x causes UpgradeException - Liferay Issues

    liferay.com | 1 year ago
    com.liferay.portal.kernel.events.ActionException: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: java.lang.reflect.UndeclaredThrowableException
  6. 0

    RE: what triggered this "UpgradeProcess" ? - Forums | Liferay

    liferay.com | 2 years ago
    com.liferay.portal.kernel.events.ActionException: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: java.lang.ClassCastException: java.lang.String cannot be cast to java.util.Date       at com.liferay.portal.events.StartupAction.run(StartupAction.java:52)
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

    FEHLER: Operator existiert nicht: character varying = integer_ Hinweis: Kein Operator stimmt mit dem angegebenen Namen und den Argumenttypen überein. Sie müssen möglicherweise ausdrückliche Typumwandlungen hinzufügen._ Position: 50 [Sanitized]

    at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse()
  2. PostgreSQL JDBC Driver
    AbstractJdbc2Statement.executeQuery
    1. org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2103)
    2. org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1836)
    3. org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
    4. org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:512)
    5. org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388)
    6. org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:273)
    6 frames
  3. c3p0:JDBC DataSources/Resource Pools
    NewProxyPreparedStatement.executeQuery
    1. com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:116)
    1 frame
  4. Liferay Portal Impl
    UpgradeJournal.doUpgrade
    1. com.liferay.portal.upgrade.v6_2_0.UpgradeJournal.updateStructure(UpgradeJournal.java:323)
    2. com.liferay.portal.upgrade.v6_2_0.UpgradeJournal.addDDMStructure(UpgradeJournal.java:127)
    3. com.liferay.portal.upgrade.v6_2_0.UpgradeJournal.updateStructures(UpgradeJournal.java:404)
    4. com.liferay.portal.upgrade.v6_2_0.UpgradeJournal.doUpgrade(UpgradeJournal.java:217)
    4 frames
  5. Liferay Portal Service
    UpgradeProcess.upgrade
    1. com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:178)
    2. com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:195)
    2 frames
  6. Liferay Portal Impl
    UpgradeProcess_6_2_0.doUpgrade
    1. com.liferay.portal.upgrade.UpgradeProcess_6_2_0.doUpgrade(UpgradeProcess_6_2_0.java:75)
    1 frame
  7. Liferay Portal Service
    UpgradeProcess.upgrade
    1. com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:178)
    1 frame
  8. Liferay Portal Impl
    MainServlet.init
    1. com.liferay.portal.upgrade.UpgradeProcessUtil._upgradeProcess(UpgradeProcessUtil.java:162)
    2. com.liferay.portal.upgrade.UpgradeProcessUtil.upgradeProcess(UpgradeProcessUtil.java:114)
    3. com.liferay.portal.upgrade.UpgradeProcessUtil.upgradeProcess(UpgradeProcessUtil.java:94)
    4. com.liferay.portal.events.StartupHelper.upgradeProcess(StartupHelper.java:138)
    5. com.liferay.portal.events.StartupHelperUtil.upgradeProcess(StartupHelperUtil.java:61)
    6. com.liferay.portal.tools.DBUpgrader.upgrade(DBUpgrader.java:143)
    7. com.liferay.portal.events.StartupAction.doRun(StartupAction.java:160)
    8. com.liferay.portal.events.StartupAction.run(StartupAction.java:68)
    9. com.liferay.portal.servlet.MainServlet.processStartupEvents(MainServlet.java:1238)
    10. com.liferay.portal.servlet.MainServlet.init(MainServlet.java:206)
    10 frames
  9. JavaServlet
    GenericServlet.init
    1. javax.servlet.GenericServlet.init(GenericServlet.java:160)
    1 frame
  10. Glassfish Core
    HostConfig$DeployDescriptor.run
    1. org.apache.catalina.core.StandardWrapper.initServlet(StandardWrapper.java:1280)
    2. org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1193)
    3. org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:1088)
    4. org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:5176)
    5. org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5460)
    6. org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
    7. org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901)
    8. org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877)
    9. org.apache.catalina.core.StandardHost.addChild(StandardHost.java:633)
    10. org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:656)
    11. org.apache.catalina.startup.HostConfig$DeployDescriptor.run(HostConfig.java:1635)
    11 frames
  11. Java RT
    Thread.run
    1. java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441)
    2. java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
    3. java.util.concurrent.FutureTask.run(FutureTask.java:138)
    4. java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
    5. java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
    6. java.lang.Thread.run(Thread.java:662)
    6 frames