E-Db2 Sqr Error (SQR 5528) ODBC SQL dbsql: SQLPrepare error -151 [IBM][CLI Driver][DB2/AIX64] SQL0151N (Doc ID 972744.1)

Last updated on JANUARY 19, 2016

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.40 to 8.54 [Release 8.4]
Information in this document applies to any platform.
***Checked for relevance on 12-AUG-2014***
*** currency checked Jan 2016 ***

Goal

Currently using PT 8.48.19/ on a Db2 Luw environment, and performing a Tools Only Upgrade to PT 8.50.
When executing the step "Running a DBTSFIX Report" the DBTSFIX sqr fails with the message:

(SQR 5528) ODBC SQL dbsql: SQLPrepare error -151 in cursor 1:
[IBM][CLI Driver][DB2/AIX64] SQL0151N The column "AUDITPOLICYNAME" cannot be updated. SQLSTATE=42808


SQL: SELECT TABNAME, TBSPACE FROM SYSCAT.TABLES WHERE SUBSTR(TABNAME, 1, 3) =
'PS_' AND TYPE = 'T'

Error on line 724:
(SQR 3716) Error in SQL statement.

(SQR 5528) ODBC SQL dbsql: SQLPrepare error -151 in cursor 2:
[IBM][CLI Driver][DB2/AIX64] SQL0151N The column "AUDITPOLICYNAME" cannot be updated. SQLSTATE=42808


SQL: SELECT TABNAME, TBSPACE FROM SYSCAT.TABLES WHERE SUBSTR(TABNAME, 1, 3)
<> 'PS_' AND TYPE = 'T'

Error on line 740:
(SQR 3716) Error in SQL statement.


Errors were found in the program file.

SQR for PeopleSoft: Program Aborting.

Solution

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