Error "Object reference not set to an instance"

llerrac

Hi
I am trialing out the Oracle suite. Using the UI at the moment. I aim to use command line
I compare a largish schema from a database. Its just one schema of many in the database, they are all interelated.
I have tried 3 databases, local XE database which was copied by sql developer 4 locally. So that will miss some references, fine. I tried it against a two test systems, one which will people play with, one which is first level acceptance. Then i tried to compare a schema against itself. Same error each time. I tried in comparisons in both directions.

The logs seem to blow up with:
10:34:37.923|Warn |Object Model |7 |:Using all_indextype_operators instead of dba_indextype_operators
Devart.Data.Oracle.OracleException (0x80004005): ORA-00942: table or view does not exist

So I thought I should use a user with more rights than than a schema owner.
I have used a user with cross schema rights, it works. On all.
so what rights must a connection/user have?


Thanks

Alex

Sample Log file:
10:07:04.190|Info |Logging |1 |Current Logging levels enabled: Verbose,Warning,Fatal,Debug,Information,Trace,Error
10:09:05.721|Info |Object Model |17 |:Populating databases. Source: TOO3, Target tot3
10:09:05.722|Info |Object Model |17 |:Program version 3.0.0.689
10:09:05.722|Info |Object Model |17 |:Populating database TOO3
10:09:05.722|Trace |Object Model |17 |:Populating schemas TOPLINE
10:09:05.722|Info |Object Model |17 |:Initializing database connection
10:09:05.722|Debug |Object Model |17 |:Opening connection
10:09:05.722|Debug |Object Model |17 |:Devart.Data version 5.0.401.0
10:09:05.722|Debug |Object Model |17 |:Devart.Data.Oracle version 6.70.302.0
10:09:05.843|Debug |Object Model |17 |:Successfully selected from dba_users - using dba mode
10:09:05.862|Warn |Object Model |17 |:Using all_indextype_operators instead of dba_indextype_operators
Devart.Data.Oracle.OracleException (0x80004005): ORA-00942: table or view does not exist
at Devart.Data.Oracle.a4.b(Int32 A_0)
at Devart.Data.Oracle.b1.a(Int32 A_0, br A_1)
at Devart.Data.Oracle.OracleCommand.InternalExecute(CommandBehavior behavior, IDisposable disposable, Int32 startRecord, Int32 maxRecords, Boolean nonQuery)
at Devart.Common.DbCommandBase.ExecuteDbDataReader(CommandBehavior behavior, Boolean nonQuery)
at Devart.Common.DbCommandBase.ExecuteDbDataReader(CommandBehavior behavior)
at Devart.Common.DbCommandBase.ExecuteScalar()
at RedGate.Oracle.Common.ObjectModel.DatabaseReader.ExecuteScalar(String query)
at RedGate.Oracle.SchemaCompare.ObjectModel.DatabaseReader.Initialize(ICollection`1 #L0Qb)
10:09:18.381|Debug |Object Model |17 |:Populating schema TOPLINE
10:09:18.395|Trace |Object Model |17 |:Database version: 11.2.0.3.0
10:09:18.395|Trace |Object Model |17 |:Initializing object selector with schemas TOPLINE
10:09:18.395|Debug |Object Model |17 |:Opening connection
10:09:18.395|Debug |Object Model |17 |:Devart.Data version 5.0.401.0
10:09:18.395|Debug |Object Model |17 |:Devart.Data.Oracle version 6.70.302.0
10:09:18.527|Debug |Object Model |17 |:Successfully selected from dba_users - using dba mode
10:09:18.548|Warn |Object Model |17 |:Using all_indextype_operators instead of dba_indextype_operators
Devart.Data.Oracle.OracleException (0x80004005): ORA-00942: table or view does not exist
at Devart.Data.Oracle.a4.b(Int32 A_0)
at Devart.Data.Oracle.b1.a(Int32 A_0, br A_1)
at Devart.Data.Oracle.OracleCommand.InternalExecute(CommandBehavior behavior, IDisposable disposable, Int32 startRecord, Int32 maxRecords, Boolean nonQuery)
at Devart.Common.DbCommandBase.ExecuteDbDataReader(CommandBehavior behavior, Boolean nonQuery)
at Devart.Common.DbCommandBase.ExecuteDbDataReader(CommandBehavior behavior)
at Devart.Common.DbCommandBase.ExecuteScalar()
at RedGate.Oracle.Common.ObjectModel.DatabaseReader.ExecuteScalar(String query)
at RedGate.Oracle.SchemaCompare.ObjectModel.DatabaseReader.Initialize(ICollection`1 #L0Qb)
10:09:31.055|Debug |Object Model |17 |:Populating schema TOPLINE
10:09:31.068|Trace |Object Model |17 |:Database version: 11.2.0.3.0
10:09:31.068|Trace |Object Model |17 |:Initializing object selector with schemas TOPLINE
10:09:31.068|Info |Object Model |17 |:Populating database tot3
10:09:31.068|Trace |Object Model |17 |:Populating schemas TOPLINE
10:09:31.068|Info |Object Model |17 |:Initializing database connection
10:09:31.068|Debug |Object Model |17 |:Opening connection
10:09:31.068|Debug |Object Model |17 |:Devart.Data version 5.0.401.0
10:09:31.068|Debug |Object Model |17 |:Devart.Data.Oracle version 6.70.302.0
10:09:31.198|Debug |Object Model |17 |:Successfully selected from dba_users - using dba mode
10:09:31.215|Warn |Object Model |17 |:Using all_indextype_operators instead of dba_indextype_operators
Devart.Data.Oracle.OracleException (0x80004005): ORA-00942: table or view does not exist
at Devart.Data.Oracle.a4.b(Int32 A_0)
at Devart.Data.Oracle.b1.a(Int32 A_0, br A_1)
at Devart.Data.Oracle.OracleCommand.InternalExecute(CommandBehavior behavior, IDisposable disposable, Int32 startRecord, Int32 maxRecords, Boolean nonQuery)
at Devart.Common.DbCommandBase.ExecuteDbDataReader(CommandBehavior behavior, Boolean nonQuery)
at Devart.Common.DbCommandBase.ExecuteDbDataReader(CommandBehavior behavior)
at Devart.Common.DbCommandBase.ExecuteScalar()
at RedGate.Oracle.Common.ObjectModel.DatabaseReader.ExecuteScalar(String query)
at RedGate.Oracle.SchemaCompare.ObjectModel.DatabaseReader.Initialize(ICollection`1 #L0Qb)
10:09:46.897|Debug |Object Model |17 |:Populating schema TOPLINE
10:09:46.914|Trace |Object Model |17 |:Database version: 11.2.0.3.0
10:09:46.914|Trace |Object Model |17 |:Initializing object selector with schemas TOPLINE
10:09:46.914|Debug |Object Model |17 |:Opening connection
10:09:46.914|Debug |Object Model |17 |:Devart.Data version 5.0.401.0
10:09:46.914|Debug |Object Model |17 |:Devart.Data.Oracle version 6.70.302.0
10:09:47.053|Debug |Object Model |17 |:Successfully selected from dba_users - using dba mode
10:09:47.070|Warn |Object Model |17 |:Using all_indextype_operators instead of dba_indextype_operators
Devart.Data.Oracle.OracleException (0x80004005): ORA-00942: table or view does not exist
at Devart.Data.Oracle.a4.b(Int32 A_0)
at Devart.Data.Oracle.b1.a(Int32 A_0, br A_1)
at Devart.Data.Oracle.OracleCommand.InternalExecute(CommandBehavior behavior, IDisposable disposable, Int32 startRecord, Int32 maxRecords, Boolean nonQuery)
at Devart.Common.DbCommandBase.ExecuteDbDataReader(CommandBehavior behavior, Boolean nonQuery)
at Devart.Common.DbCommandBase.ExecuteDbDataReader(CommandBehavior behavior)
at Devart.Common.DbCommandBase.ExecuteScalar()
at RedGate.Oracle.Common.ObjectModel.DatabaseReader.ExecuteScalar(String query)
at RedGate.Oracle.SchemaCompare.ObjectModel.DatabaseReader.Initialize(ICollection`1 #L0Qb)
10:10:02.820|Debug |Object Model |17 |:Populating schema TOPLINE
10:10:02.838|Trace |Object Model |17 |:Database version: 11.2.0.3.0
10:10:02.838|Trace |Object Model |17 |:Initializing object selector with schemas TOPLINE
10:10:02.839|Debug |Object Model |36 |:Populating dependencies for (TOPLINE)
10:10:02.839|Debug |Object Model |38 |:Populating dependencies for (TOPLINE)
10:10:02.839|Warn |Object Model |38 |:Fast dependencies enabled; some things may break
10:10:02.839|Warn |Object Model |36 |:Fast dependencies enabled; some things may break
10:10:02.857|Error |Engine Service |1 |:Exception in progress dialog
System.NullReferenceException: Object reference not set to an instance of an object.

Server stack trace:
at RedGate.Oracle.Utils.DataReaders.DataReaderWrapper.#m5()
at RedGate.Oracle.SchemaCompare.ObjectModel.DatabaseFactory.GetDependencies(IScriptExecutor executor, IEnumerable`1 schemas, Action checkCancel)
at RedGate.Oracle.SchemaCompare.ObjectModel.DatabaseFactory.GetDependencies(IEnumerable`1 #L0Qb)
at RedGate.Oracle.SchemaCompare.ObjectModel.LivePopulator.#UqJ(IEnumerable`1 #L0Qb)
at RedGate.Oracle.SchemaCompare.ObjectModel.DependenciesPopulationHelper.#BYD(IDependenciesPopulator #SKPb, ISet`1 #L0Qb, Boolean #T8Zb, Dictionary`2 #Q8Zb, Dictionary`2 #R8Zb, ISet`1 #Y8Zb)
at System.Runtime.Remoting.Messaging.StackBuilderSink._PrivateProcessMessage(IntPtr md, Object[] args, Object server, Object[]& outArgs)
at System.Runtime.Remoting.Messaging.StackBuilderSink.AsyncProcessMessage(IMessage msg, IMessageSink replySink)

Exception rethrown at [0]:
at System.Runtime.Remoting.Proxies.RealProxy.EndInvokeHelper(Message reqMsg, Boolean bProxyCase)
at System.Runtime.Remoting.Proxies.RemotingProxy.Invoke(Object NotUsed, MessageData& msgData)
at RedGate.Oracle.SchemaCompare.ObjectModel.DependenciesPopulationHelper.#nVD.EndInvoke(IAsyncResult result)
at RedGate.Oracle.SchemaCompare.ObjectModel.DependenciesPopulationHelper.#yYD(Dictionary`2& #I8Zb, Dictionary`2& #K8Zb, Dictionary`2& #J8Zb, Dictionary`2& #L8Zb, Set`1& #M8Zb, Set`1& #N8Zb)
at RedGate.Oracle.SchemaCompare.ObjectModel.DependenciesPopulationHelper.PopulateDependencies(Set`1& #0ysc, Set`1& #1ysc)
at RedGate.Oracle.SchemaCompare.ObjectModel.DatabasePopulator.PopulateDependencies()
at RedGate.Oracle.Compare.EngineController.Schema.OracleEngine.<>c__DisplayClass6.<GetPopulateDependenciesProgressTask>b__5()
at RedGate.Shared.Controls.ProgressDialogEx.<>c__DisplayClass8.<DoTasks>b__3(Object q)
10:34:06.300|Info |Object Model |7 |:Populating databases. Source: TOO3, Target too3
10:34:06.300|Info |Object Model |7 |:Program version 3.0.0.689
10:34:06.300|Info |Object Model |7 |:Populating database TOO3
10:34:06.300|Trace |Object Model |7 |:Populating schemas TOPLINE
10:34:06.300|Info |Object Model |7 |:Initializing database connection
10:34:06.300|Debug |Object Model |7 |:Opening connection
10:34:06.300|Debug |Object Model |7 |:Devart.Data version 5.0.401.0
10:34:06.300|Debug |Object Model |7 |:Devart.Data.Oracle version 6.70.302.0
10:34:06.528|Debug |Object Model |7 |:Successfully selected from dba_users - using dba mode
10:34:06.718|Warn |Object Model |7 |:Using all_indextype_operators instead of dba_indextype_operators
Devart.Data.Oracle.OracleException (0x80004005): ORA-00942: table or view does not exist
at Devart.Data.Oracle.a4.b(Int32 A_0)
at Devart.Data.Oracle.b1.a(Int32 A_0, br A_1)
at Devart.Data.Oracle.OracleCommand.InternalExecute(CommandBehavior behavior, IDisposable disposable, Int32 startRecord, Int32 maxRecords, Boolean nonQuery)
at Devart.Common.DbCommandBase.ExecuteDbDataReader(CommandBehavior behavior, Boolean nonQuery)
at Devart.Common.DbCommandBase.ExecuteDbDataReader(CommandBehavior behavior)
at Devart.Common.DbCommandBase.ExecuteScalar()
at RedGate.Oracle.Common.ObjectModel.DatabaseReader.ExecuteScalar(String query)
at RedGate.Oracle.SchemaCompare.ObjectModel.DatabaseReader.Initialize(ICollection`1 #L0Qb)
10:34:25.827|Debug |Object Model |7 |:Populating schema TOPLINE
10:34:25.840|Trace |Object Model |7 |:Database version: 11.2.0.3.0
10:34:25.840|Trace |Object Model |7 |:Initializing object selector with schemas TOPLINE
10:34:25.840|Debug |Object Model |7 |:Opening connection
10:34:25.840|Debug |Object Model |7 |:Devart.Data version 5.0.401.0
10:34:25.840|Debug |Object Model |7 |:Devart.Data.Oracle version 6.70.302.0
10:34:25.962|Debug |Object Model |7 |:Successfully selected from dba_users - using dba mode
10:34:25.980|Warn |Object Model |7 |:Using all_indextype_operators instead of dba_indextype_operators
Devart.Data.Oracle.OracleException (0x80004005): ORA-00942: table or view does not exist
at Devart.Data.Oracle.a4.b(Int32 A_0)
at Devart.Data.Oracle.b1.a(Int32 A_0, br A_1)
at Devart.Data.Oracle.OracleCommand.InternalExecute(CommandBehavior behavior, IDisposable disposable, Int32 startRecord, Int32 maxRecords, Boolean nonQuery)
at Devart.Common.DbCommandBase.ExecuteDbDataReader(CommandBehavior behavior, Boolean nonQuery)
at Devart.Common.DbCommandBase.ExecuteDbDataReader(CommandBehavior behavior)
at Devart.Common.DbCommandBase.ExecuteScalar()
at RedGate.Oracle.Common.ObjectModel.DatabaseReader.ExecuteScalar(String query)
at RedGate.Oracle.SchemaCompare.ObjectModel.DatabaseReader.Initialize(ICollection`1 #L0Qb)
10:34:37.772|Debug |Object Model |7 |:Populating schema TOPLINE
10:34:37.790|Trace |Object Model |7 |:Database version: 11.2.0.3.0
10:34:37.790|Trace |Object Model |7 |:Initializing object selector with schemas TOPLINE
10:34:37.790|Info |Object Model |7 |:Populating database too3
10:34:37.790|Trace |Object Model |7 |:Populating schemas TOPLINE
10:34:37.790|Info |Object Model |7 |:Initializing database connection
10:34:37.790|Debug |Object Model |7 |:Opening connection
10:34:37.790|Debug |Object Model |7 |:Devart.Data version 5.0.401.0
10:34:37.790|Debug |Object Model |7 |:Devart.Data.Oracle version 6.70.302.0
10:34:37.906|Debug |Object Model |7 |:Successfully selected from dba_users - using dba mode
10:34:37.923|Warn |Object Model |7 |:Using all_indextype_operators instead of dba_indextype_operators
Devart.Data.Oracle.OracleException (0x80004005): ORA-00942: table or view does not exist
at Devart.Data.Oracle.a4.b(Int32 A_0)
at Devart.Data.Oracle.b1.a(Int32 A_0, br A_1)
at Devart.Data.Oracle.OracleCommand.InternalExecute(CommandBehavior behavior, IDisposable disposable, Int32 startRecord, Int32 maxRecords, Boolean nonQuery)
at Devart.Common.DbCommandBase.ExecuteDbDataReader(CommandBehavior behavior, Boolean nonQuery)
at Devart.Common.DbCommandBase.ExecuteDbDataReader(CommandBehavior behavior)
at Devart.Common.DbCommandBase.ExecuteScalar()
at RedGate.Oracle.Common.ObjectModel.DatabaseReader.ExecuteScalar(String query)
at RedGate.Oracle.SchemaCompare.ObjectModel.DatabaseReader.Initialize(ICollection`1 #L0Qb)
10:34:49.808|Debug |Object Model |7 |:Populating schema TOPLINE
10:34:49.822|Trace |Object Model |7 |:Database version: 11.2.0.3.0
10:34:49.822|Trace |Object Model |7 |:Initializing object selector with schemas TOPLINE
10:34:49.822|Debug |Object Model |7 |:Opening connection
10:34:49.822|Debug |Object Model |7 |:Devart.Data version 5.0.401.0
10:34:49.822|Debug |Object Model |7 |:Devart.Data.Oracle version 6.70.302.0
10:34:50.179|Debug |Object Model |7 |:Successfully selected from dba_users - using dba mode
10:34:50.205|Warn |Object Model |7 |:Using all_indextype_operators instead of dba_indextype_operators
Devart.Data.Oracle.OracleException (0x80004005): ORA-00942: table or view does not exist
at Devart.Data.Oracle.a4.b(Int32 A_0)
at Devart.Data.Oracle.b1.a(Int32 A_0, br A_1)
at Devart.Data.Oracle.OracleCommand.InternalExecute(CommandBehavior behavior, IDisposable disposable, Int32 startRecord, Int32 maxRecords, Boolean nonQuery)
at Devart.Common.DbCommandBase.ExecuteDbDataReader(CommandBehavior behavior, Boolean nonQuery)
at Devart.Common.DbCommandBase.ExecuteDbDataReader(CommandBehavior behavior)
at Devart.Common.DbCommandBase.ExecuteScalar()
at RedGate.Oracle.Common.ObjectModel.DatabaseReader.ExecuteScalar(String query)
at RedGate.Oracle.SchemaCompare.ObjectModel.DatabaseReader.Initialize(ICollection`1 #L0Qb)
10:35:02.147|Debug |Object Model |7 |:Populating schema TOPLINE
10:35:02.160|Trace |Object Model |7 |:Database version: 11.2.0.3.0
10:35:02.160|Trace |Object Model |7 |:Initializing object selector with schemas TOPLINE
10:35:02.160|Debug |Object Model |14 |:Populating dependencies for (TOPLINE)
10:35:02.160|Debug |Object Model |36 |:Populating dependencies for (TOPLINE)
10:35:02.160|Warn |Object Model |36 |:Fast dependencies enabled; some things may break
10:35:02.160|Warn |Object Model |14 |:Fast dependencies enabled; some things may break
10:35:02.222|Error |Engine Service |1 |:Exception in progress dialog
System.NullReferenceException: Object reference not set to an instance of an object.

Server stack trace:
at RedGate.Oracle.Utils.DataReaders.DataReaderWrapper.#m5()
at RedGate.Oracle.SchemaCompare.ObjectModel.DatabaseFactory.GetDependencies(IScriptExecutor executor, IEnumerable`1 schemas, Action checkCancel)
at RedGate.Oracle.SchemaCompare.ObjectModel.DatabaseFactory.GetDependencies(IEnumerable`1 #L0Qb)
at RedGate.Oracle.SchemaCompare.ObjectModel.LivePopulator.#UqJ(IEnumerable`1 #L0Qb)
at RedGate.Oracle.SchemaCompare.ObjectModel.DependenciesPopulationHelper.#BYD(IDependenciesPopulator #SKPb, ISet`1 #L0Qb, Boolean #T8Zb, Dictionary`2 #Q8Zb, Dictionary`2 #R8Zb, ISet`1 #Y8Zb)
at System.Runtime.Remoting.Messaging.StackBuilderSink._PrivateProcessMessage(IntPtr md, Object[] args, Object server, Object[]& outArgs)
at System.Runtime.Remoting.Messaging.StackBuilderSink.AsyncProcessMessage(IMessage msg, IMessageSink replySink)

Exception rethrown at [0]:
at System.Runtime.Remoting.Proxies.RealProxy.EndInvokeHelper(Message reqMsg, Boolean bProxyCase)
at System.Runtime.Remoting.Proxies.RemotingProxy.Invoke(Object NotUsed, MessageData& msgData)
at RedGate.Oracle.SchemaCompare.ObjectModel.DependenciesPopulationHelper.#nVD.EndInvoke(IAsyncResult result)
at RedGate.Oracle.SchemaCompare.ObjectModel.DependenciesPopulationHelper.#yYD(Dictionary`2& #I8Zb, Dictionary`2& #K8Zb, Dictionary`2& #J8Zb, Dictionary`2& #L8Zb, Set`1& #M8Zb, Set`1& #N8Zb)
at RedGate.Oracle.SchemaCompare.ObjectModel.DependenciesPopulationHelper.PopulateDependencies(Set`1& #0ysc, Set`1& #1ysc)
at RedGate.Oracle.SchemaCompare.ObjectModel.DatabasePopulator.PopulateDependencies()
at RedGate.Oracle.Compare.EngineController.Schema.OracleEngine.<>c__DisplayClass6.<GetPopulateDependenciesProgressTask>b__5()
at RedGate.Shared.Controls.ProgressDialogEx.<>c__DisplayClass8.<DoTasks>b__3(Object q)

Eddie D

Thank you for your forum post and sorry that you have encountered this problem.

Assuming that the security permissions are correct, how often does this problem occur? Is it every time you connect to each data sources selected, Intermittent or the one and only time this problem as occurred?

If you can recreate the reported every time or intermittently, can you please recreate the problem and send to us the latest

Schema Compare for Oracle-2013_08_xx_xx_xx_xx_0.log
SCO_Comparison.log

A new Schema Compare for Oracle-2013_08_xx_xx_xx_xx_0.log is created each time you start up the Schema Compare for Oracle GUI and the SCO_Comparison.log is created the first time you perform a comparison and overwritten on each subsequent comparison, hence the request to perform another comparison so we obtain the latest overwrite of this file.

If you could please send an e-mail to support@red-gate.com and mark it for my attention and reference this forum post, I will then create a support call for you.

Many Thanks
Eddie

llerrac

Thanks for the reply

The error pops up every time unless I log in as user with a lot of rights. I am not a DBA.
I was just wondering what access rights your tool requires(what you need to search), then I can ask our DBA's whats up.

I can attach a few more logs tomorrow. I did restart the software last time a few times. I saw identical as such, faults logs when i logged in as a user which had only rights across the schema(and all referenced objects in schema) I wished to compare. I presume a schema compare user would require some more rights, if for instance I was to create a user/role specifically for the schema compare tool to login as.

Thanks alex