SA-18701

Summary

A "No suitable driver" error is observed when running Pega pre-upgrade environment scanner.

Error Messages

Unable to load platform XML java.lang.ClassNotFoundException: Cannot find the specified class com.ibm.websphere.ssl.protocol.SSLSocketFactory
Please select a Application Server option from the following:

java.lang.NumberFormatException: For input string: ""
at java.lang.NumberFormatException.forInputString(NumberFormatException.java:59)
at java.lang.Integer.parseInt(Integer.java:481)
at java.lang.Integer.parseInt(Integer.java:510)
at application.input.UserInput.validateEmptyIntegerInput(UserInput.java:138)
at application.input.UserInput.handleAppServerInput(UserInput.java:124)
at application.input.UserInput.captureUserInput(UserInput.java:91)
at application.controller.commandline.CLHomeController.establishConnection(CLHomeController.java:160)
at application.CLMain.main(CLMain.java:35)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:60)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
at java.lang.reflect.Method.invoke(Method.java:611)
at org.eclipse.jdt.internal.jarinjarloader.JarRsrcLoader.main(JarRsrcLoader.java:58)
java.sql.SQLException: No suitable driver
at java.sql.DriverManager.getConnection(DriverManager.java:439)
at java.sql.DriverManager.getConnection(DriverManager.java:467)
at application.utils.DBUtils.getConnection(DBUtils.java:34)
at application.controller.commandline.CLHomeController.establishConnection(CLHomeController.java:163)
at application.CLMain.main(CLMain.java:35)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:60)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
at java.lang.reflect.Method.invoke(Method.java:611)
at org.eclipse.jdt.internal.jarinjarloader.JarRsrcLoader.main(JarRsrcLoader.java:58)
error message:No suitable driver

Steps to Reproduce

Run the command: java -jar PreUpgradeEnvScannerCMD.jar

Root Cause

A software use or operation error:  The user had not filled out the config.properties file, thus there was no database connection URL specified.

Resolution

The configuration file must be fully filled out. Please see the following article for additional instructions for how to fill it out: https://pdn.pega.com/community/pega-exchange/pre-upgrade-environment-scanner

# ALL PROPERTIES ARE MANDATORY
pega.database.type=[Database type]
pega.jdbc.url=[Connection URL]
pega.jdbc.username=[Database User]
pega.jdbc.password=[Database Password]
pega.prpc.schema.name=[Database Schema]
build.image.path=[Path to Pega Build Image]