oracle.odi.sap.km.OdiSapConnection.SAP_MESSAGE_SERVER_CONNECTION: { sapConnection.setSAP_USER_NAME("<?=userName?>"); sapLogger.fine("ODIKM-SAPERP-RKM-10000","",new Object[] {"SAP User Name: "+sapConnection.getSAP_USER_NAME()}); sapConnection.setSAP_PWD("<?=password?>"); sapConnection.setSAP_MSG_HOST("<?=msHost?>"); sapLogger.fine("ODIKM-SAPERP-RKM-10000","",new Object[] {"SAP Message Host Name: "+sapConnection.getSAP_MSG_HOST()}); sapConnection.setSAP_SERV_NAME("<?=msService?>"); sapLogger.fine("ODIKM-SAPERP-RKM-10000","",new Object[] {"SAP Service Name: "+sapConnection.getSAP_SERV_NAME()}); sapConnection.setSAP_LOGON_GROUP("<?=msGroupName?>");//must be CASE-Sensitive sapLogger.fine("ODIKM-SAPERP-RKM-10000","",new Object[] {"SAP Group Name: "+sapConnection.getSAP_LOGON_GROUP()}); sapConnection.setSAP_R3NAME("<?=msR3Name?>"); sapLogger.fine("ODIKM-SAPERP-RKM-10000","",new Object[] {"SAP R3 Name: "+sapConnection.getSAP_R3NAME()}); } ; break; } sapConnection.setSAP_CONNECTION_POOL_NAME("SAP_ODI_ERP_POOL_<?=snpRef.getInfo("SRC_DSERV_NAME") ?>"); sapLogger.fine("ODIKM-SAPERP-RKM-10000","",new Object[] {"SAP Connection Pool Name: "+sapConnection.getSAP_CONNECTION_POOL_NAME()}); sapConnection.setSAP_CONNECTION_POOL_SIZE("5"); sapLogger.fine("ODIKM-SAPERP-RKM-10000","",new Object[] {"SAP Connection Pool size: "+sapConnection.getSAP_CONNECTION_POOL_SIZE()}); odiSapERPAdapter.setSAPConnection(sapConnection); //Get the repository connection Connection repoConnection = odiRef.getJDBCConnection("DEST"); sapLogger.fine("ODIKM-SAPERP-RKM-10000","",new Object[] {"repoConnection: "+repoConnection});.

Oracle Community | 2875303 | 11 months ago
  1. 0

    Reverse Enginner - SAP ERP with ODI

    Oracle Community | 11 months ago | 2875303
    oracle.odi.sap.km.OdiSapConnection.SAP_MESSAGE_SERVER_CONNECTION: { sapConnection.setSAP_USER_NAME("<?=userName?>"); sapLogger.fine("ODIKM-SAPERP-RKM-10000","",new Object[] {"SAP User Name: "+sapConnection.getSAP_USER_NAME()}); sapConnection.setSAP_PWD("<?=password?>"); sapConnection.setSAP_MSG_HOST("<?=msHost?>"); sapLogger.fine("ODIKM-SAPERP-RKM-10000","",new Object[] {"SAP Message Host Name: "+sapConnection.getSAP_MSG_HOST()}); sapConnection.setSAP_SERV_NAME("<?=msService?>"); sapLogger.fine("ODIKM-SAPERP-RKM-10000","",new Object[] {"SAP Service Name: "+sapConnection.getSAP_SERV_NAME()}); sapConnection.setSAP_LOGON_GROUP("<?=msGroupName?>");//must be CASE-Sensitive sapLogger.fine("ODIKM-SAPERP-RKM-10000","",new Object[] {"SAP Group Name: "+sapConnection.getSAP_LOGON_GROUP()}); sapConnection.setSAP_R3NAME("<?=msR3Name?>"); sapLogger.fine("ODIKM-SAPERP-RKM-10000","",new Object[] {"SAP R3 Name: "+sapConnection.getSAP_R3NAME()}); } ; break; } sapConnection.setSAP_CONNECTION_POOL_NAME("SAP_ODI_ERP_POOL_<?=snpRef.getInfo("SRC_DSERV_NAME") ?>"); sapLogger.fine("ODIKM-SAPERP-RKM-10000","",new Object[] {"SAP Connection Pool Name: "+sapConnection.getSAP_CONNECTION_POOL_NAME()}); sapConnection.setSAP_CONNECTION_POOL_SIZE("5"); sapLogger.fine("ODIKM-SAPERP-RKM-10000","",new Object[] {"SAP Connection Pool size: "+sapConnection.getSAP_CONNECTION_POOL_SIZE()}); odiSapERPAdapter.setSAPConnection(sapConnection); //Get the repository connection Connection repoConnection = odiRef.getJDBCConnection("DEST"); sapLogger.fine("ODIKM-SAPERP-RKM-10000","",new Object[] {"repoConnection: "+repoConnection});.

    Root Cause Analysis

    1. oracle.odi.sap.km.OdiSapConnection.SAP_MESSAGE_SERVER_CONNECTION

      { sapConnection.setSAP_USER_NAME("<?=userName?>"); sapLogger.fine("ODIKM-SAPERP-RKM-10000","",new Object[] {"SAP User Name: "+sapConnection.getSAP_USER_NAME()}); sapConnection.setSAP_PWD("<?=password?>"); sapConnection.setSAP_MSG_HOST("<?=msHost?>"); sapLogger.fine("ODIKM-SAPERP-RKM-10000","",new Object[] {"SAP Message Host Name: "+sapConnection.getSAP_MSG_HOST()}); sapConnection.setSAP_SERV_NAME("<?=msService?>"); sapLogger.fine("ODIKM-SAPERP-RKM-10000","",new Object[] {"SAP Service Name: "+sapConnection.getSAP_SERV_NAME()}); sapConnection.setSAP_LOGON_GROUP("<?=msGroupName?>");//must be CASE-Sensitive sapLogger.fine("ODIKM-SAPERP-RKM-10000","",new Object[] {"SAP Group Name: "+sapConnection.getSAP_LOGON_GROUP()}); sapConnection.setSAP_R3NAME("<?=msR3Name?>"); sapLogger.fine("ODIKM-SAPERP-RKM-10000","",new Object[] {"SAP R3 Name: "+sapConnection.getSAP_R3NAME()}); } ; break; } sapConnection.setSAP_CONNECTION_POOL_NAME("SAP_ODI_ERP_POOL_<?=snpRef.getInfo("SRC_DSERV_NAME") ?>"); sapLogger.fine("ODIKM-SAPERP-RKM-10000","",new Object[] {"SAP Connection Pool Name: "+sapConnection.getSAP_CONNECTION_POOL_NAME()}); sapConnection.setSAP_CONNECTION_POOL_SIZE("5"); sapLogger.fine("ODIKM-SAPERP-RKM-10000","",new Object[] {"SAP Connection Pool size: "+sapConnection.getSAP_CONNECTION_POOL_SIZE()}); odiSapERPAdapter.setSAPConnection(sapConnection); //Get the repository connection Connection repoConnection = odiRef.getJDBCConnection("DEST"); sapLogger.fine("ODIKM-SAPERP-RKM-10000","",new Object[] {"repoConnection: "+repoConnection});.

      at com.sunopsis.dwg.dbobj.SnpSessStep.createTaskLogs()
    2. com.sunopsis.dwg
      SnpSession.treatSession
      1. com.sunopsis.dwg.dbobj.SnpSessStep.createTaskLogs(SnpSessStep.java:837)
      2. com.sunopsis.dwg.dbobj.SnpSessStep.treatSessStep(SnpSessStep.java:465)
      3. com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:2128)
      3 frames
    3. oracle.odi.runtime
      StartSessRequestProcessor$2.doAction
      1. oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor$2.doAction(StartSessRequestProcessor.java:366)
      1 frame
    4. oracle.odi.core
      DwgObjectTemplate.execute
      1. oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:216)
      1 frame
    5. oracle.odi.runtime
      DefaultAgentTaskExecutor$2.run
      1. oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor.doProcessStartSessTask(StartSessRequestProcessor.java:300)
      2. oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor.access$0(StartSessRequestProcessor.java:292)
      3. oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor$StartSessTask.doExecute(StartSessRequestProcessor.java:855)
      4. oracle.odi.runtime.agent.processor.task.AgentTask.execute(AgentTask.java:126)
      5. oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor$2.run(DefaultAgentTaskExecutor.java:83)
      5 frames
    6. Java RT
      Thread.run
      1. java.lang.Thread.run(Thread.java:662)
      1 frame