Delphix Toolkits (dxToolkit and dxmToolkit)

 View Only
Expand all | Collapse all

Wrong message displayed by test connector dxmc command for invalid connector details

  • 1.  Wrong message displayed by test connector dxmc command for invalid connector details

    Posted 12-09-2021 05:53:00 AM
    Hello Tino,
    Below command is to test the connector from the va0021 engine, when we are passing all parameter to test invalid connector it is showing connector test succeed ( for invalid dbname and SID) 

    [delphix_os@lmen2100 ~]$ ./dxmc connector test --engine va0021 --connectorname CO_AHS_GOLDEN --envname SDK_GOLD_A_TO_H
    Connector test CO_AHS_GOLDEN succeeded

    Invalid dbname and SID is - AHS70Gww
    In masking engine logs showing correct logs:
    Caused by: java.net.UnknownHostException: AHS70Gww
    at java.net.InetAddress.getAllByName0(InetAddress.java:1281)
    at java.net.InetAddress.getAllByName(InetAddress.java:1193)
    at java.net.InetAddress.getAllByName(InetAddress.java:1127)
    at oracle.net.nt.TcpNTAdapter.connect(TcpNTAdapter.java:149)
    at oracle.net.nt.ConnOption.connect(ConnOption.java:174)
    at oracle.net.nt.ConnStrategy.execute(ConnStrategy.java:510)
    ... 98 common frames omitted
    2021-12-09 11:45:19,111 [http-nio-127.0.0.1-8284-exec-7] INFO c.d.w.inventory.InventoryController - Inside public ModelAndView view(HttpServletRequest request,HttpServletResponse response,InventoryDTO inventoryDTO)
    2021-12-09 11:45:19,219 [http-nio-127.0.0.1-8284-exec-7] INFO c.d.w.inventory.InventoryController - Connector type table
    2021-12-09 11:45:19,219 [http-nio-127.0.0.1-8284-exec-7] INFO c.d.w.inventory.InventoryController - CollectionName RS_AHS_1_OF_1_G
    2021-12-09 11:45:19,330 [http-nio-127.0.0.1-8284-exec-7] INFO c.d.w.inventory.InventoryController - getInventoryRowTypes for envId 92, Table name CUSTOMER_INFO
    2021-12-09 11:45:24,058 [http-nio-127.0.0.1-8284-exec-3] INFO c.dmsuite.web.audit.AuditController - inside audit controller view ....
    2021-12-09 11:45:24,058 [http-nio-127.0.0.1-8284-exec-3] INFO c.dmsuite.web.audit.AuditController - userName : null
    2021-12-09 11:45:24,058 [http-nio-127.0.0.1-8284-exec-3] INFO c.dmsuite.web.audit.AuditController - startDate : null
    2021-12-09 11:45:24,058 [http-nio-127.0.0.1-8284-exec-3] INFO c.dmsuite.web.audit.AuditController - endDate : null
    2021-12-09 11:45:24,058 [http-nio-127.0.0.1-8284-exec-3] INFO c.dmsuite.web.audit.AuditController - searchAudit : null
    2021-12-09 11:46:35,344 [http-nio-127.0.0.1-8284-exec-10] INFO c.dmsuite.manager.EnvironmentManager - User is admin: true
    2021-12-09 11:46:35,996 [http-nio-127.0.0.1-8284-exec-6] ERROR c.dmsuite.dataPlatform.DataPlatform - Test Connector CO_AHS_GOLDEN: error connecting
    java.sql.SQLRecoverableException: IO Error: The Network Adapter could not establish the connection
    at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:854)
    at oracle.jdbc.driver.PhysicalConnection.connect(PhysicalConnection.java:793)
    at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:57)
    at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:747)
    at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:562)
    at java.sql.DriverManager.getConnection(DriverManager.java:664)

    ------------------------------
    Pankaj Asegaonkar
    Delphix Community Members
    ------------------------------


  • 2.  RE: Wrong message displayed by test connector dxmc command for invalid connector details

    Posted 12-09-2021 06:02:00 AM
    Some more explanation:
    [delphix_os@lmen2100 ~]$ ./dxmc connector list --engine va0021 --connectorname CO_AHS_GOLDEN --envname SDK_GOLD_A_TO_H --details

    Engine name Environment name Connector name Connector type Hostname Port Schema name Type depended
    ============================== ============================== ============================== =============== ============================== ===== ============================== ====================================================================================================
    va0021 SDK_GOLD_A_TO_H CO_AHS_GOLDEN ORACLE AHS70Gww 1540 AHS_SCHEMAFFFFFFFF username = BLABLA SID = AHS70Gww


    [delphix_os@lmen2100 ~]$ ./dxmc connector test --engine va0021 --connectorname CO_AHS_GOLDEN --envname SDK_GOLD_A_TO_H --debug
    Connector test CO_AHS_GOLDEN succeeded

    ------------------------------
    Pankaj Asegaonkar
    Delphix Community Members
    ------------------------------