Author Topic: Relationships are present but don't appear (Read 5924 times)

Henrique Narciso · « **on:** October 23, 2009, 09:05:31 pm »

Hello,

after a migration, the links/relationships between elements don't appear in the diagrams.
When I open the elements they state the link exists, but after some efforts of updateding diagrams, changing visibility properties , etc. I can't put the relationships back to normal.

Can any one help?

Thanks in Advance

Geert Bellekens · « **Reply #1 on:** October 23, 2009, 09:51:02 pm »

Have you checked the "Visible Relations" dialog (menu Diagram/Visible Relations)?

Geert

Henrique Narciso · « **Reply #2 on:** October 23, 2009, 09:56:45 pm »

no relationships appear in the dialog box.

Paolo F Cantoni · « **Reply #3 on:** October 23, 2009, 11:35:35 pm »

Exactly how did you perform the migration?

Paolo

Henrique Narciso · « **Reply #4 on:** October 24, 2009, 12:41:58 am »

Hello,

I think it might be a bug.

From an EAP project, I exported the package to a XML.
I then import them into an SQLserver project.
all elements are present, the relationships appear in the links tab of all elements, however the relationships seem to be not valid and don't appear in the diagrams.
I try to get the "target" element and the element's information appears, so I think all the info is present.

If I import to a new EAP project, the links are ok, they appear normally.

My version is 7.5.848

Henrique Narciso · « **Reply #5 on:** October 27, 2009, 02:00:43 am »

Anyone know what are the main tables where the link properties appear?

I have compared the following tables:
T_object
T_diagram;
[t_connector]
[t_diagramobjects]
[t_diagramlinks]

the values are identical, but EA behaviour is diferent, in one the links appear and in the other they don't.

Can anyone help me out please!?

Henrique Narciso · « **Reply #6 on:** October 27, 2009, 03:24:58 am »

Found the solution!

diagramId is null in the [t_connector] table.

The import mechanism should put it at Zero(0), but it put's it at NULL.

Can anyone validate if I can do an Update to the table to change the NULL into a Zero(0) and if this doens't bring issues?

Geert Bellekens · « **Reply #7 on:** October 27, 2009, 04:26:22 am »

I think it will be OK, but if you really want to be sure you can always ask Sparx support.

Geert

Paolo F Cantoni · « **Reply #8 on:** October 27, 2009, 09:26:32 am »

Quote

Found the solution!

diagramId is null in the [t_connector] table.

The import mechanism should put it at Zero(0), but it put's it at NULL.

Can anyone validate if I can do an Update to the table to change the NULL into a Zero(0) and if this doesn't bring issues?

I think this is another example of subtle differences between the schemas of the various db technologies. Some of the boolean fields exhibit similar issues.

I agree with Geert, there should be no problems. I, too, have seen occasional null diagram ids and couldn't figure why they occurred. I set them to zero.

HTH,
Paolo

Henrique Narciso · « **Reply #9 on:** October 27, 2009, 08:52:27 pm »

Did it and no problems(till now) have been found.

Sparx Systems Forum

News: