Question

Issue with the import command for PRPC 7.1.8v

Hi all,

We are using the Pega import command to import the product jar to the target server. In this process, we have updated the prpcutils.properties file with the required data base information and jar path. After running the command we are getting the following error:

[java] (!) Unable to use given database configuration

[java] (!) Unable to locate classes on filesystem

Any suggestions would be helpful and following is the log file.

Log file:

-import:

[echo] about to Import from : /apps/Oracle/Middleware/user_projects/domains/PegaDomain/Pega_DevOps/ExportedProducts/TestImportJAR.jar archive ...

[echo] arg line : -y -c "100" load -j "Customer" -k "06-01-01" -M -U "vishal" -P "install"

[java] Feb 26, 2018 2:55:56 PM com.pega.pegarules.internal.bootstrap.PRBootstrapDataSource

[java] 19830421: Loading bootstrap properties from file:////apps/Oracle/Middleware/user_projects/domains/PegaDomain/Temp_pega/PegaInstallTemp-26-February-2018-14.55.53/prbootstrap.properties

[java] Feb 26, 2018 2:55:56 PM com.pega.pegarules.internal.bootstrap.SettingReaderJNDI

[java] 19830421: Could not find java:comp/env/prbootstrap/ in the local JNDI context, skipping prconfig setting lookup

[java] Feb 26, 2018 2:55:56 PM com.pega.pegarules.internal.bootstrap.SettingReaderJNDI

[java] 19830421: Could not find prbootstrap in the local JNDI context, skipping prconfig setting lookup

[java] Feb 26, 2018 2:55:56 PM com.pega.pegarules.internal.bootstrap.PRBootstrapDataSource

[java] 19830421: Bootstrap datatables schema: PEGA3

[java] Feb 26, 2018 2:55:57 PM com.pega.pegarules.internal.bootstrap.PRBootstrap

[java] 19830421: Engine schema defined in allclasses: null

[java] Feb 26, 2018 2:55:57 PM com.pega.pegarules.internal.bootstrap.SettingReaderJNDI

[java] 19830421: Could not find java:comp/env/prconfig/ in the local JNDI context, skipping prconfig setting lookup

[java] Feb 26, 2018 2:55:57 PM com.pega.pegarules.internal.bootstrap.SettingReaderJNDI

[java] 19830421: Could not find prconfig in the local JNDI context, skipping prconfig setting lookup

[java] Feb 26, 2018 2:55:57 PM com.pega.pegarules.internal.bootstrap.PRBootstrap

[java] 19830421: Engine classes schema: null

[java] Feb 26, 2018 2:55:57 PM com.pega.pegarules.internal.bootstrap.PRBootstrap

[java] 19830421: Assembled classes schema: null

[java] Feb 26, 2018 2:55:57 PM com.pega.pegarules.internal.bootstrap.PRBootstrap

[java] 19830421: prbootstrap.properties merged with prbootstrap entries in Data-Admin-System-Settings

[java] Feb 26, 2018 2:55:57 PM com.pega.pegarules.internal.bootstrap.PRMiniLoader

[java] 19830421: Will load phase 2 bootstrap from Pega-EngineCode:07-10-17

[java] Feb 26, 2018 2:55:57 PM com.pega.pegarules.internal.bootstrap.PRMiniLoader

[java] SEVERE:

[java] Feb 26, 2018 2:55:57 PM com.pega.pegarules.internal.bootstrap.PRMiniLoader

[java] SEVERE: ============================= Failed to bootstrap PegaRULES =============================

[java] Feb 26, 2018 2:55:57 PM com.pega.pegarules.internal.bootstrap.PRMiniLoader

[java] SEVERE:

[java] Feb 26, 2018 2:55:57 PM com.pega.pegarules.internal.bootstrap.PRMiniLoader

[java] SEVERE: Could not load the java class 'com/pega/pegarules/internal/bootstrap/phase2/PRBootstrapImpl.class' from the database table 'PEGA3.pr_engineclasses'

[java] Feb 26, 2018 2:55:57 PM com.pega.pegarules.internal.bootstrap.PRMiniLoader

[java] SEVERE: This is usually due to an empty 'PEGA3.pr_engineclasses' table, or possibly it does not contain the configured codeset version.

[java] Feb 26, 2018 2:55:57 PM com.pega.pegarules.internal.bootstrap.PRMiniLoader

[java] SEVERE: In this run the prbootstrap.properties specified 'pega-enginecode:07-10-17', checking database...

[java] Feb 26, 2018 2:55:57 PM com.pega.pegarules.internal.bootstrap.PRMiniLoader

[java] SEVERE:

[java] Feb 26, 2018 2:55:57 PM com.pega.pegarules.internal.bootstrap.PRMiniLoader

[java] SEVERE: 'PEGA3.pr_engineclasses' contains a total of 39833 classes, searching for available codesets...

[java] Feb 26, 2018 2:55:57 PM com.pega.pegarules.internal.bootstrap.PRMiniLoader

[java] SEVERE:

[java] /apps/Oracle/Middleware/user_projects/domains/PegaDomain/Temp_pega/PegaInstallTemp-26-February-2018-14.55.53/load/WEB-INF/lib/boot/prbootphase2.jar (No such file or directory)

[java] Perhaps executing with a non-standard classpath (e.g. JUnit tests)?

[java] Feb 26, 2018 2:55:57 PM com.pega.pegarules.internal.bootstrap.PRMiniLoader

[java] SEVERE: Codeset |Version

[java] Feb 26, 2018 2:55:57 PM com.pega.pegarules.internal.bootstrap.PRMiniLoader

[java] SEVERE: customer |06-01-01

[java] Feb 26, 2018 2:55:57 PM com.pega.pegarules.internal.bootstrap.PRMiniLoader

[java] SEVERE: pega-enginecode |06-03-10

[java] Feb 26, 2018 2:55:57 PM com.pega.pegarules.internal.bootstrap.PRMiniLoader

[java] SEVERE:

[java] Feb 26, 2018 2:55:57 PM com.pega.pegarules.internal.bootstrap.PRMiniLoader

[java] SEVERE: Subsequent exceptions relating to class not being found are all related to this root cause...

[java] Feb 26, 2018 2:55:57 PM com.pega.pegarules.internal.bootstrap.PRMiniLoader

[java] SEVERE: Check to make sure the database is correctly configured and that the codeset version specified was correct and is present in that database.

[java] Feb 26, 2018 2:55:57 PM com.pega.pegarules.internal.bootstrap.PRMiniLoader

[java] SEVERE: =========================================================================================

[java] Feb 26, 2018 2:55:57 PM com.pega.pegarules.internal.bootstrap.PRMiniLoader

[java] SEVERE:

[java] Feb 26, 2018 2:55:57 PM com.pega.pegarules.internal.bootstrap.PRBootstrap

[java] 19830421:

[java] ============ PegaRULES Bootstrap Configuration ============

[java] Date: Mon Feb 26 14:55:57 SGT 2018

[java] Java Version: Oracle Corporation 1.7.0_75

[java] Configuration: file:////apps/Oracle/Middleware/user_projects/domains/PegaDomain/Temp_pega/PegaInstallTemp-26-February-2018-14.55.53/prbootstrap.properties

[java] Pega-EngineCode: 07-10-17

[java] Database: Oracle Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

[java] With the Partitioning, Oracle Label Security, OLAP, Data Mining

[java] and Real Application Testing options

[java] Driver: Oracle JDBC driver 11.2.0.3.0

[java]

[java] (!) Unable to use given database configuration

[java] (!) Unable to locate classes on filesystem

[java] =============== End Bootstrap Configuration ===============

[java]

[java] Unable to load phase 2 bootstrap class: com.pega.pegarules.internal.bootstrap.phase2.PRBootstrapImpl

[java] Feb 26, 2018 2:55:57 PM com.pega.pegarules.internal.bootstrap.PRBootstrap

[java] SEVERE: Error initializing PRAppLoader

[java] java.lang.ClassNotFoundException: com.pega.pegarules.internal.bootstrap.phase2.PRBootstrapImpl

[java] at com.pega.pegarules.internal.bootstrap.PRMiniLoader.loadClass(PRMiniLoader.java:388)

[java] at java.lang.ClassLoader.loadClass(ClassLoader.java:358)

[java] at com.pega.pegarules.internal.bootstrap.PRBootstrap.loadPhase2BootstrapClass(PRBootstrap.java:717)

[java] at com.pega.pegarules.internal.bootstrap.PRBootstrap.checkForStartup(PRBootstrap.java:658)

[java] at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethodPropagatingThrowable(PRBootstrap.java:405)

[java] at com.pega.pegarules.boot.internal.extbridge.AppServerBridgeToPega.invokeMethodPropagatingThrowable(AppServerBridgeToPega.java:223)

[java] at com.pega.pegarules.boot.internal.extbridge.AppServerBridgeToPega.invokeMethod(AppServerBridgeToPega.java:272)

[java] at com.pega.pegarules.pub.PegaRULES.main(PegaRULES.java:85)

[java]

[java] Feb 26, 2018 2:55:57 PM com.pega.pegarules.boot.internal.extbridge.AppServerBridgeToPega

[java] SEVERE: Problem during method invocation (main)

[java] java.lang.RuntimeException: PRAppLoader was not properly initialized, unable to load class com.pega.pegarules.deploy.external.util.ImportUtility

[java] at com.pega.pegarules.internal.bootstrap.PRBootstrap.getImplementationOf(PRBootstrap.java:205)

[java] at com.pega.pegarules.internal.bootstrap.PRBootstrap.getEntry(PRBootstrap.java:321)

[java] at com.pega.pegarules.internal.bootstrap.PRBootstrap.getMethod(PRBootstrap.java:301)

[java] at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethodPropagatingThrowable(PRBootstrap.java:406)

[java] at com.pega.pegarules.boot.internal.extbridge.AppServerBridgeToPega.invokeMethodPropagatingThrowable(AppServerBridgeToPega.java:223)

[java] at com.pega.pegarules.boot.internal.extbridge.AppServerBridgeToPega.invokeMethod(AppServerBridgeToPega.java:272)

[java] at com.pega.pegarules.pub.PegaRULES.main(PegaRULES.java:85)

[java]

[java] Exception in thread "main" java.lang.RuntimeException: Problem during method invocation (main)

[java] at com.pega.pegarules.boot.internal.extbridge.AppServerBridgeToPega.invokeMethod(AppServerBridgeToPega.java:278)

[java] at com.pega.pegarules.pub.PegaRULES.main(PegaRULES.java:85)

[java] Caused by: java.lang.RuntimeException: PRAppLoader was not properly initialized, unable to load class com.pega.pegarules.deploy.external.util.ImportUtility

[java] at com.pega.pegarules.internal.bootstrap.PRBootstrap.getImplementationOf(PRBootstrap.java:205)

[java] at com.pega.pegarules.internal.bootstrap.PRBootstrap.getEntry(PRBootstrap.java:321)

[java] at com.pega.pegarules.internal.bootstrap.PRBootstrap.getMethod(PRBootstrap.java:301)

[java] at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethodPropagatingThrowable(PRBootstrap.java:406)

[java] at com.pega.pegarules.boot.internal.extbridge.AppServerBridgeToPega.invokeMethodPropagatingThrowable(AppServerBridgeToPega.java:223)

[java] at com.pega.pegarules.boot.internal.extbridge.AppServerBridgeToPega.invokeMethod(AppServerBridgeToPega.java:272)

[java] ... 1 more

BUILD FAILED

/apps/Oracle/Middleware/user_projects/domains/PegaDomain/Pega_DevOps/PRPC_Utility/scripts/utils/prpcUtilsTarget_DEV.xml:645: Java returned: 1

Total time: 4 seconds

Ant Process returned a non 0 value

Build step 'Execute shell' marked build as failure

$ ssh-agent -k

unset SSH_AUTH_SOCK;

unset SSH_AGENT_PID;

echo Agent pid 4908 killed;

[ssh-agent] Stopped.

Finished: FAILURE

Correct Answer
February 28, 2018 - 10:24pm

The issue has been resolved now, earlier I used single schema name for both rules schema and data schema which is causing this error. So changed the schema names in the prpcutils.properties file for rules.schema.name and data.schema.name with valid data accordingly and it worked.  Thanks for your comments Mahesh and Arun.

Comments

Keep up to date on this post and subscribe to comments

February 28, 2018 - 3:56am

Hi Vishal,

Could you share the prpcutils.properties file with your configuration and the command you had used to perform the import?

Regards

Mahesh

December 18, 2018 - 4:26pm
Response to Mahesh Midthuru

Do you have any Command to Import Product using prpcutils.bat?

December 18, 2018 - 4:55pm
Response to VIGNESWARAN

Have you gone through the Pega Help, if not could you have a look into Import tool Settings section over here to understand the usage of import feature using prpcUtils. Basically you need to configure the properties available in this section as per your requirement then call the "prpcUtils.bat/sh import" command and you can have a look into the bottom of the page to see the prpcUtils script arguments that you can pass through the command line execution. Hope that helps you to achieve your requirement.

December 18, 2018 - 5:10pm
Response to Mahesh Midthuru

Mahesh,

 

Thank you responding back to  the query.

I have configured all the required parameters in the properties file.

For Export RAP:

we give ExportRAP in command

Similarly for Importing from a File path, once we have configured the file path in prpc properties file.

What will be the syntax to use in command prompt? also where we can see the imported product?

December 18, 2018 - 5:24pm
Response to Mahesh Midthuru

Also Where will we mention which File we need to import and the location from where the script needs to import it?

December 19, 2018 - 11:12am
Response to VIGNESWARAN

You need to provide the file name along with the full path in import.archive.path property and run the "prpcUtils.bat/sh import" command from the utility directory where this bat file exists. Hope this helps you.

December 19, 2018 - 1:36pm
Response to Mahesh Midthuru

Hi Mahesh.

 

Thank you for helping out. I see the Import is Successful but I'm not sure where the Jar file will be Imported.

In the prpcutils.properties there was a reference for temp directory and I changed it as below

user.temp.dir=C:\TESTIMPORT

 

Even then I dont see the imported file?

December 19, 2018 - 3:45pm
Response to VIGNESWARAN

You can login to the target system and check for the product rule whether its imported or not. By the way i would suggest you to raise a new post with all the artifacts if you face any further issue in the import process instead of discussing in this old closed thread, as your's a different scenario.

February 28, 2018 - 4:29am

I think it's not able to load the prbootstrap from the engine .

Have you mentioned the schema names properly .

please attach prpcutils.properties  file to have a look .

Thanks,

Arun

February 28, 2018 - 10:24pm

The issue has been resolved now, earlier I used single schema name for both rules schema and data schema which is causing this error. So changed the schema names in the prpcutils.properties file for rules.schema.name and data.schema.name with valid data accordingly and it worked.  Thanks for your comments Mahesh and Arun.