Description
When doing an extraction of PeopleSoft source code, in the extraction log, you observe many errors like:
MESSAGE*M2015-08-17 12:58:22.108 - Extraction error: ORA-00903: invalid table name
cast.dmt.extractor.squirrel.processOutput*MESSAGE**2015-08-17 12:58:09.840 - null Line 176: from null.PSPCMNAME
Observed in CAST AIP
Release | Yes/No |
|---|---|
| 8.0.x |  |
| 7.3.x | |
| 7.2.x | |
| 7.0.x |  |
Observed on RDBMS
This section is not applicable for this page(DMT)
RDBMS | Yes/No |
|---|---|
| Oracle Server | NA |
| Microsoft SQL Server | NA |
| CSS2 | NA |
| CSS1 | NA |
Step by Step Scenario
- Open DMT
- Do an extraction of the peopleSoft code
- Open the extraction log and observe reported errors
Action Plan
- You have to check that the selected schema contains PeopleSoft tables (PSRECDEFN, …)
Figure 1
For example, in the screenshot above, we have to check that the phtest schema selected contains PeopleSoft tables (as PSRECDEFN for example)
If it is not the case, it cannot be selected as schema as this will lead to reported null schema error
Impact on Analysis Results and Dashboard
When you get the error, the extraction is not proper as it will not contain Peoplesoft tables.
When resolving the error, extraction will contain tables to be analyzed
Notes/comments
Ticket # 3013
Related Pages
