Devart Forums

I'm modeling a very complex database and I've spent hours laying out the tables and routing the relations. When I open the diagram a number of Tables and Relationships are reported as missing. The Database Explorer shows a red "X" for those tables and there seems to be no way to bring them back to an active state.

The database structure has not changed between edits of the diagram and all of the missing tables and relations still exist unchanged in the database.

This has been a consistent problem with a number of diagrams with this database. I'm currently using Standard Edition version 3.8.220.

Can anyone assist with this issue?

Thanks

Could you please let us know what version of the SQL Server server you are using and provide us the CREATE definitions of the tables? Screenshots and the diagram file would be also of help.

You can send a reply straight to our support system at supportATdevartDOTcom, so we will keep further correspondence with you on this issue via e-mail.

I'm operating against a SQL Server 2012 Database. I just completed recreating the diagram yesterday for a design review meeting. After the meeting I closed the diagram and this morning upon reopening it, 129 tables and relationships are missing. The databse was untouched outside of this diagramming exercise.

I will send image shots of the diagram after I recreate it for the last time today along with a few of the create definitions that came up missing. I've already captured images of the diagram with the missing components. I'll send all of this to the support email address later today.

I hope this will assist in determining what is happening.

Unfortunately, we still haven't received an e-mail from you.

I actually sent in all the information requested yesterday in a Request Support Form. I'll retransmit the information again today in an email.

Could you please also send the information to supportATdevartDOTcom ?

DONE

Thank you for the reply.

We have received your e-mail and are currently investigating it. We will answer you as soon as possible.

I am having the same issue outlined in this post. The day after finishing an elaborate diagram with 363 tables I was surprised to load it and have the objects removed from the diagram and marked as missing when they clearly are not.

Has anything been discovered? Is the issue fixed?

Note: We are on SQL 2014. We are using dbForge Studio 4.5.60 Standard Edition.

Could you please send us a screenshot displaying the diagram and the tables being present in Database Explorer?

Please also perform the following:

1. Select 'Tools -> Options' from the main menu. The 'Options' window opens.
2. Navigate to the 'Environment -> Output' branch.
3. Select the 'Write queries sent by the program to the SQL Log'.
4. Click 'OK'.
5. Restart dbForge.
6. Create a lite simplified diagram with 2 tables, one of which had a red cross in Database Explorer, for example, staging.Transactions. Please also make relations between the tables. Save the diagram and close it.
7. Navigate to the 'SQL Log' tab in the 'Output' window that can be invoked by selecting 'View -> Output' from the main menu.
8. Open the diagram and, if the issue reproduces again, send us the diagram along with the CREATE definitions of the diagram objects and the content of the 'SQL Log' tab of the 'Output' window. Additionally, to reproduce it, you can press 'Refresh' in Database Explorer.
9. Send us for investigation the system information generated by clicking the 'Send Info' button in the 'System Info Report Contents' window invoked by selecting 'Help -> About...' from the main menu and then clicking the 'View System Info' button in the 'About dbForge Studio for SQL Server' window.

You can send a reply straight to our support system at supportATdevartDOTcom

Information sent as requested.

One thing I noticed while gathering the data is that the tables having the issues are defined in multiple schemas. For example. We have schema A and B. The Table FOO exists in both schemas with similar definitions and the same table/PK/Index names.
Ex:
CREATE TABLE [A].[Foo]
(
[FooID] [bigint] IDENTITY(1,1) NOT NULL,
[CreatedDate] [datetime] NOT NULL,
CONSTRAINT [FOO_PK] PRIMARY KEY CLUSTERED ( [FooID] ASC )
) ON [UD01];

CREATE TABLE .[Foo]
(
[BarID] [bigint] NOT NULL,
[FooID] [bigint] NOT NULL,
[CreatedDate] [datetime] NOT NULL,
CONSTRAINT [FOO_PK] PRIMARY KEY CLUSTERED ( [BarID] ASC, [FooID] ASC )
) ON [UD01];

Could the issue be in how the meta data is processed when there are matching constraint/index/table/column names in different schemas?

Could you please also resend your e-mail to alexaATdevartDOTcom ?

Sent yesterday...

Thank you for the reply.

We have received your e-mail and are currently investigating this issue.

We will answer you as soon as possible.

Could you please also provide us the result of the following query: