on 06-08-2010 1:31 PM
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
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
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
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
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.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.