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."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" >
(DB) ERROR: DDL statement failed
(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"
DbSlExecute: rc = 103
(SQL error 208)
error message returned by DbSl:
Invalid object name '/SAPTRX/ASFCTEV'.
Invalid object name '/SAPTRX/ASFCTEVT'
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."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" >
(DB) ERROR: DDL statement failed
(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"
DbSlExecute: rc = 103
(SQL error 208)
error message returned by DbSl:
Invalid object name '/SAPTRX/ASFCTEV'.
Invalid object name '/SAPTRX/ASFCTEVT'