Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SAP R/3 4.7 Enterprise install issue on SQL 200

Status
Not open for further replies.

SAPdogg

MIS
Feb 16, 2004
1
US
Hello All,

I am trying to do a central system install of 4.7 on our server, but running into errors.

I got the SQL Server installed, along with SP3,QFE and INSTCOLL.exe. I 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. As soon as all the jobs finish, it shows R3 Load Jobs :Finished SAPVIEW. Then, I get the pop up messaging saying there has been a error. When I check SAPVIEW, I see something like this.

(DB) ERROR: DDL statement failed....SQL error 208)
error message returned by DbSl:
Invalid object name '/SAPTRX/ASFCTPAR'.
Invalid object name '/SAPTRX/ASFCTPAT'.

To make a long story short, 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. BTW, I am logged in as administrator, trying to do a local installation.

Some details: OS is Win2K server, DB is MSSQL 2000, CI and DB are one same servrer. If anyone can advise, i would appreciate any input.
Below is a paste of the SAPVIEW logfile.

thanks!

SAPDogg


SAPVIEW LOG
F:\usr\sap\DEV\SYS\exe\run/R3load.exe: START OF LOG: 20040216040556

F:\usr\sap\DEV\SYS\exe\run/R3load.exe: sccsid @(#) $Id: //bas/620/src/R3ld/R3load/R3ldmain.c#6 $ SAP
F:\usr\sap\DEV\SYS\exe\run/R3load.exe: version R6.20/V1.2
F:\usr\sap\DEV\SYS\exe\run/R3load.exe -ctf I D:\cd7/DATA/SAPVIEW.STR D:\cd7/DB/DDLMSS.TPL C:\Program Files\SAPinstDEV/SAPVIEW.TSK MSS -l C:\Program Files\SAPinstDEV/SAPVIEW.log -o D


F:\usr\sap\DEV\SYS\exe\run/R3load.exe: job completed
F:\usr\sap\DEV\SYS\exe\run/R3load.exe: END OF LOG: 20040216040557

F:\usr\sap\DEV\SYS\exe\run/R3load.exe: START OF LOG: 20040216053226

F:\usr\sap\DEV\SYS\exe\run/R3load.exe: sccsid @(#) $Id: //bas/620/src/R3ld/R3load/R3ldmain.c#6 $ SAP
F:\usr\sap\DEV\SYS\exe\run/R3load.exe: version R6.20/V1.2
F:\usr\sap\DEV\SYS\exe\run/R3load.exe -dbcodepage 1100 -i C:\Program Files\SAPinstDEV/SAPVIEW.cmd -l C:\Program Files\SAPinstDEV/SAPVIEW.log -loadprocedure fast

DbSl Trace: SQLOLEDB Provider Release:08.10.9042

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 : [tbsapdev01], dbname: DEV, dbuser: dev

DbSl Trace: Using dynamic link library 'F:\usr\sap\DEV\SYS\exe\run\dbmssslib.dll'

DbSl Trace: dbmssslib.dll patch info

DbSl Trace: patchlevel 0

DbSl Trace: patchno 524

DbSl Trace: patchcomment DBDYNPSOURCE/DBDYNPSOURCE~, SHADOW_IMPORT_ALL (578789)

DbSl Trace: The IRow interface is supported by this OLEDB provider

(DB) INFO: connected to DB
DbSl Trace: ExecuteAndFlush return code: 0x80040e37 Stmt: [CREATE VIEW [/SAPTRX/VDASFEV] ( [CLIENT] , [FUNC_TYPE] , [FUNCTION_ID] , [MILESTONE] , [SPRAS] , [DESCRIPTION] ) AS SELECT T0001."CLIENT", T0001."FUNC_TYPE", T0001."FUNCTION_ID", T0001."MILESTONE", T0002."SPRAS", T0002."DESCRIPTION" FROM "/SAPTRX/ASFCTEV" T0001, "/SAPTRX/ASFCTEVT" T0002 WHERE T0001."CLIENT" = T0002."CLIENT" AND T0001."FUNC_TYPE" = T0002."FUNC_TYPE" AND T0001."FUNCTION_ID" = T0002."FUNCTION_ID" AND T0001."MILESTONE" = T0002."MILESTONE" ]

DbSl Trace: ExecuteAndFlush: line 36654. hr: 0x80040e37 Invalid object name '/SAPTRX/ASFCTEVT'.

DbSl Trace: HandleOledbError [ExecuteAndFlush,line 36654]: Error/Message: (err 208, sev 16), Invalid object name '/SAPTRX/ASFCTEVT'.

DbSl Trace: HandleOledbError [ExecuteAndFlush,line 36654]: Error/Message: (err 208, sev 16), Invalid object name '/SAPTRX/ASFCTEV'.

DbSl Trace: DbSlExecute - Error 103 (dbcode 208) on DDLExecute

DbSl Trace: DbSlExecute - <CREATE VIEW [/SAPTRX/VDASFEV] ( [CLIENT] , [FUNC_TYPE] , [FUNCTION_ID] , [MILESTONE] , [SPRAS] , [DESCRIPTION] ) AS SELECT T0001.&quot;CLIENT&quot;, T0001.&quot;FUNC_TYPE&quot;, T0001.&quot;FUNCTION_ID&quot;, T0001.&quot;MILESTONE&quot;, T0002.&quot;SPRAS&quot;, T0002.&quot;DESCRIPTION&quot; FROM &quot;/SAPTRX/ASFCTEV&quot; T0001, &quot;/SAPTRX/ASFCTEVT&quot; T0002 WHERE T0001.&quot;CLIENT&quot; = T0002.&quot;CLIENT&quot; AND T0001.&quot;FUNC_TYPE&quot; = T0002.&quot;FUNC_TYPE&quot; AND T0001.&quot;FUNCTION_ID&quot; = T0002.&quot;FUNCTION_ID&quot; AND T0001.&quot;MILESTONE&quot; = T0002.&quot;MILESTONE&quot; >

(DB) ERROR: DDL statement failed
(CREATE VIEW [/SAPTRX/VDASFEV] ( [CLIENT] , [FUNC_TYPE] , [FUNCTION_ID] , [MILESTONE] , [SPRAS] , [DESCRIPTION] ) AS SELECT T0001.&quot;CLIENT&quot;, T0001.&quot;FUNC_TYPE&quot;, T0001.&quot;FUNCTION_ID&quot;, T0001.&quot;MILESTONE&quot;, T0002.&quot;SPRAS&quot;, T0002.&quot;DESCRIPTION&quot; FROM &quot;/SAPTRX/ASFCTEV&quot; T0001, &quot;/SAPTRX/ASFCTEVT&quot; T0002 WHERE T0001.&quot;CLIENT&quot; = T0002.&quot;CLIENT&quot; AND T0001.&quot;FUNC_TYPE&quot; = T0002.&quot;FUNC_TYPE&quot; AND T0001.&quot;FUNCTION_ID&quot; = T0002.&quot;FUNCTION_ID&quot; AND T0001.&quot;MILESTONE&quot; = T0002.&quot;MILESTONE&quot;)
DbSlExecute: rc = 103
(SQL error 208)
error message returned by DbSl:
Invalid object name '/SAPTRX/ASFCTEV'.
Invalid object name '/SAPTRX/ASFCTEVT'

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top