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 for Me (Login required).

Search for additional results

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