sql error 942 occured when accessing program CL_A

[former_member182034]

Dear all,

I was applying SAPKB and SAPKA support package and during Support Packages(SAPKB70016) , i am getting following error.

sql error 942 occured when accessing program CL_A

your help is required.

Regards,

[Former Member · Accepted solution]

Hi,

Check the note 662644 - Composite SAP Note: ORA-00942

Best regards,

Orkun Gedik

[former_member182034 · Accepted solution]

hi Dear,

i read this 662644 but no luck and I am getting following dumps against different transactions.

DBIF_RSQL_TABLE_UNKNOWN

DDIC_REFTYPE_INCONSISTENT

DBIF_REPO_SQL_ERROR

with

sql error 942 occured when accessing program CL_???

Regards,

[Former Member · Accepted solution]

hi Dear,
> i read this 662644 but no luck and I am getting following dumps against different transactions.
> DBIF_RSQL_TABLE_UNKNOWN
> DDIC_REFTYPE_INCONSISTENT
> DBIF_REPO_SQL_ERROR 
> with 
> sql error 942 occured when accessing program CL_???
> 
> Regards,

Hi Majamil,

Could you provide table names that you faced in the shortdump, when you called the transaction?

Best regards,

Orkun Gedik

[former_member182034 · Accepted solution]

hi Orkun

I am only getting Dump and 00942 error on every transaction. when i run ST22 and click on dumps(Today, Yesterday) then i got DDIC_REFTYPE_INCONSISTENT with sql error 942 occured when accessing program CL_G.

how can i get the table? while no transaction is being complete successfully.

fyi... I got following error during SAPKB70016 and found below tables

The SQL Statement was not executed
Index could not be created completely in the database
Index REPOSRC-SPM could not be created

while you can see that above table is inconsistent

SQL> select tabname from SAPSR3.ddntt where tabform = 'T' and tabtype in ('T','P
','C') minus select table_name from dba_tables;

TABNAME
-----------------------

REPOSRC

the PAT05 table exist in SE14 while TRBA3 is not in SE14.

SQL> SELECT TABLE_NAME FROM DBA_TABLES WHERE TABLE_NAME LIKE 'PAT05%';

TABLE_NAME
------------------------------
PAT05

SQL> SELECT TABLE_NAME FROM DBA_TABLES WHERE TABLE_NAME LIKE 'TRBA3%';

no rows selected

Regards,

[Former Member · Accepted solution]

Hi Majamil,

I didn't say to call ST22 to see shortdumps, I said you check the shortdump when you face it. Are those dumps are occurred at the background? Or foreground?

Anyway, are you able to execute the statement, successfully on Sqlplus?

Select * from dbowner.reposrc;

By the way, I suggest you to check datafiles with "dbv" command

Best regards,

Orkun Gedik

[former_member182034 · Accepted solution]

hi Orkun,

SQL> Select * from dbowner.reposrc;
Select * from dbowner.reposrc
                      *
ERROR at line 1:
ORA-00942: table or view does not exist

Regards,

[Former Member · Accepted solution]

Hi Majamil,

Replace "dbowner" with owner of the database, for example sapsr3.reposrc. Then execute the command.

Best regards,

Orkun Gedik

[former_member182034 · Accepted solution]

Dear Orkun,

sorry, I executed with sapsr3.reposrc but sent you wrong.

anyways... i am getting same if i execute with sapsr3.reposr,

Regards,

[Former Member · Accepted solution]

Majamil,

Have you found your solution yet? Looks like Orkun was trying to see if you actually had the table in question. Usually not a good start if the table(s) is missing.

Sincerely,

Mike Kennedy

[former_member182034 · Accepted solution]

not yet..

now I will restore the system on coming weekend.

Regards,