E-SQR: "(SQR 1305) CMPSQL: Unknown data type in database: 492" Error Occurs When Reading BIGINT Datatype

(Doc ID 1967053.1)

Last updated on FEBRUARY 22, 2016

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.51 and later
Information in this document applies to any platform.

Symptoms

SQR functionality does not work with BIGINT data type for DB2 database.

When attempting to run the SQR report on DB2 database using BIGINT field type the following error occurs:

Error:
-------
"(SQR 1305) CMPSQL: Unknown data type in database: 492."

The issue does only occur when running the sample piece of code from Process
Scheduler and not from command line using sqrw.exe.

Steps:
-------
The issue can be reproduced at will with the following steps:
1. Login to PIA;
2. Created a new BIGINT SQR process
3. The sqr program has the following piece of code:

begin-select
log.[Table column]
from  [Table Name] log
end-select

!where table column is defined in the DB2 as BIGINT datatyype

4. Navigate to Process Scheduler > System Process Requests
5. Select an existing Run Control Id or add a new one;
Create a new run cntrl id (e.g. bigint_test)
6. Run the BIGINT SQR - tested on  PSNT process scheduler
7. Go to the View Log/Trace page
8. Open the "*.out" file generated (e.g. "BIGINT_13124.out")
9. The error occurs

 

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