E-UPG/Db2: [IBM][CLI Driver][DB2/AIX64] SQL0513W The SQL Statement will Modify an entire Table or View.

(Doc ID 2103687.1)

Last updated on FEBRUARY 09, 2016

Applies to:

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

Symptoms

ENVIRONMENT:
==========
DB2/LUX 10.5
Application 9.2 / PeopleTools 8.54
 

PROBLEM STATEMENT:
=====================

Encountered an error while running the PeopleTools Data Conversion step: 

UPGCONVERT process ABENDED at Step UPGPTPGDATA.UpgData.UpdDATPG (PeopleCode)

 with the following error message


'UPGPTPGDATA' Program Started (226,2)
SQL error. Function: CreateSQL
  Error Position: 0
  Return: 8616 - [IBM][CLI Driver][DB2/AIX64] SQL0513W The SQL statement will modify an entire table or view. SQLSTATE=01504
 (SQLSTATE 01504) 513
  Statement: UPDATE PSPGVIEWOPT SET PTPG_ROWS_GRID=' ', PTPG_CLMNS_GRID=' ', PTPG_FLRS_GRID=' ', PTPG_FLRS_GRID_EX=:1
  Original Statement: UPDATE PSPGVIEWOPT SET PTPG_ROWS_GRID=' ', PTPG_CLMNS_GRID=' ', PTPG_FLRS_GRID=' ', PTPG_FLRS_GRID_EX=%TextIn(:1) (0,0)
Fatal SQL error occurred. (2,125) UPGPTPGDATA.UpgData.GBL.default.1900-01-01.UpdDATPG.OnExecute PCPC:5695 Statement:36
 Message Set Number: 2

STEPS to replicate the error:
=====================
1. Run the Upgrade job
2. Task Peopletools Objects
3. Data Conversion step
4. UPGCONVERT process ABENDED at Step UPGPTPGDATA

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