com.querydsl.core.QueryException: Caught PSQLException for select "AO_54307E_SERVICEDESK"."ID", "AO_54307E_SERVICEDESK"."PROJECT_ID", "PROJECT"."PNAME", "AO_54307E_SERVICEDESK"."PUBLIC_SIGNUP", "AO_54307E_SERVICEDESK"."OPEN_CUSTOMER_ACCESS", "AO_54307E_SERVICEDESK"."CREATED_BY_USER_KEY", "AO_54307E_SERVICEDESK"."CREATED_DATE", "AO_54307E_SERVICEDESK"."CREATED_WITH_EMPTY_PROJECT", "AO_54307E_SERVICEDESK"."VERSION_CREATED_AT", "AO_54307E_SERVICEDESK"."LEGACY_TRANSITION_DISABLED" from "AO_54307E_SERVICEDESK" "AO_54307E_SERVICEDESK" inner join "PROJECT" "PROJECT" on "AO_54307E_SERVICEDESK"."PROJECT_ID" = "PROJECT"."ID" where "AO_54307E_SERVICEDESK"."ID" = ? limit ?

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

Solutions on the web

via Atlassian JIRA by Joao Palharini [Atlassian], 1 year ago
Caught PSQLException for select "AO_54307E_SERVICEDESK"."ID", "AO_54307E_SERVICEDESK"."PROJECT_ID", "PROJECT"."PNAME", "AO_54307E_SERVICEDESK"."PUBLIC_SIGNUP", "AO_54307E_SERVICEDESK"."OPEN_CUSTOMER_ACCESS", "AO_54307E_SERVICEDESK
via GitHub by sarababaei
, 2 years ago
Caught SQLSyntaxErrorException for select * from ( select a.*, rownum rn from ( select TB_CLEARING_SETUP.CODE, TB_CLEARING_SETUP.CODE, TB_CLEARING_SETUP.TITLE, TB_CLEARING_SETUP.PARAMETER_VALUE from CHK.TB_CLEARING_SETUP TB_CLEARING_SETUP order by TB_CLEARING_SETUP.CODE desc ) a) where rn > 2 and rownum <= 3
via Atlassian JIRA by Andy Nguyen [Atlassian], 1 year ago
Caught SQLException for select top 1000 cast(CHANGE_ITEM.oldvalue as bigint), max(CHANGE_GROUP.created) from dbo.changeitem CHANGE_ITEM left join dbo.changegroup CHANGE_GROUP on CHANGE_ITEM.groupid = CHANGE_GROUP.id where CHANGE_ITEM.field = ? and
via Atlassian JIRA by Andy Nguyen [Atlassian], 1 year ago
Caught SQLException for select top 1000 cast(CHANGE_ITEM.oldvalue as bigint), max(CHANGE_GROUP.created) from dbo.changeitem CHANGE_ITEM left join dbo.changegroup CHANGE_GROUP on CHANGE_ITEM.groupid = CHANGE_GROUP.id where CHANGE_ITEM.field = ? and
via GitHub by leekung
, 1 year ago
Caught SQLSyntaxErrorException for select `CONFIG`.`VALUE` from `CONFIG` `CONFIG` where `CONFIG`.`NAME` = ? limit ?
via GitHub by serphacker
, 1 year ago
Caught SQLException for insert into `user` (`email`) values (?)
com.querydsl.core.QueryException: Caught PSQLException for select "AO_54307E_SERVICEDESK"."ID", "AO_54307E_SERVICEDESK"."PROJECT_ID", "PROJECT"."PNAME", "AO_54307E_SERVICEDESK"."PUBLIC_SIGNUP", "AO_54307E_SERVICEDESK"."OPEN_CUSTOMER_ACCESS", "AO_54307E_SERVICEDESK"."CREATED_BY_USER_KEY", "AO_54307E_SERVICEDESK"."CREATED_DATE", "AO_54307E_SERVICEDESK"."CREATED_WITH_EMPTY_PROJECT", "AO_54307E_SERVICEDESK"."VERSION_CREATED_AT", "AO_54307E_SERVICEDESK"."LEGACY_TRANSITION_DISABLED" from "AO_54307E_SERVICEDESK" "AO_54307E_SERVICEDESK" inner join "PROJECT" "PROJECT" on "AO_54307E_SERVICEDESK"."PROJECT_ID" = "PROJECT"."ID" where "AO_54307E_SERVICEDESK"."ID" = ? limit ?
at com.querydsl.sql.DefaultSQLExceptionTranslator.translate(DefaultSQLExceptionTranslator.java:50)
at com.querydsl.sql.Configuration.translate(Configuration.java:453)
at com.querydsl.sql.AbstractSQLQuery.iterateSingle(AbstractSQLQuery.java:410)
at com.querydsl.sql.AbstractSQLQuery.iterate(AbstractSQLQuery.java:342)
at com.querydsl.sql.ProjectableSQLQuery.fetchOne(ProjectableSQLQuery.java:372)
at com.atlassian.servicedesk.internal.feature.servicedesk.ServiceDeskQStoreImpl.getServiceDeskById(ServiceDeskQStoreImpl.java:139)
at com.atlassian.servicedesk.internal.feature.servicedesk.ServiceDeskQStoreImpl.lambda$addServiceDesk$4(ServiceDeskQStoreImpl.java:121)
at com.atlassian.pocketknife.internal.querydsl.DatabaseAccessorImpl.lambda$execute$0(DatabaseAccessorImpl.java:66)
at com.atlassian.sal.core.rdbms.DefaultTransactionalExecutor.executeInternal(DefaultTransactionalExecutor.java:103)
at com.atlassian.sal.core.rdbms.DefaultTransactionalExecutor$1.execute(DefaultTransactionalExecutor.java:50)
at com.atlassian.sal.jira.rdbms.JiraHostConnectionAccessor.lambda$borrowConnectionAndExecute$0(JiraHostConnectionAccessor.java:62)
at com.atlassian.jira.database.DatabaseAccessorImpl.executeQuery(DatabaseAccessorImpl.java:67)

Users with the same issue

10 times, 1 year ago

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