ERROR: java.lang.NullPointerException

Cognos Controller 10.4.2
Microsoft Windows 2019 server

When open FAP.UDL file with DBCONV.exe program to upgrade the database you get a error.

ERROR: java.lang.NullPointerException

Possible solution:

The UDL file does not contain a password.

Copy the fap.uld file to folder D:\Program files\ibm\cognos\ccr_64\Data

Open the file in Cognos Controller configuration and add a password.

Click on test connection icon.

Click on arrow to start the Database conversion program.

Select FAP DB.

Click Connect.

Check if the numbers are different, then you need to click on Upgrade button.

Close the program.

Remove the fap.udl file from the \ibm\cognos\ccr_64\Data folder.

Also, ensure the SQLJDBC42.JAR file is in the folder D:\Program files\ibm\cognos\ccr_64

More Information: