E-SQR: SQR Reports Fails On PSNT/PSUNX With 'Invalid database type'
(Doc ID 642977.1)
Last updated on FEBRUARY 14, 2022
Applies to:
PeopleSoft Enterprise PT PeopleTools - Version 8.2 and laterInformation in this document applies to any platform.
SPECIFIC TO: Enterprise, PeopleTools
*** ***
*** Checked For Relevance On 03-Jan-2019 ***
Symptoms
SQR reports fails on PSNT with 'Invalid database type'. Other process types work fine.
When any SQR reports is run, the following error message appears even though the database type is set correctly :
-------------------------------------------------------------------------
PeopleTools 8 - PSSQR
Copyright (c) 1988-2004 PeopleSoft, Inc.
All Rights Reserved
Invalid database type
Usage: pssqr -CT <dbtype>
Values:
DB2|DB2400|DB2UNIX|INFORMIX|MICROSFT|ORACLE|SYBASE
-CS <server>
-CD <database name>
-CA <access id> [Encrypted by PeopleSoft]
-CAP <access pswd> [Encrypted by PeopleSoft]
-RP <program name>
-I <process instance>
-R <run control id>
-LG <language code>
-CO <operator id>
-COWN <database owner id> (OS/390 only)
-OT <output type>
2 (FILE)
3 (PRINTER)
4 (WINDOW)
5 (EMAIL)
6 (WEB)
-OF <output format> (column headings refer to -OT setting)
FILE PRINTER WINDOW EMAIL WEB
BROWSER
---------- ---------- ---------- --------
-----------
2 (PDF) 4 (HP) 13 (SPF) 2 (PDF) 2 (PDF)
3 (CSV) 6 (LP) 3 (CSV) 3 (CSV)
4 (HP) 10 (PS) 4 (HP) 4 (HP)
5 (HTML) 15 (Other) 5 (HTML) 5 (HTML)
6 (LP) 6 (LP) 6 (LP)
10 (PS) 10 (PS) 10 (PS)
13 (SPF) 13 (SPF) 13 (SPF)
15 (Other)
-OP <output destination>
-PP <"prepend parameters">
-AP <"append parameters">
-FILE <parameter file (WARNING:file will be deleted after -EF <file containing Email parameters>
-EL <email option to include/exclude SQR log and trace
files)>
0 (Exclude Log and Trace files from email)
1 (Include Log and Trace files in email)
-MR <multiple report output> Values: #(max 99)
-------------------------------------------------------------------------
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |