Load schema problem

Data Abstract
1

Hi,
It always has the following error after upgrade the new version of 1517. Besides, I found it will not change the data type after click “recreate fields”. I need to repeat to close and open Schema Modeler. Besides retry to click “recreate fields”.

schema_error
schema_error1121×305 30.6 KB

schema_error2
schema_error2958×506 57.9 KB

2

I can not answer this one myself, but I know one of the first questions the team will ask you on Monday is what kind of database this is and what driver you are using ;).

3

Hi,
I’m using MSSQL and using SDAC driver for all connections.

1 Like
4

Hello

Could you answer a couple of questions?

  1. Expand the node representing broken connection (one with a red cross) and put the cursor over the “Unreachable connection” label. There will be a tooltip providing detailed connection failure info. What will it say?
    Example:
    2021-08-23-18-14-38-Load_schema_problem_-Data_Abstract-_RemObjects_T
    2021-08-23-18-14-38-Load_schema_problem_-Data_Abstract-_RemObjects_T1023×328 25.3 KB
  2. Do these connection point ot local MS SQL instance or to a some remote server?
  3. Please provide step-by-step instruction how to reproduce this error:
    2021-08-23-18-16-32-Load_schema_problem_-Data_Abstract-_RemObjects_T
    2021-08-23-18-16-32-Load_schema_problem_-Data_Abstract-_RemObjects_T1030×525 261 KB

    If possible, please also provide schema and SQL definition of this table

Thanks in advance

5

Hi,
About your question 1, it is random. I can’t reproduce it directly. I will capture the error about question 1 next time.
Question 3 is difficult reproduce because I need to change the SQL DB table structure and then re-update the schema. It is also random. Besides, I found it will not re-update the fields sometimes. I need to repeat the few times that close “Schema Modeler” and reopen it again.

6

Hi,
I captured the error as below.

schema_error3
schema_error3745×349 43.1 KB

7

After this error, I closed Schema and reopen it. The connections are normal. But “Update Fields” will have the following error. (I add the new field in SQL server)

schema_error4
schema_error4917×512 59 KB

9

Hi,

pls add these lines to ..\Data Abstract (Common)\Bin\RemObjects.DataAbstract.Unmanaged.ini

[Debug]
Debug=1

after error is raised in DASM, pls send to support@ this file:
%appdata%\RemObjects Software\Schema Modeler\RemObjects.DataAbstract.Unmanaged.log

Note: this file can contain private data

10

Hi,
I added your lines in “INI” file and tried to double click Schema in my project. It has an error and then try to find the log file. But I search it in full HDD that still can’t found the log.

11

Hi,

Have you restarted DASM after adding lines?

%appdata%\RemObjects Software\Schema Modeler\RemObjects.DataAbstract.Unmanaged.log

this is

C:\Users\YOUR_USERNAME\AppData\Roaming\RemObjects Software\Schema Modeler\RemObjects.DataAbstract.Unmanaged.log

12

Hi,
I tried to restart the computer that tested it again. But I also can’t find any folder like you said.

smerror
smerror755×623 46 KB

13

Hi,

weird, it works on my side:

Untitled
Untitled828×602 22.8 KB

edit: try to create C:\Users\USERNAME\AppData\Roaming\RemObjects Software\Schema Modeler folder manually

14

Hi,
It works now after I create the folder manually. I will send the log for you when I got the error again. Thanks!

1 Like