2459155 - Oracle DB error Pushing Solution Documentation to ALM | SAP Knowledge Base Article

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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.