Failed to compress the database


---------------------------
Compress Database
---------------------------
Failed to compress the database.
Underlying DBMS error[ORA-00001: unique constraint (MJEC.R416_SDE_ROWID_UK) violated
][SDE.DEFAULT]
---------------------------
OK
---------------------------

In M_N/Table based Relationship fields "RID" Field having duplicates. So add relation ships to ArcMAP. Export to excel and find the duplicate RID's and delete those relation ships in table. Still compressing problem check all the  M_N/Table based  relationships. Delete duplicate RID's. After compressing SDE. Given what ever deleted the duplicate RID relationships by Manually.

Also you can check the which is having the duplicate field and table name. Then you can check the the number for error number in below executed command. for example 416 in


SELECT registration_id,table_name,ROWID_COLUMN FROM sde.table_registry WHERE owner = 'MJEC'

Comments

Post a Comment

Popular posts from this blog

SDE Lineages count and some commands

Connect as sde login in your database through Sql sql> SELECT COUNT(*) FROM sde.state_lineages WHERE lineage_name NOT IN (SELECT DISTINCT lineage_name FROM sde.states); Versions names and State_ID SELECT name, state_id FROM sde.versions; States count SELECT COUNT(*) FROM sde.states;
Read more

Strengths for Appraisals

Hard worker Punctual Determined Able to prioritize Believe in myself; self-confidence I have the ability to cope with failures and try to learn from my mistakes. I like to work in team and have been an active participant and organizer at several places. One of my greatest strengths I've acquired during my education is good analytical and planning skills. This has always benefited me to set goals and try to achieve them. But at the same time, I'm driven by the thoughts of success. Full commitment to my work Highly energetic Love to learn new things. Having good interpersonal skills Well organized and like to be neat with all of my work A good helper towards those who need it I am a team player and work well with others. I have great communication skills. I am a quick learner. I have great problem-solving skills and am willing to learn new things to get the job done.
Read more

Label In ARCGIS

Image
I want to display the label after a character in ArcGIS desktop Function FindLabel ( [LABEL]  ) la = InStr([LABEL],"-") lab=len([LABEL])-la FindLabel = Right([LABEL],lab) End Function here i have used the two variable - "la"& "lab" Ex:- My Label field having ABC-25367. I want to display 25367 la variable will store the 4th position means value will be 4 lab = (length  of label (9)-la(4)) = 5 Using Right expression, It will display the 5 right side characters (25367)
Read more