SA-1957

Summary

Pega admin had issues upgrading from Single schema to split schema.

Error Messages

[java] 2014-10-03 12:38:53,962 [                main] [          ] [                    ] (ernal.access.DataSourceManager) ERROR   - Unable to obtain DataSource for other
[java] com.pega.pegarules.pub.PRException: Unable to complete import of Application Bundle.
[java] From: (unknown)
[java] at com.pega.pegarules.deploy.internal.archive.ApplicationBundle.doImport(ApplicationBundle.java:1339)
...

Root Cause

The problem here is that there exist custom database tables that are mapped to the PegaRULES database.

In PRPC 7.1, the database table will be mapped to PegaDATA, not PegaRULES.  
So admins must temporarily map the custom database tables that are currently mapped to PegaRULES to another database schema, hence a new database schema (e.g. "OTHER" schema) was created and modifed the Database table to point to OTHER instead of PegaRULES.
When running the Rules upgrade script (i.e. upgrade.sh) the above error was seen. This was due to, inside Database rule for OTHER, "How to connect” option "use JDBC Connection pool" was selected from the drop down.  The database had no datasource defined for this temporary OTHER database.

Resolution

 In the Database rule for OTHER, select the "How to connect” dropdown option and "use JDBC URL listed below" was selected.  Test the connection.