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'.)
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.
Awnaba Software S.L.
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG
You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs