I got an error during sap 4.7 insatallation the error message:DDL statement failed SQL Error:942ORA 00942: table or view does not exist, it has occured at the time of last job (database loading). Please help me.

Hi,Please check first if you`ve got all valid objects :select count(*) from dba_objects where status=`INVALID`; You should have 0 objects. If more :-) please run :/oracle/SID/......./rdbms/admin/utlrp.sqlif script errors, you`re at the same level as me.

Guest |

| 13 Apr 2009 1:49 pm

Hi ,

Start the Query analyser for MSSQL and then run the command -- select @@version. This will give you the exact version of the database. Start the enterprise manager and right click the master database there you see the properties check the collation type there .It can be bin1 or bin2. Now bin1 with SP4 is good enough for ECC5 NON-UNICODE but you will definitely need BIN2 with SP4 for making a UNICODE system. In short collation is the BIN1 or BIN2 types of the Master DB they have to be in proper order for the installation to start.Either of these are required.

Guest |

| 13 Apr 2009 1:49 pm

Hi,

I tried installation again, I am not sure where I am going wrong, I have installed sql server 2000 , on windows advance server 2000 I have applied service packs 3,4 and Hotfix also. the BINN directory is there. so please advise , how to go about. regards puneet.

Guest |

| 13 Apr 2009 1:49 pm

Hi,

After installing SQL 2000 server,service packs and hotfix you have to execute instcoll.exe file ,which is located in instcoll folder in service pack CD. Now the collation setting is changed to BIN2.

Guest |

| 13 Apr 2009 1:49 pm

Hi,

I tried the same as mentioned by you, It gives me this error on execution of instcoll.exe file The current collation is SQL_Latin1_general_CP1_CI_AS , not SQL_Latin1_General_CP850_BIN Please reinstall SQL_SERVER with collation SQL_Latin1_General_CP850_BIN then install the unicode hotfix (QFE) Nothing done. Please guide me further how do i proceed.

SAP to Re-Engineer the Indian Postal ServiceMost of us would not be aware of the fact that the Department of Posts has been in existence for more than 150 years. The Department has touched the lives of million of Indians ever since it started its operations, right from delivering letters to their near and dear ones, enabling them to send...

SAP Focuses On The Banking SectorSAP is known all over the world as the market leader in the field of ERP (Enterprise Resource Planning), CRM solutions and financial accounting. The brand has been consistently working towards achieving as well as delivering real standard software along with managing technology renewal cycles...

SAP Updates Failures Impact the Efforts of CompaniesUpgrading SAP processes is more often than not considered as a costly, time consuming and inefficient function for businesses, thereby leading to a scarcity in SAP updates. Over 33 percent of companies using the popular Oracle E-Business Suite have failed to upgrade their modules. 40...

SAP HANA set to change the face of Indian Railways Ticketing SystemDid you know that at an average Indian Railways sells close to 21 million tickets daily? Almost 250 million tickets are booked via IRCTC annually. At 8:00am when the booking window opens thousands of people are waiting to get their tickets booked both online as well as at the railway reservation...

Why is SAP Considered as one of the Highest Paid Jobs?Candidates who are looking for employment wants to acquire SAP certification as it offer extraordinary compensation. The most widely used ERP system currently is SAP due to which a SAP consultant gets lots of opportunities. The extensive use of SAP (Systems, Applications, Products in Data...

ERROR Installing SAP 4.7
Hi There I am having trouble installing SAP 4.7 on my laptop. I am having the following error: MOS-01224 Failed to add privileges 'SeTcbPrivilege SeAssignPrimaryTokenPrivilege...

SAP 4.7 IDES Installatio Error
Hi all I was installing SAP 4.7 IDES... but in Database Load Post Processing error ocur the error is listed below when i try to check that the Databs is running or not it give me error ...

SAP Installation 4.7 IDES
Greetings Freinds, Please help me with the below issue, i am trying to install 4.7 IDES and failing during the SAPINST, please find below the logs and kindly help me out Please write back to me on...

Error installing 4.7IDES
Hi my son installing 4.7IDEs to begin with learning SAP but getting errors in attached log files. We have followed steps from friends and from the internet but still same error. I would highly...