Question

5
Replies
183
Views
peyrussien Member since 2012 1 post
MACIF
Posted: 2 years ago
Last activity: 2 years 11 months ago
Closed

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 :

[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.

DevOps Low-Code App Development Installation and Deployment
Moderation Team has archived post
Share this page LinkedIn