SAP Knowledge Base Article - Preview

2459155 - Oracle DB error Pushing Solution Documentation to ALM

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.