cancel
Showing results for 
Search instead for 
Did you mean: 

error in dd activation by sapkb70015, do i need need a great ocs-queue?

Former Member
0 Kudos

hello friends,

my compnents:

sm51

n4shost_N4S_01 n4shost Dialog Batch Update Spool Enqueue ICM VMC J2EE aktiv

SAP-Kernel : 700_REL

Datenbank Client Library : SQLDBC 7.6.3.014 CL 170762

hergestellt auf : Linux GNU SLES-9 x86_64 cc3.3.3

Kernel Patchnummer : 133

ICU Version : 3.0 Unicode Version 4.0.1

libsapu16 Version : 1.0025 Oct 19 2007 20:32:00

maxdb:

Kernel 7.6.03 Build 014-123-170-762

DBMServer 7.6.03 Build 014-123-170-762

SAP_ABA 700 0014 SAPKA70014 Anwendungsübergreifende Komponente Appl. Interface SP

SAP_BASIS 700 0014 SAPKB70014 SAP Basiskomponente Basis Support Pack.

PI_BASIS 2006_1_700 0004 SAPKIPYM04 Basis Plug-In (PI_BASIS) 2006_1_700 Kompon. Supp. Pack.

SAP_BW 700 0016 SAPKW70016 SAP NetWeaver BI 7.0 Kompon. Supp. Pack.

BI_CONT 703 0008 SAPKIBIIP8 Business Intelligence Content Kompon. Supp. Pack.

j2ee/jspm : Stack sp15 without umeadmin and caf.

st22:

Laufzeitfehler DBIF_DSQL2_SQL_ERROR

Ausnahme CX_SY_NATIVE_SQL_ERROR

Datum und Zeit 06.04.2008 17:32:45

Der Fehler "-4005" ist auf der aktuellen Datenbankverbindung "DEFAULT"

aufgetreten.

Fehlertext der Datenbank...: "POS(8) Unknown column name:VIRTUALKEY"

Fehlercode der Datenbank...: "-4005"

Auslösende SQL-Anweisung...: "SELECT VIRTUALKEY FROM DOMAIN.TABLES WHERE OWNER

= USER AND TABLENAME = ? "

Interne Aufrufcodierung....: "[DBDS/NEW DSQL]"

Bitte die Einträge im SAP-Systemlog auswerten (Transaktion SM21).

Falls der Fehler in einem nicht modifizierten SAP-Programm vorkommt

findet sich vielleicht eine Vorablösung im SAP-Hinweissystem.

Falls Sie selbst Zugang zum SAP-Hinweissystem haben, so suchen Sie

bitte zunächst mit folgenden Schlagworten:

"DBIF_DSQL2_SQL_ERROR" "CX_SY_NATIVE_SQL_ERROR"

"SDB1FADA" bzw. "SDB1FADA"

"TAB_WITHOUT_VIRTUAL_KEY"

OSS Hint : Hinweis 1017520 - SQL-Fehler -4005 bei der Indexaktivierung gives no solution

SM21:

12:45:48 DIA 002 000 DDIC BY 2 Datenbankfehler -4005 beim OPC aufgetreten

12:45:49 DIA 002 000 DDIC BY 0 > POS(8) Unknown column name:VIRTUALKEY

12:45:55 DIA 002 000 DDIC AB 0 Laufzeitfehler "DBIF_DSQL2_SQL_ERROR" aufgetreten.

12:45:59 DIA 002 000 DDIC AB 1 > Kurzdump "080406 124556 n4shost_ N4S_01 " erstellt.

do i have a index problem on db?

thanks for any ideas...

christoph

Accepted Solutions (1)

Accepted Solutions (1)

former_member229109
Active Contributor
0 Kudos

Hello Christoph,

-> You posted that you have on your system::

SAP_BASIS 700 0014 SAPKB70014 SAP Basiskomponente Basis Support Pack.

< therefore the SAP Note No. 1017520 is applied >

==> Were the SPs updated successfully or you are in the update process?

-> You posted that you have on your system::

maxdb: Kernel 7.6.03 Build 014-123-170-762

=> Did you run the database upgrade recently? Did you have problems during the database

upgrade? Were the system tables loaded during the upgrade?

-> What activity you was running, when the reported Dump occurred?

Did you already create the SAP OSS ticket, where this issue is reported?

Thank you and best regards, Natalia Khlopina

Former Member
0 Kudos

hello helena,

nice shot. "load_sys_tab" was the golden goal ;-). many thanks. i finished the import2, an the job "OCS_QUEUE_IMPORT" runs in background. i have stopped the instances with stopsapr3, dbmgui with "load_sys_tab" then i start the sap-instances with startsap r3, then spam in phase import1. thats is the right way for tomorrow on other system (windows). SAP Note No. 1017520 is obsolet, i stood in phase sapkb70014 to sapkb70015.

note 1017520 is for sapkb70010/11.

10 points for this nice quick hint.

after the db-upgrade runs "load_sys_tab" automatically in script, i wonder why this is not impacted.

p.s.

"OCS_QUEUE_IMPORT" runs now 900 seconds ...

nice evening and see you,

christoph

Edited by: Christoph Kautz on Apr 7, 2008 9:07 PM

Answers (0)