cancel
Showing results for 
Search instead for 
Did you mean: 

Unexpected error -9406

Former Member
0 Kudos

Trying to upgrade one our databases from 7.6 to 7.7 leads to the

following messages:

ERR-AUTOLOADSYSTAB

The database seems to be ok - it can be brought online, but the SYS schema is missing.

We tried load_systab on the console, but this leads to the message:

ERR

-24964,ERR_EXECUTE: error in program execution

3,"I:\Programme\sdb\7606\bin\sdbsysload" -R "I:\Programme\sdb\7606" -d ELLIPSO -u dba,*"

Installing tables for instances

Removing obsolete objects

ERROR:

-


Command----


DROP SCHEMA SYS

-


Error----


Unexpected error -9406

-


Any hint that could help is apprecciated.

Regards, Bernhard

P.S.: OS is Win32, but we also tried to set up a new database under Linux created from a backup of our database

and this ressults in the same errors during the upgrade.

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member229109
Active Contributor
0 Kudos

Hello Bernhard,

Are you SAP customer?

Please post additional information in the thread:

Run the following commands & update with output:

sdbregview u2013l

sdbregview u2013instancedata

dbmcli u2013d ELLIPSO u2013u <dbm-user>,<pwd>

<enter>

dbmcli on ELLIPSO>param_directget UseDDLTrigger

<enter>

dbmcli on ELLIPSO>exit

Thank you and best regards, Natalia Khlopina

Former Member
0 Kudos

Hallo Natalia,

it is not a Database for an SAP System.

>sdbregview -l

DB Analyzer             c:/programme/sdb/programs    7.7.07.16     32 bit    valid
Server Utilities        c:/programme/sdb/programs    7.7.07.16     32 bit    valid
WebSQL                  c:/programme/sdb/programs    7.7.07.16               valid
WebDAV Servlet          c:/programme/sdb/programs    7.7.07.16               valid
MaxDB ADO.NET Driver    c:/programme/sdb/programs    7.7.07.16     32 bit    valid
Redist Python           c:/programme/sdb/programs    7.7.07.16     32 bit    valid
Base                    c:/programme/sdb/programs    7.7.07.16     32 bit    valid
JDBC                    c:/programme/sdb/programs    7.6.06.05               valid
Messages                c:/programme/sdb/programs    MSG 0.8507              valid
ODBC                    c:/programme/sdb/programs    7.7.07.16     32 bit    valid
Database Kernel         c:/programme/sdb/7606        7.7.07.16     32 bit    valid
Loader                  c:/programme/sdb/programs    7.7.07.16     32 bit    valid
MaxDB PHP Driver        c:/programme/sdb/programs    7.7.07.16     32 bit    valid
SQLDBC                  c:/programme/sdb/programs    7.7.07.16     32 bit    valid

> sdbregview u2013instancedata

package "DB Analyzer":
----------------------


PACKAGE DIRECTORY:    c:/programme/sdb/programs
SOFTWARE VERSION:     7.7.07.16
PACKAGE VERSION:      0
VALID:                YES
MODE:                 32 bit
MODIFICATION DATE:    08.06.2010
REQUIRE:              Base >= 7.7.07.16
FILELIST:             YES
HAS DISPLAY NAME:     NO
SCRIPT:               YES
TEST FILE:            bin/dbanalyzer.exe
IS SUBPACKAGE:        NO
DBANALYZER PATH:      C:/Programme/SDB/programs





package "Server Utilities":
---------------------------

PACKAGE DIRECTORY:           c:/programme/sdb/programs
SOFTWARE VERSION:            7.7.07.16
PACKAGE VERSION:             0
VALID:                       YES
MODE:                        32 bit
MODIFICATION DATE:           08.06.2010
REQUIRE:                     Base >= 7.7.07.16
FILELIST:                    YES
HAS DISPLAY NAME:            NO
SCRIPT:                      YES
TEST FILE:                   bin/x_server.exe
IS SUBPACKAGE:               NO
INDEPENDENT PROGRAM PATH:    C:/Programme/SDB/programs





package "WebSQL":
-----------------


PACKAGE DIRECTORY:    c:/programme/sdb/programs
SOFTWARE VERSION:     7.7.07.16
PACKAGE VERSION:      0
VALID:                YES
MODIFICATION DATE:    08.06.2010
REQUIRE:              Base
FILELIST:             YES
HAS DISPLAY NAME:     NO
SCRIPT:               YES
TEST FILE:            NO
IS SUBPACKAGE:        NO
WEBSQL_J PATH:        C:/Programme/SDB/programs





package "WebDAV Servlet":
-------------------------


PACKAGE DIRECTORY:     c:/programme/sdb/programs
SOFTWARE VERSION:      7.7.07.16
PACKAGE VERSION:       0
VALID:                 YES
MODIFICATION DATE:     08.06.2010
REQUIRE:               JDBC
FILELIST:              YES
HAS DISPLAY NAME:      NO
SCRIPT:                YES
TEST FILE:             NO
IS SUBPACKAGE:         NO
WEBDAVSERVLET PATH:    C:/Programme/SDB/programs





package "MaxDB ADO.NET Driver":
-------------------------------


PACKAGE DIRECTORY:            c:/programme/sdb/programs
SOFTWARE VERSION:             7.7.07.16
PACKAGE VERSION:              0
VALID:                        YES
MODE:                         32 bit
MODIFICATION DATE:            08.06.2010
REQUIRE:                      Database Connectivity >= 7.7.07.16
FILELIST:                     YES
HAS DISPLAY NAME:             NO
SCRIPT:                       YES
TEST FILE:                    NO
IS SUBPACKAGE:                NO
MAXDB ADO.NET DRIVER PATH:    C:/Programme/SDB/programs





package "Redist Python":
------------------------


PACKAGE DIRECTORY:     c:/programme/sdb/programs
SOFTWARE VERSION:      7.7.07.16
PACKAGE VERSION:       0
VALID:                 YES
MODE:                  32 bit
MODIFICATION DATE:     08.06.2010
REQUIRE:               Base
FILELIST:              YES
HAS DISPLAY NAME:      NO
SCRIPT:                YES
TEST FILE:             bin/x_python.exe
IS SUBPACKAGE:         NO
REDIST PYTHON PATH:    C:/Programme/SDB/programs





package "Base":
---------------


PACKAGE DIRECTORY:           c:/programme/sdb/programs
SOFTWARE VERSION:            7.7.07.16
PACKAGE VERSION:             0
VALID:                       YES
MODE:                        32 bit
MODIFICATION DATE:           08.06.2010
REQUIRE:                    
FILELIST:                    YES
HAS DISPLAY NAME:            NO
SCRIPT:                      YES
TEST FILE:                   pgm/dbmcli.exe
IS SUBPACKAGE:               NO
INDEPENDENT DATA PATH:       D:/sdb/data
INDEPENDENT PROGRAM PATH:    C:/Programme/SDB/programs





package "JDBC":
---------------


PACKAGE DIRECTORY:    c:/programme/sdb/programs
SOFTWARE VERSION:     7.6.06.05
PACKAGE VERSION:      0
VALID:                YES
MODIFICATION DATE:    08.06.2010
REQUIRE:              Base
FILELIST:             YES
HAS DISPLAY NAME:     NO
SCRIPT:               YES
TEST FILE:            NO
IS SUBPACKAGE:        NO
JAVA DRIVER PATH:     C:/Programme/SDB/programs





package "Messages":
-------------------


PACKAGE DIRECTORY:    c:/programme/sdb/programs
SOFTWARE VERSION:     MSG 0.8507
PACKAGE VERSION:      0
VALID:                YES
MODIFICATION DATE:    08.06.2010
REQUIRE:              Base
FILELIST:             YES
HAS DISPLAY NAME:     NO
SCRIPT:               YES
TEST FILE:            NO
IS SUBPACKAGE:        NO
MESSAGES PATH:        C:/Programme/SDB/programs





package "ODBC":
---------------


PACKAGE DIRECTORY:    c:/programme/sdb/programs
SOFTWARE VERSION:     7.7.07.16
PACKAGE VERSION:      0
VALID:                YES
MODE:                 32 bit
MODIFICATION DATE:    08.06.2010
REQUIRE:              Base >= 7.7.07.16
FILELIST:             YES
HAS DISPLAY NAME:     NO
SCRIPT:               YES
TEST FILE:            pgm/sdbodbc.dll
IS SUBPACKAGE:        NO
ODBC PATH:            C:/Programme/SDB/programs





package "Database Kernel":
--------------------------


PACKAGE DIRECTORY:    c:/programme/sdb/7606
SOFTWARE VERSION:     7.7.07.16
PACKAGE VERSION:      0
VALID:                YES
MODE:                 32 bit
MODIFICATION DATE:    08.06.2010
REQUIRE:              Server Utilities >= 7.7.07.16
FILELIST:             YES
HAS DISPLAY NAME:     NO
SCRIPT:               YES
TEST FILE:            pgm/kernel.exe
IS SUBPACKAGE:        NO
DEPENDENT PATH:       c:/programme/sdb/7606





package "Loader":
-----------------


PACKAGE DIRECTORY:    c:/programme/sdb/programs
SOFTWARE VERSION:     7.7.07.16
PACKAGE VERSION:      0
VALID:                YES
MODE:                 32 bit
MODIFICATION DATE:    08.06.2010
REQUIRE:              Redist Python >= 7.7.07.16
FILELIST:             YES
HAS DISPLAY NAME:     NO
SCRIPT:               YES
TEST FILE:            bin/loadercli.exe
IS SUBPACKAGE:        NO
LOADER PATH:          C:/Programme/SDB/programs





package "MaxDB PHP Driver":
---------------------------


PACKAGE DIRECTORY:        c:/programme/sdb/programs
SOFTWARE VERSION:         7.7.07.16
PACKAGE VERSION:          0
VALID:                    YES
MODE:                     32 bit
MODIFICATION DATE:        08.06.2010
REQUIRE:                  Database Connectivity >= 7.7.07.16
FILELIST:                 YES
HAS DISPLAY NAME:         NO
SCRIPT:                   YES
TEST FILE:                NO
IS SUBPACKAGE:            NO
MAXDB PHP DRIVER PATH:    C:/Programme/SDB/programs





package "SQLDBC":
-----------------


PACKAGE DIRECTORY:    c:/programme/sdb/programs
SOFTWARE VERSION:     7.7.07.16
PACKAGE VERSION:      0
VALID:                YES
MODE:                 32 bit
MODIFICATION DATE:    08.06.2010
REQUIRE:              Base
FILELIST:             YES
HAS DISPLAY NAME:     YES
SCRIPT:               YES
TEST FILE:            pgm/libSQLDBC.dll
IS SUBPACKAGE:        NO
DBC PATH:             C:/Programme/SDB/programs

>param_directget UseDDLTrigger

UseDDLTrigger YES

former_member229109
Active Contributor
0 Kudos

Hello Bernhard,

1. Could you please run the following commands:

dbmcli u2013d ELLIPSO u2013u <dbm-user>,<pwd>

<enter>

dbmcli on ELLIPSO>param_directput UseLoadSystemTables NO

<enter>

dbmcli on ELLIPSO>param_checkall

<enter>

dbmcli on ELLIPSO>db_offline

<enter>

dbmcli on ELLIPSO>db_online

<enter>

dbmcli on ELLIPSO>load_systab

<enter>

dbmcli on ELLIPSO>exit

<enter>

And update with output.

2. Could you please run the following commands:

dbmcli u2013d ELLIPSO u2013u <dbm-user>,<pwd>

<enter>

dbmcli on ELLIPSO>sql_connect dba,<pwd>

<enter>

dbmcli on ELLIPSO>sql_execute select * from triggers where owner = 'SYS'

<enter>

u2026

And update with output.

3. What is the value of the parameter _UNICODE in the source database?

Did you load system tables after restore the databackup, before to run the database upgrade?

Thank you and best regards, Natalia Khlopina

Former Member
0 Kudos

Hello Natalia,

thanks for your fast answer.

Here are the results:

dbmcli on ELLIPSO>param_directput UseLoadSystemTables NO

OK

dbmcli on ELLIPSO>param_checkall

OK

dbmcli on ELLIPSO>db_offline

OK

dbmcli on ELLIPSO>db_online

OK

dbmcli on ELLIPSO>load_systab

ERR

-24964,ERR_EXECUTE: error in program execution

3,"I:\Programme\sdb\7606\bin\sdbsysload" -R "I:\Programme\sdb\7606" -d ELLIPSO -u dba,*"

Installing tables for instances

Removing obsolete objects

ERROR:

-


Command----


DROP SCHEMA SYS

-


Error----


Unexpected error -9406

-


dbmcli on ELLIPSO>sql_execute select * from triggers where owner = 'SYS'

ERR

-24988,ERR_SQL: SQL error

100,Row not found

dbmcli on ELLIPSO>param_directget _UNICODE

OK

_UNICODE YES

REMARK: We performed a 'db_migratecatalog' just a few days before we tried the upgrade.

Best regards,

Bernhard

former_member229109
Active Contributor
0 Kudos

Hello Bernhard,

1. Could you please run the following commands:

dbmcli u2013d ELLIPSO u2013u <dbm-user>,<pwd>

<enter>

dbmcli on ELLIPSO>sql_connect dba,<pwd>

<enter>

dbmcli on ELLIPSO>sql_execute select count(*) from triggers

u2026

And update with output.

2. I will discuss with database developers what will be the workaround for this issue & update the thread after that.

3. Please let me know if you could give us the databackup to reproduce the case on the local server.

What is the size of the databackup?

What is the version of the source release database? < 7.6.<patch ?>.<build ?> >

Thank you and best regards, Natalia Khlopina

former_member229109
Active Contributor
0 Kudos

Hello Bernhard,

The case was discussed with database developers.

As workaround to this issue, please, run the following steps::

dbmcli u2013d ELLIPSO u2013u <dbm-user>,<pwd>

<enter>

dbmcli on ELLIPSO>sql_connect dba,<pwd>

<enter>

dbmcli on ELLIPSO>sql_execute drop dbproc sysddltriggerpl

<enter>

dbmcli on ELLIPSO>sql_execute commit

<enter>

dbmcli on ELLIPSO>sql_release

<enter>

dbmcli on ELLIPSO>load_systab

<enter>

dbmcli on ELLIPSO>exit

If the loading system tables will be done successfully, please run<restart> the database upgrade to finish it.

< Check that output of u201Csdbregview u2013instancedatau201D will be empty after that >

Please update the thread with the results.

Thank you and best regards, Natalia Khlopina

Former Member
0 Kudos

Hello Natalia,

thanks for your answers.

We just discovered, that the problem only happens with versions:

7.6.06.03 => 7.7.06.09

(reproducable on windows and linux)

But everything works fine, if we use the new versions:

7.6.06.10 => 7.7.07.16

Regards, Bernhard

BTW:

You get the same error message if you omit the "load_systab"

after restoring the backup into the 7.6.06.10 - but if you call

this operation after the recovery everythings works fine with

the new versions.