Question

27
Replies
4100
Views
PHILIPSRONNE Member since 2011 4 posts
Philips Corp
Posted: 4 years ago
Last activity: 4 years 10 months ago
Closed
Solved

how to use prpcUtils.sh importPegaArchive with split schema

We are using Pega 7.1.7 with split schema

I am trying to set up command line deployment using prpcUtils importPegaArchive

Our split schema is divided into pegadat and pegasys

<pegarules>

        <!-- This is a minimum format prconfig.xml file.  Only the settings which are required to access settings in the database are included.

        All other settings which were formerly located only in this file are now Data-Admin-System-Settings.      -->

        <env name="initialization/settingsource" value="merged" />

        <env name="database/databases/PegaRULES/dataSource" value="java:comp/env/jdbc/PegaRULES"/>

        <env name="database/databases/PegaDATA/dataSource" value="java:comp/env/jdbc/PegaRULES"/>

we have a connection string for Pega:

jdbc:oracle:thin:@(DESCRIPTION= (LOAD_BALANCE=ON) (FAILOVER=ON) (ADDRESS_LIST= (ADDRESS=(PROTOCOL = TCP)(HOST = qasolodbl5-v5)(PORT = 1531)) (ADDRESS=(PROTOCOL = TCP)(HOST = qasolodbl6-v6)(PORT = 1531))) (CONNECT_DATA=(SERVICE_NAME=monusql_svc)(SERVER=DEDICATED) (FAILOVER_MODE=(TYPE=SELECT)(METHOD=basic))))

that uses a pegaapp user to login.

I am using pegaapp in my connection to import a Pega Archive but i'm getiting table or view does not exist.

Executing prpcUtils.sh ant script...

/fs01/apps1/products/prpc_7.1.7/scripts/utils/prpcUtils.sh importPegaArchive --driverClass oracle.jdbc.OracleDriver --driverJAR /fs01/apps1/pega/jdbc/ojdbc7.jar --dbType oracledate --dbURL jdbc:oracle:thin:@//devsolracl5:1531/monusdl_svc --dbUser pegaapp --dbPassword XXXXXX --archivePath /fs01/apps1/pega/temp/StaticContent/global/ServiceExport/ECareFW_03_01_78.jar

_findSystemName:

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

Unable to execute sql query:

        select max(s.pySystemName) from PEGAAPP.pr_data_admin s inner join PEGAAPP.pr_data_admin r    on s.pySystemName = r.pySystemName    where s.pxobjclass = 'Data-Admin-System' and r.pxObjClass = 'Data-Admin-Requestor': ORA-00942: table or view does not exist

Which user should i be using with a split schema???

Thanks in advance

Data Integration
Moderation Team has archived post
Share this page LinkedIn