Question

27
Replies
4243
Views
David Ronne (PHILIPSRONNE)
Philips Corp

Philips Corp
US
PHILIPSRONNE Member since 2011 4 posts
Philips Corp
Posted: December 14, 2015
Last activity: December 30, 2015
Posted: 14 Dec 2015 17:44 EST
Last activity: 30 Dec 2015 15:35 EST
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...

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, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.