ODI 12.2 SVN Subversion Restore back to default remove SVN Location that has been setup

ODI 12.2.1 SVN (VCS) Restore back to Default

The feature to remove SVN setup has not been documented as far as we can see. At your own risk. Worked for us and we never encountered any problems.

ODI 12.2 Has SVN ( Subversion ) checkout Version Control built in . We had setup this up but then realised we needed to point to setup on another server folder location and we could not.

We found the SNP_LOC_REP table in the Master Repository Schema in Database and reset the VCS* Fields to null. This allowed us to reset our SVN Repository folder locations. 



Returned SVN (VCS) to Default on the master repository. We could not find any documentation to do so. 

Solution : 

Close ODI Studio


Query the SNP_LOC_REP table and retrieve values and reset to null

select REP_NAME
,VCS_NAME
,VCS_ENABLE
,VCS_REP_NAME
,VCS_PROJECT_NAME
,VCS_BRANCH_NAME
,SYNC_STATUS
,VCS_AUTO_VERSIONING
,ENC_VCS_KEY 
FROM SNP_LOC_REP;

UPDATE SNP_LOC_REP
SET VCS_FIELDS = NULL;

COMMIT all field changes.

Restart ODI Studio.

TO RESET SVN FOLDERS AND REPOSITORY LOCATIONS UPDATE THE TABLE SNP_LOC_REP AND UPDATE ALL FIELDS THAT BEGIN WITH VCS TO NULL IE BLANK

Over and Out . Shahed & Krishna