Error when configuring tableadapter in dataset

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for PostgreSQL
Post Reply
nhill383
Posts: 16
Joined: Sun 26 Apr 2015 21:43

Error when configuring tableadapter in dataset

Post by nhill383 » Mon 03 May 2021 22:08

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

DmitryGm
Devart Team
Posts: 29
Joined: Fri 11 Dec 2020 10:27

Re: Error when configuring tableadapter in dataset

Post by DmitryGm » Wed 05 May 2021 12:41

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.

nhill383
Posts: 16
Joined: Sun 26 Apr 2015 21:43

Re: Error when configuring tableadapter in dataset

Post by nhill383 » Wed 05 May 2021 13:07

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
---------------------------

DmitryGm
Devart Team
Posts: 29
Joined: Fri 11 Dec 2020 10:27

Re: Error when configuring tableadapter in dataset

Post by DmitryGm » Thu 13 May 2021 07:48

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?

nhill383
Posts: 16
Joined: Sun 26 Apr 2015 21:43

Re: Error when configuring tableadapter in dataset

Post by nhill383 » Fri 14 May 2021 10:24

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

DmitryGm
Devart Team
Posts: 29
Joined: Fri 11 Dec 2020 10:27

Re: Error when configuring tableadapter in dataset

Post by DmitryGm » Mon 17 May 2021 06:11

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.

Post Reply