Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Installation Error(SolMgr4.0SR1)

Hi Friends,

I am facing problem on 2 step of 41 while SAPGUIcreate stored procedures. My system configuration is:

  • Win server 2003

  • MS SQL server 2000 (latest hotfix & collation & BIN2)

@ first instance it shows some MSS database error in MSSLOG.log as shown here. But there I found nothing wrong in there.I also posted SAPGUI.log for UR reference. Please feel free to ask for any other piece of info if you consider necessary for this issue. In hope of an earlier and positive response.

-


executeSQL is called with following parameters:

Server: SOLMGR

Login: integrated security

Resultset will be copied to procs

Ignore errors is false

Append results is false

-


use S23

setuser 's23'

declare @rel nvarchar(3)

set @rel = (@@microsoftversion / 65536) / 256

set @rel = @rel + N'.0'

select a.PROCNAME from MSSSOURCE a

where DBRELEASE in (N' ', @rel)

and REVISION = (select MAX(REVISION) from MSSSOURCE b where b.PROCNAME = a.PROCNAME and DBRELEASE in (N' ', @rel))

group by a.PROCNAME

-


executeSQL is called with following parameters:

Server: SOLMGR

Login: integrated security

Resultset will be copied to current

Ignore errors is false

Append results is false

-


use S23

setuser 's23'

declare @rel nvarchar(3)

set @rel = (@@microsoftversion / 65536) / 256

set @rel = @rel + N'.0'

select SRCLINE from MSSSOURCE

where PROCNAME = 'ERASER'

and DBRELEASE in (N' ', @rel)

and REVISION = (select MAX(REVISION) from MSSSOURCE where PROCNAME = 'ERASER' and DBRELEASE in (N' ', @rel))

order by LINENR

-


executeSQL is called with following parameters:

Server: SOLMGR

Login: integrated security

Resultset will not be copied

Ignore errors is false

Append results is false

-


use S23

setuser 's23'

/**********************************************************************/

/* */

/* ERASER 04/07/01 P. Goertz, SAP Labs */

/* -


*/

/* */

/* Used to drop objects for which the MSSPROCS script was deleted. */

/* When a stored procedure, for example, is obsolete and its script */

/* is deleted in MSSPROCS the procedure still remains in the DB. */

/* ********************************************************************/

set nocount on

declare @name sysname

declare @cmd nvarchar(256)

-- stored procedures

create table #procs (name sysname)

insert into #procs values ('sap_atomic_BWupg_create_indexP')

insert into #procs values ('sap_atomic_BWupg_drop_sec_inds')

insert into #procs values ('sap_atomic_BWupg_rework_sec_inds')

insert into #procs values ('sap_bind_ddic_type')

insert into #procs values ('sap_change_ATAB_3')

insert into #procs values ('sap_change_ATAB_4')

insert into #procs values ('sap_change_datatype')

insert into #procs values ('sap_change_datatype_without_checks')

insert into #procs values ('sap_do_change')

insert into #procs values ('sap_fix_dd16s_defaults')

insert into #procs values ('sap_repair_nullable_initial')

insert into #procs values ('sap_unpad_all')

insert into #procs values ('sap_unpadtable_70')

-- cleanup 620 dale

insert into #procs values ('sap_chk_db_iface')

insert into #procs values ('sap_chk_idx_exists')

insert into #procs values ('sap_get_helptext')

insert into #procs values ('sap_get_perf_counters')

-- insert into #procs values ('sap_get_selectivity')

-- sp is re-crerated in 6.20, Peter

insert into #procs values ('sap_get_spmonitor')

insert into #procs values ('sap_get_spwho')

insert into #procs values ('sap_get_sqlconfig')

insert into #procs values ('sap_get_trans')

insert into #procs values ('sap_mon_cpus')

insert into #procs values ('sap_mon_dbcheck')

insert into #procs values ('sap_mon_dbup')

insert into #procs values ('sap_mon_getprocinfo')

insert into #procs values ('sap_mon_idx_detls')

insert into #procs values ('sap_readerrorlog')

insert into #procs values ('sap_sys_indexes')

insert into #procs values ('sap_sys_objects')

declare proc_eraser cursor for

select name from #procs

open proc_eraser

fetch next from proc_eraser into @name

while (@@fetch_status <> -1)

begin

if (@@fetch_status <> -2)

if exists (select name

from dbo.sysobjects

where name = @name

and xtype = 'P'

and uid = user_id())

begin

select @cmd = N'drop proc [' + @name + N']'

exec( @cmd )

end

fetch next from proc_eraser into @name

end

close proc_eraser

deallocate proc_eraser

drop table #procs

-- functions

-


[Microsoft][ODBC SQL Server Driver][SQL Server]Could not find database table ID 7, name 'S23'.

-


SAPGUILOG.LOG

-


INFO 2006-10-05 10:32:37

Copied file 'C:/Program Files/sapinst_instdir/SOLMAN/SYSTEM/MSS/CENTRAL/AS/inifile.xml' to 'C:/Program Files/sapinst_instdir/SOLMAN/SYSTEM/MSS/CENTRAL/AS/inifile.4.xml'.

INFO 2006-10-05 10:32:37

Copied file 'C:/Program Files/sapinst_instdir/SOLMAN/SYSTEM/MSS/CENTRAL/AS/inifile.xml' to 'C:/Program Files/sapinst_instdir/SOLMAN/SYSTEM/MSS/CENTRAL/AS/inifile.5.xml'.

INFO 2006-10-05 10:32:46

Copied file 'C:/Program Files/sapinst_instdir/SOLMAN/SYSTEM/MSS/CENTRAL/AS/keydb.xml' to 'C:/Program Files/sapinst_instdir/SOLMAN/SYSTEM/MSS/CENTRAL/AS/keydb.3.xml'.

INFO 2006-10-05 10:32:46

Execute step ExeProcs of component |NW_Onehost|ind|ind|ind|ind|0|0|NW_Onehost_System|ind|ind|ind|ind|1|0|NW_CreateDBandLoad|ind|ind|ind|ind|9|0|NW_Postload|ind|ind|ind|ind|10|0|NW_Postload_MSS|ind|ind|ind|ind|2|0|MssProcs|ind|ind|ind|ind|1|0.

ERROR 2006-10-05 10:33:15

FCO-00011 The step ExeProcs with step key |NW_Onehost|ind|ind|ind|ind|0|0|NW_Onehost_System|ind|ind|ind|ind|1|0|NW_CreateDBandLoad|ind|ind|ind|ind|9|0|NW_Postload|ind|ind|ind|ind|10|0|NW_Postload_MSS|ind|ind|ind|ind|2|0|MssProcs|ind|ind|ind|ind|1|0|ExeProcs was executed with status ERROR .

Former Member
Not what you were looking for? View more on this topic or Ask a question