Printer FriendlyEmail Article Link

Granite Inventory Gateway: Why are circuits not loading into REACT or Perform when using the Granite Inventory Gateway?

Answer

One reason this can occur is the target for the database connector is wrong.  Check the /hekimian/CenterOpGateway/GraniteWebPortal/log/GraniteWebPortalDebug.log* files for messages similar to this:

Fri Sep 06 01:02:03 EDT 2013  [1] ERROR occurred in doWork
Fri Sep 06 01:02:03 EDT 2013  [1] java.sql.SQLException: Io exception: The Network Adapter could not establish the connection
java.sql.SQLException: Io exception: The Network Adapter could not establish the connection
        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:255)
        at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:387)
        at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:420)
        at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:165)
        at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:35)
        at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:801)
        at java.sql.DriverManager.getConnection(DriverManager.java:525)
        at java.sql.DriverManager.getConnection(DriverManager.java:193)
        at com.spirentcom.ciras.util.InventoryDB.doQuery(InventoryDB.java:158)
        at com.spirentcom.ciras.util.InventoryDB.getDeletedCircuits(InventoryDB.java:99)
        at com.spirentcom.ciras.util.InventoryDB.getDeletedCircuits(InventoryDB.java:94)
        at com.spirentcom.ciras.inventory.BulkUpdateManager.addInventoryDailyDelete(BulkUpdateManager.java:349)
        at com.spirentcom.ciras.adaptors.inbound.InventoryDailyDeleteAdaptor.doAction(InventoryDailyDeleteAdaptor.java:20)
        at com.spirentcom.ciras.adaptors.inbound.DailyUpdateAdaptor.doWork(DailyUpdateAdaptor.java:35)
        at com.spirentcom.wegs.process.InboundAdaptorThread.run(InboundAdaptorThread.java:37)
        at java.lang.Thread.run(Thread.java:595)

or:

Fri Sep 06 02:01:55 EDT 2013  [1] ERROR occurred in doWork
Fri Sep 06 02:01:55 EDT 2013  [1] java.sql.SQLException: Io exception: The Network Adapter could not establish the connection

To resolve update file  /hekimian/CenterOpGateway/GraniteWebPortal/config.txt.  Set INVENTORY_JDBC_URL to the correct setting and restart the Gateway.

Product : GRANITE,REACT,Perform