E-UPG: Compare Report Option "Generate output to table" Leads to Arithmetic Overflow Error (Doc ID 1408718.1)

Last updated on APRIL 25, 2016

Applies to:

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

Symptoms

Running a large project compare in PeopleTools 8.52 leads to a SQL error when report option "Generate output to table" is checked.  The issue affects multiple database platforms, including Oracle, MS SQL Server and DB2 platforms. 

REPLICATION STEPS
=================
1. Open a large project with many different components
2. Tools, Compare and Report.
3. Sign in to an upgrade target database.
4. Go to Options before running Compare
5. Go to Report Options tab
6. For Report Output, select "Generate Output to Tables"
7. Run compare

Sample ERRORS
=================

All database platforms see the error "Error inserting into PSCOMPOBJDIFF", with a preceding error indicating an overflow or value too large problem.

For example, on SQL Server platforms:

System Error : File: E:\pt85204b-retail\peopletools\src\pssys\cmputil.cppSQL error. Stmt #: 337 Error Position: 0 Return: 8608 - [Microsoft][SQL Server Native Client 10.0][SQL Server]Arithmetic overflow error for data type smallint, value nt, (62,16)
System Error : PTRECNAME1, PTRECNAME2, PTRECNAME3, PTRECNAME4, PTRECNAME5, PTRECNAME6, PTRECNAME7, PTRECNAME8, PTRECNAME9, PTRECNAME10, PTTABLENAME1, PTTABLENAME2, PTTABLENAME3, PTTABLENAME4, PTTABLENAME5, PTTABLENAME6, PTTABLENAME7, PTTABLTNCO (62,16)
System Error : COL11, PTKEYCOL12, PTKEYCOL13, PTKEYCOL14, PTKEYCOL15, PTKEYCOL16, PTKEYVALUE1, PTKEYVALUE2, PTKEYVALUE3, PTKEYVALUE4, PTKEYVALUE5, PTKEYVALUE6, PTKEYVALUE7, PTKEYVALUE8, PTKEYVALUE9, PTKEYVALUE10, PTKEYVALUE11, PTKEYVALUE12, YP0, (62,16)
System Error : LVALTYPE, PTREMOTEVALTYPE, PTLOCALVALUE, PTREMOTEVALUE, PTMERGEACTION, PTMERGESTATUS, SEQNO) VALUES ( :1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21, :22, :23, :24, :, : (62,16)
System Error : :78, :79, :80, :81, :82, :83, :84, :85, :86, :87, :88, :89, :90, :91, :92, :93, :94, :95) (62,16)
SQL Error inserting into PSCOMPOBJDIFF
SQL Error inserting into PSCOMPOBJDIFF
SQL Error inserting into PSCOMPOBJDIFF
SQL Error inserting into PSCOMPOBJDIFF
...
SQL Error inserting into PSCOMPOBJDIFF
SQL Error inserting into PSCOMPOBJDIFF
Internal Error: invalid transaction handle instance passed from SamDestroy 0: 71 vs 0

DB2 platforms sample error:

[IBM][CLI Driver] CLI0111E  Numeric value out of range. SQLSTATE=22003 (SQLSTATE 22003) -99999PE, PTTYPENAME, OB,  (62,16)

Oracle platforms sample errors:

ORA-12899: value too large for column "SYSADM"."PSCOMPOBJDIFF"."PTTYPENAME"
ORA-00001: unique constraint (SYSADM.PS_PSCOMPOBJDIFF) violated RT INTO PSCOMPOBJDIFF (PTSESSIONID, PTPRESENCE,EYNA (62,16)

 

Information on "Generate Output to Table" option from PeopleBooks:
=================
Generate Output to Tables: Select this option to write the compare output to database tables. This enables you to keep a historical record of your compares in your database, and it also provides you the flexibility of being able to design custom queries for analyzing specific definitions, attributes, and so on.

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