com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT PE.PROP ERTY_KEY, PE.ENTITY_NAME, PE.ID, PS.propertyvalue FROM propertyentry PE LEFT JOIN propertystring PS ON PE.ID = PS.ID WHERE PE.PROPERTY_KEY=? AND PE.ENTITY_NAM E=? (ORA-00933: SQL command not properly ended )

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Samebug tips

Do you know how to solve this issue? Write a tip to help other users and build your expert profile.

Solutions on the web

via Atlassian JIRA by Eric Helfrich, 1 year ago
org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT PE.PROP ERTY_KEY, PE.ENTITY_NAME, PE.ID, PS.propertyvalue FROM propertyentry PE LEFT JOIN propertystring PS ON PE.ID = PS.ID WHERE PE.PROPERTY_KEY=? AND PE.ENTITY_NAM E=? (ORA-00933: SQL command not properly ended )
via Atlassian JIRA by Eric Helfrich, 1 year ago
org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT PE.PROP ERTY_KEY, PE.ENTITY_NAME, PE.ID, PS.propertyvalue FROM propertyentry PE LEFT JOIN propertystring PS ON PE.ID = PS.ID WHERE PE.PROPERTY_KEY=? AND PE.ENTITY_NAM E=? (ORA-00933: SQL command not properly ended )
via Atlassian JIRA by Theo Tzidamis [Atlassian], 1 year ago
org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT ID, groupid, FIELDTYPE, FIELD, OLDVALUE, OLDSTRING, NEWVALUE, NEWSTRING FROM changeitem WHERE (groupid IN (?, ?, ?, ?, ?, ...) (ORA-01795: maximum number of expressions in a list is 1000)
via Atlassian JIRA by Theo Tzidamis [Atlassian], 1 year ago
org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT ID, groupid, FIELDTYPE, FIELD, OLDVALUE, OLDSTRING, NEWVALUE, NEWSTRING FROM changeitem WHERE (groupid IN (?, ?, ?, ?, ?, ...) (ORA-01795: maximum number of expressions in a list is 1000)
via Atlassian JIRA by Zulfadli Noor Sazali [Atlassian], 1 year ago
org.ofbiz.core.entity.GenericDataSourceException: Unable to esablish a connection with the database. (Communications link failure The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.)
via Atlassian JIRA by Zulfadli Noor Sazali [Atlassian], 1 year ago
org.ofbiz.core.entity.GenericDataSourceException: Unable to esablish a connection with the database. (Communications link failure The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.)
com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT PE.PROP ERTY_KEY, PE.ENTITY_NAME, PE.ID, PS.propertyvalue FROM propertyentry PE LEFT JOIN propertystring PS ON PE.ID = PS.ID WHERE PE.PROPERTY_KEY=? AND PE.ENTITY_NAM E=? (ORA-00933: SQL command not properly ended )
at com.atlassian.jira.ofbiz.DefaultOfBizDelegator.findByAnd(DefaultOfBizDelegator.java:32)
at com.atlassian.jira.user.util.UserUtilImpl.getUserLocalePreferenceEntries(UserUtilImpl.java:131)
at com.atlassian.jira.user.util.UserUtilImpl.getUserLocalePreferenceCount(UserUtilImpl.java:122)
at com.atlassian.jira.upgrade.tasks.UpgradeTask_Build125.doUpgrade(UpgradeTask_Build125.java:60)
at com.atlassian.jira.upgrade.UpgradeManagerImpl.doUpgradeTaskSucess(UpgradeManagerImpl.java:681)
at com.atlassian.jira.upgrade.UpgradeManagerImpl.runUpgradeTasks(UpgradeManagerImpl.java:577)
at com.atlassian.jira.upgrade.UpgradeManagerImpl.doUpgrade(UpgradeManagerImpl.java:403)
at com.atlassian.jira.upgrade.UpgradeManagerImpl.doUpgradeIfNeeded(UpgradeManagerImpl.java:351)
at com.atlassian.jira.upgrade.UpgradeManagerImpl.doUpgradeIfNeededAndAllowed(UpgradeManagerImpl.java:311)
at com.atlassian.jira.upgrade.UpgradeLauncher.contextInitialized(UpgradeLauncher.java:68)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3212)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:3554)
at org.apache.catalina.core.StandardHostDeployer.start(StandardHostDeployer.java:582)
at org.apache.catalina.core.StandardHost.start(StandardHost.java:866)
at org.apache.catalina.servlets.ManagerServlet.start(ManagerServlet.java:1056)
at org.apache.catalina.servlets.HTMLManagerServlet.start(HTMLManagerServlet.java:506)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:696)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:809)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:200)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:146)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:209)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:596)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:433)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:948)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:144)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:596)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:504)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:594)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:433)

Users with the same issue

You are the first who have seen this exception. Write a tip to help other users and build your expert profile.

Write tip

Know the solutions? Share your knowledge to help other developers to debug faster.