Why am I getting this error?

Nabeel Ali

Hi 

I have migrated Jira to a SQL server. When I click on my project under Service Desk I'm Immediately faced by an error 500 with a long message. I also face an error when trying to create a new project.  

Please find below the full error I recieve.

Technical details
Log's referral number: 0ecd167a-f045-469d-80e8-fe5b62e2e3b9
Cause
Referer URL: http://localhost:8080/plugins/servlet/applications/versions-licenses\\ java.lang.RuntimeException: com.querydsl.core.QueryException: Caught SQLException 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 "null"."AO_54307E_SERVICEDESK" "AO_54307E_SERVICEDESK" inner join "null"."PROJECT" "PROJECT" on "AO_54307E_SERVICEDESK"."PROJECT_ID" = "PROJECT"."ID" order by "PROJECT"."PNAME" asc
java.lang.RuntimeException: com.querydsl.core.QueryException: Caught SQLException 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", 
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729) [servlet-api.jar:?]
at com.atlassian.plugin.servlet.DelegatingPluginServlet.service(DelegatingPluginServlet.j

 

 

I had to delete some of the error due to character limit.

 

 

Jobin Kuruvilla [Adaptavist]

Can you post the last part of the Stacktrace? The error is not clear from the snippet you posted.