ECC 6.0 installation o WIndows 2003 Ent R2 on SQL 2005

[Former Member]

Hello Folks,

As mentioned in subject line, I am in middle of the installation. I have got error in phase "Run ABAP Reports".

The error is mentioned in the file dev_slic file which I have pasted below. It is not able to drop an index to create a temporary lisense.

"Cannot drop the index 'MLICHECK.MLICHECK0', because it does not exist or you do not have permission."

Till the time I have already opened ticket with SAP.

Here is the dev_slic file -

---

>

-

---

trc file: "dev_slic", trc level: 2, release: "700"

-

---

SlicIGetDate: <20080413>

SlicPwForR3Setup: calc password out of <RPD20080413FJAWFNLTL>

SlicIGetDate: <20080413>

SlicSapInstall: sysname: >RPD< connect: >1< rollback: >1<

SlicIDbLock: first call to SlicIDbLock: initialize Mutex

db_con_init called

create_con (con_name=R/3)

Loading DB library 'dbmssslib.dll' ...

load shared library (dbmssslib.dll), hdl 0

using "D:\usr\sap\RPD\SYS\exe\uc\NTI386\dbmssslib.dll"

Library 'dbmssslib.dll' loaded

function DbSlExpFuns loaded from library dbmssslib.dll

Version of 'dbmssslib.dll' is "700.08", patchlevel (0.72)

function dsql_db_init loaded from library dbmssslib.dll

function dbdd_exp_funs loaded from library dbmssslib.dll

New connection 0 created

0: name = R/3, con_id = -000000001 state = DISCONNECTED, perm = YES, reco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO

db_con_connect (con_name=R/3)

find_con_by_name found the following connection for reuse:

0: name = R/3, con_id = 000000000 state = DISCONNECTED, perm = YES, reco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO

Thread ID:1884

Thank You for using the SLOLEDB-interface

Using dynamic link library 'D:\usr\sap\RPD\SYS\exe\uc\NTI386\dbmssslib.dll'

dbmssslib.dll patch info

patchlevel 0

patchno 72

patchcomment MSSQL: Thread check in DbSlDisconnect (969143)

np:(local) connection used on RPDSERV

CopyLocalParameters: dbuser is 'rpd'

Using Provider SQLNCLI

OpenOledbConnection: MARS property was set successfully.

Provider Release:9.00.3042.00

Using Provider SQLNCLI

OpenOledbConnection: MARS property was set successfully.

Cache sizes: header 68 bytes, 100 names (157600 bytes), 100 dynamic statements (568800 bytes), total 726468 bytes

Initializing private procedure name cache.

procedure cache created/attached

Connected to db server : [RPDSERV] server_used : [np:(local)], dbname: RPD, dbuser: rpd

pn_id:RPDSERV_RPDRPD_RPD

Using MARS (on sql 9.0)

Connection 0 opened (DBSL handle 0)

ExecuteAndFlush return code: 0x80040e37 Stmt: [DROP INDEX MLICHECK.MLICHECK0 ]

ExecuteAndFlush: line 6324. hr: 0x80040e37 Cannot drop the index 'MLICHECK.MLICHECK0', because it does not exist or you do not have permission.

sloledb.cpp [ExecuteAndFlush,line 6324]: Error/Message: (err 3701, sev 11), Cannot drop the index 'MLICHECK.MLICHECK0', because it does not exist or you do not have permission.

Procname: [ExecuteAndFlush - no proc]

DbSlExecute - Error 103 (dbcode 3701) on DDLExecute

DbSlExecute - <DROP INDEX MLICHECK.MLICHECK0 >

License index MLICHECK0 not found( - ok)

ExecuteAndFlush return code: 0x80040e37 Stmt: [DROP INDEX MLICHECK.MLICHECK__0 ]

ExecuteAndFlush: line 6324. hr: 0x80040e37 Cannot drop the index 'MLICHECK.MLICHECK__0', because it does not exist or you do not have permission.

sloledb.cpp [ExecuteAndFlush,line 6324]: Error/Message: (err 3701, sev 11), Cannot drop the index 'MLICHECK.MLICHECK__0', because it does not exist or you do not have permission.

Procname: [ExecuteAndFlush - no proc]

DbSlExecute - Error 103 (dbcode 3701) on DDLExecute

DbSlExecute - <DROP INDEX MLICHECK.MLICHECK__0 >

License index MLICHECK__0 not found( - ok)

ExecuteAndFlush return code: 0x80040e14 Stmt: [DROP INDEX "MLICHECK~I1" ]

ExecuteAndFlush: line 6324. hr: 0x80040e14 Must specify the table name and index name for the DROP INDEX statement.

sloledb.cpp [ExecuteAndFlush,line 6324]: Error/Message: (err 159, sev 0), Must specify the table name and index name for the DROP INDEX statement.

Procname: [ExecuteAndFlush - no proc]

DbSlExecute - Error 99 (dbcode 159) on DDLExecute

DbSlExecute - <DROP INDEX "MLICHECK~I1" >

• ERROR => DBSL statement where error happend:

DROP INDEX ... [slicdb.c 2433]

*****************************************************************************

*

• ERROR Can not drop license index MLICHECK~I1

*

• TIME Sun Apr 13 22:31:15 2008

• RELEASE 700

• COMPONENT SLIC

• VERSION 300

• RC 99

• MODULE slicdb.c

• LINE 504

• DETAIL DbSlExecute failed with return code 99

• Must specify the table name and index name for the DROP INDEX

• statement.

• COUNTER 1

*

*****************************************************************************

Old license index not dropped...(rc: -111)

Database vendor is MICROSOFT SQL

License table created

License table created (rc: 0)

Index for license table created

License index created (rc: 0)

License table created (rc: 0)

Go and create a temporary license

SlicIGetDate: <20080511>

SlicCalcLicenseKey: key db/prod = >TEMPLICENSERPDINITIAL R3_MSS 20080511<

SlicIGetDate: <20080413>

License created as follows:

LICENSE DATA:

systemname: >RPD<

hardware-key: >TEMPLICENSE<

productid: >R3_MSS <

installation-nr: >INITIAL <

system-id: >INITIAL_SY<

userlimit: >0<

creation_date: >20080413<

expiration_date: >20080511<

lcheck_date: >19800101<

lkey: >8JU8CFNH4IKQLC7CJ2UUETJD<

fprint: >VTV96XNXYK97XYIA35ZFGISK<

Write license into database

The IRow interface is supported by this OLEDB provider

License >RPD< >TEMPLICENSE< >R3_MSS < requested from db

License >RPD< >TEMPLICENSE< >R3_MSS < not found in db

license does not exists, do a license insert

Try to insert inserted >RPD< >TEMPLICENSE< >R3_MSS <

License inserted >RPD< >TEMPLICENSE< >R3_MSS <

License written: >RPD< >TEMPLICENSE< >R3_MSS <

Temporary License written into database

SlicSapInstall sap-msgserver license ok.

db_con_commit (con_da={R/3,0,0},th_commit=0,tx=1,hold_cursor=0)

DbSlDisconnect curr_thread_id: 1884 sl_conn[0]->thread_id: 1884

Disconnected from connection con_da={R/3,0,0}

Regards,

SAT

[rajesh_gupta11 · Accepted solution]

Delete table MLICHECK with a database tool. saplicense then creates it again with the correct index only. However, you must then again install all licenses which were previously in the table (if they are still needed). For this, you call "saplicense -show" beforehand. Then the system displays all licenses, and you can install them again with the data displayed.

Ref: Note 111563 - saplicense cannot delete index

[Former Member]

Dear,

If your problem not get resolved please check SAP Note 44958 - IDES installation 3.0C, saplicense

As per SAP Note its advised you can drop database index and continue with your installation.

Regards,

Nikunj Thaker.

[Former Member]

Where u able to resolve the issue?