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
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.