Hello... were upgrading from Worldserver 10.4.2 to 11.3.1 on a test server in preparation for the production server.

When upgrading from 11.2.0 to 11.3.0 we get an "integrity constraint" database error (Oracle) which we cannot resolve. Any ideas??

$ sqlplus idiom @WS-Upgrade-11.2.0-to-11.3.0.ora.sql

SQL*Plus: Release 11.2.0.3.0 Production on Thu Aug 23 16:25:26 2018

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

Enter password:

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

-->Start Upgrading Database from WS11.2.x to WS11.3.0 ...

PL/SQL procedure successfully completed.

Elapsed: 00:00:00.03

Procedure created.

Elapsed: 00:00:00.02

Procedure created.

Elapsed: 00:00:00.03

Procedure created.

Elapsed: 00:00:00.08

Procedure created.

Elapsed: 00:00:00.05

---->Removed "Delimited Text File Type (Deprecated)" filter.

DECLARE tcount INTEGER;

*

ERROR at line 1:

ORA-02292: integrity constraint (IDIOM.FILTERGROUPENTRYFKFILTERCONFIG) violated - child record found

ORA-06512: at line 15

Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

$