Red Gate forums :: View topic - Error "Object reference not set to an instance"
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
Schema Compare for Oracle
Schema Compare for Oracle forum

Error "Object reference not set to an instance"

Search in Schema Compare for Oracle forum
Post new topic   Reply to topic
Jump to:  
Author Message
llerrac



Joined: 08 Aug 2013
Posts: 6

PostPosted: Thu Aug 08, 2013 9:58 am    Post subject: Error "Object reference not set to an instance" Reply with quote

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)
Back to top
View user's profile Send private message
eddie davis



Joined: 14 Jun 2006
Posts: 921
Location: Red Gate Software

PostPosted: Thu Aug 08, 2013 3:15 pm    Post subject: Reply with quote

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
_________________
Eddie Davis
Technical Support Engineer
Red Gate Software Ltd
E-mail: support@red-gate.com
Back to top
View user's profile Send private message Send e-mail
llerrac



Joined: 08 Aug 2013
Posts: 6

PostPosted: Wed Aug 14, 2013 7:42 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group