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
Service Desk Manager 17.3 and higher
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.
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.