Hello,
we are middle in the preparations of an new HCM landscape. Starting with: ECC5.0SR1 (640_EX2 Kernel), Windows2008R2 and now MaxDB7.8 (to get the data from the "old" System). The installation was done with MaxDB7.6, and migrated from Version 7.6 -> 7.7 -> 7.8. At the end will be an ECC6.06 System.
To use several transactions, like DB02 and DB50, we needed to patched it to Basis Level 28 (incl. corresponding ABA Packages, SPAM of course was updated too). Everything was fine until finished spam phase DDIC Activation. After that the import stopps in Phase IMPORT_PROPER, we got several ST22 dumps (DBIF_DSQL2_SQL_ERROR, Exception: CX_SY_NATIVE_SQL_ERROR, 3x Minute) and in the trc-file of the WPs this info (for more details, see attached files):
C *** ERROR => prepare() of C_0173, rc=1, rcSQL=-4030 (POS(168) Unknown schema:SYS)
[dbsdbsql.cpp 1627]
C *** ERROR => PREPARE on connection 0, rc=-4030 (POS(168) Unknown schema:SYS)
[dbdssdb.cpp 1911]
C sc_p=0000000007FB1688,no=173,idc_p=0000000000000000,con=0,act=0,slen=351,smax=512,#vars=1,stmt=000000002AF62000,table= DOMAIN.COLUMNS
C SELECT COL.COLUMNNAME, COL.MODE, TAB.NULLABLE, COL.DATATYPE, COL.CODETYPE, COL.LEN, COL.DEC, NVL ( C\
C OL.DEFAULT, 'NULL' ), COL.POS, COL.KEYPOS FROM DOMAIN.COLUMNS COL, SYS.ALL_TAB_COLUMNS TAB WHERE COL\
C .OWNER = USER AND COL.TABLENAME = ? AND COL.OWNER = TAB.OWNER AND COL.TABLENAME = TAB.TABLE_NAME AN\
C D COL.COLUMNNAME = TAB.COLUMN_NAME ORDER BY COL.POS;
C *** ERROR => dbdssdb: SQL Error -4030, Message: POS(168) Unknown schema:SYS
[dbdssdb.cpp 2403]
B ***LOG BY2=> sql error -4030 performing OPC [dbds#4 @ 486] [dbds 0486 ]
B ***LOG BY0=> POS(168) Unknown schema:SYS [dbds#4 @ 486] [dbds 0486 ]
A TH VERBOSE LEVEL FULL
A ** RABAX: level LEV_RX_PXA_RELEASE_MTX entered.
A ** RABAX: level LEV_RX_PXA_RELEASE_MTX completed.
A ** RABAX: level LEV_RX_VMIT_CLEANUP entered.
A ** RABAX: level LEV_RX_VMIT_CLEANUP completed.
A ** RABAX: level LEV_RX_SAVE_SHMLOCKS entered.
A ** RABAX: level LEV_RX_SAVE_SHMLOCKS completed.
We already checked the table DOMAIN.SCHEMAS, and it's true: Schema SYS not there? Any Idea what the reason is?
Thanks in advance!
Kind regards,
Benita Alonso