Page 1 of 1

Error when configuring tableadapter in dataset

Posted: Mon 03 May 2021 22:08
by nhill383
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

Re: Error when configuring tableadapter in dataset

Posted: Wed 05 May 2021 12:41
by DmitryGm
nhill383 wrote: Mon 03 May 2021 22:08I 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.
So, we are waiting for the test project and sample schema in order to reproduce the error.

Re: Error when configuring tableadapter in dataset

Posted: Wed 05 May 2021 13:07
by nhill383
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
---------------------------

Re: Error when configuring tableadapter in dataset

Posted: Thu 13 May 2021 07:48
by DmitryGm
nhill383 wrote: Wed 05 May 2021 13:07i will continue to try and generate a simple schema that recreates the issue.
Did you manage to create such a and sample schema and test project in order to reproduce the issue?

Re: Error when configuring tableadapter in dataset

Posted: Fri 14 May 2021 10:24
by nhill383
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

Re: Error when configuring tableadapter in dataset

Posted: Mon 17 May 2021 06:11
by DmitryGm
nhill383 wrote: Fri 14 May 2021 10:24 can i email it across as i cant see how to add it to this ticket as an attachment
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

Posted: Mon 07 Jun 2021 12:01
by DmitryGm
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