SDE - State ID error

In the Snap shot While deleting we found this error some time due State not found in the State table.





Ans : In that if you want to delete the version. Need to delete from back end using below Sql statement using SDE login
Sqlplus/nolog
Sql> Conn sde/sde@Databasename
Sql> delete from versions where name='---------';

Version will be delete


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

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

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