disp+work.exe problem sql error 942

[Former Member]

Hi experts,

I am Not able to login SAP first time after instalation and getting error:

'SQL ERROR 942 occurred when accessing program SAPM'

Problem Detail:

When i am starting SAPMMC following error occured and i got popup.

'disp+work.exe is facing a problem and need to close'.

Although SAPMMC converted into green status sucessfully.

Process list in SAPMMC is green and there are two processes running

MSG_SERVER.EXE

disp+work.exe (Status: Running message server connection Ok, Dilog Queue time 0.00 sec)

When I am trying to login through through SAPLOGON i am getting the following error

'SQL ERROR 942 occurred when accessing program SAPM'

This is SAP 4.7 Version with Oracle 8i and windows SP2 as OS.

[Former Member]

Hi Experts,

Thanks for your answers...

This is Windows XP Service Pack 2 .

I have done 2 times reinstalation but problem not solved and it is the same . Please help how i may solve it ?

Thanks & Regards,

Rohit

[Former Member]

Hi

Will you check OS & Database patches properly?

Its recomend you to used win2003 Enterprise edition & patch it properly first & after instalation database, apply database patch also. Its seen loopholes in your instaltion so that you face this problem at OS level.

[markus_doehr2]

> This is Windows XP Service Pack 2 .

> I have done 2 times reinstalation but problem not solved and it is the same . Please help how i may solve it ?

The problem can't be solved because:

- Windows XP is not released as an OS for SAP R/3 4.7

- Oracle 8i will not run on Windows XP (same as with Windos 2003)

- your software is both already out of maintenance

Markus

[former_member204746]

I am locking this topic.

all version installed are not supported. it has all the looks for an illegal installation.

[markus_doehr2]

> This is SAP 4.7 Version with Oracle 8i and windows SP2 as OS.

If you mean Windows 2003 then you're out of luck, Oracle 8i was never supported on that OS - and is YEARS out of support for 4.7.

Markus

[Former Member]

>>This is SAP 4.7 Version with Oracle 8i and windows SP2 as OS.

Is this real installation? why you installing 4.7 and oracle 8i? have you checked the service.sap.com/pam for product support?

make sure R3trans -d works, and go through the trans.log (this file get created under same location from where you execute R3trans)

then check dev_w0, dev_disp which is under instance work directory.

[audunlea_hansen]

Hi!

ORA-942: "table or view does not exist"

Seems like you are missing a table or view, or you have some syntax error in the sql pointing you to a object that doesn't exists. Have seen the error if you have no grants on the object, but that should not be a problem here.

Regards

Audun

DBA