Discussion

3
Replies
1252
Views
JaySetty9999 Member since 2014 1 post
Amerigroup
Posted: 4 years ago
Last activity: 3 years 10 months ago
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

Moderation Team has archived post
Share this page LinkedIn