Upgrading to 14.2 can fail and need redoing if prior to the upgrade the properties.xml contains an <encryption> element with no useSystemKey="true|false" attribute value present.
The file would include the following output example when this problem occurs:
4/25/15 2:08 AM (admin) java.lang.NullPointerException
4/25/15 2:08 AM (admin) at com.niku.tools.taskdefs.JDBCSecurePasswordTask.getConnection(JDBCSecurePasswordTask.java:44)
4/25/15 2:08 AM (admin) at com.niku.tools.taskdefs.SQLTask.execute(SQLTask.java:540)
4/25/15 2:08 AM (admin) at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:291)
4/25/15 2:08 AM (admin) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
4/25/15 2:08 AM (admin) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
Steps to Reproduce:
- Install Clarity and get it working with basic setup
- Go into the CSA and navigate to the properties > security tab
- Without changing anything, click on Save
- Check the properties.xml, the <encryption> element will have been created but no attribute for useSystemKey exists
- Upgrading at this point will cause the error
Expected Result: Upgrade to complete without encountering this error
Actual Result: Upgrade will encounter this error in a few places (e.g. post-upgrade scripts) and fail with an incomplete upgrade
Applies to all supported PAS environments for upgrades to CA PPM 14.2.
Caused by CLRT-77615
Resolved in CA PPM 14.3
- Go back to the CSA properties > security tab before upgrade
- Under the Encrypt Passwords section change the setting (e.g. from No Encryption to Using System Key)
- Click on Save
- Change the setting back again (e.g. from Using System Key to No Encryption)
- Click Save again.
Now the <encryption> element will exist and the useSystemKey attribute should exist too. Now the upgrade should proceed without error.
It is best to do this workaround proactively and avoid the need to rollback and redo the upgrade.
Reference Release Notes and CA PPM Resolved Defects Index for CA PPM 14.3