on 12-26-2007 1:15 AM
Hii experts!!!
During installation of 4.7 IDES on standalone system, I have got an error which is as follows -
ERROR 2008-12-26 05:42:23
MSC-01015 Process finished with error(s), check log file C:\SAPinst ORACLE KERNEL/SAPVIEW.log
and when I checked SAPVIEW.log it says something like this -
(DB) INFO: APPL_ENQU created
(DB) INFO: APPL_FUGR created
(DB) ERROR: DDL statement failed
(CREATE VIEW "APPL_FUGRG" ( "AREA" , "DEVCLASS" , "OBJ_NAME" ) AS SELECT T0001."AREA", T0002."DEVCLASS", T0002."OBJ_NAME" FROM "TLIBG" T0001, "TADIR" T0002 WHERE T0001."AREA" = T0002."OBJ_NAME" AND T0002."PGMID" = 'R3TR' AND T0002."OBJECT" = 'FUGR')
DbSlExecute: rc = 103
(SQL error 942)
error message returned by DbSl:
ORA-00942: table or view does not exist
DbSl Trace: Disconnecting from connection 0 ...
Please help me to fix this problem. Points will be rewarded to each one of you.
regards
kapil
hi,
Such an error on this step means that one or more tables used for the view creation are missing in the database although at this point of time they should be there as all other load processes have already finished.The first thing to do is to find out which table (or tables) is missing. It can be easily checked on database level. Please note that in the example above, table names are TLIBG and ADIR.
TADIR. T0001 and T0002 serve here only as aliases.Furthermore it is important to know which SAP<tabart_name>.STR file contains a definition of missing tables. Let us assume it is SAPXXX.STR.
Possible reasons for the error are:
1) the installation tool (R3SETUP or SAPinst) is not aware that SAPXXX.STR file exists. This can happen when SAPXXX.STR file has not been copied from source system in case of a system copy or from EXPORT CD in case of a new installation.
2) some of the parameter files described per note # 118059 and # 455195 (for R3load higher than 6.10) are missing or corrupt, and the corresponding command and/or task file has not been created. As a result the corresponded load process has not been started at all. If so (for both 1st and 2nd reasons) there should be no SAPXXX.log file in the installation directory. In such cases all the objects that belong to SAPXXX.STR file are missing in the database.
3) missing table was not created because of a database or operating system error. If so you should be able to find error message in SAPXXX.log file.
4) for R3load version >= 6.10 only: because of some reason the load process of SAPXXX.STR has been hard terminated (Ctrl-C, power failure, OS or hardware crash, etc.). If so there should be SAPXXX.TSK.bck file written in the installation directory.
Corresponded solutions are:
1) copy missing SAPXXX.STR into the export directory on the target system in the case of system copy or into the directory where all the EXPORT CDs are copied to for an installation. Start the database instance installation from the scratch.
FOR EXPERIENCED CONSULTANTS ONLY: an alternative would be to create SAPXXX.CMD file manually, generate SAPXXX.TSK file (in case of R3load version >= 6.10) and start R3load for SAPXXX.CMD manually. After this R3load process finished you can re-start the installation tool as normal.
2) find out exactly which parameter files are missing and copy the missing (or corrupted) files either from the corresponding Export-CD's (new installation) or from the export directory of the source system (system
copy).
3) fix the problem that caused the termination. Re-start R3load for SAPXXX.CMD file manually. After this R3load process is finished you can re-start the installation tool as normal.
4) start R3load for SAPXXX.CMD manually as described in note 455195. Repeat the procedure for every SAP*.TSK.bck file found in the installation directory. After all R3load processes have finished you canre-start the installation tool as normal.
Important for IDES installations:
For some IDES-installations it is required to build a virtual Export-disk on the local filesystem. You will find a detailled documentation on your IDES Export CD in a readme file or in an IDES-specific documentation.
If you miss this, you will also have the situation that entire TABARTS and many tables are missing.
Header
regards
aaji
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
The error is:
ORA-00942: table or view does not exist
It happens creating a view from tables:
FROM "TLIBG" T0001, "TADIR" T0002
Do the tables exist?
Do the user have access to this tables?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
No I have not done it like that.. Can you suggest me what all I need to do? I am giving you some querries which are rolling in my mind.
1) Whether its realy possible to install SAP 4.7 IDES on win xp.
2) I had already tried it on win2k server, but due to non-availability of good antivirus, I am not able to complete the install. That time I had crossed the error, which is coming right now. Previously I found error on very last stage for RFC connection paaswrod. Why it happened, if the dump is the same.
3) Last but not least, I want to install it on win xp so that I can access internet and as well as SAP to practice with. Suggest me how?
thanks in advance
kapil
> 1) Whether its realy possible to install SAP 4.7 IDES on win xp.
Possible - yes, without hazzles - no.
> 2) I had already tried it on win2k server, but due to non-availability of good antivirus, I am not able to complete the install. That time I had crossed the error, which is coming right now. Previously I found error on very last stage for RFC connection paaswrod. Why it happened, if the dump is the same.
I would never install a virus scanner on a database machine...
> 3) Last but not least, I want to install it on win xp so that I can access internet and as well as SAP to practice with. Suggest me how?
I suggest you get, if you're a licensed customer, the official installation documentation - it will help you to get the system installed.
What Oracle version are you using?
Markus
What is your system configuration ???
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Yea I have checked my oracle installation. I have used oracle patches. Do you want me to remove those patches? I can try that. But before then that, can you suggest me if I am using the same dump which I was using in WIN2003 Adv Serv. and it worked fine with patches. Is it problematic using patches with win xp?
regards
kapil
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.