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
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

    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 | 9 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