My Oracle Support Banner

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 NOVEMBER 13, 2019

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

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution
References


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