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.