DB error when trying to import data

Questions & Answers
1

Hi. I deleted my source data by mistake. After creating it again and trying to import issues from jira I always get an error

NativeException: java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1
ORA-00001: unique constraint (SYS.I_WRI$_OPTSTAT_HH_OBJ_ICOL_ST) violated
: ALTER TABLE “#97_JIRA_ISSUES” DROP COLUMN “CUSTOMFIELD_10203”

The customfield_10203 is valid and should not throw errors.

Do you know what could be happening?

Thank you in advance

2

Looks like the new data source is not playing nice with the old cube. The best thing to do would be deleting entire cube from the Analyze tab and then importing it again. Just remember to export your report definitions first so they don’t get lost with the cube.

3

Thank you Janis, I was figuring it out that the solution was in this direction.
Regards