E-SQR: SQR Reports Fails On PSNT/PSUNX With 'Invalid database type' (Doc ID 642977.1)

Last updated on FEBRUARY 14, 2022

Applies to:

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.