- SAP Community
- Products and Technology
- Technology
- Technology Q&A
- Error installing BW 3.1 (WAS 6.20) on MS-SQL
- Subscribe to RSS Feed
- Mark Question as New
- Mark Question as Read
- Bookmark
- Subscribe
- Printer Friendly Page
- Report Inappropriate Content
Error installing BW 3.1 (WAS 6.20) on MS-SQL
- Subscribe to RSS Feed
- Mark Question as New
- Mark Question as Read
- Bookmark
- Subscribe
- Printer Friendly Page
- Report Inappropriate Content
on 12-09-2004 8:50 AM
Hi all
I'm currently working on a new installation of BW 3.1 (WAS 6.20) on MSSQL. I got the SQL Server installed, along with SP3 and I have setup the Central Instance with no errors as well. However, when I do the Database Instance install, I get an error at the Database Load (post processing) Screen.
Up to this point, it appears ok but now I get a pop up message saying there has been a error. When I check SAPSSEXC.log I can isolate the following error.
***LOG BZA=> table SVERS does not exist on database [dblink#1 @ 1292] [dblink 1292 ]
I've tried reinstalling multiple times and it keeps happening. Is it an authorization issue with MS SQL? Can someone advise, if I need to change any user ids, etc. I'am logged in as administrator, trying to do a local installation and have tried to log in as <SID>adm as well but get the same error...
Some details: OS is Win2003 server, DB is MSSQL 2000 with SP3, CI and DB are one same server. If anyone can advise, i would appreciate any input.
Below is a paste of the complete SAPSSEXC logfile.
Regards
/Frank
E:\usr\sap\BW1\SYS\exe\run/R3load.exe: START OF LOG: 20041129162541
E:\usr\sap\BW1\SYS\exe\run/R3load.exe: sccsid @(#) $Id: //bas/620/src/R3ld/R3load/R3ldmain.c#6 $ SAP
E:\usr\sap\BW1\SYS\exe\run/R3load.exe: version R6.20/V1.2
E:\usr\sap\BW1\SYS\exe\run/R3load.exe -ctf I C:\InstalFiles\Export1/DATA/SAPSSEXC.STR C:\InstalFiles\Export1/DB/DDLMSS.TPL C:\SAPinst MSSQL KERNEL/SAPSSEXC.TSK MSS -l C:\SAPinst MSSQL KERNEL/SAPSSEXC.log
E:\usr\sap\BW1\SYS\exe\run/R3load.exe: job completed
E:\usr\sap\BW1\SYS\exe\run/R3load.exe: END OF LOG: 20041129162542
E:\usr\sap\BW1\SYS\exe\run/R3load.exe: START OF LOG: 20041129162604
E:\usr\sap\BW1\SYS\exe\run/R3load.exe: sccsid @(#) $Id: //bas/620/src/R3ld/R3load/R3ldmain.c#6 $ SAP
E:\usr\sap\BW1\SYS\exe\run/R3load.exe: version R6.20/V1.2
E:\usr\sap\BW1\SYS\exe\run/R3load.exe -dbcodepage 1100 -i C:\SAPinst MSSQL KERNEL/SAPSSEXC.cmd -l C:\SAPinst MSSQL KERNEL/SAPSSEXC.log -loadprocedure fast
DbSl Trace: SQLOLEDB Provider Release:08.50.1022
DbSl Trace: Shared cache sizes: header 52 bytes, 10000 names (13360000 bytes), 1000 dynamic statements (5436000 bytes), total 18796052 bytes
DbSl Trace: Initializing private procedure name cache.
DbSl Trace: procedure cache created/attached
DbSl Trace: Thank You for using the SLOLEDB-interface
DbSl Trace: Connected to db server : [cphtst26], dbname: BW1, dbuser: bw1
DbSl Trace: Using dynamic link library 'E:\usr\sap\BW1\SYS\exe\run\dbmssslib.dll'
DbSl Trace: dbmssslib.dll patch info
DbSl Trace: patchlevel 0
DbSl Trace: patchno 494
DbSl Trace: patchcomment MSSQL: SY-DBCNT for EXEC SQL. EXECUTE(..) ENDEXEC (574316)
DbSl Trace: The IRow interface is supported by this OLEDB provider
DbSl Trace: ParamStmtExec: line 23549. hr: 0x80040e37 Invalid object name 'SVERS'.
DbSl Trace: HandleOledbError [ParamStmtExec,line 23549]: Error/Message: (err 208, sev 16), Invalid object name 'SVERS'.
DbSl Trace: ParamStmtExec failed. HR 80040e37 DBSL retcode 103. stmt: [SELECT VERSION AS c FROM SVERS ]
DbSl Trace: Conn_i:1 selection:1 singleton:1 flag_fupd:0 use_cursor:0 chksum:12157
DbSl Trace: DbSlRead - Error 103 (dbcode 208) on open
DbSl Trace: DbSlRead - <##Y2CPHTST26bw100000019040000000001162604>
DbSl Trace: DbSlRead - Error 103 (dbcode 208) on fetch
DbSl Trace: DbSlRead - <##Y2CPHTST26bw100000019040000000001162604>
Mon Nov 29 16:26:04 2004
***LOG BZA=> table SVERS does not exist on database [dblink#1 @ 1292] [dblink 1292 ]
(DB) INFO: connected to DB
DbSl Trace: ParamStmtExec: line 23549. hr: 0x80040e37 Invalid object name 'SVERS'.
DbSl Trace: HandleOledbError [ParamStmtExec,line 23549]: Error/Message: (err 208, sev 16), Invalid object name 'SVERS'.
DbSl Trace: ParamStmtExec failed. HR 80040e37 DBSL retcode 103. stmt: [SELECT VERSION AS c FROM SVERS ]
DbSl Trace: Conn_i:1 selection:1 singleton:1 flag_fupd:0 use_cursor:0 chksum:12157
DbSl Trace: DbSlRead - Error 103 (dbcode 208) on open
DbSl Trace: DbSlRead - <##Y2CPHTST26bw100000019040000000002162604>
DbSl Trace: DbSlRead - Error 103 (dbcode 208) on fetch
DbSl Trace: DbSlRead - <##Y2CPHTST26bw100000019040000000002162604>
Interface access functions from dynamic library dbmssslib.dll loaded.(IMP) INFO: import of BRATEXT completed (259725 rows)
(IMP) INFO: import of D010INC completed (359297 rows)
(IMP) INFO: import of D010TAB completed (1180062 rows)
(IMP) INFO: import of D020S completed (26058 rows)
(IMP) INFO: import of D020T completed (46964 rows)
(IMP) INFO: import of D021T completed (220317 rows)
(IMP) INFO: import of D301T completed (0 rows)
(IMP) INFO: InitFastLoad failed with <3: (null)>(IMP) INFO: DBSL will be used(IMP) INFO: import of D345T completed (0 rows)
(IMP) INFO: import of D347T completed (0 rows)
(IMP) INFO: import of DBDIFF completed (156 rows)
(IMP) INFO: import of DD01L completed (13508 rows)
(IMP) INFO: import of DD01T completed (28975 rows)
(IMP) INFO: import of DD02L completed (35238 rows)
(IMP) INFO: import of DD02T completed (73738 rows)
(IMP) INFO: import of DD03L completed (368844 rows)
(IMP) INFO: import of DD03T completed (33493 rows)
(IMP) INFO: import of DD04L completed (53152 rows)
(IMP) INFO: import of DD04T completed (111036 rows)
(IMP) INFO: import of DD06L completed (56 rows)
(IMP) INFO: import of DD06T completed (212 rows)
(IMP) INFO: import of DD07L completed (20163 rows)
(IMP) INFO: import of DD07T completed (54024 rows)
(IMP) INFO: import of DD09L completed (10510 rows)
(IMP) INFO: import of DD20L completed (19 rows)
(IMP) INFO: import of DD25L completed (3015 rows)
(IMP) INFO: import of DD26S completed (5793 rows)
(IMP) INFO: import of DD27S completed (23964 rows)
(IMP) INFO: import of DD28S completed (4856 rows)
(IMP) INFO: import of DD29L completed (2229 rows)
(IMP) INFO: import of DD30L completed (1157 rows)
(IMP) INFO: import of DD30T completed (2332 rows)
(IMP) INFO: import of DD31S completed (1310 rows)
(IMP) INFO: import of DD32S completed (3925 rows)
(IMP) INFO: import of DD33S completed (3406 rows)
(IMP) INFO: import of DD35L completed (1663 rows)
(IMP) INFO: import of DD36S completed (5348 rows)
(IMP) INFO: import of DD40L completed (7005 rows)
(IMP) INFO: import of DD40T completed (14165 rows)
(IMP) INFO: import of DD42S completed (1828 rows)
(IMP) INFO: import of DDTYPES completed (103119 rows)
(IMP) INFO: import of DDTYPET completed (2820 rows)
(IMP) INFO: import of DDXTF completed (0 rows)
(IMP) INFO: import of DDXTF_CONV_UC completed (0 rows)
(IMP) INFO: import of DDXTT completed (0 rows)
(IMP) INFO: import of DDXTT_CONV_UC completed (0 rows)
(IMP) INFO: import of DF03L completed (0 rows)
(IMP) INFO: import of DF03T completed (24502 rows)
(IMP) INFO: import of DF04L completed (44 rows)
(IMP) INFO: import of DF04T completed (25145 rows)
(IMP) INFO: import of DF06L completed (0 rows)
(IMP) INFO: import of DF06T completed (0 rows)
(IMP) INFO: import of DF07L completed (0 rows)
(IMP) INFO: import of DF07T completed (0 rows)
(IMP) INFO: import of DF08L completed (0 rows)
(IMP) INFO: import of DF08T completed (0 rows)
(IMP) INFO: import of DF10L completed (0 rows)
(IMP) INFO: import of DF10T completed (0 rows)
(IMP) INFO: import of DF11L completed (0 rows)
(IMP) INFO: import of DF11T completed (0 rows)
(IMP) INFO: import of DF12L completed (0 rows)
(IMP) INFO: import of DF12T completed (0 rows)
(IMP) INFO: import of DF13L completed (0 rows)
(IMP) INFO: import of DF13T completed (0 rows)
(IMP) INFO: import of DF14L completed (542 rows)
(IMP) INFO: import of DF14T completed (7042 rows)
(IMP) INFO: import of DF15L completed (0 rows)
(IMP) INFO: import of DF15T completed (0 rows)
(IMP) INFO: import of DF16L completed (0 rows)
(IMP) INFO: import of DF16T completed (0 rows)
(IMP) INFO: import of DF30S completed (0 rows)
(IMP) INFO: import of DF34S completed (0 rows)
(IMP) INFO: import of DF40D completed (91 rows)
(IMP) INFO: import of DF41S completed (373 rows)
(IMP) INFO: import of DF42S completed (0 rows)
(IMP) INFO: import of DF43S completed (0 rows)
(IMP) INFO: import of DIAPAR completed (682 rows)
(IMP) INFO: import of DM02L completed (286 rows)
(IMP) INFO: import of DM02S completed (0 rows)
(IMP) INFO: import of DM02T completed (572 rows)
(IMP) INFO: import of DM03S completed (192 rows)
(IMP) INFO: import of DM25L completed (93 rows)
(IMP) INFO: import of DM26L completed (281 rows)
(IMP) INFO: import of DM40L completed (109 rows)
(IMP) INFO: import of DM40T completed (218 rows)
(IMP) INFO: import of DM41S completed (370 rows)
(IMP) INFO: import of DM42S completed (371 rows)
(IMP) INFO: import of DM42T completed (975 rows)
(IMP) INFO: import of DM43T completed (13 rows)
(IMP) INFO: import of DM45L completed (39 rows)
(IMP) INFO: import of DM45T completed (1235 rows)
(IMP) INFO: import of DM46S completed (79 rows)
(IMP) INFO: import of DOKCLU completed (298826 rows)
(IMP) INFO: import of DOKHL completed (361786 rows)
(IMP) INFO: import of DOKIL completed (311698 rows)
(IMP) INFO: import of DSYST completed (1880 rows)
(IMP) INFO: InitFastLoad failed with <3: (null)>(IMP) INFO: DBSL will be used(IMP) INFO: InitFastLoad failed with <3: (null)>(IMP) INFO: DBSL will be used(IMP) INFO: InitFastLoad failed with <3: (null)>(IMP) INFO: DBSL will be used(IMP) INFO: import of DYNPSOURCE completed (26058 rows)
(IMP) INFO: import of ENLFDIR completed (54453 rows)
(IMP) INFO: import of EUDB completed (5577 rows)
(IMP) INFO: import of EUGUITEXT completed (854 rows)
(IMP) INFO: import of EUOBJ completed (417 rows)
(IMP) INFO: import of EUOBJEDIT completed (277 rows)
(IMP) INFO: import of EUOBJT completed (536 rows)
(IMP) INFO: import of FUNCT completed (353242 rows)
(IMP) INFO: import of FUPARAREF completed (364467 rows)
(IMP) INFO: import of IADB2 completed (20 rows)
(IMP) INFO: import of IADB6 completed (20 rows)
(IMP) INFO: import of IAINF completed (20 rows)
(IMP) INFO: import of IAMSS completed (0 rows)
(IMP) INFO: import of IAORA completed (20 rows)
(IMP) INFO: import of IGDB2 completed (10 rows)
(IMP) INFO: import of IGORA completed (15 rows)
(IMP) INFO: InitFastLoad failed with <3: (null)>(IMP) INFO: DBSL will be used(IMP) INFO: InitFastLoad failed with <3: (null)>(IMP) INFO: DBSL will be used(IMP) INFO: InitFastLoad failed with <3: (null)>(IMP) INFO: DBSL will be used(IMP) INFO: InitFastLoad failed with <3: (null)>(IMP) INFO: DBSL will be used(IMP) INFO: InitFastLoad failed with <3: (null)>(IMP) INFO: DBSL will be used(IMP) INFO: import of INDTEXT completed (42717 rows)
(IMP) INFO: import of LDBA completed (0 rows)
(IMP) INFO: import of LDBB completed (0 rows)
(IMP) INFO: import of LDBD completed (17 rows)
(IMP) INFO: import of LDBH completed (6 rows)
(IMP) INFO: import of LDBN completed (38 rows)
(IMP) INFO: import of LDBNT completed (76 rows)
(IMP) INFO: import of LDBQUAN completed (5 rows)
(IMP) INFO: import of LDBT completed (35 rows)
(IMP) INFO: import of MACID completed (16 rows)
(IMP) INFO: import of MACOB completed (18 rows)
(IMP) INFO: import of MCUSREXITS completed (0 rows)
(IMP) INFO: import of MSSPROCS completed (201 rows)
(IMP) INFO: import of MSSSOURCE completed (20644 rows)
(IMP) INFO: import of MSSSPVERS completed (2 rows)
(IMP) INFO: import of MSSSTORAGE completed (1 rows)
(IMP) INFO: import of NOTRA completed (192 rows)
(IMP) INFO: InitFastLoad failed with <3: (null)>(IMP) INFO: DBSL will be used(IMP) INFO: InitFastLoad failed with <3: (null)>(IMP) INFO: DBSL will be used(IMP) INFO: InitFastLoad failed with <3: (null)>(IMP) INFO: DBSL will be used(IMP) INFO: InitFastLoad failed with <3: (null)>(IMP) INFO: DBSL will be used(IMP) INFO: InitFastLoad failed with <3: (null)>(IMP) INFO: DBSL will be used(IMP) INFO: InitFastLoad failed with <3: (null)>(IMP) INFO: DBSL will be used(IMP) INFO: InitFastLoad failed with <3: (null)>(IMP) INFO: DBSL will be used(IMP) INFO: InitFastLoad failed with <3: (null)>(IMP) INFO: DBSL will be used(IMP) INFO: InitFastLoad failed with <3: (null)>(IMP) INFO: DBSL will be used(IMP) INFO: InitFastLoad failed with <3: (null)>(IMP) INFO: DBSL will be used(IMP) INFO: InitFastLoad failed with <3: (null)>(IMP) INFO: DBSL will be used(IMP) INFO: InitFastLoad failed with <3: (null)>(IMP) INFO: DBSL will be used(IMP) INFO: InitFastLoad failed with <3: (null)>(IMP) INFO: DBSL will be used(IMP) INFO: InitFastLoad failed with <3: (null)>(IMP) INFO: DBSL will be used(IMP) INFO: InitFastLoad failed with <3: (null)>(IMP) INFO: DBSL will be used(IMP) INFO: InitFastLoad failed with <3: (null)>(IMP) INFO: DBSL will be used(IMP) INFO: InitFastLoad failed with <3: (null)>(IMP) INFO: DBSL will be used(IMP) INFO: InitFastLoad failed with <3: (null)>(IMP) INFO: DBSL will be used(IMP) INFO: InitFastLoad failed with <3: (null)>(IMP) INFO: DBSL will be used(IMP) INFO: InitFastLoad failed with <3: (null)>(IMP) INFO: DBSL will be used(IMP) INFO: InitFastLoad failed with <3: (null)>(IMP) INFO: DBSL will be used(IMP) INFO: InitFastLoad failed with <3: (null)>(IMP) INFO: DBSL will be used(IMP) INFO: InitFastLoad failed with <3: (null)>(IMP) INFO: DBSL will be used(IMP) INFO: InitFastLoad failed with <3: (null)>(IMP) INFO: DBSL will be used(IMP) INFO: InitFastLoad failed with <3: (null)>(IMP) INFO: DBSL will be used(RFF) ERROR: file SAPSSEXC.002 not found
(IMP) INFO: InitFastLoad failed with <3: (null)>(IMP) INFO: DBSL will be used(RFF) ERROR: file SAPSSEXC.002 not found
(RFF) ERROR: file SAPSSEXC.002 not found
(RFF) ERROR: file SAPSSEXC.002 not found
(RFF) ERROR: file SAPSSEXC.002 not found
(RFF) ERROR: file SAPSSEXC.002 not found
(IMP) INFO: import of SEOCLASSEX completed (0 rows)
(RFF) ERROR: file SAPSSEXC.002 not found
(RFF) ERROR: file SAPSSEXC.002 not found
(RFF) ERROR: file SAPSSEXC.002 not found
(IMP) INFO: import of SEOCOMPOEX completed (0 rows)
(RFF) ERROR: file SAPSSEXC.002 not found
(RFF) ERROR: file SAPSSEXC.002 not found
(RFF) ERROR: file SAPSSEXC.002 not found
(RFF) ERROR: file SAPSSEXC.002 not found
(RFF) ERROR: file SAPSSEXC.002 not found
(RFF) ERROR: file SAPSSEXC.002 not found
(RFF) ERROR: file SAPSSEXC.002 not found
(RFF) ERROR: file SAPSSEXC.002 not found
(RFF) ERROR: file SAPSSEXC.002 not found
(RFF) ERROR: file SAPSSEXC.002 not found
(RFF) ERROR: file SAPSSEXC.002 not found
(RFF) ERROR: file SAPSSEXC.002 not found
(RFF) ERROR: file SAPSSEXC.002 not found
(RFF) ERROR: file SAPSSEXC.002 not found
(RFF) ERROR: file SAPSSEXC.002 not found
(RFF) ERROR: file SAPSSEXC.002 not found
(RFF) ERROR: file SAPSSEXC.002 not found
(RFF) ERROR: file SAPSSEXC.002 not found
(IMP) INFO: import of TERCL completed (0 rows)
(RFF) ERROR: file SAPSSEXC.002 not found
(IMP) INFO: import of TERCL3 completed (0 rows)
(RFF) ERROR: file SAPSSEXC.002 not found
(IMP) INFO: import of TERM2 completed (0 rows)
(IMP) INFO: import of TERM3 completed (0 rows)
(IMP) INFO: import of TERM4 completed (0 rows)
(IMP) INFO: import of TERM6 completed (0 rows)
(IMP) INFO: import of TERM7 completed (0 rows)
(RFF) ERROR: file SAPSSEXC.002 not found
(IMP) INFO: import of TFM18X completed (0 rows)
(RFF) ERROR: file SAPSSEXC.002 not found
(RFF) ERROR: file SAPSSEXC.002 not found
(RFF) ERROR: file SAPSSEXC.002 not found
(RFF) ERROR: file SAPSSEXC.002 not found
(IMP) INFO: import of TITLE completed (0 rows)
(RFF) ERROR: file SAPSSEXC.002 not found
(RFF) ERROR: file SAPSSEXC.002 not found
(RFF) ERROR: file SAPSSEXC.002 not found
(RFF) ERROR: file SAPSSEXC.002 not found
(RFF) ERROR: file SAPSSEXC.002 not found
(RFF) ERROR: file SAPSSEXC.002 not found
(RFF) ERROR: file SAPSSEXC.002 not found
(IMP) INFO: import of TRBAT completed (0 rows)
(RFF) ERROR: file SAPSSEXC.002 not found
(RFF) ERROR: file SAPSSEXC.002 not found
(RFF) ERROR: file SAPSSEXC.002 not found
(RFF) ERROR: file SAPSSEXC.002 not found
(RFF) ERROR: file SAPSSEXC.002 not found
(RFF) ERROR: file SAPSSEXC.002 not found
(RFF) ERROR: file SAPSSEXC.002 not found
(RFF) ERROR: file SAPSSEXC.002 not found
(RFF) ERROR: file SAPSSEXC.002 not found
(RFF) ERROR: file SAPSSEXC.002 not found
(RFF) ERROR: file SAPSSEXC.002 not found
(RFF) ERROR: file SAPSSEXC.002 not found
(RFF) ERROR: file SAPSSEXC.002 not found
(IMP) INFO: import of TSTC_SRT completed (0 rows)
(RFF) ERROR: file SAPSSEXC.002 not found
(RFF) ERROR: file SAPSSEXC.002 not found
(IMP) INFO: import of TTREEN completed (0 rows)
(RFF) ERROR: file SAPSSEXC.002 not found
(RFF) ERROR: file SAPSSEXC.002 not found
(RFF) ERROR: file SAPSSEXC.002 not found
(RFF) ERROR: file SAPSSEXC.002 not found
(RFF) ERROR: file SAPSSEXC.002 not found
(RFF) ERROR: file SAPSSEXC.002 not found
(RFF) ERROR: file SAPSSEXC.002 not found
(RFF) ERROR: file SAPSSEXC.002 not found
(RFF) ERROR: file SAPSSEXC.002 not found
(RFF) ERROR: file SAPSSEXC.002 not found
(RFF) ERROR: file SAPSSEXC.002 not found
(RFF) ERROR: file SAPSSEXC.002 not found
(TFH) ERROR: Unable to close C:\InstalFiles\Export1/DATA/SAPSSEXC.001
(DB) INFO: disconnected from DB
E:\usr\sap\BW1\SYS\exe\run/R3load.exe: job finished with 68 error(s)
E:\usr\sap\BW1\SYS\exe\run/R3load.exe: END OF LOG: 20041129173637
Accepted Solutions (0)
Answers (3)
Answers (3)
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Report Inappropriate Content
Hi,
A simple fix, Apply the latest patch for Patch for dbmssslib.dll the Database Library patch.
Good Luck..
Regards
Rajesh Gupta
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Report Inappropriate Content
Hello,
I'm having the same problem with MS-SQL when upgrading from BW3.0B to BW3.5.
- invalid object name svers
Any solution?
Thanks,
PT
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Report Inappropriate Content
Hello!
I am having exactly the same problem with my install of BW IDES. I have reinstalled 10 times and have it admit I'm getting tired of the repetition!
How were you able to overcome or workaround this error?
Thanks,
Bob
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
- error during install SAP S/4HANA Server 2022 in Technology Q&A
- explore the business continuity recovery sap solutions on AWS DRS in Technology Blogs by Members
- SAP Datasphere: Using Replication Flows on Finance Foundation Business Content in Technology Q&A
- SAP ADT installation issue in Technology Q&A
- Exciting updates from TTA Cloud in Technology Blogs by Members
| User | Count |
|---|---|
| 93 | |
| 10 | |
| 10 | |
| 9 | |
| 9 | |
| 7 | |
| 6 | |
| 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.