EducationSoftwareStrategy.com
StrategyCommunity

Knowledge Base

Product

Community

Knowledge Base

TopicsBrowse ArticlesDeveloper Zone

Product

Download SoftwareProduct DocumentationSecurity Hub

Education

Tutorial VideosSolution GalleryEducation courses

Community

GuidelinesGrandmastersEvents
x_social-icon_white.svglinkedin_social-icon_white.svg
Strategy logoCommunity

© Strategy Inc. All Rights Reserved.

LegalTerms of UsePrivacy Policy
  1. Home
  2. Topics

KB48028: "ORA-00001: unique constraint violated" error message appears when migrating an object between environments in MicroStrategy Object Manager 9.3.1 - 10.x


Community Admin

• Strategy


This knowledge base article describes the error when migrating an object in MicroStrategy 9.3.1 - 10.x

SYMPTOM:
When migrating an object between environments using Strategy Object Manager 9.3.1 - 10.x, users receive the error below:
 

ka04W000000OffUQAS_0EM440000002CGq.png

 


Database error <5>: OdbcParameterizedQuery::ExecQuery failed.Error type: Odbc error. Odbc operation attempted: SQLExecute.ORA-00001: unique constraint violated (xxxx.SYS_C00131333) violated

NOTE: This is the error received when using an Oracle metadata.  The error message may vary slightly depending on the database platform being used for the metadata database.
CAUSE:
This error is caused by a physical inconsistency within the metadata.  There is already an entry for the particular object and project within the metadata, but this definition is not complete, nor should it exist.  Thus, upon trying to insert the object ID and definition into the metadata it is violating a primary key constraint put in place to prevent further inconsistencies down the line.
ACTION:
Contact Strategy Support if you encounter this issue.
Customers encountering this issue should make note of Schema-related changes, Object Migrations, or error messages prior to experiencing the problem.
 


Comment

0 comments

Details

Knowledge Article

Published:

April 7, 2017

Last Updated:

December 8, 2017