When trying to export our Service Desk project in our on-premise server environment we get the below message and are unable to export the configuration.
Service Desk is in a shared instance with JIRA Software that was previously in the cloud.
An error occurred:
org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:select distinct customfield from customfieldvalue inner join jiraissue on customfieldvalue.issue = jiraissue.id where jiraissue.project in (11700) (Invalid object name 'customfieldvalue'.)
Hi Ira,
This seems to be the same problem described at https://awnaba.atlassian.net/browse/PCP-379. Have a look at the discussion there. Earlier in the comments you will see a workaround that will enable you to export the configuration, and further below the identification of the root cause (the connection to the database is prefixing table names with the scheme name, this happens sometimes, especially with MS SQL Server) and its likely fix.
If you need additional information, please feel free to ask again.
Kind regards,
José Marañón
Awnaba Software S.L.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.