Upgrade from 15.4 to 16.7.25 on Oracle Database

Hello everyone!!

I´m having a lot of problems upgrading eB. While doing upgrade from 15.4 to 15.6 everything was OK, but during the execution of the scripts from 15.6 to 16.7.25 I´m getting a lot of errors. I managed to solve some of the errors but some not, and I´m stuck. Next I left to you some of the errors:

Problem 1

Using Oracle Console I was able to get the SQL script that was producing this error:

ALTER TABLE documents MODIFY( template NCHAR(1) DEFAULT(N'N') );

The problem was that Oracle automatically created and Index for performance on that column (Template), and when the script tried to change it the error appeard.

I solved this problem droppping the Index, but I had to restore the backup of the original 15.6 database make the fix discovered and run the upgrade again.

 

Problem 2

It seems that the scripts are trying to enable a constraint, but the column of that constraint has null values. This time I cannot get ths script runnig with Oracle Console, so I don´t know which table/column has null values. Then I clicked on “YES”.

 

Problem 3

After restoring the 15.6 database and applying all the fixes to solve many problems discovered durign the upgrade, I ran the upgrade again. The upgrade run for many hours, and I left it running on some scripts that verifies the files on the repository (I know this beacause I capture ths script running using Oracle Console), then I went to sleep. The next morning I found an error stating that wanted to create an Index and that Index already existed. So if the Index already exist there is no problem, so I clicked on "Yes" to continue the upgrade process, immediately I got this error: 

This error happend to me many times during various upgrade attempts.

It seems that this error occurs after a long period of time after an error window appears, and after some hours later a user click on “Yes” on that window to continue with the process. Opposite the other errors, this error is really complicated beacuse our database has more tan 1.8 million documents and many of the upgrade scripts take a lot of time to execute, so it is imposible to watch the progress of the upgrade all time and be pending of every error that shows to quickly press some button.

I need help with this last error most, because I cant´t upgrade in this conditions.

Thanks in advance.

Parents
  • I have more info to add....In problem 2 the complete error in the log is this:

    Upgrade/1645_numerics.sql line 113, Execution time: 00:01:17.5754697
    Upgrade/1651_consolidate_db_schema.sql line 64, Error: ORA-02296: cannot enable (EB16CHACOUSR.) - null values found
    ORA-06512: at line 14
    Error while processing line 64 in the file 'Core.16.5.1.Oracle.zip/Upgrade/1651_consolidate_db_schema.sql'.
    ORA-02296: cannot enable (EB16CHACOUSR.) - null values found
    ORA-06512: at line 14

    I need to know which is the table/column involved so I can solve the null values.

  • HI Ezequiel,

    There is a known issue with Oracle Upgrade scripts described in this Wiki: https://communities.bentley.com/products/assetwise/assetwise_platform/w/eb_internal_wiki/37108/database-upgrade-extremely-slow-on-oracle-for-upgrade-step-15-6-1-to-16-1-1

    I have uploaded the file mentioned in the wiki to this link: https://bentley.sharefile.com/d-s8669d4213f943dba . Just download and replace the existing file in DB upgrade scripts folder.

    I am not sure this is the root cause of the upgrade issues you are getting, but from my experience with other Oracle upgrades using the modified script zip file addresses a lot of the upgrade process errors. Can you please use the attached, rerun your upgrade and let us know? After doing the above, if you still are getting errors please share the upgrade logs with us.

    Also, after replacing the zip , one test I always try is to disable the options that stops the upgrade on each step or on errors and let upgrade run all the way from 15.6.1 to version you are upgrading to. That will get you a full upgrade with all errors. In some cases errors can be ignored because later scripts might have addressed the issue reported in earlier versions.

                                          

    Address: Bentley | 10052 Mesa Ridge Court Suite
    100 | San Diego | CA | 92121 | USA



  • Thanks Roberto!!

    I will try and I´ll let you know....

  • I have managed to complete the update !! Everything on the SMC looks good, no errors on storage or any other service.

    But when entering in Director, right after login I got this error, and I can´t get in.

    Could you help me please? I don´t know what to do here.

  • Hi Ezequiel,

    I think I know what is causing this. Do you have ebweb configured? if you can login with ebweb you should be able to fix this with steps below.

    It is related to an Oracle-Only setting in eB General system preferences to Use "LINGUISTIC COMPARE" in Oracle . it can be Fixed  with following steps:

     

    1. Login to eBweb as ADMIN.

    2. Go to your System preferences (under the “Show System Reports” icon)

    3. Under topic “General” , turn off the “Linguistic Compare” box

    4. Save the settings

    5. Log out from web, then try login in from Director

    Let me know if this works for you.

                                          

    Address: Bentley | 10052 Mesa Ridge Court Suite
    100 | San Diego | CA | 92121 | USA



    Answer Verified By: Ezequiel Kohan 

  • More info to add....

    Attached is the upgrade LOG.

    #***********************************************************************************
    # Database update log
    # Application Server Version : 16.7.25.5 Release
    # Database Name : eb16chacousr
    # Database Server Name : orcl
    # DBMS Name : Oracle 11g
    # DBMS Version : 11.2.0.4.0
    #***********************************************************************************
    #***********************************************************************************
    # Package name : Core
    #
    # Date : Friday, October 23, 2020
    # Time : 11:03:20 AM
    #
    # Current Core Database Version : 15.6.1
    # New Core Database Version : 16.1.1
    # Package file : C:\Program Files\Bentley\eB\Server\Database\Core.16.1.1.Oracle.zip
    #**********************************************************************************
    
    Database Server name sucessfully updated.
    
    
    Package version information successfully updated.
    
    
    ** Database update step 1 / 48 completed with 0 errors and 0 warnings.
    
    #***********************************************************************************
    # Package name : Core
    #
    # Date : Friday, October 23, 2020
    # Time : 11:23:52 AM
    #
    # Current Core Database Version : 16.1.1
    # New Core Database Version : 16.2.1
    # Package file : C:\Program Files\Bentley\eB\Server\Database\Core.16.2.1.Oracle.zip
    #**********************************************************************************
    
    
    Package version information successfully updated.
    
    
    ** Database update step 2 / 48 completed with 0 errors and 0 warnings.
    
    #***********************************************************************************
    # Package name : Core
    #
    # Date : Friday, October 23, 2020
    # Time : 11:23:56 AM
    #
    # Current Core Database Version : 16.2.1
    # New Core Database Version : 16.3.1
    # Package file : C:\Program Files\Bentley\eB\Server\Database\Core.16.3.1.Oracle.zip
    #**********************************************************************************
    
    Upgrade/1631_char_to_nchar1.sql line 3063,	Execution time: 00:26:21.0041273
    
    Package version information successfully updated.
    
    
    ** Database update step 3 / 48 completed with 0 errors and 0 warnings.
    
    #***********************************************************************************
    # Package name : Core
    #
    # Date : Friday, October 23, 2020
    # Time : 11:50:39 AM
    #
    # Current Core Database Version : 16.3.1
    # New Core Database Version : 16.4.1
    # Package file : C:\Program Files\Bentley\eB\Server\Database\Core.16.4.1.Oracle.zip
    #**********************************************************************************
    
    
    Package version information successfully updated.
    
    
    ** Database update step 4 / 48 completed with 0 errors and 0 warnings.
    
    #***********************************************************************************
    # Package name : Core
    #
    # Date : Friday, October 23, 2020
    # Time : 11:50:50 AM
    #
    # Current Core Database Version : 16.4.1
    # New Core Database Version : 16.4.2
    # Package file : C:\Program Files\Bentley\eB\Server\Database\Core.16.4.2.Oracle.zip
    #**********************************************************************************
    
    
    Package version information successfully updated.
    
    
    ** Database update step 5 / 48 completed with 0 errors and 0 warnings.
    
    #***********************************************************************************
    # Package name : Core
    #
    # Date : Friday, October 23, 2020
    # Time : 11:51:41 AM
    #
    # Current Core Database Version : 16.4.2
    # New Core Database Version : 16.5.1
    # Package file : C:\Program Files\Bentley\eB\Server\Database\Core.16.5.1.Oracle.zip
    #**********************************************************************************
    
    Upgrade/1645_numerics.sql line 113,	Execution time: 00:01:17.5754697
    Upgrade/1651_consolidate_db_schema.sql line 64,	Error: ORA-02296: cannot enable (EB16CHACOUSR.) - null values found
    ORA-06512: at line 14
    Error while processing line 64 in the file 'Core.16.5.1.Oracle.zip/Upgrade/1651_consolidate_db_schema.sql'.
    ORA-02296: cannot enable (EB16CHACOUSR.) - null values found
    ORA-06512: at line 14
    
    Package version information successfully updated.
    
    
    ** Database update step 6 / 48 completed with 1 error(s) .
    
    #***********************************************************************************
    # Package name : Core
    #
    # Date : Friday, October 23, 2020
    # Time : 11:54:00 AM
    #
    # Current Core Database Version : 16.5.1
    # New Core Database Version : 16.6.1
    # Package file : C:\Program Files\Bentley\eB\Server\Database\Core.16.6.1.Oracle.zip
    #**********************************************************************************
    
    Upgrade/revalidate_files.sql line 23,	Execution time: 14:21:47.9070408
    Tables/_performance_indexes.sql line 3708,	Error: ORA-01408: such column list already indexed
    ORA-06512: at line 461
    Error while processing line 3708 in the file 'Core.16.6.1.Oracle.zip/Tables/_performance_indexes.sql'.
    ORA-01408: such column list already indexed
    ORA-06512: at line 461
    
    Package version information successfully updated.
    
    
    ** Database update step 7 / 48 completed with 1 error(s) .
    
    #***********************************************************************************
    # Package name : Core
    #
    # Date : Saturday, October 24, 2020
    # Time : 2:16:41 AM
    #
    # Current Core Database Version : 16.6.1
    # New Core Database Version : 16.6.2
    # Package file : C:\Program Files\Bentley\eB\Server\Database\Core.16.6.2.Oracle.zip
    #**********************************************************************************
    
    Tables/_performance_indexes.sql line 3702,	Error: ORA-01408: such column list already indexed
    ORA-06512: at line 461
    Error while processing line 3702 in the file 'Core.16.6.2.Oracle.zip/Tables/_performance_indexes.sql'.
    ORA-01408: such column list already indexed
    ORA-06512: at line 461
    
    Package version information successfully updated.
    
    
    ** Database update step 8 / 48 completed with 1 error(s) .
    
    #***********************************************************************************
    # Package name : Core
    #
    # Date : Saturday, October 24, 2020
    # Time : 2:17:21 AM
    #
    # Current Core Database Version : 16.6.2
    # New Core Database Version : 16.6.3
    # Package file : C:\Program Files\Bentley\eB\Server\Database\Core.16.6.3.Oracle.zip
    #**********************************************************************************
    
    Tables/_performance_indexes.sql line 3702,	Error: ORA-01408: such column list already indexed
    ORA-06512: at line 461
    Error while processing line 3702 in the file 'Core.16.6.3.Oracle.zip/Tables/_performance_indexes.sql'.
    ORA-01408: such column list already indexed
    ORA-06512: at line 461
    
    Package version information successfully updated.
    
    
    ** Database update step 9 / 48 completed with 1 error(s) .
    
    #***********************************************************************************
    # Package name : Core
    #
    # Date : Saturday, October 24, 2020
    # Time : 2:17:58 AM
    #
    # Current Core Database Version : 16.6.3
    # New Core Database Version : 16.6.4
    # Package file : C:\Program Files\Bentley\eB\Server\Database\Core.16.6.4.Oracle.zip
    #**********************************************************************************
    
    Tables/_performance_indexes.sql line 3702,	Error: ORA-01408: such column list already indexed
    ORA-06512: at line 461
    Error while processing line 3702 in the file 'Core.16.6.4.Oracle.zip/Tables/_performance_indexes.sql'.
    ORA-01408: such column list already indexed
    ORA-06512: at line 461
    
    Package version information successfully updated.
    
    
    ** Database update step 10 / 48 completed with 1 error(s) .
    
    #***********************************************************************************
    # Package name : Core
    #
    # Date : Saturday, October 24, 2020
    # Time : 2:18:34 AM
    #
    # Current Core Database Version : 16.6.4
    # New Core Database Version : 16.6.5
    # Package file : C:\Program Files\Bentley\eB\Server\Database\Core.16.6.5.Oracle.zip
    #**********************************************************************************
    
    Tables/_performance_indexes.sql line 3702,	Error: ORA-01408: such column list already indexed
    ORA-06512: at line 461
    Error while processing line 3702 in the file 'Core.16.6.5.Oracle.zip/Tables/_performance_indexes.sql'.
    ORA-01408: such column list already indexed
    ORA-06512: at line 461
    
    Package version information successfully updated.
    
    
    ** Database update step 11 / 48 completed with 1 error(s) .
    
    #***********************************************************************************
    # Package name : Core
    #
    # Date : Saturday, October 24, 2020
    # Time : 2:19:11 AM
    #
    # Current Core Database Version : 16.6.5
    # New Core Database Version : 16.6.6
    # Package file : C:\Program Files\Bentley\eB\Server\Database\Core.16.6.6.Oracle.zip
    #**********************************************************************************
    
    Tables/_performance_indexes.sql line 3828,	Error: ORA-01408: such column list already indexed
    ORA-06512: at line 461
    Error while processing line 3828 in the file 'Core.16.6.6.Oracle.zip/Tables/_performance_indexes.sql'.
    ORA-01408: such column list already indexed
    ORA-06512: at line 461
    
    Package version information successfully updated.
    
    
    ** Database update step 12 / 48 completed with 1 error(s) .
    
    #***********************************************************************************
    # Package name : Core
    #
    # Date : Saturday, October 24, 2020
    # Time : 2:19:52 AM
    #
    # Current Core Database Version : 16.6.6
    # New Core Database Version : 16.6.7
    # Package file : C:\Program Files\Bentley\eB\Server\Database\Core.16.6.7.Oracle.zip
    #**********************************************************************************
    
    Tables/_performance_indexes.sql line 3015,	Error: ORA-01408: such column list already indexed
    ORA-06512: at line 454
    Error while processing line 3015 in the file 'Core.16.6.7.Oracle.zip/Tables/_performance_indexes.sql'.
    ORA-01408: such column list already indexed
    ORA-06512: at line 454
    
    Package version information successfully updated.
    
    
    ** Database update step 13 / 48 completed with 1 error(s) .
    
    #***********************************************************************************
    # Package name : Core
    #
    # Date : Saturday, October 24, 2020
    # Time : 2:20:29 AM
    #
    # Current Core Database Version : 16.6.7
    # New Core Database Version : 16.6.8
    # Package file : C:\Program Files\Bentley\eB\Server\Database\Core.16.6.8.Oracle.zip
    #**********************************************************************************
    
    Tables/_performance_indexes.sql line 3885,	Error: ORA-01408: such column list already indexed
    ORA-06512: at line 466
    Error while processing line 3885 in the file 'Core.16.6.8.Oracle.zip/Tables/_performance_indexes.sql'.
    ORA-01408: such column list already indexed
    ORA-06512: at line 466
    
    Package version information successfully updated.
    
    
    ** Database update step 14 / 48 completed with 1 error(s) .
    
    #***********************************************************************************
    # Package name : Core
    #
    # Date : Saturday, October 24, 2020
    # Time : 2:21:08 AM
    #
    # Current Core Database Version : 16.6.8
    # New Core Database Version : 16.6.9
    # Package file : C:\Program Files\Bentley\eB\Server\Database\Core.16.6.9.Oracle.zip
    #**********************************************************************************
    
    Tables/_performance_indexes.sql line 3885,	Error: ORA-01408: such column list already indexed
    ORA-06512: at line 466
    Error while processing line 3885 in the file 'Core.16.6.9.Oracle.zip/Tables/_performance_indexes.sql'.
    ORA-01408: such column list already indexed
    ORA-06512: at line 466
    
    Package version information successfully updated.
    
    
    ** Database update step 15 / 48 completed with 1 error(s) .
    
    #***********************************************************************************
    # Package name : Core
    #
    # Date : Saturday, October 24, 2020
    # Time : 2:21:49 AM
    #
    # Current Core Database Version : 16.6.9
    # New Core Database Version : 16.6.10
    # Package file : C:\Program Files\Bentley\eB\Server\Database\Core.16.6.10.Oracle.zip
    #**********************************************************************************
    
    Tables/_performance_indexes.sql line 3902,	Error: ORA-01408: such column list already indexed
    ORA-06512: at line 466
    Error while processing line 3902 in the file 'Core.16.6.10.Oracle.zip/Tables/_performance_indexes.sql'.
    ORA-01408: such column list already indexed
    ORA-06512: at line 466
    
    Package version information successfully updated.
    
    
    ** Database update step 16 / 48 completed with 1 error(s) .
    
    #***********************************************************************************
    # Package name : Core
    #
    # Date : Saturday, October 24, 2020
    # Time : 2:22:38 AM
    #
    # Current Core Database Version : 16.6.10
    # New Core Database Version : 16.6.11
    # Package file : C:\Program Files\Bentley\eB\Server\Database\Core.16.6.11.Oracle.zip
    #**********************************************************************************
    
    Tables/_performance_indexes.sql line 3902,	Error: ORA-01408: such column list already indexed
    ORA-06512: at line 466
    Error while processing line 3902 in the file 'Core.16.6.11.Oracle.zip/Tables/_performance_indexes.sql'.
    ORA-01408: such column list already indexed
    ORA-06512: at line 466
    
    Package version information successfully updated.
    
    
    ** Database update step 17 / 48 completed with 1 error(s) .
    
    #***********************************************************************************
    # Package name : Core
    #
    # Date : Saturday, October 24, 2020
    # Time : 2:23:17 AM
    #
    # Current Core Database Version : 16.6.11
    # New Core Database Version : 16.6.12
    # Package file : C:\Program Files\Bentley\eB\Server\Database\Core.16.6.12.Oracle.zip
    #**********************************************************************************
    
    Tables/_performance_indexes.sql line 3918,	Error: ORA-01408: such column list already indexed
    ORA-06512: at line 466
    Error while processing line 3918 in the file 'Core.16.6.12.Oracle.zip/Tables/_performance_indexes.sql'.
    ORA-01408: such column list already indexed
    ORA-06512: at line 466
    
    Package version information successfully updated.
    
    
    ** Database update step 18 / 48 completed with 1 error(s) .
    
    #***********************************************************************************
    # Package name : Core
    #
    # Date : Saturday, October 24, 2020
    # Time : 2:23:55 AM
    #
    # Current Core Database Version : 16.6.12
    # New Core Database Version : 16.6.13
    # Package file : C:\Program Files\Bentley\eB\Server\Database\Core.16.6.13.Oracle.zip
    #**********************************************************************************
    
    Tables/_performance_indexes.sql line 3918,	Error: ORA-01408: such column list already indexed
    ORA-06512: at line 466
    Error while processing line 3918 in the file 'Core.16.6.13.Oracle.zip/Tables/_performance_indexes.sql'.
    ORA-01408: such column list already indexed
    ORA-06512: at line 466
    
    Package version information successfully updated.
    
    
    ** Database update step 19 / 48 completed with 1 error(s) .
    
    #***********************************************************************************
    # Package name : Core
    #
    # Date : Saturday, October 24, 2020
    # Time : 2:24:33 AM
    #
    # Current Core Database Version : 16.6.13
    # New Core Database Version : 16.6.14
    # Package file : C:\Program Files\Bentley\eB\Server\Database\Core.16.6.14.Oracle.zip
    #**********************************************************************************
    
    Tables/_performance_indexes.sql line 3936,	Error: ORA-01408: such column list already indexed
    ORA-06512: at line 466
    Error while processing line 3936 in the file 'Core.16.6.14.Oracle.zip/Tables/_performance_indexes.sql'.
    ORA-01408: such column list already indexed
    ORA-06512: at line 466
    
    Package version information successfully updated.
    
    
    ** Database update step 20 / 48 completed with 1 error(s) .
    
    #***********************************************************************************
    # Package name : Core
    #
    # Date : Saturday, October 24, 2020
    # Time : 2:25:32 AM
    #
    # Current Core Database Version : 16.6.14
    # New Core Database Version : 16.6.16
    # Package file : C:\Program Files\Bentley\eB\Server\Database\Core.16.6.16.Oracle.zip
    #**********************************************************************************
    
    Tables/_performance_indexes.sql line 3978,	Error: ORA-01408: such column list already indexed
    ORA-06512: at line 466
    Error while processing line 3978 in the file 'Core.16.6.16.Oracle.zip/Tables/_performance_indexes.sql'.
    ORA-01408: such column list already indexed
    ORA-06512: at line 466
    
    Package version information successfully updated.
    
    
    ** Database update step 21 / 48 completed with 1 error(s) .
    
    #***********************************************************************************
    # Package name : Core
    #
    # Date : Saturday, October 24, 2020
    # Time : 2:26:10 AM
    #
    # Current Core Database Version : 16.6.16
    # New Core Database Version : 16.6.17
    # Package file : C:\Program Files\Bentley\eB\Server\Database\Core.16.6.17.Oracle.zip
    #**********************************************************************************
    
    Tables/_performance_indexes.sql line 3978,	Error: ORA-01408: such column list already indexed
    ORA-06512: at line 466
    Error while processing line 3978 in the file 'Core.16.6.17.Oracle.zip/Tables/_performance_indexes.sql'.
    ORA-01408: such column list already indexed
    ORA-06512: at line 466
    
    Package version information successfully updated.
    
    
    ** Database update step 22 / 48 completed with 1 error(s) .
    
    #***********************************************************************************
    # Package name : Core
    #
    # Date : Saturday, October 24, 2020
    # Time : 2:26:48 AM
    #
    # Current Core Database Version : 16.6.17
    # New Core Database Version : 16.6.19
    # Package file : C:\Program Files\Bentley\eB\Server\Database\Core.16.6.19.Oracle.zip
    #**********************************************************************************
    
    Tables/_performance_indexes.sql line 3978,	Error: ORA-01408: such column list already indexed
    ORA-06512: at line 466
    Error while processing line 3978 in the file 'Core.16.6.19.Oracle.zip/Tables/_performance_indexes.sql'.
    ORA-01408: such column list already indexed
    ORA-06512: at line 466
    
    Package version information successfully updated.
    
    
    ** Database update step 23 / 48 completed with 1 error(s) .
    
    #***********************************************************************************
    # Package name : Core
    #
    # Date : Saturday, October 24, 2020
    # Time : 2:27:26 AM
    #
    # Current Core Database Version : 16.6.19
    # New Core Database Version : 16.6.22
    # Package file : C:\Program Files\Bentley\eB\Server\Database\Core.16.6.22.Oracle.zip
    #**********************************************************************************
    
    Tables/_performance_indexes.sql line 3984,	Error: ORA-01408: such column list already indexed
    ORA-06512: at line 466
    Error while processing line 3984 in the file 'Core.16.6.22.Oracle.zip/Tables/_performance_indexes.sql'.
    ORA-01408: such column list already indexed
    ORA-06512: at line 466
    
    Package version information successfully updated.
    
    
    ** Database update step 24 / 48 completed with 1 error(s) .
    
    #***********************************************************************************
    # Package name : Core
    #
    # Date : Saturday, October 24, 2020
    # Time : 2:28:06 AM
    #
    # Current Core Database Version : 16.6.22
    # New Core Database Version : 16.7.2
    # Package file : C:\Program Files\Bentley\eB\Server\Database\Core.16.7.2.Oracle.zip
    #**********************************************************************************
    
    Tables/_performance_indexes.sql line 3984,	Error: ORA-01408: such column list already indexed
    ORA-06512: at line 466
    Error while processing line 3984 in the file 'Core.16.7.2.Oracle.zip/Tables/_performance_indexes.sql'.
    ORA-01408: such column list already indexed
    ORA-06512: at line 466
    
    Package version information successfully updated.
    
    
    ** Database update step 25 / 48 completed with 1 error(s) .
    
    #***********************************************************************************
    # Package name : Core
    #
    # Date : Saturday, October 24, 2020
    # Time : 2:28:45 AM
    #
    # Current Core Database Version : 16.7.2
    # New Core Database Version : 16.7.3
    # Package file : C:\Program Files\Bentley\eB\Server\Database\Core.16.7.3.Oracle.zip
    #**********************************************************************************
    
    Tables/_performance_indexes.sql line 3984,	Error: ORA-01408: such column list already indexed
    ORA-06512: at line 466
    Error while processing line 3984 in the file 'Core.16.7.3.Oracle.zip/Tables/_performance_indexes.sql'.
    ORA-01408: such column list already indexed
    ORA-06512: at line 466
    
    Package version information successfully updated.
    
    
    ** Database update step 26 / 48 completed with 1 error(s) .
    
    #***********************************************************************************
    # Package name : Core
    #
    # Date : Saturday, October 24, 2020
    # Time : 2:29:25 AM
    #
    # Current Core Database Version : 16.7.3
    # New Core Database Version : 16.7.4
    # Package file : C:\Program Files\Bentley\eB\Server\Database\Core.16.7.4.Oracle.zip
    #**********************************************************************************
    
    Tables/_performance_indexes.sql line 3984,	Error: ORA-01408: such column list already indexed
    ORA-06512: at line 466
    Error while processing line 3984 in the file 'Core.16.7.4.Oracle.zip/Tables/_performance_indexes.sql'.
    ORA-01408: such column list already indexed
    ORA-06512: at line 466
    
    Package version information successfully updated.
    
    
    ** Database update step 27 / 48 completed with 1 error(s) .
    
    #***********************************************************************************
    # Package name : Core
    #
    # Date : Saturday, October 24, 2020
    # Time : 2:30:05 AM
    #
    # Current Core Database Version : 16.7.4
    # New Core Database Version : 16.7.5
    # Package file : C:\Program Files\Bentley\eB\Server\Database\Core.16.7.5.Oracle.zip
    #**********************************************************************************
    
    Tables/_performance_indexes.sql line 4009,	Error: ORA-01408: such column list already indexed
    ORA-06512: at line 466
    Error while processing line 4009 in the file 'Core.16.7.5.Oracle.zip/Tables/_performance_indexes.sql'.
    ORA-01408: such column list already indexed
    ORA-06512: at line 466
    
    Package version information successfully updated.
    
    
    ** Database update step 28 / 48 completed with 1 error(s) .
    
    #***********************************************************************************
    # Package name : Core
    #
    # Date : Saturday, October 24, 2020
    # Time : 2:30:45 AM
    #
    # Current Core Database Version : 16.7.5
    # New Core Database Version : 16.7.6
    # Package file : C:\Program Files\Bentley\eB\Server\Database\Core.16.7.6.Oracle.zip
    #**********************************************************************************
    
    Tables/_performance_indexes.sql line 4021,	Error: ORA-01408: such column list already indexed
    ORA-06512: at line 466
    Error while processing line 4021 in the file 'Core.16.7.6.Oracle.zip/Tables/_performance_indexes.sql'.
    ORA-01408: such column list already indexed
    ORA-06512: at line 466
    
    Package version information successfully updated.
    
    
    ** Database update step 29 / 48 completed with 1 error(s) .
    
    #***********************************************************************************
    # Package name : Core
    #
    # Date : Saturday, October 24, 2020
    # Time : 2:31:24 AM
    #
    # Current Core Database Version : 16.7.6
    # New Core Database Version : 16.7.7
    # Package file : C:\Program Files\Bentley\eB\Server\Database\Core.16.7.7.Oracle.zip
    #**********************************************************************************
    
    Tables/_performance_indexes.sql line 4021,	Error: ORA-01408: such column list already indexed
    ORA-06512: at line 466
    Error while processing line 4021 in the file 'Core.16.7.7.Oracle.zip/Tables/_performance_indexes.sql'.
    ORA-01408: such column list already indexed
    ORA-06512: at line 466
    
    Package version information successfully updated.
    
    
    ** Database update step 30 / 48 completed with 1 error(s) .
    
    #***********************************************************************************
    # Package name : Core
    #
    # Date : Saturday, October 24, 2020
    # Time : 2:32:02 AM
    #
    # Current Core Database Version : 16.7.7
    # New Core Database Version : 16.7.8
    # Package file : C:\Program Files\Bentley\eB\Server\Database\Core.16.7.8.Oracle.zip
    #**********************************************************************************
    
    Tables/_performance_indexes.sql line 4021,	Error: ORA-01408: such column list already indexed
    ORA-06512: at line 466
    Error while processing line 4021 in the file 'Core.16.7.8.Oracle.zip/Tables/_performance_indexes.sql'.
    ORA-01408: such column list already indexed
    ORA-06512: at line 466
    
    Package version information successfully updated.
    
    
    ** Database update step 31 / 48 completed with 1 error(s) .
    
    #***********************************************************************************
    # Package name : Core
    #
    # Date : Saturday, October 24, 2020
    # Time : 2:32:42 AM
    #
    # Current Core Database Version : 16.7.8
    # New Core Database Version : 16.7.9
    # Package file : C:\Program Files\Bentley\eB\Server\Database\Core.16.7.9.Oracle.zip
    #**********************************************************************************
    
    Tables/_performance_indexes.sql line 4021,	Error: ORA-01408: such column list already indexed
    ORA-06512: at line 466
    Error while processing line 4021 in the file 'Core.16.7.9.Oracle.zip/Tables/_performance_indexes.sql'.
    ORA-01408: such column list already indexed
    ORA-06512: at line 466
    
    Package version information successfully updated.
    
    
    ** Database update step 32 / 48 completed with 1 error(s) .
    
    #***********************************************************************************
    # Package name : Core
    #
    # Date : Saturday, October 24, 2020
    # Time : 2:33:21 AM
    #
    # Current Core Database Version : 16.7.9
    # New Core Database Version : 16.7.10
    # Package file : C:\Program Files\Bentley\eB\Server\Database\Core.16.7.10.Oracle.zip
    #**********************************************************************************
    
    Tables/_performance_indexes.sql line 4045,	Error: ORA-01408: such column list already indexed
    ORA-06512: at line 466
    Error while processing line 4045 in the file 'Core.16.7.10.Oracle.zip/Tables/_performance_indexes.sql'.
    ORA-01408: such column list already indexed
    ORA-06512: at line 466
    
    Package version information successfully updated.
    
    
    ** Database update step 33 / 48 completed with 1 error(s) .
    
    #***********************************************************************************
    # Package name : Core
    #
    # Date : Saturday, October 24, 2020
    # Time : 2:34:01 AM
    #
    # Current Core Database Version : 16.7.10
    # New Core Database Version : 16.7.11
    # Package file : C:\Program Files\Bentley\eB\Server\Database\Core.16.7.11.Oracle.zip
    #**********************************************************************************
    
    Upgrade/16711_external_attribute_definition_namespaces.sql line 30,	Error: ORA-00955: name is already used by an existing object
    ORA-06512: at line 21
    Error while processing line 30 in the file 'Core.16.7.11.Oracle.zip/Upgrade/16711_external_attribute_definition_namespaces.sql'.
    ORA-00955: name is already used by an existing object
    ORA-06512: at line 21
    Tables/_performance_indexes.sql line 4045,	Error: ORA-01408: such column list already indexed
    ORA-06512: at line 466
    Error while processing line 4045 in the file 'Core.16.7.11.Oracle.zip/Tables/_performance_indexes.sql'.
    ORA-01408: such column list already indexed
    ORA-06512: at line 466
    
    Package version information successfully updated.
    
    
    ** Database update step 34 / 48 completed with 2 error(s) .
    
    #***********************************************************************************
    # Package name : Core
    #
    # Date : Saturday, October 24, 2020
    # Time : 2:34:42 AM
    #
    # Current Core Database Version : 16.7.11
    # New Core Database Version : 16.7.12
    # Package file : C:\Program Files\Bentley\eB\Server\Database\Core.16.7.12.Oracle.zip
    #**********************************************************************************
    
    Tables/_performance_indexes.sql line 4045,	Error: ORA-01408: such column list already indexed
    ORA-06512: at line 466
    Error while processing line 4045 in the file 'Core.16.7.12.Oracle.zip/Tables/_performance_indexes.sql'.
    ORA-01408: such column list already indexed
    ORA-06512: at line 466
    
    Package version information successfully updated.
    
    
    ** Database update step 35 / 48 completed with 1 error(s) .
    
    #***********************************************************************************
    # Package name : Core
    #
    # Date : Saturday, October 24, 2020
    # Time : 2:35:20 AM
    #
    # Current Core Database Version : 16.7.12
    # New Core Database Version : 16.7.13
    # Package file : C:\Program Files\Bentley\eB\Server\Database\Core.16.7.13.Oracle.zip
    #**********************************************************************************
    
    Tables/_performance_indexes.sql line 4045,	Error: ORA-01408: such column list already indexed
    ORA-06512: at line 466
    Error while processing line 4045 in the file 'Core.16.7.13.Oracle.zip/Tables/_performance_indexes.sql'.
    ORA-01408: such column list already indexed
    ORA-06512: at line 466
    
    Package version information successfully updated.
    
    
    ** Database update step 36 / 48 completed with 1 error(s) .
    
    #***********************************************************************************
    # Package name : Core
    #
    # Date : Saturday, October 24, 2020
    # Time : 2:35:58 AM
    #
    # Current Core Database Version : 16.7.13
    # New Core Database Version : 16.7.14
    # Package file : C:\Program Files\Bentley\eB\Server\Database\Core.16.7.14.Oracle.zip
    #**********************************************************************************
    
    Upgrade/16714_task_orders.sql line 276,	Warning: ORA-14452: attempt to create, alter or drop an index on temporary table already in use
    ORA-06512: at "EB16CHACOUSR.EBPS_DROP", line 47
    ORA-06512: at line 4
    Upgrade/16714_task_orders.sql line 374,	Warning: ORA-14452: attempt to create, alter or drop an index on temporary table already in use
    ORA-06512: at "EB16CHACOUSR.EBPS_DROP", line 47
    ORA-06512: at line 5
    Tables/_performance_indexes.sql line 4057,	Error: ORA-01408: such column list already indexed
    ORA-06512: at line 466
    Error while processing line 4057 in the file 'Core.16.7.14.Oracle.zip/Tables/_performance_indexes.sql'.
    ORA-01408: such column list already indexed
    ORA-06512: at line 466
    
    Package version information successfully updated.
    
    
    ** Database update step 37 / 48 completed with 1 error(s)  and 2 warning(s).
    
    #***********************************************************************************
    # Package name : Core
    #
    # Date : Saturday, October 24, 2020
    # Time : 2:36:39 AM
    #
    # Current Core Database Version : 16.7.14
    # New Core Database Version : 16.7.15
    # Package file : C:\Program Files\Bentley\eB\Server\Database\Core.16.7.15.Oracle.zip
    #**********************************************************************************
    
    Tables/_performance_indexes.sql line 4057,	Error: ORA-01408: such column list already indexed
    ORA-06512: at line 466
    Error while processing line 4057 in the file 'Core.16.7.15.Oracle.zip/Tables/_performance_indexes.sql'.
    ORA-01408: such column list already indexed
    ORA-06512: at line 466
    
    Package version information successfully updated.
    
    
    ** Database update step 38 / 48 completed with 1 error(s) .
    
    #***********************************************************************************
    # Package name : Core
    #
    # Date : Saturday, October 24, 2020
    # Time : 2:37:16 AM
    #
    # Current Core Database Version : 16.7.15
    # New Core Database Version : 16.7.16
    # Package file : C:\Program Files\Bentley\eB\Server\Database\Core.16.7.16.Oracle.zip
    #**********************************************************************************
    
    Tables/_performance_indexes.sql line 4057,	Error: ORA-01408: such column list already indexed
    ORA-06512: at line 466
    Error while processing line 4057 in the file 'Core.16.7.16.Oracle.zip/Tables/_performance_indexes.sql'.
    ORA-01408: such column list already indexed
    ORA-06512: at line 466
    
    Package version information successfully updated.
    
    
    ** Database update step 39 / 48 completed with 1 error(s) .
    
    #***********************************************************************************
    # Package name : Core
    #
    # Date : Saturday, October 24, 2020
    # Time : 2:37:54 AM
    #
    # Current Core Database Version : 16.7.16
    # New Core Database Version : 16.7.17
    # Package file : C:\Program Files\Bentley\eB\Server\Database\Core.16.7.17.Oracle.zip
    #**********************************************************************************
    
    Tables/_performance_indexes.sql line 4063,	Error: ORA-01408: such column list already indexed
    ORA-06512: at line 466
    Error while processing line 4063 in the file 'Core.16.7.17.Oracle.zip/Tables/_performance_indexes.sql'.
    ORA-01408: such column list already indexed
    ORA-06512: at line 466
    
    Package version information successfully updated.
    
    
    ** Database update step 40 / 48 completed with 1 error(s) .
    
    #***********************************************************************************
    # Package name : Core
    #
    # Date : Saturday, October 24, 2020
    # Time : 2:38:33 AM
    #
    # Current Core Database Version : 16.7.17
    # New Core Database Version : 16.7.18
    # Package file : C:\Program Files\Bentley\eB\Server\Database\Core.16.7.18.Oracle.zip
    #**********************************************************************************
    
    Tables/_performance_indexes.sql line 4075,	Error: ORA-01408: such column list already indexed
    ORA-06512: at line 466
    Error while processing line 4075 in the file 'Core.16.7.18.Oracle.zip/Tables/_performance_indexes.sql'.
    ORA-01408: such column list already indexed
    ORA-06512: at line 466
    
    Package version information successfully updated.
    
    
    ** Database update step 41 / 48 completed with 1 error(s) .
    
    #***********************************************************************************
    # Package name : Core
    #
    # Date : Saturday, October 24, 2020
    # Time : 2:39:11 AM
    #
    # Current Core Database Version : 16.7.18
    # New Core Database Version : 16.7.19
    # Package file : C:\Program Files\Bentley\eB\Server\Database\Core.16.7.19.Oracle.zip
    #**********************************************************************************
    
    Tables/_performance_indexes.sql line 4075,	Error: ORA-01408: such column list already indexed
    ORA-06512: at line 466
    Error while processing line 4075 in the file 'Core.16.7.19.Oracle.zip/Tables/_performance_indexes.sql'.
    ORA-01408: such column list already indexed
    ORA-06512: at line 466
    
    Package version information successfully updated.
    
    
    ** Database update step 42 / 48 completed with 1 error(s) .
    
    #***********************************************************************************
    # Package name : Core
    #
    # Date : Saturday, October 24, 2020
    # Time : 2:39:48 AM
    #
    # Current Core Database Version : 16.7.19
    # New Core Database Version : 16.7.20
    # Package file : C:\Program Files\Bentley\eB\Server\Database\Core.16.7.20.Oracle.zip
    #**********************************************************************************
    
    Tables/_performance_indexes.sql line 4075,	Error: ORA-01408: such column list already indexed
    ORA-06512: at line 466
    Error while processing line 4075 in the file 'Core.16.7.20.Oracle.zip/Tables/_performance_indexes.sql'.
    ORA-01408: such column list already indexed
    ORA-06512: at line 466
    
    Package version information successfully updated.
    
    
    ** Database update step 43 / 48 completed with 1 error(s) .
    
    #***********************************************************************************
    # Package name : Core
    #
    # Date : Saturday, October 24, 2020
    # Time : 2:40:25 AM
    #
    # Current Core Database Version : 16.7.20
    # New Core Database Version : 16.7.21
    # Package file : C:\Program Files\Bentley\eB\Server\Database\Core.16.7.21.Oracle.zip
    #**********************************************************************************
    
    Tables/_performance_indexes.sql line 4087,	Error: ORA-01408: such column list already indexed
    ORA-06512: at line 466
    Error while processing line 4087 in the file 'Core.16.7.21.Oracle.zip/Tables/_performance_indexes.sql'.
    ORA-01408: such column list already indexed
    ORA-06512: at line 466
    
    Package version information successfully updated.
    
    
    ** Database update step 44 / 48 completed with 1 error(s) .
    
    #***********************************************************************************
    # Package name : Core
    #
    # Date : Saturday, October 24, 2020
    # Time : 2:41:09 AM
    #
    # Current Core Database Version : 16.7.21
    # New Core Database Version : 16.7.22
    # Package file : C:\Program Files\Bentley\eB\Server\Database\Core.16.7.22.Oracle.zip
    #**********************************************************************************
    
    Tables/_performance_indexes.sql line 4087,	Error: ORA-01408: such column list already indexed
    ORA-06512: at line 466
    Error while processing line 4087 in the file 'Core.16.7.22.Oracle.zip/Tables/_performance_indexes.sql'.
    ORA-01408: such column list already indexed
    ORA-06512: at line 466
    
    Package version information successfully updated.
    
    
    ** Database update step 45 / 48 completed with 1 error(s) .
    
    #***********************************************************************************
    # Package name : Core
    #
    # Date : Saturday, October 24, 2020
    # Time : 2:41:47 AM
    #
    # Current Core Database Version : 16.7.22
    # New Core Database Version : 16.7.23
    # Package file : C:\Program Files\Bentley\eB\Server\Database\Core.16.7.23.Oracle.zip
    #**********************************************************************************
    
    Tables/_performance_indexes.sql line 4087,	Error: ORA-01408: such column list already indexed
    ORA-06512: at line 466
    Error while processing line 4087 in the file 'Core.16.7.23.Oracle.zip/Tables/_performance_indexes.sql'.
    ORA-01408: such column list already indexed
    ORA-06512: at line 466
    
    Package version information successfully updated.
    
    
    ** Database update step 46 / 48 completed with 1 error(s) .
    
    #***********************************************************************************
    # Package name : Core
    #
    # Date : Saturday, October 24, 2020
    # Time : 2:42:25 AM
    #
    # Current Core Database Version : 16.7.23
    # New Core Database Version : 16.7.24
    # Package file : C:\Program Files\Bentley\eB\Server\Database\Core.16.7.24.Oracle.zip
    #**********************************************************************************
    
    Tables/_performance_indexes.sql line 4087,	Error: ORA-01408: such column list already indexed
    ORA-06512: at line 466
    Error while processing line 4087 in the file 'Core.16.7.24.Oracle.zip/Tables/_performance_indexes.sql'.
    ORA-01408: such column list already indexed
    ORA-06512: at line 466
    
    Package version information successfully updated.
    
    
    ** Database update step 47 / 48 completed with 1 error(s) .
    
    #***********************************************************************************
    # Package name : Core
    #
    # Date : Saturday, October 24, 2020
    # Time : 2:43:02 AM
    #
    # Current Core Database Version : 16.7.24
    # New Core Database Version : 16.7.25
    # Package file : C:\Program Files\Bentley\eB\Server\Database\Core.16.7.25.Oracle.zip
    #**********************************************************************************
    
    Tables/_performance_indexes.sql line 4087,	Error: ORA-01408: such column list already indexed
    ORA-06512: at line 466
    Error while processing line 4087 in the file 'Core.16.7.25.Oracle.zip/Tables/_performance_indexes.sql'.
    ORA-01408: such column list already indexed
    ORA-06512: at line 466
    Populate/interop_methods.sql line 125,	Execution time: 00:01:34.7212301
    Upgrade/check_uppercase_indexes.sql line 20,	Execution time: 00:10:16.2884291
    Errors encountered.
    Invalid objects from an unknown package or a package not yet executed:
    	DCP_FULLPROCESS_PRY
    	DCP_RELGVI_PRY
    	DCVFOLLOWUP
    	EBFSP_ANCESTORS
    	EBFSP_DESCENDANTS
    	EBPHPW_ONOBJECTCHECKEDIN
    	EBPHPW_ONOBJECTCHECKEDOUT
    	EBPHPW_ONOBJECTDELETED
    	EBPHPW_ONOBJECTDELETING
    	EBPHSP_ONATTRIBUTECHANGED
    	EBPHSP_ONCANCELCHECKOUT
    	EBPHSP_ONOBJECTADDED
    	EBPHSP_ONOBJECTCHANGED
    	EBPHSP_ONOBJECTCHECKEDIN
    	EBPHSP_ONOBJECTCHECKEDOUT
    	EBPHSP_ONOBJECTDELETING
    	EBPPW_ADD_OBJECT
    	EBPPW_ADD_QUEUE_JOB
    	EBPPW_DEL_OBJECT
    	EBPPW_FVF_EB_EVENTS
    	EBPPW_FVF_PW_EVENTS
    	EBPPW_ISSUE_SYNCHRONIZATION
    	EBPPW_REFERENCE_UPDATED
    	EBPPW_REGISTER_OBJECT
    	EBPSP_ADD_SHAREPOINT_ITEM
    	EBPSP_ADD_SHAREPOINT_JOB
    	EBPSP_CHG_SHAREPOINT_ITEM
    	EBPSP_COMPLETE_PROVISION
    	EBPSP_COPY_SHAREPOINT_ITEM
    	EBPSP_DEL_SHAREPOINT_ITEM
    	EBPSP_EXCLUDE_SHAREPOINT_ITEM
    	EBPSP_GET_SHAREPOINT
    	EBPSP_PROVISION_OBJECT
    	EBPSP_REFERENCE_UPDATED
    	EBPSP_SHAREPOINT_BEGIN_SYNC
    	EBPSP_SHAREPOINT_END_SYNC
    	EBPSP_SHAREPOINT_FVF_EB_EVENTS
    	EBPSP_SHAREPOINT_FVF_SP_EVENTS
    	EBPSP_SHAREPOINT_LINK_OBJECT
    	EBPSP_SHAREPOINT_MOVE_OBJECT
    	VW_ACCESO_ARCHIVOS
    41 object(s) were found to be invalid. Please review the log file for detailed information....There are 31 more invalid objects...
    
    Database system information successfully updated.
    
    
    User information successfully updated.
    
    
    User information successfully updated.
    
    
    Reports recompiled successfully.
    
    
    Storage device configuration information successfully updated.
    
    
    Attribute lookup datasources successfully updated.
    
    
    Package version information successfully updated.
    
    
    ** Database update step 48 / 48 completed with 42 error(s) .
    
    ** Database update completed with 86 error(s) and 2 warning(s).
    
    ** Log file closed on Saturday, October 24, 2020 at 2:59:08 AM
    

  • Thanks!!!

    That was it!!! I think the upgrade success completely.

    Have a good day.

Reply Children
No Data