SAP Knowledge Base Article - Preview

2858626 - Error 'An unexpected token "PMTEMP T" was found' updating model into repository - SAP PD

Symptom

  • Connecting to the Repository database via the Proxy.
  • Error is returned when updating a Physical Data Model (PDM) into the repository:

- Updating the repository document...
Some errors occur during the update of the repository model.
Unexpected error while executing SQL statements in the repository
A command sent to the repository proxy failed.
42601 (SQLSTATE [IBM][CLI Driver][DB2/AIX64] SQL0104N An unexpected token "PMTEMP T" was found following "ete from PMRLSH from". Expected tokens may include: "<space>". SQLSTATE=42601
)
Query: delete from PMRLSH from PMTEMP T join PMOBJT O on T.NUM2=O.OBJT where PMRLSH.PRNT=1 and T.SESS=562213652 and O.CLSS=1 and PMRLSH.SRCE=T.NUM2 and not exists (select 1 from PMTEMP where SESS=562213652 and NUM2=PMRLSH.TRGT)42601 (SQLSTATE [IBM][CLI Driver][DB2/AIX64] SQL0104N An unexpected token "PMTEMP T" was found following "ete from PMRLSH from". Expected tokens may include: "<space>". SQLSTATE=42601
)
Query: delete from PMRLSH from PMTEMP T join PMOBJT O on T.NUM2=O.OBJT where PMRLSH.PRNT=1 and T.SESS=562213652 and O.CLSS=1 and PMRLSH.SRCE=T.NUM2 and not exists (select 1 from PMTEMP where SESS=562213652 and NUM2=PMRLSH.TRGT)
Unexpected error while updating the repository document.
The check in of the document has been cancelled.

  • The same error is reported in the defaultlogger.log file.
  • It works fine if creating a baseline version or updating the document using a Direct repository definition.

Read more...

Environment

  • SAP PowerDesigner (PD) 16.6
  • IBM DB2 Version 11 for Linux, UNIX and Windows

Product

SAP PowerDesigner 16.6

Keywords

LUW, CS, z/OS, zos, canceled, 820409, CR820409, CR#820409 , KBA , BC-SYB-PD , PowerDesigner , Bug Filed

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.