1 Reply Latest reply on Aug 2, 2016 7:18 PM by Gmfeinberg-Oracle

    Unable to get table metadata:Illegal character in: SYS$IndexStatsLease (12.1.3.3.4)

    907163

      Hi,

       

      We have installed the Oracle NoSQL database.

       

      I am trying to connect to store from SQL Developer(Version 4.1.1.19), we are getting error:

      "Unable to get table metadata:Illegal character in: SYS$IndexStatsLease (12.1.3.3.4)"

       

      oracle.kv.FaultException: Unable to get table metadata:Illegal character in: SYS$IndexStatsLease (12.1.3.3.4)

      Fault class name: org.apache.avro.SchemaParseException

      Remote stack trace: org.apache.avro.SchemaParseException: Illegal character in: SYS$IndexStatsLease

          at org.apache.avro.Schema.validateName(Schema.java:1068)

          at org.apache.avro.Schema.access$200(Schema.java:79)

          at org.apache.avro.Schema$Name.<init>(Schema.java:439)

          at org.apache.avro.Schema.parse(Schema.java:1092)

          at org.apache.avro.Schema$Parser.parse(Schema.java:953)

          at org.apache.avro.Schema$Parser.parse(Schema.java:943)

          at oracle.kv.impl.api.table.TableImpl.setSchema(TableImpl.java:1834)

          at oracle.kv.impl.api.table.TableImpl.readObject(TableImpl.java:350)

          at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

          at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)

          at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

          at java.lang.reflect.Method.invoke(Method.java:497)

          at java.io.ObjectStreamClass.invokeReadObject(ObjectStreamClass.java:1017)

          at java.io.ObjectInputStream.readSerialData(ObjectInputStream.java:1896)

          at java.io.ObjectInputStream.readOrdinaryObject(ObjectInputStream.java:1801)

          at java.io.ObjectInputStream.readObject0(ObjectInputStream.java:1351)

          at java.io.ObjectInputStream.readObject(ObjectInputStream.java:371)

          at java.util.TreeMap.buildFromSorted(TreeMap.java:2564)

          at java.util.TreeMap.buildFromSorted(TreeMap.java:2547)

          at java.util.TreeMap.buildFromSorted(TreeMap.java:2504)

          at java.util.TreeMap.readObject(TreeMap.java:2450)

          at sun.reflect.GeneratedMethodAccessor71.invoke(Unknown Source)

          at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

          at java.lang.reflect.Method.invoke(Method.java:497)

          at java.io.ObjectStreamClass.invokeReadObject(ObjectStreamClass.java:1017)

          at java.io.ObjectInputStream.readSerialData(ObjectInputStream.java:1896)

          at java.io.ObjectInputStream.readOrdinaryObject(ObjectInputStream.java:1801)

          at java.io.ObjectInputStream.readObject0(ObjectInputStream.java:1351)

          at java.io.ObjectInputStream.defaultReadFields(ObjectInputStream.java:1993)

          at java.io.ObjectInputStream.readSerialData(ObjectInputStream.java:1918)

          at java.io.ObjectInputStream.readOrdinaryObject(ObjectInputStream.java:1801)

          at java.io.ObjectInputStream.readObject0(ObjectInputStream.java:1351)

          at java.io.ObjectInputStream.readObject(ObjectInputStream.java:371)

          at sun.rmi.server.UnicastRef.unmarshalValue(UnicastRef.java:326)

          at sun.rmi.server.UnicastRef.invoke(UnicastRef.java:175)

          at java.rmi.server.RemoteObjectInvocationHandler.invokeRemoteMethod(RemoteObjectInvocationHandler.java:194)

          at java.rmi.server.RemoteObjectInvocationHandler.invoke(RemoteObjectInvocationHandler.java:148)

          at com.sun.proxy.$Proxy20.getMetadata(Unknown Source)

          at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

          at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)

          at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

          at java.lang.reflect.Method.invoke(Method.java:497)

          at oracle.kv.impl.security.MethodHandlerUtils.invokeMethod(MethodHandlerUtils.java:74)

          at oracle.kv.impl.security.ContextProxy$ContextMethodHandler.invoke(ContextProxy.java:230)

          at oracle.kv.impl.security.ContextProxy.invoke(ContextProxy.java:91)

          at com.sun.proxy.$Proxy20.getMetadata(Unknown Source)

          at oracle.kv.impl.rep.admin.RepNodeAdminAPI.getMetadata(RepNodeAdminAPI.java:415)

          at oracle.kv.impl.api.table.TableAPIImpl.getTableMetadataFromRepNode(TableAPIImpl.java:936)

          at oracle.kv.impl.api.table.TableAPIImpl.getTableMetadata(TableAPIImpl.java:186)

          at oracle.kv.impl.api.table.TableAPIImpl.getTables(TableAPIImpl.java:166)

          at oracle.dbtools.raptor.onsd.navigator.FolderTreeNode$LoadTask.doWork(FolderTreeNode.java:77)

          at oracle.dbtools.raptor.onsd.navigator.FolderTreeNode$LoadTask.doWork(FolderTreeNode.java:39)

          at oracle.dbtools.raptor.backgroundTask.RaptorTask.call(RaptorTask.java:193)

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

          at oracle.dbtools.raptor.backgroundTask.RaptorTaskManager$RaptorFutureTask.run(RaptorTaskManager.java:621)

          at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)

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

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

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

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

       

          at oracle.kv.impl.api.table.TableAPIImpl.getTableMetadata(TableAPIImpl.java:197)

          at oracle.kv.impl.api.table.TableAPIImpl.getTables(TableAPIImpl.java:166)

          at oracle.dbtools.raptor.onsd.navigator.FolderTreeNode$LoadTask.doWork(FolderTreeNode.java:77)

          at oracle.dbtools.raptor.onsd.navigator.FolderTreeNode$LoadTask.doWork(FolderTreeNode.java:39)

          at oracle.dbtools.raptor.backgroundTask.RaptorTask.call(RaptorTask.java:193)

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

          at oracle.dbtools.raptor.backgroundTask.RaptorTaskManager$RaptorFutureTask.run(RaptorTaskManager.java:621)

          at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)

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

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

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

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

       

       

      *********************************NoSQL Running*****************************

       

      C:\Users\spapana.ORADEV>java -jar %KVHOME%\lib\kvstore.jar kvlite

      Created new kvlite store with args:

      -root ./kvroot -store kvstore -host SPAPANA-LAP -port 5000 -admin 5001

       

      C:\Users\spapana.ORADEV>java -jar %KVHOME%/lib/kvstore.jar ping -port 5000 -host SPAPANA-LAP

      Pinging components of store kvstore based upon topology sequence #14

      10 partitions and 1 storage nodes

      Time: 2016-07-15 11:21:25 UTC   Version: 12.1.4.0.9

      Shard Status: healthy:1 writable-degraded:0 read-only:0 offline:0

      Admin Status: healthy

      Zone [name=KVLite id=zn1 type=PRIMARY allowArbiters=false]   RN Status: online:1 offline:0

      Storage Node [sn1] on SPAPANA-LAP:5000    Zone: [name=KVLite id=zn1 type=PRIMARY allowArbiters=false]    Status: RUNNING   Ver: 12cR1.4.0.9 2016-06-03 06:01:53 UTC  Build id: 4c964eba544c

              Admin [admin1]          Status: RUNNING,MASTER

              Rep Node [rg1-rn1]      Status: RUNNING,MASTER sequenceNumber:45 haPort:5006

       

       

      *********************************NoSQL Running*****************************