Symptom
The following error can be seen in portal:
- System Error
An exception occurred during the program execution.
Exception message: while trying to invoke the method com.sapportals.wcm.service.ridid.IRidIdService.getIdForRid(com.sapportals.wcm.util.uri.RID) of a null object loaded from field com.sapportals.wcm.repository.service.appproperties.persistence.Persistence.idService of an object loaded from local variable 'this'
- While trying to open /documents repository from Content Administration -> KM Content -> documents, the following error can be seen:
while trying to invoke the method com.sapportals.wcm.service.ridid.IRidIdService.getIdForRid(com.sapportals.wcm.util.uri.RID) of a null object loaded from field com.sapportals.wcm.repository.service.appproperties.persistence.Persistence.idService of an object loaded from local variable 'this'
-
If you go to System Administration -> Monitoring -> Knowledge Management -> Component Monitor -> Services, you can see the following errors:
1. ridid - Service startup failed
Startup Error: com.sapportals.wcm.WcmException: com.sap.sql.exception.OpenSQLException: SAP DBTech JDBC: [257]: sql syntax error: incorrect syntax near ";": line 1 col 84 (at pos 84) OpenSQLExceptionCategories: [NON_TRANSIENT, SYNTAX_ERROR]
2. urimapper - Service startup failed
Startup Error: can't find ridIdService
-
In the Default trace file you could see the following related error:
#Error#com.sap.sql.jdbc.direct.DirectConnection#
#BC-JAS-PER-SQL#opensqlkernel#C0000A085EC0002A0000000300002559#82430655000009628#sap.com/com.sap.km.application#com.sap.sql.jdbc.direct.DirectConnection#Guest#0##C0720C7FE28811E7AC34000004E9CABF#c0720c7fe28811e7ac34000004e9cabf##0#Application [60]#Plain##SQL error occurred on connection hananode01:HD1:SAPJI1JAVA: code=257, state="HY000", message="SAP DBTech JDBC: [257]: sql syntax error: incorrect syntax near ";": line 1 col 84 (at pos 84)";
SQL statement is "select count(*) from SYS.PROCEDURES where PROCEDURE_NAME = 'CREATEDEEPIDSETFROMID';".
[EXCEPTION]
com.sap.db.jdbc.exceptions.JDBCDriverException: SAP DBTech JDBC: [257]: sql syntax error: incorrect syntax near ";": line 1 col 84 (at pos 84)
at com.sap.db.jdbc.exceptions.SQLExceptionSapDB.createException(SQLExceptionSapDB.java:345)
at com.sap.db.jdbc.exceptions.SQLExceptionSapDB.generateDatabaseException(SQLExceptionSapDB.java:185)Error#com.sapportals.wcm.WcmException#
#EP-KM-FWK-RF#sap.com/com.sap.netweaver.bc.util#C0000A085EC0002A0000000400002559#82430655000009628#sap.com/com.sap.km.application#com.sapportals.wcm.WcmException.WcmException(118)#Guest#0##C0720C7FE28811E7AC34000004E9CABF#c0720c7fe28811e7ac34000004e9cabf##0#Application [60]#Plain##
SAP DBTech JDBC: [257]: sql syntax error: incorrect syntax near ";": line 1 col 84 (at pos 84)
OpenSQLExceptionCategories: [NON_TRANSIENT, SYNTAX_ERROR] com.sap.sql.exception.OpenSQLException: SAP DBTech JDBC: [257]: sql syntax error: incorrect syntax near ";": line 1 col 84 (at pos 84)
OpenSQLExceptionCategories: [NON_TRANSIENT, SYNTAX_ERROR]
at com.sap.sql.exception.SQLExceptionFactory.createOpenSQLException(SQLExceptionFactory.java:167)
at com.sap.sql.exception.SQLExceptionFactory.wrapChainedSQLException(SQLExceptionFactory.java:72)
at com.sap.sql.jdbc.direct.DirectPooledConnection.processSQLExceptionJava6(DirectPooledConnection.java:1000)...
Caused by: com.sap.db.jdbc.exceptions.JDBCDriverException: SAP DBTech JDBC: [257]: sql syntax error: incorrect syntax near ";": line 1 col 84 (at pos 84)
Read more...
Environment
- SAP NetWeaver 7.3
- SAP enhancement package 1 for SAP NetWeaver 7.3
- SAP NetWeaver 7.4
- SAP Netweaver 7.5
- HANA 1.0
Product
Keywords
Enterprise Portal 7.30, EP 7.30, Enterprise Portal 7.31, EP 7.31, Enterprise Portal 7.40, EP 7.4, Enterprise Portal 7.50, EP 7.5, while trying to invoke the met , KBA , EP-KM-CM , Content Management , HAN-DB-SCR , SAP HANA SQL Script , 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.