I was being stupid and enabled automatically lock object during edit / opened when I was asked the first time.

Now I want to remove the automatically lock from GUI but I couldn't seem to find it. I googled with such topics



So I searched userpref.xml inside the hard drive, I do find one userpref.xml.

I opened the file and inside it's just

<?xml version="1.0" encoding="UTF-8" ?>
<UserPreferences xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
                 xsi:schemaLocation="http://www.oracle.com/odi/userprefs UserPref.xsd"

What can I do to make it not locking up anymore each time I open an object? If it can be done through GUI then it's perfect if not, what should I do inside the XML file?

Thanks in advance for any help and advices.


I finally found a way to disable it. For my, I need to go into this path.


The file need to find is actually called userpref1222.xml. The file will be full of your users' configuration.

Search for this DEFAULT_LOCK_ON_OPENING and you'll see an object block looks something like this

<Object class="com.sunopsis.dwg.dbobj.SnpUserParam">
    <Field name="Key" type="java.lang.String"><![CDATA[DEFAULT_LOCK_ON_OPENING]]></Field>
    <Field name="Value" type="java.lang.String"><![CDATA[YES]]></Field>
    <Field name="Label" type="java.lang.String"><![CDATA[Lock object when opening]]></Field>
    <Field name="Type" type="java.lang.String"><![CDATA[com.sunopsis.graphical.userparam.SnpsTextFieldEditor]]></Field>
    <Field name="Help" type="java.lang.String"><![CDATA[Lock object when opening]]></Field>
    <Field name="Visible" type="boolean"><![CDATA[true]]></Field>
    <Field name="Updatable" type="boolean"><![CDATA[true]]></Field>
    <Field name="Position" type="int"><![CDATA[0]]></Field>

change the second field name of "Value" then change YES to NO like below

<Field name="Value" type="java.lang.String"><![CDATA[NO]]></Field>

After changing it, save it, disconnect ODI, close ODI then reopen, reconnect. This worked for me with two machines.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.