0
Fixed

can't add tables, program locks up

sizer 3 months ago • updated by dev 1 month ago 9

I'm trying to add tables to my schema using the reverse engineer feature.  Once I select the tables and click add, the program locks up.  I've tried doing this in both Firefox and Chrome, and have the same issue every time.  

Under review

Dear User,


Sorry for the inconvenience.


Can you please provide us some details to investigate it:

- if possible share the DDL SQL that you are using to RE

- Any screenshots which you have, if you think, can help us to understand the problem easily


Please provide above details, so we can detect the issue and resolve it soon.

Thanks

Team - SqlDBM

+1

The DDL code I’m using is:
create TABLE BIZ_ACCOUNT_TO_EMAILS (

ACCOUNT_ID VARCHAR,

EMAIL VARCHAR,

MODIFIED_DATE TIMESTAMP_NTZ,

CREATED_DATE TIMESTAMP_NTZ,

IS_DELETED BOOLEAN,

constraint FK_ACCOUNTTOEMAILS_ACCOUNTS foreign key (ACCOUNT_ID) references BIZ_ACCOUNTS(ID),

constraint PK_ACCOUNT_TO_EMAILS primary key (ACCOUNT_ID, EMAIL)

)

Here are some screen shots:

Before I click Import:

After I click Import:


And from there it never finishes uploading, no matter how long I wait. This happens in both Firefox and Chrome.

Hope that helps, please let me know if I provide any additional information.

Thanks!

-1

Dear User,

  I tried to RE with DDL that your provided on chrome, and it worked perfectly fine.


Also, I noticed in your screenshots, there was no warning messages, But there should be a warning message, because you are importing single table which has FK in it and there is no corresponding parent table. See following the video :


Can you please try to remove browser cache, close the browser and try to reproduce the issue again?

Let us know, if problem still persists.

Thanks,

Team - SqlDBM

I tried clearing the cache and reopening the browser.  I'm still having the same issue.

I want to clarify, I am not uploading a new ddl.  I'm trying to ADD a table to an existing schema.  I am not getting a warning on the foreign key in my table because the table it's referencing has already been created. 


Is it possible to add tables to existing schemas??  Otherwise it seems as though I'm going to have to delete all my work and start over, which isn't going to work in the long run as we add tables to our data model.

Dear User,

   Sorry for inconvenience. 

 

If possible, can you please share your project (using share link feature) with us, so we can investigate the issue.

Following is the article showing how to generate share link feature:

https://support.sqldbm.com/knowledge-bases/2/articles/33-how-to-share-your-sqldbm-project-for-readonly-purpose 

Thanks,

Team - SqlDBM

Dear User,

  We did not hear from you, but if possible can you please try one more time, since we had new release this week, in which we have resolved one of the Reverse Engineer performance issue. 

In case if it still does not work, please share your project (using share link feature) with us, so we can investigate the issue.

Following is the article showing how to generate share link feature:

https://support.sqldbm.com/knowledge-bases/2/articles/33-how-to-share-your-sqldbm-project-for-readonly-purpose

Thanks,

Team SqlDBM

+1

I tried to add a table this morning, and it is working as expected.  Thanks for letting me know this was fixed.  I appreciate your help! 

I have the same questions.  My chrome always crash when I import tables. Is there a limit on free versions? 

Before this questions, I have import 91 tables sucessfully.