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

Last updated on AUGUST 02, 2017

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.2 and later
Information in this document applies to any platform.
SPECIFIC TO: Enterprise, PeopleTools
Checked for relevance on 27-Oct-2011

*** Checked For Relevance On 28-Jul-2017 ***

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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms