11 Replies Latest reply on Apr 23, 2019 8:57 AM by Gianni Ceresa

    Cytoscape: Error Loading Property Graph Object

    Sal09

      Hi guys,

       

      So recently I've get myself into the Graph Analytics and read up on this tutorial by Arthur Dayton on how to Create Property Graph on Oracle Database.

      I followed the tutorial, downloading all the tools and patches from his website. Everything went smooth until the part where it is time for me to load the graph using Cytoscape. I'm able to connect Cytoscape to my database, logging in and choosing the graph is perfectly fine however when I want to load the graph, somehow I'm getting an error that stated "Error Loading Property Graph Object".

      I tried reinstalling the VM, Oracle DB & its schema, patches as well as trying different version of Cytoscape but all yielded the same error.

       

      Here's what I got from the Terminal when I got the error:

       

      SwingWorker-pool-8-thread-3 ERROR [PGLOGGER] - ERROR during the initialization:

       

      oracle.pg.common.OraclePropertyGraphException: java.sql.SQLException: ORA-06550: line 1, column 7:

       

      PLS-00306: wrong number or types of arguments in call to 'CREATE_PG'

      ORA-06550: line 1, column 7:

      PL/SQL: Statement ignored

       

      at oracle.pg.rdbms.OraclePropertyGraph.createGraphTables(OraclePropertyGraph.java:1161)

      at oracle.pg.rdbms.OraclePropertyGraph.init(OraclePropertyGraph.java:2960)

      at oracle.pg.rdbms.OraclePropertyGraph.<init>(OraclePropertyGraph.java:2803)

      at oracle.pg.rdbms.OraclePropertyGraph.getInstance(OraclePropertyGraph.java:3144)

      at oracle.spatial.propertyGraph.client.visualization.cytoscape.util.PGXUtilities.initOraclePropertyGraph(PGXUtilities.java:451)

      at oracle.spatial.propertyGraph.client.visualization.cytoscape.util.PGXUtilities.initOraclePropertyGraph(PGXUtilities.java:328)

      at oracle.spatial.propertyGraph.client.visualization.cytoscape.gui.PanelPGQL.loadGraph(PanelPGQL.java:656)

      at oracle.spatial.propertyGraph.client.visualization.cytoscape.gui.PanelPGQL.executeQuery(PanelPGQL.java:764)

      at oracle.spatial.propertyGraph.client.visualization.cytoscape.gui.PanelPGQL.access$1300(PanelPGQL.java:107)

      at oracle.spatial.propertyGraph.client.visualization.cytoscape.gui.PanelPGQL$ExecuteQuery.doInBackground(PanelPGQL.java:1122)

      at oracle.spatial.propertyGraph.client.visualization.cytoscape.gui.PanelPGQL$ExecuteQuery.doInBackground(PanelPGQL.java:1104)

      at javax.swing.SwingWorker$1.call(SwingWorker.java:295)

      at java.util.concurrent.FutureTask.run(FutureTask.java:266)

      at javax.swing.SwingWorker.run(SwingWorker.java:334)

      at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)

      at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)

      at java.lang.Thread.run(Thread.java:748)

      Caused by: java.sql.SQLException: ORA-06550: line 1, column 7:

      PLS-00306: wrong number or types of arguments in call to 'CREATE_PG'

      ORA-06550: line 1, column 7:

      PL/SQL: Statement ignored

       

      at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:494)

      at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:446)

      at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1051)

      at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:537)

      at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:255)

      at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:609)

      at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:249)

      at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:82)

      at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:924)

      at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1136)

      at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3640)

      at oracle.jdbc.driver.T4CCallableStatement.executeInternal(T4CCallableStatement.java:1318)

      at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3752)

      at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:4242)

      at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1079)

      at oracle.pg.rdbms.OraclePropertyGraph.createGraphTables(OraclePropertyGraph.java:1139)

      ... 16 more

      Caused by: Error : 6550, Position : 6, Sql = begin opg_apis.create_pg(:1, :2, :3, :4, :5, :6, :7); end;, OriginalSql = begin opg_apis.create_pg(:1, :2, :3, :4, :5, :6, :7); end;, Error Msg = ORA-06550: line 1, column 7:

      PLS-00306: wrong number or types of arguments in call to 'CREATE_PG'

      ORA-06550: line 1, column 7:

      PL/SQL: Statement ignored

       

      at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:498)

      ... 31 more

       

      I've attached the screenshot to this post for your reference.

      Wondering if anyone has any clue to this? Really appreciate your help!

       

      terminal error (1).JPG

      error message (1).JPG