E-DAM Psarchive.Rowbased.Step001.Peoplecode Creating Invalid Sql Statement (Doc ID 1407943.1)

Last updated on SEPTEMBER 29, 2015

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.51 and later
Information in this document applies to any platform.
** Currency checked Oct 2013 **
** Currency checked Sept 2015 **

Symptoms


On : PeopleTools 8.51 version, Data Archive Manager

When attempting to run the "remove from history " during data archive process, by selecting
Row based processing options in Oracle platform,
the following error occurs.

ERROR
-----------------------
Begin PSARCHIVE (142,105)

Archive ID = KC_DAPC, Archive Process = H, Batch Number = 748, Query = ,
Audit Row = Y, Restart = N (142,104)

Processing PSAPMSGPUBDATA (142,89)

SQL error. Function: SQL.Execute

Error Position: 173

Return: 936 - ORA-00936: missing expression

Statement: select
psarch_id,psarch_batchnum,ibtransactionid,ib_segmentindex,segmentno,subsegment
no,dataseqno,uncompmimedatalen,compmimedatalen,mimedatalong from
ps_kc_apmsgphd_h where WHERE PSARCH_ID = 'KC_DAPC' AND PSARCH_BATCHNUM = 748

Original Statement: %SelectAll(:1) WHERE WHERE PSARCH_ID = 'KC_DAPC' AND
PSARCH_BATCHNUM = 748

Fatal SQL error occurred. (2,125)
PSARCHIVE.ROWBASED.GBL.default.1900-01-01.Step001.OnExecute PCPC:5067
Statement:79

Process 2766258 ABENDED at Step PSARCHIVE.ROWBASED.Step001 (PeopleCode) -- RC
= 8 (108,524).




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