Question

5
Replies
190
Views
peyrussie nicolas (peyrussien)
MACIF

MACIF
FR
peyrussien Member since 2012 1 post
MACIF
Posted: November 22, 2017
Last activity: November 23, 2017
Posted: 22 Nov 2017 5:27 EST
Last activity: 23 Nov 2017 5:23 EST
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 System Administration Installation and Deployment
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.