- This topic has 1 reply, 2 voices, and was last updated 10 years, 4 months ago by .
Viewing 2 posts - 1 through 2 (of 2 total)
Viewing 2 posts - 1 through 2 (of 2 total)
- You must be logged in to reply to this topic.
Home › Forums › eaDocX queries › Accessing Repository causes error
Home › Forums › eaDocX queries › Accessing Repository causes error
Hi,
starting EADocx very first time causes following error: table T_OBJECTS doesn’t not exist. There is probably an access right problem. What kind of right ?
Remarks: I’m accessing a company repository, EA works fine.
Thanks a lot,
Michel
When eaDocX accesses the EA repository directly – which it has to do because there aren’t the required APIs in EA – it uses upper-case table names. This works OK in all the major DBMSs, when they are configured normally. We’ve tried it with SQLServer, Oracle, MySQL and EAP files.
BUT, we know that it is possible to configure some DBMSs so that they are case sensitive, so, we issue SQL to look at T_OBJECTS, and it only has a t_objects table.
We have so far not found a pattern to when this happens, and it would be a MAJOR change to eaDocX to allow for case-sensitive SQL, as we will have to parse the results in mixed case as well.
So, have a look at the case sensitivity of your DBMS.
Also, EA itself seems to be OK with this, it’s just SQL issues via EA which has the problem.
Download eaTeamWorks today for several free for life features, plus no obligation, 30-day trials of all the products: eaDocX, ea Revision Manager, eaSheets, Model Expert and PortfolioManager. Discover for yourself why we sell the world’s best-selling Enterprise Architect extension.
Download