addon projector configurator

Ira Greenfield June 22, 2016

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'.)

1 answer

0 votes
José Marañón [Awnaba Software S.L.]
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
June 22, 2016

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.

 

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events