2 Replies Latest reply on Jan 25, 2016 6:09 AM by David Miller

    DBMS error when upgrading geodatabase from 9.3.1SP1 to 10SP2

    Francisco Javier Solís

      Hi everyone,

       

      we are facing a upgrading project from ArcFM 9.3.1 SP1 to ArcFM 10.

      We have replicated production environment in virtual machines and we are performing the migration in such site.

      First step is to upgrade ArcSDE from 9.3.1 SP1 to 10 SP2. But we have following error executing Upgrade Geodatabase Tool from ArcCatalog:

       

      ....

      Finished checking prerequisites.

      ArcSDE server tables and stored procedures are up to date.

      Underlying DBMS error [Layer not found] [Error executing PL/SQL Block db_stgeom_create_indexORA-29855: se ha producido un error en la ejecución de la rutina ODCIINDEXCREATE

      ORA-06502: PL/SQL: error : error de conversión de carácter a número numérico o de valor]

      Underlying DBMS error [Error executing PL/SQL Block db_stgeom_create_indexORA-29855: se ha producido un error en la ejecución de la rutina ODCIINDEXCREATE

      ORA-06502: PL/SQL: error : error de conversión de carácter a número numérico o de valor]

      Unpaused the database.

      Failed to execute (UpgradeGDB).

       

      It complains  about a numeric conversion, but I don't have any clue about where the problem can be.

      Geodatabase is compressed and no versions are present. sdegdbrepair have been executed already.

       

      Oracle version is: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0

      Previous ArcGIS version are:

      * ArcGIS Desktop 9.3.1 Service Pack1

      * ArcGIS ArcSDE for Oracle10g 9.3.1 Service Pack 1

       

      Intended ArcGIS version is:

      * ArcGIS Desktop 10 Service Pack 2

       

      ArcSDE 10 is not installed yet, because upgrading of database must be performed by direct connection.

       

      Where or how can I find more detailed trace or error log?

      Have you got any clue about the problem?

       

      Thank you for your support.