Error ORA-00942 when start of the services.

Products

• CA Service Desk Manager

Issue/Introduction

When running pdm_init in the app servers the following Oracle errors are returned:

08/17 13:53:45.76 <Server Name> sqlagt:select23         5469 ERROR        orclclass.c           1313 SQL Statement Failed. ORA: 942  Message: ORA-00942: table or view does not exist
08/17 13:53:45.76 <Server Name> sqlagt:select23         5469 ERROR        orclclass.c           1314 SELECT count(*) FROM usm_configuration
08/17 13:53:45.76 <Server Name> sqlagt:select23         5469 ERROR        orcl.c                1762  Oracle error #: 0
08/17 13:53:45.76 <Server Name> sqlagt:select23         5469 ERROR        orcl.c                1763  Oracle msg #: 0
08/17 13:53:45.76 <Server Name> bpvirtdb_srvr           5385 ERROR        vdbmisc.c              688 Miscellaneous Database error occured :ORA-00942: table or view does not exist
08/17 13:53:45.76 <Server Name> sqlagt:select19         5461 ERROR        orclclass.c           1313 SQL Statement Failed. ORA: 942  Message: ORA-00942: table or view does not exist
08/17 13:53:45.76 <Server Name> sqlagt:select19         5461 ERROR        orclclass.c           1314 SELECT count(*) FROM usm_contact_domain_role
08/17 13:53:45.76 <Server Name> sqlagt:select19         5461 ERROR        orcl.c                1762  Oracle error #: 0
08/17 13:53:45.76 <Server Name> sqlagt:select19         5461 ERROR        orcl.c                1763  Oracle msg #: 0
08/17 13:53:45.76 <Server Name> sqlagt:select4          5425 ERROR        orclclass.c           1313 SQL Statement Failed. ORA: 942  Message: ORA-00942: table or view does not exist
08/17 13:53:45.76 <Server Name> sqlagt:select4          5425 ERROR        orclclass.c           1314 SELECT count(*) FROM usm_offering WHERE usm_offering.offering_id > 0
08/17 13:53:45.76 <Server Name> sqlagt:select4          5425 ERROR        orcl.c                1762  Oracle error #: 0
08/17 13:53:45.76 <Server Name> sqlagt:select4          5425 ERROR        orcl.c                1763  Oracle msg #: 0
08/17 13:53:45.77 <Server Name> sqlagt:select17         5457 ERROR        orclclass.c           1313 SQL Statement Failed. ORA: 942  Message: ORA-00942: table or view does not exist
08/17 13:53:45.77 <Server Name> sqlagt:select17         5457 ERROR        orclclass.c           1314 SELECT count(*) FROM usm_tenant_ext
08/17 13:53:45.77 <Server Name> sqlagt:select17         5457 ERROR        orcl.c                1762  Oracle error #: 0
08/17 13:53:45.77 <Server Name> sqlagt:select17         5457 ERROR        orcl.c                1763  Oracle msg #: 0

Environment

Service Desk Manager 17.3 and higher

Cause

The NX.env file doesn't have any Catalog-related environment variables, but the ddict.sch has references for many Catalog-related tables.

If this is a fresh installation of Service Desk, this should not be happening.

Resolution

Recommend to locate another Linux server where Service Desk was installed correctly and:

1. On the server with this problem, back up your NX_ROOT/site/sch folder and NX_ROOT/site/dditct.sch file.

2. Copy the NX_ROOT/site/sch folder from a computer where this is working to the computer with the problem.

3. Then perform pdm_configure and verify the issue.