EADOCX and a Server connected model

[Mike Blackwell]

We have recently been using EADOCX with an EA Model located on a Server using ODBC MySQL for connection.
The model is quite locked down so that some users are read only on some parts of model.
It works fine apart from:
If we save a Design/Matrix model and then include it in a Word Docx file using
INSERT, REPORT, RELATIONSHIP MATRIX

It comes up with these two errors (see attached).

We do the same thing on a locally based model and it works fine.

Is there some other setup you need to use for EADOCX if the model is on a server.

[eadocX Support]

“Table doesn’t exist” is indeed a very strange error message.
Looking at the code, when you start creating a new Relationship Matrix, the most obvious database call is where eaDocX reads the T_TRXTYPES table (I think for the only time) to get a list of already-defined relationship matrices in EA, but there are almost certainly lots of other bits of database access as well.

Are you comparing two MySQL DBs here, or a local EAPX and a server-based MySQL ?
You mention ‘locked down’ – do these take the form of additional database constraints, on top of EA’s security?

[Mike Blackwell]

It is a local EAP model (which works) and a server based MySQL (that doesn’t). Only EA security is used within the EA model itself to make sure that parts of model are read only to some users. The bit we are using in the server model was created ourselves by pasting packages in from a local model. We repointed the sections in our EADOC template and can regenerate the document fine apart from the matrix report as described.

[eadocX Support]

So is the generation of the doc which is falling over, or the creation of the RM ?

[Mike Blackwell]

If you ignore the error it will generate the rest of the document ok. Though obviously if report is only thing in doc , nothing happens.

The 1st error screen shows about 4 times in a row, the second one once.

[Author]

Posts