TIBCO JasperReports® Server install with Oracle 12c and "username should starts with c##" message

Issue Description

Oracle 12c with CDB/PDB configured requires particular users for TIBCO JasperReports^® Server installation.

The first symptom is that during js-install.bat (or other buildomatic commands) you encounter an error with message:

"username should starts with c##".

Resolution

Oracle CDB/PDB provides a multi-tenant architecture. If you are seeing the "username should starts with c##" message this is a sign that you are using a local or regular user to connect to the CDB. If you connect directly to the PDB via a specific SID, then the local or regular user should be fine, but you can't connect regular or local user to the CDB per Oracle, see https://docs.oracle.com/database/121/DBSEG/users.htm#DBSEG573

To connect to the CDB follow the instructions in the Installation Guide: https://community.jaspersoft.com/documentation/tibco-jasperreports-server-installation-guide/v630/installing-war-file-using-js  . It states that for Oracle 12c with CDB/PDB  a common user should be specified in the default_master.properties file using the ## syntax as specified by Oracle:

Use settings for Oracle, except for the following changes:

dbUsername=c##jasperserver sid=cdb1

Ref. Case 01533066