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.
SAP Knowledge Base Article - Preview