Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Discussion

 Dhanunjaya Singamsetty (DhanunjayaS16932751)
Elevance Health inc.
Elevance Health inc.
Elevance Health inc.
US
DhanunjayaS16932751 Member since 2023 3 posts
Elevance Health inc.
Posted: Jun 1, 2016
Last activity: Dec 15, 2016
Posted: 1 Jun 2016 17:19 EDT
Last activity: 15 Dec 2016 20:20 EST
Closed

PRPCUtils - Column Populator

Hi.

I

I am trying to populate a column in the work table from existing blob. The business has requested IT to add a column in the work table, so that they can query that table using that column. The column has been added to the table. Now I am trying to update the values in that column from the blob using the Column Populator command line tool. Right now I am stuck with an error. Below is the part of the log showing the error. Any help would be greatly appreciated. if this not right forum location, please let me know the details where to post it.

Thanks in advance.

Jay

 

Invoke our ant script, passing in the arguments as collected
Buildfile: C:\temp\114820_PEGA_718-UPD\scripts\utils\prpcUtils.xml

-init:
[pega:propertyparser] Reading Properties from : C:\temp\114820_PEGA_718-UPD\scripts\utils/prpcUtils.properties
[pega:propertyparser] pega.jdbc.driver.jar=sqljdbc41.jar
[pega:propertyparser] pega.jdbc.driver.class=com.microsoft.sqlserver.jdbc.SQLServerDriver
[pega:propertyparser] pega.database.type=mssql
[pega:propertyparser] pega.jdbc.url=jdbc:sqlserver://*****\*******;databaseName=******;selectMethod=cursor;sendStringParametersAsUnicode=false
[pega:propertyparser] pega.jdbc.username=*******
[pega:propertyparser] pega.jdbc.password=******
[pega:propertyparser] pegarules.config=prconfig.xml
[pega:propertyparser] pega.user.username=*******
[pega:propertyparser] pega.user.password=*******
[pega:propertyparser] rules.schema.name=dbo
[pega:propertyparser] data.schema.name=dbo
[pega:propertyparser] pega.agents.enable=true
[pega:propertyparser] column.population.job.mode=COMMANDLINE_JOB
[pega:propertyparser] user.temp.dir=C:/temp
[pega:propertyparser] import.archive.path=C:/importfile.zip
[pega:propertyparser] import.mode=import
[pega:propertyparser] import.existing.instances=skip
[pega:propertyparser] import.nofailonerror=false
[pega:propertyparser] import.commit.count=100
[pega:propertyparser] import.compile.libraries=true
[pega:propertyparser] import.codeset.name=Customer
[pega:propertyparser] import.codeset.version=06-01-01
[pega:propertyparser] export.archive.full.path=C:/path/to/export/file/exported-Jan-5.zip
[pega:propertyparser] export.archive.productkey=
[pega:propertyparser] export.classes.included=
[pega:propertyparser] export.included.descendent=true
[pega:propertyparser] export.classes.excluded=
[pega:propertyparser] export.excluded.descendent=true
[pega:propertyparser] export.startVersion=
[pega:propertyparser] export.endVersion=
[pega:propertyparser] export.keys.file=
[pega:propertyparser] export.ruleset.name=
[pega:propertyparser] export.application.context=
[pega:propertyparser] export.preserve.locks=false
[pega:propertyparser] export.migration.xml=
[pega:propertyparser] export.migration.date=
[pega:propertyparser] expose.classes.included=AGP-CS-CLAIMS-CICR-Work-Claims
[pega:propertyparser] expose.included.descendent=true
[pega:propertyparser] expose.classes.excluded=
[pega:propertyparser] expose.excluded.descendent=true
[pega:propertyparser] expose.declareIndex.accessgroup=
[pega:propertyparser] expose.startKey=
[pega:propertyparser] expose.endKey=
[pega:propertyparser] expose.startDate="2016-02-24 18:33:08.290"
[pega:propertyparser] expose.endDate="2016-02-24 18:33:14.103"
[pega:propertyparser] expose.reindex=true
[pega:propertyparser] expose.reindexType=nonpega
[pega:propertyparser] expose.commitRate=100
[pega:propertyparser] expose.numOfThreads=
[pega:propertyparser] resave.classes.included=AGP-CS-CLAIMS-CICR-Work-Claims
[pega:propertyparser] resave.included.descendent=true
[pega:propertyparser] resave.classes.excluded=
[pega:propertyparser] resave.excluded.descendent=true
[pega:propertyparser] resave.startKey=
[pega:propertyparser] resave.endKey=
[pega:propertyparser] resave.startDate="2016-02-24 18:33:08.290"
[pega:propertyparser] resave.endDate="2016-02-24 18:33:14.103"
[pega:propertyparser] runagent.agentruleset=Pega-RulesEngine
[pega:propertyparser] runagent.agentname=PropertyOptimization
[pega:propertyparser] scan.applicationName=PegaRULES
[pega:propertyparser] scan.applicationVersion=
[pega:propertyparser] scan.lib.external.jars=
[pega:propertyparser] scan.result.file=E:/Results.csv
[pega:propertyparser] scan.ruletypes.file=E:/RuleTypes.txt
[pega:propertyparser] manage.hotfix=
[pega:propertyparser] syntax.rules.excludeCore=false
[pega:propertyparser] syntax.rules.allVersions=true
[pega:hasenoughspace] Found 23773328KB of free space on 'C:/temp'
    [mkdir] Created dir: C:\temp\PegaInstallTemp-01-June-2016-16.50.43\load
    [mkdir] Created dir: C:\temp\PegaInstallTemp-01-June-2016-16.50.43\pr_temp
     [echo] Using C:/temp/PegaInstallTemp-01-June-2016-16.50.43 for install scratch space...
    [unzip] Expanding: C:\temp\114820_PEGA_718-UPD\archives\pegadbinstall-classes.zip into C:\temp\PegaInstallTemp-01-June-2016-16.50.43\load
    [unzip] Expanding: C:\temp\114820_PEGA_718-UPD\archives\prweb.war into C:\temp\PegaInstallTemp-01-June-2016-16.50.43\load
     [copy] Copying 1 file to C:\temp\PegaInstallTemp-01-June-2016-16.50.43\load\lib
     [copy] Copying 1 file to C:\temp\PegaInstallTemp-01-June-2016-16.50.43\load\WEB-INF\classes
     [copy] Copying 1 file to C:\temp\PegaInstallTemp-01-June-2016-16.50.43

Checking Configuration Files:

_findSystemName:
     [echo] select max(s.pySystemName) from dbo.pr_data_admin s inner join dbo.pr_data_admin r    on s.pySystemName = r.pySystemName    where s.pxobjclass = 'Data-Admin-System' and r.pxObjClass = 'Data-Admin-Requestor'

Processing Configuration Files:
[propertyfile] Creating new property file: C:\temp\PegaInstallTemp-01-June-2016-16.50.43\prbootstrap.properties

Configuration:
     [echo] Database Type: mssql
     [echo] JDBC Driver JAR: sqljdbc41.jar
     [echo] Bootstrap Config: C:/temp/PegaInstallTemp-01-June-2016-16.50.43/prbootstrap.properties
     [echo] PegaRULES Config: prconfig.xml
     [echo] PegaRULES Logging Config: C:/temp/PegaInstallTemp-01-June-2016-16.50.43/prlogging.xml

-exposeColumns:
     [echo] arg line :  :  -C AGP-CS-CLAIMS-CICR-Work-Claims    -d "2016-02-24 18:33:08.290" -D "2016-02-24 18:33:14.103" -r -i nonpega -U ******* -P *********** -s 100    
     [java] Jun 01, 2016 4:51:22 PM com.pega.pegarules.internal.bootstrap.PRBootstrapDataSource 
     [java] 19830421: Loading bootstrap properties from file:///C:/temp/PegaInstallTemp-01-June-2016-16.50.43/prbootstrap.properties
     [java] Jun 01, 2016 4:51:22 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] Jun 01, 2016 4:51:22 PM com.pega.pegarules.internal.bootstrap.SettingReaderJNDI 
     [java] 19830421: Could not find prbootstrap in the local JNDI context, skipping prconfig setting lookup
     [java] Jun 01, 2016 4:51:22 PM com.pega.pegarules.internal.bootstrap.PRBootstrapDataSource 
     [java] 19830421: Bootstrap datatables schema: dbo
     [java] Jun 01, 2016 4:51:23 PM com.pega.pegarules.internal.bootstrap.PRBootstrap 
     [java] 19830421: Engine schema defined in allclasses: null
     [java] Jun 01, 2016 4:51:23 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] Jun 01, 2016 4:51:23 PM com.pega.pegarules.internal.bootstrap.SettingReaderJNDI 
     [java] 19830421: Could not find prconfig in the local JNDI context, skipping prconfig setting lookup
     [java] Jun 01, 2016 4:51:23 PM com.pega.pegarules.internal.bootstrap.PRBootstrap 
     [java] 19830421: Engine classes schema: null
     [java] Jun 01, 2016 4:51:23 PM com.pega.pegarules.internal.bootstrap.PRBootstrap 
     [java] 19830421: Assembled classes schema: null
     [java] Jun 01, 2016 4:51:23 PM com.pega.pegarules.internal.bootstrap.PRBootstrap 
     [java] 19830421: prbootstrap.properties merged with prbootstrap entries in Data-Admin-System-Settings
     [java] Jun 01, 2016 4:51:23 PM com.pega.pegarules.internal.bootstrap.PRMiniLoader 
     [java] 19830421: Will load phase 2 bootstrap from Pega-EngineCode:07-10-17
     [java] Jun 01, 2016 4:51:28 PM com.pega.pegarules.internal.bootstrap.phase2.PRBootstrapImpl 
     [java] 19830421: PegaRULES signed jar files will be extracted to: C:/temp/PegaInstallTemp-01-June-2016-16.50.43\extractedFiles
     [java] Jun 01, 2016 4:51:28 PM com.pega.pegarules.internal.bootstrap.phase2.PRBootstrapImpl 
     [java] WARNING: Cannot delete directory: extractedFiles
     [java] Jun 01, 2016 4:51:30 PM com.pega.pegarules.internal.bootstrap.phase2.PRBootstrapImpl 
     [java] 19830421: PegaRULES classes will be loaded from the database
     [java] Jun 01, 2016 4:51:30 PM com.pega.pegarules.internal.bootstrap.PRBootstrap 
     [java] 19830421: 
     [java] ============ PegaRULES Bootstrap Configuration ============
     [java]            Date: Wed Jun 01 16:51:30 EDT 2016
     [java]    Java Version: Oracle Corporation 1.8.0_92
     [java]   Configuration: file:/C:/temp/PegaInstallTemp-01-June-2016-16.50.43/prbootstrap.properties
     [java] Pega-EngineCode: 07-10-17
     [java]     ASM Version: -1551638810
     [java]        Database: Microsoft SQL Server 11.00.5058
     [java]          Driver: Microsoft JDBC Driver 4.1 for SQL Server 4.1.5605.100
     [java] Active CodeSets: pega-enginecode:07-10-17 at (latest patch)
     [java]                  hc-x12-debatch:06-01-01 at (latest patch)
     [java]                  customer:06-01-01 at (latest patch)
     [java] 
     [java] =============== End Bootstrap Configuration ===============
     [java] 
     [java] Current "user.dir" (default directory) is: C:\temp\PegaInstallTemp-01-June-2016-16.50.43\load
     [java] Located PegaRULES logging configuration: file:/C:/temp/PegaInstallTemp-01-June-2016-16.50.43/load/WEB-INF/classes/prlogging.xml
     [java] Found spec for PegaRULES (V5.x) configuration using System property: prconfig.xml
     [java] Located PegaRULES (V5.x) configuration: file:/C:/temp/PegaInstallTemp-01-June-2016-16.50.43/load/WEB-INF/classes/prconfig.xml
     [java] Jun 01, 2016 4:51:34 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] Jun 01, 2016 4:51:34 PM com.pega.pegarules.internal.bootstrap.SettingReaderJNDI 
     [java] 19830421: Could not find prconfig in the local JNDI context, skipping prconfig setting lookup
     [java] 2016-06-01 16:51:34,623 [                main] [          ] [                    ] (     basic.config.SettingsImpl) INFO    - prconfig.xml merged with prconfig entries in Data-Admin-System-Settings
     [java] 2016-06-01 16:51:34,926 [                main] [          ] [                    ] (able.DefaultVirtualTableConfig) INFO    - Using Hybrid Virtual Rules Table implementation
     [java] 2016-06-01 16:51:34,926 [                main] [          ] [                    ] (able.DefaultVirtualTableConfig) INFO    - VTable dispatches rules for 7 Aspects: 'Action, Alias, Validate, Collection, When, Input, Model'.
     [java] 2016-06-01 16:51:34,926 [                main] [          ] [                    ] (able.DefaultVirtualTableConfig) INFO    - ABA[AC] dispatches rules for 1 Aspect: 'Stream'.
     [java] 2016-06-01 16:51:34,948 [                main] [          ] [                    ] (  priv.context.JNDIEnvironment) INFO    - Enterprise-tier default Engine bean name is EngineBMT
     [java] 2016-06-01 16:51:34,985 [                main] [          ] [                    ] (r.context.EtierEnvironmentImpl) WARN    - Enterprise tier has no local JNDI context
     [java] reason: Need to specify class name in environment or system property, or as an applet parameter, or in an application resource file:  java.naming.factory.initial
     [java] 2016-06-01 16:51:35,492 [                main] [          ] [                    ] (ion.internal.PRGenProviderImpl) INFO    - invokeDynamic instrumentation for inlining is enabled
     [java] 2016-06-01 16:51:35,492 [                main] [          ] [                    ] (ion.internal.PRGenProviderImpl) INFO    - Assembly Version: -1551638810
     [java] 2016-06-01 16:51:36,577 [                main] [          ] [                    ] (ernal.access.DataSourceManager) ERROR   - Unable to obtain DataSource for pegadata
     [java] 2016-06-01 16:51:36,592 [                main] [          ] [                    ] (ernal.access.DataSourceManager) ERROR   - Unable to obtain DataSource for pegadata
     [java] Unable to locate KeyringImpl keyring after trying:
     [java]     <properties>
     [java]     AC86613-pegarules.keyring
     [java]     L5CG5033BX3-pegarules.keyring
     [java]     pegarules.keyring
     [java] Jun 01, 2016 4:51:36 PM com.pega.pegarules.internal.bootstrap.PRBootstrap 
     [java] SEVERE: Problem during method invocation (main)
     [java] com.pega.pegarules.pub.PRRuntimeException: Error determining the mode of PRPC install from database.
     [java]     at com.pega.pegarules.data.internal.PRDataProviderImpl.isMultiTenantEnvironment(PRDataProviderImpl.java:1135)
     [java]     at com.pega.pegarules.data.internal.PRDataProviderImpl.getCacheContainerTenantInstance(PRDataProviderImpl.java:639)
     [java]     at com.pega.pegarules.data.internal.PRDataProviderImpl.enableCache(PRDataProviderImpl.java:577)
     [java]     at com.pega.pegarules.deploy.internal.util.ExposeCols.main(ExposeCols.java:517)
     [java]     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
     [java]     at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
     [java]     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
     [java]     at java.lang.reflect.Method.invoke(Method.java:498)
     [java]     at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethod(PRBootstrap.java:367)
     [java]     at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethodPropagatingThrowable(PRBootstrap.java:408)
     [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] Caused by: com.pega.pegarules.pub.database.BadDatabaseDefinitionException: Database-BadDBDef-Missing    pegadata
     [java] From: (unknown) 
     [java]     at com.pega.pegarules.data.internal.access.DataSourceManager.registerDatabase(DataSourceManager.java:127)
     [java]     at com.pega.pegarules.data.internal.access.DatabaseConfigurationImpl.<init>(DatabaseConfigurationImpl.java:589)
     [java]     at com.pega.pegarules.data.internal.access.ConnectionManagerImpl.<init>(ConnectionManagerImpl.java:601)
     [java]     at com.pega.pegarules.data.internal.access.ConnectionManagerImpl.getInstance(ConnectionManagerImpl.java:1391)
     [java]     at com.pega.pegarules.data.internal.PRDataProviderImpl.isMultiTenantEnvironment(PRDataProviderImpl.java:1120)
     [java]     ... 12 more
     [java] 
     [java] Jun 01, 2016 4:51:36 PM com.pega.pegarules.boot.internal.extbridge.AppServerBridgeToPega 
     [java] SEVERE: Problem during method invocation (main)
     [java] com.pega.pegarules.pub.PRRuntimeException: Error determining the mode of PRPC install from database.
     [java]     at com.pega.pegarules.data.internal.PRDataProviderImpl.isMultiTenantEnvironment(PRDataProviderImpl.java:1135)
     [java]     at com.pega.pegarules.data.internal.PRDataProviderImpl.getCacheContainerTenantInstance(PRDataProviderImpl.java:639)
     [java]     at com.pega.pegarules.data.internal.PRDataProviderImpl.enableCache(PRDataProviderImpl.java:577)
     [java]     at com.pega.pegarules.deploy.internal.util.ExposeCols.main(ExposeCols.java:517)
     [java]     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
     [java]     at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
     [java]     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
     [java]     at java.lang.reflect.Method.invoke(Method.java:498)
     [java]     at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethod(PRBootstrap.java:367)
     [java]     at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethodPropagatingThrowable(PRBootstrap.java:408)
     [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] Caused by: com.pega.pegarules.pub.database.BadDatabaseDefinitionException: Database-BadDBDef-Missing    pegadata
     [java] From: (unknown) 
     [java]     at com.pega.pegarules.data.internal.access.DataSourceManager.registerDatabase(DataSourceManager.java:127)
     [java]     at com.pega.pegarules.data.internal.access.DatabaseConfigurationImpl.<init>(DatabaseConfigurationImpl.java:589)
     [java]     at com.pega.pegarules.data.internal.access.ConnectionManagerImpl.<init>(ConnectionManagerImpl.java:601)
     [java]     at com.pega.pegarules.data.internal.access.ConnectionManagerImpl.getInstance(ConnectionManagerImpl.java:1391)
     [java]     at com.pega.pegarules.data.internal.PRDataProviderImpl.isMultiTenantEnvironment(PRDataProviderImpl.java:1120)
     [java]     ... 12 more
     [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: com.pega.pegarules.pub.PRRuntimeException: Error determining the mode of PRPC install from database.
     [java]     at com.pega.pegarules.data.internal.PRDataProviderImpl.isMultiTenantEnvironment(PRDataProviderImpl.java:1135)
     [java]     at com.pega.pegarules.data.internal.PRDataProviderImpl.getCacheContainerTenantInstance(PRDataProviderImpl.java:639)
     [java]     at com.pega.pegarules.data.internal.PRDataProviderImpl.enableCache(PRDataProviderImpl.java:577)
     [java]     at com.pega.pegarules.deploy.internal.util.ExposeCols.main(ExposeCols.java:517)
     [java]     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
     [java]     at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
     [java]     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
     [java]     at java.lang.reflect.Method.invoke(Method.java:498)
     [java]     at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethod(PRBootstrap.java:367)
     [java]     at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethodPropagatingThrowable(PRBootstrap.java:408)
     [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
     [java] Caused by: com.pega.pegarules.pub.database.BadDatabaseDefinitionException: Database-BadDBDef-Missing    pegadata
     [java] From: (unknown) 
     [java]     at com.pega.pegarules.data.internal.access.DataSourceManager.registerDatabase(DataSourceManager.java:127)
     [java]     at com.pega.pegarules.data.internal.access.DatabaseConfigurationImpl.<init>(DatabaseConfigurationImpl.java:589)
     [java]     at com.pega.pegarules.data.internal.access.ConnectionManagerImpl.<init>(ConnectionManagerImpl.java:601)
     [java]     at com.pega.pegarules.data.internal.access.ConnectionManagerImpl.getInstance(ConnectionManagerImpl.java:1391)
     [java]     at com.pega.pegarules.data.internal.PRDataProviderImpl.isMultiTenantEnvironment(PRDataProviderImpl.java:1120)
     [java]     ... 12 more
Exiting with Error

To see attachments, please log in.

Posted: 8 years ago
Posted: 4 Jun 2016 3:46 EDT
Divakaran Jeyaraj (DIVAKARJEY12)
IP australia
Pega Developer
IP australia
AU

The column populator runs on a different context altogether from PRPC. ensure that you have the right version of the Dbutil.jar file. Check the current Dbutil jar file being used by the system and copy the jar file to the location .

BadDatabase exceptions can occur due to multiple scenarios. First the datasource is not corrrectly specified or the SQL service is not available or it can be because its missing the right drivers in finding the DB.

If the issue is persisting you can try and restart the SQL service and try again

To see attachments, please log in.

Related content:

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice