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.
Hello! My name is Genevieve Blanch, and I'm the Marketing Manager at RefinedWiki, creators of apps to give teams the tools to customize Atlassian platforms. Currently, 44% of the tech team at Re...
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