search cancel

Error ORA-00942 when start of the services.

book

Article ID: 257947

calendar_today

Updated On:

Products

CA Service Desk Manager

Issue/Introduction

Hi,

When I run pdm_init in the app servers I get the following errors of oracle:

08/17 13:53:45.76 xxxxxxxxxxxx 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 xxxxxxxxxxxx sqlagt:select23         5469 ERROR        orclclass.c           1314 SELECT count(*) FROM usm_configuration
08/17 13:53:45.76 xxxxxxxxxxxx sqlagt:select23         5469 ERROR        orcl.c                1762  Oracle error #: 0
08/17 13:53:45.76 xxxxxxxxxxxx sqlagt:select23         5469 ERROR        orcl.c                1763  Oracle msg #: 0
08/17 13:53:45.76 xxxxxxxxxxxx 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 xxxxxxxxxxxx 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 xxxxxxxxxxxx sqlagt:select19         5461 ERROR        orclclass.c           1314 SELECT count(*) FROM usm_contact_domain_role
08/17 13:53:45.76 xxxxxxxxxxxx sqlagt:select19         5461 ERROR        orcl.c                1762  Oracle error #: 0
08/17 13:53:45.76 xxxxxxxxxxxx sqlagt:select19         5461 ERROR        orcl.c                1763  Oracle msg #: 0
08/17 13:53:45.76 xxxxxxxxxxxx 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 xxxxxxxxxxxx sqlagt:select4          5425 ERROR        orclclass.c           1314 SELECT count(*) FROM usm_offering WHERE usm_offering.offering_id > 0
08/17 13:53:45.76 xxxxxxxxxxxx sqlagt:select4          5425 ERROR        orcl.c                1762  Oracle error #: 0
08/17 13:53:45.76 xxxxxxxxxxxx sqlagt:select4          5425 ERROR        orcl.c                1763  Oracle msg #: 0
08/17 13:53:45.77 xxxxxxxxxxxx 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 xxxxxxxxxxxx sqlagt:select17         5457 ERROR        orclclass.c           1314 SELECT count(*) FROM usm_tenant_ext
08/17 13:53:45.77 xxxxxxxxxxxx sqlagt:select17         5457 ERROR        orcl.c                1762  Oracle error #: 0
08/17 13:53:45.77 xxxxxxxxxxxx sqlagt:select17         5457 ERROR        orcl.c                1763  Oracle msg #: 0

Environment

Release : 17.3

Cause

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

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

Resolution

Recommended 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.