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

  1. ,
    Expert tip

    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>

Solutions on the web

via Atlassian JIRA by Nick Mason [Atlassian], 1 year ago
SQL Exception while executing the following:SELECT ID FROM public.cwd_membership WHERE directory_id = (select id from cwd_directory where directory_name='Remote Crowd Directory') (ERROR: more than one row returned by a subquery used as an expression)
via Atlassian JIRA by Barrow Kwan, 1 year ago
SQL Exception while executing the following:SELECT ID, ISSUE, CUSTOMFIELD, STRINGVALUE, NUMBERVALUE, TEXTVALUE , DATEVALUE FROM customfieldvalue WHERE ISSUE=? (ERROR: relation "customfieldval ue" does not exist )
via atlassian.com by Unknown author, 1 year ago
SQL Exception while executing the following:SELECT ID, NAME, DESCRIPTION, mailfrom, PREFIX, smtp_port, protocol, server_type, SERVERNAME, JNDILOCATION, mailusername, mailpassword, ISTLSREQUIRED, TIMEOUT FROM mailserver (ERROR: column "protocol" does not exist Position: 60)
via Atlassian JIRA by William Crighton [CCC], 1 year ago
SQL Exception while executing the following:SELECT ID, groupid, FIELDTYPE, FIELD, OLDVALUE, OLDSTRING, NEWVALUE, NEWSTRING FROM changeitem WHERE FIELD =? AND OLDSTRING=? ORDER BY groupid desc (The text, ntext, and image data types cannot be compared or sorted, except when using IS NULL or LIKE operator.)
via Atlassian JIRA by William Crighton [CCC], 2 years ago
SQL Exception while executing the following:SELECT ID, groupid, FIELDTYPE, FIELD, OLDVALUE, OLDSTRING, NEWVALUE, NEWSTRING FROM changeitem WHERE FIELD =? AND OLDSTRING=? ORDER BY groupid desc (The text, ntext, and image data types cannot be compared or sorted, except when using IS NULL or LIKE operator.)
via JIRA by Michael Simon, 2 years ago
SQL Exception while executing the following:SELECT caller,finish_date FROM .jiraissue issue INNER JOIN .OS_HISTORYSTEP workflow on issue.workflow_id = workflow.entry_id WHERE issue.id = ? and workflow.action_id IN (791) ORDER BY finish_date DESC (ORA-00903: invalid table name )
org.postgresql.util.PSQLException: ERROR: more than one row returned by a subquery used as an expression	at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2157)	at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1886)	at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)	at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:555)	at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:417)	at org.apache.tomcat.dbcp.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:82)	at org.apache.tomcat.dbcp.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:82)	at org.ofbiz.core.entity.jdbc.SQLProcessor.executeQuery(SQLProcessor.java:633)	at org.ofbiz.core.entity.GenericDAO.createEntityListIterator(GenericDAO.java:967)	at org.ofbiz.core.entity.GenericDAO.selectListIteratorByCondition(GenericDAO.java:883)	at org.ofbiz.core.entity.GenericDAO.selectByCondition(GenericDAO.java:798)	at org.ofbiz.core.entity.GenericDAO.selectByCondition(GenericDAO.java:777)	at org.ofbiz.core.entity.GenericHelperDAO.findByCondition(GenericHelperDAO.java:178)	at org.ofbiz.core.entity.GenericDelegator.findByCondition(GenericDelegator.java:1085)	at com.atlassian.ondemand.backupmanager.service.BackupEntityChangesProvider.findEntityIds(BackupEntityChangesProvider.java:215)	at com.atlassian.ondemand.backupmanager.service.BackupEntityChangesProvider.parseBackupEntityChange(BackupEntityChangesProvider.java:194)	at com.atlassian.ondemand.backupmanager.service.BackupEntityChangesProvider.loadFromXml(BackupEntityChangesProvider.java:153)	at com.atlassian.ondemand.backupmanager.service.BackupEntityChangesProvider.(BackupEntityChangesProvider.java:56)	at com.atlassian.ondemand.backupmanager.service.JiraBackupService.backup(JiraBackupService.java:125)	at com.atlassian.ondemand.backupmanager.rest.OnDemandBackupTask.run(OnDemandBackupTask.java:84)	at com.atlassian.ondemand.backupmanager.longrunning.ManagedTask.run(ManagedTask.java:35)	at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)	at java.util.concurrent.FutureTask.run(FutureTask.java:266)	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)	at java.lang.Thread.run(Thread.java:745)