EGL: CMgrSqlParser::ParseStatement: failed to parse SQL statement - Upgrading from 9.1 to 9.2 Image 11 Performing Task 2-4 (Doc ID 2126864.1)

Last updated on JUNE 21, 2016

Applies to:

PeopleSoft Enterprise FIN General Ledger - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

ISSUE
--------
Post upgrade from 9.1 to 9.2 Image 11 during step 2-4, while running chartfield configuration the following message was seen in the log file even though process went to success:

CMgrSqlParser::ParseStatement: failed to parse SQL statement
 
ERROR (error occurred 4 times) 
---------------
1st occurrence:
58787 10:09:07.513 0.000635 15: SQLExec("%InsertSelect(DISTINCT, PSPROJECTITEM, PSRECFIELD, PROJECTNAME='" | &aProjAdd [1] | "', OBJECTTYPE=0, OBJECTID1=1, OBJECTVALUE1=RECNAME, TAKEACTION=1) FROM PSRECFIELD WHERE FIELDNAME IN (" | &MODELCF | ") AND NOT EXISTS (SELECT 'X' FROM PS_CF_CHRT_REC A WHERE A.RECNAME=PSRECFIELD.RECN
58788 10:09:07.525 0.011992 Cur#1.17537.PSGF3R RC=0 Dur=0.010925 COM Stmt=INSERT INTO PSPROJECTITEM (PROJECTNAME, OBJECTTYPE, OBJECTID1, OBJECTVALUE1, OBJECTID2, OBJECTVALUE2, OBJECTID3, OBJECTVALUE3, OBJECTID4, OBJECTVALUE4, NODETYPE, SOURCESTATUS, TARGETSTATUS, UPGRADEACTION, TAKEACTION, COPYDONE) SELECT DISTINCT 'CF~20160315100907', 0, 1, RECNAME, 0, ' ', 0, ' ', 0, ' ', 0, 0, 0, 0, 1, 0 FROM PSRECFIELD WHERE FIELDNAME IN ('CHARTFIELD2') AND NOT EXISTS (SELECT 'X' FROM PS_CF_CHRT_REC A WHERE A.RECNAME=PSRECFIELD.RECNAME)
58789 10:09:07.526 0.000872 CMgrSqlParser::ParseStatement: Parser lacks support for SQL statement INSERT INTO PSPROJECTITEM (PROJECTNAME, OBJECTTYPE, OBJECTID1, OBJECTVALUE1, OBJECTID2, OBJECTVALUE2, OBJECTID3, OBJECTVALUE3, OBJECTID4, OBJECTVALUE4, NODETYPE, SOURCESTATUS, TARGETSTATUS, UPGRADEACTION, TAKEACTION, COPYDONE) SELECT DISTINCT 'CF~20160315100907', 0, 1, RECNAME, 0, ' ', 0, ' ', 0, ' ', 0, 0, 0, 0, 1, 0 FROM PSRECFIELD WHERE FIELDNAME IN ('CHARTFIELD2') AND NOT EXISTS (SELECT 'X' FROM PS_CF_CHRT_REC A WHERE A.RECNAME=PSRECFIELD.RECNAME)

2nd occurrence:
58790 10:09:07.534 0.007785 16: SQLExec("%InsertSelect(DISTINCT, PSPROJECTITEM, PSPNLFIELD, PROJECTNAME='" | &aProjAdd [1] | "', OBJECTTYPE=5, OBJECTID1=9, OBJECTVALUE1=PNLNAME, TAKEACTION=1) FROM PSPNLFIELD WHERE FIELDNAME IN (" | &CFLIST | ") AND NOT EXISTS (SELECT 'X' FROM PS_CF_CHRT_PNL A WHERE A.PNLNAME=PSPNLFIELD.PNLNA
58791 10:09:07.544 0.009826 Cur#1.17537.PSGF3R RC=0 Dur=0.008673 COM Stmt=INSERT INTO PSPROJECTITEM (PROJECTNAME, OBJECTTYPE, OBJECTID1, OBJECTVALUE1, OBJECTID2, OBJECTVALUE2, OBJECTID3, OBJECTVALUE3, OBJECTID4, OBJECTVALUE4, NODETYPE, SOURCESTATUS, TARGETSTATUS, UPGRADEACTION, TAKEACTION, COPYDONE) SELECT DISTINCT 'CF~20160315100907', 5, 9, PNLNAME, 0, ' ', 0, ' ', 0, ' ', 0, 0, 0, 0, 1, 0 FROM PSPNLFIELD WHERE FIELDNAME IN ('ACCOUNT','DEPTID','PROJECT_ID','AFFILIATE','CHARTFIELD2') AND NOT EXISTS (SELECT 'X' FROM PS_CF_CHRT_PNL A WHERE A.PNLNAME=PSPNLFIELD.PNLNAME)
58792 10:09:07.545 0.000850 CMgrSqlParser::ParseStatement: Parser lacks support for SQL statement INSERT INTO PSPROJECTITEM (PROJECTNAME, OBJECTTYPE, OBJECTID1, OBJECTVALUE1, OBJECTID2, OBJECTVALUE2, OBJECTID3, OBJECTVALUE3, OBJECTID4, OBJECTVALUE4, NODETYPE, SOURCESTATUS, TARGETSTATUS, UPGRADEACTION, TAKEACTION, COPYDONE) SELECT DISTINCT 'CF~20160315100907', 5, 9, PNLNAME, 0, ' ', 0, ' ', 0, ' ', 0, 0, 0, 0, 1, 0 FROM PSPNLFIELD WHERE FIELDNAME IN ('ACCOUNT','DEPTID','PROJECT_ID','AFFILIATE','CHARTFIELD2') AND NOT EXISTS (SELECT 'X' FROM PS_CF_CHRT_PNL A WHERE A.PNLNAME=PSPNLFIELD.PNLNAME)

3rd occurrence:
58807 10:09:07.770 0.000758 57: SQLExec("%InsertSelect(PSPROJECTITEM, PSPROJECTITEM, PROJECTNAME='" | &aProjReorder [&i] | "') FROM PSPROJECTITEM WHERE PROJECTNAME = :1 AND OBJECTTYPE IN (5,18,31,32,37) AND NOT EXISTS (SELECT 'X' FROM %Table(CF_PRJITM_TAO) WHERE PROCESS_INSTANCE = :2 AND PROJECTNAME IN (" | &ExclProj | ") AN
58808 10:09:07.771 0.000952 Fetch Field: FS_CF_UPD_AET.PROCESS_INSTANCE Value=2409195
58809 10:09:07.776 0.005592 Cur#1.17537.PSGF3R RC=0 Dur=0.004573 COM Stmt=INSERT INTO PSPROJECTITEM (PROJECTNAME, OBJECTTYPE, OBJECTID1, OBJECTVALUE1, OBJECTID2, OBJECTVALUE2, OBJECTID3, OBJECTVALUE3, OBJECTID4, OBJECTVALUE4, NODETYPE, SOURCESTATUS, TARGETSTATUS, UPGRADEACTION, TAKEACTION, COPYDONE) SELECT 'CF~R20160315100907', OBJECTTYPE, OBJECTID1, OBJECTVALUE1, OBJECTID2, OBJECTVALUE2, OBJECTID3, OBJECTVALUE3, OBJECTID4, OBJECTVALUE4, NODETYPE, SOURCESTATUS, TARGETSTATUS, UPGRADEACTION, TAKEACTION, COPYDONE FROM PSPROJECTITEM WHERE PROJECTNAME = :1 AND OBJECTTYPE IN (5,18,31,32,37) AND NOT EXISTS (SELECT 'X' FROM PS_CF_PRJITM_TAO4 WHERE PROCESS_INSTANCE = :2 AND PROJECTNAME IN ('FS_CF_REORDER') AND OBJECTTYPE=PSPROJECTITEM.OBJECTTYPE AND OBJECTID1=PSPROJECTITEM.OBJECTID1 AND OBJECTVALUE1=PSPROJECTITEM.OBJECTVALUE1) AND NOT EXISTS (SELECT 'X' FROM PSPNLDEFN WHERE PNLNAME = PSPROJECTITEM.OBJECTVALUE1 AND OBJECTOWNERID = 'FPC')
58810 10:09:07.777 0.001153 CMgrSqlParser::ParseStatement: Parser lacks support for SQL statement INSERT INTO PSPROJECTITEM (PROJECTNAME, OBJECTTYPE, OBJECTID1, OBJECTVALUE1, OBJECTID2, OBJECTVALUE2, OBJECTID3, OBJECTVALUE3, OBJECTID4, OBJECTVALUE4, NODETYPE, SOURCESTATUS, TARGETSTATUS, UPGRADEACTION, TAKEACTION, COPYDONE) SELECT 'CF~R20160315100907', OBJECTTYPE, OBJECTID1, OBJECTVALUE1, OBJECTID2, OBJECTVALUE2, OBJECTID3, OBJECTVALUE3, OBJECTID4, OBJECTVALUE4, NODETYPE, SOURCESTATUS, TARGETSTATUS, UPGRADEACTION, TAKEACTION, COPYDONE FROM PSPROJECTITEM WHERE PROJECTNAME = :1 AND OBJECTTYPE IN (5,18,31,32,37) AND NOT EXISTS (SELECT 'X' FROM PS_CF_PRJITM_TAO4 WHERE PROCESS_INSTANCE = :2 AND PROJECTNAME IN ('FS_CF_REORDER') AND OBJECTTYPE=PSPROJECTITEM.OBJECTTYPE AND OBJECTID1=PSPROJECTITEM.OBJECTID1 AND OBJECTVALUE1=PSPROJECTITEM.OBJECTVALUE1) AND NOT EXISTS (SELECT 'X' FROM PSPNLDEFN WHERE PNLNAME = PSPROJECTITEM.OBJECTVALUE1 AND OBJECTOWNERID = 'FPC')
58811 10:09:07.778 0.000767 Cur#1.17537.PSGF3R RC=0 Dur=0.000001 Bind-1 type=2 length=17 value=CF~20160315100907
58812 10:09:07.779 0.000751 Cur#1.17537.PSGF3R RC=0 Dur=0.000000 Bind-2 type=19 length=7 value=2409195

4th occurrence:
58816 10:09:07.854 0.000642 60: SQLExec("%InsertSelect(PSPROJECTITEM, PSPROJECTITEM, PROJECTNAME='" | &aProjDisplay [&i] | "') FROM PSPROJECTITEM WHERE PROJECTNAME = :1 AND NOT EXISTS (SELECT 'X' FROM %Table(CF_PRJITM_TAO) B WHERE PROCESS_INSTANCE = :2 AND B.PROJECTNAME = 'FS_CF_DISPLAY_LENGTH' AND B.OBJECTTYPE=PSPROJECTITEM
58817 10:09:07.855 0.000857 Fetch Field: FS_CF_UPD_AET.PROCESS_INSTANCE Value=2409195
58818 10:09:07.860 0.004693 Cur#1.17537.PSGF3R RC=0 Dur=0.003796 COM Stmt=INSERT INTO PSPROJECTITEM (PROJECTNAME, OBJECTTYPE, OBJECTID1, OBJECTVALUE1, OBJECTID2, OBJECTVALUE2, OBJECTID3, OBJECTVALUE3, OBJECTID4, OBJECTVALUE4, NODETYPE, SOURCESTATUS, TARGETSTATUS, UPGRADEACTION, TAKEACTION, COPYDONE) SELECT 'CF~Z20160315100907', OBJECTTYPE, OBJECTID1, OBJECTVALUE1, OBJECTID2, OBJECTVALUE2, OBJECTID3, OBJECTVALUE3, OBJECTID4, OBJECTVALUE4, NODETYPE, SOURCESTATUS, TARGETSTATUS, UPGRADEACTION, TAKEACTION, COPYDONE FROM PSPROJECTITEM WHERE PROJECTNAME = :1 AND NOT EXISTS (SELECT 'X' FROM PS_CF_PRJITM_TAO4 B WHERE PROCESS_INSTANCE = :2 AND B.PROJECTNAME = 'FS_CF_DISPLAY_LENGTH' AND B.OBJECTTYPE=PSPROJECTITEM.OBJECTTYPE AND B.OBJECTID1=PSPROJECTITEM.OBJECTID1 AND B.OBJECTVALUE1=PSPROJECTITEM.OBJECTVALUE1)
58819 10:09:07.861 0.000942 CMgrSqlParser::ParseStatement: Parser lacks support for SQL statement INSERT INTO PSPROJECTITEM (PROJECTNAME, OBJECTTYPE, OBJECTID1, OBJECTVALUE1, OBJECTID2, OBJECTVALUE2, OBJECTID3, OBJECTVALUE3, OBJECTID4, OBJECTVALUE4, NODETYPE, SOURCESTATUS, TARGETSTATUS, UPGRADEACTION, TAKEACTION, COPYDONE) SELECT 'CF~Z20160315100907', OBJECTTYPE, OBJECTID1, OBJECTVALUE1, OBJECTID2, OBJECTVALUE2, OBJECTID3, OBJECTVALUE3, OBJECTID4, OBJECTVALUE4, NODETYPE, SOURCESTATUS, TARGETSTATUS, UPGRADEACTION, TAKEACTION, COPYDONE FROM PSPROJECTITEM WHERE PROJECTNAME = :1 AND NOT EXISTS (SELECT 'X' FROM PS_CF_PRJITM_TAO4 B WHERE PROCESS_INSTANCE = :2 AND B.PROJECTNAME = 'FS_CF_DISPLAY_LENGTH' AND B.OBJECTTYPE=PSPROJECTITEM.OBJECTTYPE AND B.OBJECTID1=PSPROJECTITEM.OBJECTID1 AND B.OBJECTVALUE1=PSPROJECTITEM.OBJECTVALUE1)
58820 10:09:07.861 0.000654 Cur#1.17537.PSGF3R RC=0 Dur=0.000001 Bind-1 type=2 length=17 value=CF~20160315100907
58821 10:09:07.862 0.000616 Cur#1.17537.PSGF3R RC=0 Dur=0.000000 Bind-2 type=19 length=7 value=2409195

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