when trying to configure a tableadapter in dataset, i get the following error message
Configure TableAdapter variants failed.
Object reference not set to an instance of an object.
i get the same error message when i try and configure one of its child tables
is there any way i can get to additional info to give me more detail about the issue
7.20.1836
windows 10 64bit
visual studio community 2019 16.9.3
postgres 12.3
if i configure a data connection in server explorer then i can drag the table to create the required tableadapter, but when i try and drag one of its child tables i get a slightly different error message
Failed to merge object(s).
Object reference not set to an instance of an object..
Both of the above methods work for some tables in the schema but fail for specific tables. I have a feeling it is something to do with foreign key constraints.
I am not going to be able to post the full schema, so i have already started working on trying to generate a sample schema that will generate the issue, so that i can post that up.
my initial question is - is there any way i can get more detail on the error, are there any additional logs anywhere
secondly - any suggestions what might be causing it
Error when configuring tableadapter in dataset
Re: Error when configuring tableadapter in dataset
So, we are waiting for the test project and sample schema in order to reproduce the error.
Re: Error when configuring tableadapter in dataset
OK, thanks.i will continue to try and generate a simple schema that recreates the issue.
I did wonder if there was any way of getting additional detail on the issue. would i expect to see anything in the logs if i start devenv.exe with the /Log switch
this is the text from the two different messageboxes
---------------------------
Microsoft Visual Studio
---------------------------
Failed to merge object(s).
Object reference not set to an instance of an object..
---------------------------
OK Help
---------------------------
---------------------------
Error
---------------------------
Configure TableAdapter variants failed.
Object reference not set to an instance of an object.
---------------------------
OK
---------------------------
I did wonder if there was any way of getting additional detail on the issue. would i expect to see anything in the logs if i start devenv.exe with the /Log switch
this is the text from the two different messageboxes
---------------------------
Microsoft Visual Studio
---------------------------
Failed to merge object(s).
Object reference not set to an instance of an object..
---------------------------
OK Help
---------------------------
---------------------------
Error
---------------------------
Configure TableAdapter variants failed.
Object reference not set to an instance of an object.
---------------------------
OK
---------------------------
Re: Error when configuring tableadapter in dataset
hi,
apologies for delay in responding.
in the process of trying to create a 'minimum' schema to force the issue, i identified the issue. There was a materialized view in a different schema, with the same name as the table i was trying to create a tableadapter for.
i was working with public.variants [table] but there was also shopify.variants [materialized view]
can i email it across as i cant see how to add it to this ticket as an attachment
apologies for delay in responding.
in the process of trying to create a 'minimum' schema to force the issue, i identified the issue. There was a materialized view in a different schema, with the same name as the table i was trying to create a tableadapter for.
i was working with public.variants [table] but there was also shopify.variants [materialized view]
can i email it across as i cant see how to add it to this ticket as an attachment
Re: Error when configuring tableadapter in dataset
You can sent the project via Contact form or upload it to some file exchange server or github.
Re: Error when configuring tableadapter in dataset
New version of dotConnect for PostgreSQL (7.20.1905 03-Jun-2021) is available for download:
https://www.devart.com/dotconnect/postg ... nload.html
The bug with the "Failed to merge object(s). Object reference not set to an instance of an object…" error during create DataSet with View objects is fixed
https://www.devart.com/dotconnect/postg ... nload.html
The bug with the "Failed to merge object(s). Object reference not set to an instance of an object…" error during create DataSet with View objects is fixed