E-ES: DB2 with ES SQL Error During Build Of PTPORTALREGISTRY (Doc ID 2363964.1)

Last updated on JULY 27, 2022

Applies to:

Symptoms

PTPORTALREGISTRY. Output from PTSF_GENFEED shows SQL error

Error Position: 0 Return: 8602 - [IBM][CLI Driver][DB2] SQL0670N The statement failed because the row or column size of the resulting table would have exceeded the row or column size limit: "". Table space name: "". Resulting row or column size: "". SQLSTATE=54010

 (SQLSTATE 54010) -
Failed SQL stmt: SELECT A.PORTAL_NAME, A.PORTAL_OBJNAME, A.PORTAL_LABEL, A.DESCR254, A.OPRID, A.PORTAL_EFFDT, A.PORTAL_CREATION_DT, A.PORTAL_EXPIRE_DT, A.PORTAL_EXPIRES, A.LASTUPDDTTM, A.PORTAL_CREF_URLT, A.PORTAL_URLEXT, A.PORTAL_BASE_URI, A.PORTAL_CNTPRV_NAM, A.NODE_ITEMNAME, A.PT_URLTEXT, A.PORTAL_NODENAME, A.PORTAL_URLTEXT, '/f/[%A.PT_BASE_URI%%A.PORTAL_NAME%/%A.NODE_ITEMNAME%/%A.PTURLEXT%%A.PT_URLTEXT%%A.PORTAL_NODENAME%%A.PORTAL_URLTEXT%]', A.PORTAL_REFTYPE, B.PORTAL_PRNTLABEL, B.PORTAL_SOURCE, B.PORTAL_NAVPATH, 'psc///q/?ICAction=ICQryImageURL=PUBLIC.PTPORTALTILES&IMGFIELD=CONTIMG&IMGRECORD=PSTILEIMG_VW&PORTAL_NAME=%A.PORTAL_NAME%&PORTAL_OBJNAME=%A.PORTAL_OBJNAME%&PORTAL_REFTYPE=%A.PORTAL_REFTYPE%' FROM (PSPRSM_SRCH_VW A LEFT OUTER JOIN PSPRSMNAVINFO B ON A.PORTAL_NAME = B.PORTAL_NAME AND A.PORTAL_REFTYPE = B.PORTAL_REFTYPE AND A.PORTAL_OBJNAME = B.PORTAL_OBJNAME ) WHERE ( (( A.LASTUPDDTTM > :1 OR A.PORTAL_EFFDT > DATE(CAST(:2 AS TIMESTAMP)) OR A.PORTAL_EXPIRE_DT > DATE(CAST(:3 AS TIMESTAMP))) AND A.PORTAL_EFFDT <= CURRENT DATE AND ( A.PORTAL_EXPIRE_DT IS NULL OR A.PORTAL_EXPIRE_DT >= CURRENT DATE))) ORDER BY 1, 2

Error in running query because of SQL Error, Code=8602, Message=[IBM][CLI Driver][DB2] SQL0670N The statement failed because the row or column size of the resulting table would have exceeded the row or column size limit: "". Table space name: "".

Cause

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