Symptom
- When trying to push the Solution Documentation from Solution Manager to ALM the following error appears in the log"
"Invocation of AddLogicalComponentGroup failed [Mercury][Oracle JDBC Driver][Oracle]ORA-00904: "ISNULL": invalid identifier Failed SQL: /* ~~QC */ SELECT ISNULL(MAX(LCG_EI_ID) + 1, 1) FROM EI_LOGICAL_COMPONENT_GROUP " - The same error is captured in a SRT_UTIL payload trace:
<?xml version="1.0"?>
< soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><soap:Body><ns2:AgsSmPushBlueprintResponse xmlns:ns3="http://blueprint.sm.service.ei.erp.hp.com" xmlns:ns2="urn:sap-com:document:sap:soap:functions:mc-style"><AgsSmPushBlueprintResp><Response>Invocation of AddLogicalComponentGroup failed [Mercury][Oracle JDBC Driver][Oracle]ORA-00904: "ISNULL": invalid identifier Failed SQL: /* ~~QC */ SELECT ISNULL(MAX(LCG_EI_ID) + 1, 1) FROM EI_LOGICAL_COMPONENT_GROUP</Response><Message>Failed</Message><TransferLogUiURL>http://172.19.249.7:8080/qcbin/rest/domains/DEFAULT/projects/Solman_Integartion2/eiAuditLogs/21e60023-2060-11e7-a0a6-ef43ac13f907?login-form-required=y</TransferLogUiURL><TransferLogUiID>'21e60023-2060-11e7-a0a6-ef43ac13f907'</TransferLogUiID></AgsSmPushBlueprintResp></ns2:AgsSmPushBlueprintResponse></soap:Body></soap:Envelope>
Read more...
Environment
- SAP Solution Manager 7.2 SP04
- Oracle 12g
Product
SAP Solution Manager 7.2
Keywords
SOLMAN PTM patch fix database mercury JDBC QC , KBA , SV-SMG-QC , Adapter for SAP Quality Center by HP , Problem
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