Question
MACIF
FR
Last activity: 23 Nov 2017 5:23 EST
prpcUtils import and databases structures (on version 7.2.2)
Hi,
I do meet a problem while trying to import a RAP with prpcUtils.sh tool.
Using the option in prpcUtils.properties :
- import.bypass.schema=false
Deployment fails on the following error :
Hi,
I do meet a problem while trying to import a RAP with prpcUtils.sh tool.
Using the option in prpcUtils.properties :
- import.bypass.schema=false
Deployment fails on the following error :
[java] 2017-11-22 10:01:56,869 [267.recette.macif.fr] [ STANDARD] [ ] (y.internal.PRRuleMgmtUtilsImpl) INFO - PRPC-GestionRelationClient-04-03-01_schema.jar is Schema Archive
[java] 2017-11-22 10:18:42,078 [267.recette.macif.fr] [ STANDARD] [ ] (ternal.util.SchemaImporterTool) ERROR - Encountered an issue applying DDL: CREATE TABLE OWGMGRCPDA.pr_data_admin ( "PXCREATEDATETIME" DATE
, "PXCREATEOPNAME" VARCHAR2 (128), "PXCREATEOPERATOR" VARCHAR2 (128), "PXCREATESYSTEMID" VARCHAR2 (32), "PXINSNAME" VARCHAR2 (385), "PXOBJCLASS" VARCHAR2 (96), "PXPRODUCTNAME" VARCHAR2 (32), "PXPRODUCTPATCHVERSION" VARCHAR2 (32), "PXPRO
DUCTVERSION" VARCHAR2 (32), "PXUPDATEDATETIME" DATE, "PXUPDATEOPNAME" VARCHAR2 (128), "PXUPDATEOPERATOR" VARCHAR2 (128), "PXUPDATESYSTEMID" VARCHAR2 (32), "PYACCESSGROUP" VARCHAR2 (64), "PYDEFAULTAPPNAME" VARCHAR2 (255), "PYDEFAULTAPPVE
RSION" VARCHAR2 (32), "PYLABEL" VARCHAR2 (64), "PYMANAGER" VARCHAR2 (128), "PYNAME" VARCHAR2 (32), "PYORGDIVISION" VARCHAR2 (32), "PYORGUNIT" VARCHAR2 (32), "PYORGANIZATION" VARCHAR2 (32), "PYPURPOSE" VARCHAR2 (256), "PYSYSTEMNAME" VARC
HAR2 (32), "PYOWNER" VARCHAR2 (128), "PYWORKBASKET" VARCHAR2 (128), "PYWORKGROUP" VARCHAR2 (64), "PYWORKGROUPNAME" VARCHAR2 (64), "PYWORKPOOL" VARCHAR2 (64), "PYSETTING" VARCHAR2 (4000), "PZINSKEY" VARCHAR2 (412) NOT NULL, "PZPVSTREAM"
BLOB, "REGION" VARCHAR2 (50), "CENTRE" VARCHAR2 (50), "TYPE" VARCHAR2 (50), "SOUSTYPE" VARCHAR2 (50), "CODEBUREAU" VARCHAR2 (50), "CODEPOSTAL" VARCHAR2 (20), "LIBELLEBUREAU" VARCHAR2 (50), "CODEEO" VARCHAR2 (20), "DATEFINVALIDITE" VARCH
AR2 (10), "GENERE" VARCHAR2 (20), "SERVICE" VARCHAR2 (20), "REPORTTO" VARCHAR2 (50), "TYPEBUREAUDWH" VARCHAR2 (50), "ELIGIBLERDV" VARCHAR2 (5), "PXCOMMITDATETIME" DATE, "PXSAVEDATETIME" DATE, "PYEXPIRATION" DATE, "PYRULESETNAME" VARCHAR
2 (64), "PYTIMESTAMP" DATE, "PYNODENAME" VARCHAR2 (64), "PXSYSTEMNAMESETFROMFILE" VARCHAR2 (5), "PYPORTAL" VARCHAR2 (64), "PYKEYSTORE" VARCHAR2 (96), "PYPROCESSORNAME" VARCHAR2 (96), "PYPROFILENAME" VARCHAR2 (96), "PYSERVICEPACKAGE" VARCHAR2 (64), "PYPOLICYPROFILENAME" VARCHAR2 (96), "PYWORKBASKETTYPE" VARCHAR2 (64), "PYMAXWORKBASKETSIZE" NUMBER (10, 0), "PYMAXEXECUTIONTIME" NUMBER (6, 0), "PYGRANTTYPE_1" VARCHAR2 (32), "PYAUTHENTICATIONSCHEME" VARCHAR2 (64), CONSTRAINT PR_DATA_ADMIN_PK PRIMARY KEY ("PZINSKEY") ) : Database-General Problem executing SQL to update database schema 955 42000 ORA-00955: ce nom d'objet existe déjà
[java]
[java] DatabaseException caused by prior exception: java.sql.SQLSyntaxErrorException: ORA-00955: ce nom d'objet existe déjà
[java]
[java] | SQL Code: 955 | SQL State: 42000
[java] -- See the log for additional information.
[java] com.pega.pegarules.pub.database.DatabaseException: Database-General Problem executing SQL to update database schema 955 42000 ORA-00955: ce nom d'objet existe déjà
[java]
[java] DatabaseException caused by prior exception: java.sql.SQLSyntaxErrorException: ORA-00955: ce nom d'objet existe déjà
Using the option import.nofailonerror=true does not permit to skip this error.
Is there a way to import databases structures and not to fail on error if objects exists ?
Regards.
Pegasystems Inc.
US
We can look into why bypass isn't working but the first question I have is why are you including a pega OOB table in your RAP file at all.
I would want to see the complete log file from prpcUtils but there are 2 issues. The first issue is why is import wizard not recognizing that the pr_data_admin table exists which is probably related to the database user who is running prpcUtils not having he privileges needed to get the metadata of objects in the data and rules schemas. I believe that even if you choose to bypass making schema changes the import wizard will still go through the synchronization to know what schema changes are needed. The second issue is why does it try to create the table again if you have selected bypass.
MACIF
FR
Here is attached the complete log file.
The database user who is running prpcUtils is the same for data and rules schemas and does have full privileges on the database.
If I chose to bypass making schema changed I encounter further problems when tables does not exist.
The second issue would rather be that if I select to bypass it does not try to create existing tables again but it does not try to create non exisiting objects either...
Regards.
Pegasystems Inc.
US
I actually read the problem description incorrectly. You have set this to false and thus you are not trying to bypass making schema changes.
import.bypass.schema=false
So I still want to understand why you are including a pega OOB table in your RAP file but the ultimate issue is with regards to privileges. Does the database user who is running prpcUtils have Select_Catalog_Role? This is an Oracle OOB privilege which allows the user to view the catalog and thus metadata of all of the schemas in the database. Without this privilege the user is not able to find the metadata of the pr_data_admin table and thus assumes it doesn't exists and tries to create it.
MACIF
FR
Concerning the pega OOB table in the RAP file I do not know, this is how the dev team delivers it.
And as for the privileges on oracle schemas, I asked ou dba team and am waiting for an answer.
Regards
MACIF
FR
Hi,
Database user does have SELECT_CATALOG_ROLE.
Do we need to create synonyms as we have multiple schemas (I would say no as requests seems to be prefixed vith schema name) ?
Regards.