ODI 12.2.1 SVN (VCS) Restore back to DefaultThe 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.
Close ODI Studio
Query the SNP_LOC_REP table and retrieve values and reset to null
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