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.