Joomla Publishing Issue

[MickS]

Hi

Been playing around with Joomla publishing for the last 3 days using IIS web server, mysql, joomla and EAv13.
After successfully installing and configuring MySQL5.7, along with other prerequisites (php cgi etc) on IIS, as well as installing and configuring Joomla with MySQL and successfully creating ODBC connection to Joomla DB I'm having issues generating joomla content via EA.

The following is EA sys output:
Retrieving selected Package information .. OK   
   Package and Element Count : 28   
   Diagram Count : 1   
Connecting to Joomla! Database .. OK   
   Reading information from Joomla! Database .. OK   
   Creating Enterprise Architect Article Menu in Joomla! Database .. Fail   


The following is the error I see in ODBC log:

1479959888:select count(*) from usys_system;
1479959888:Using direct execution;
1479959888:query has been executed;
1479959888:Table 'joomla.usys_system' doesn't exist;

Anyone encounter similar issue? I can't find any reference to this joomla.usys_system table at all?

I have emailed sparx support and provided all the necessary install/config screen shots and am awaiting their response but if anyone can offer any insight, that would be fantastic.
Thank You

[qwerty]

There are quite a number of people reporting a missing usys_system table (not in Joomla context) which blocks a model transfer. You can re-construct it by making a copy of that table in an arbitrary EAP file.

q.

[MickS]

So is there a known issue why such tables are not being created, and is this only with particular DB repositories?
What is the root cause if known?

Haven't had any issues with project transfers and tables not being created, so no issues there. I guess can try creating such tables on .eap and in our dev environment, but again, looking at existing usys_system table it holds various cert keys from what i can see?

[qwerty]

It's a static table which is the same for all repositories. I have no idea why it can vanish. I just have seen a number of threads where this was an issue.

q.

[MataraIT]

Recently, I came across this post because I had the same issue when publishing to Joomla.
What struck me as odd, is that the usys_system table is part of the internal EA datamodel, but not at all of the Joomla datamodel (in my case those would all start with the prefix 'jos_' in the database).
Why is it trying to access that table when it shouldn't be there in the first place?
I don't know whether you changed anything about the menus that EA generated into Joomla. I did, and when I reverted those changes, my export went smoothly again.
I changed the name of the menu and display-name of the menu (because I thought the first name was the second name, yeah I'm not a Joomla expert yet). Maybe this helps.
Also, I've managed to export Joomla directly to an online Joomla-installation, which made debugging a little easier for me than having to deal with installing php, Joomla, MySQL and the lot on my local machine.
Just my two cents.

[berhauz]

The error about the usys_system missing table is actually a (miss)consequence of another error. In my case:

INSERT INTO `ea_joomla`.`aba_assets` (`parent_id`,`lft`,`rgt`,`level`,`name`,`title`,`rules`) VALUES (?,?,?,?,?,?,?);
[ODBC 9.0(w) Driver][mysqld-5.5.5-10.4.32-MariaDB]No data supplied for parameters in prepared statement;

Fact is, this is a nasty effect of the ODBC driver version 9. Stepping down to mysql-connector-odbc-8.0.28-winx64.msi
AND Joomla 3.9.25 (unfortunately, Sparx EA developpers indicate that Joomla compatibility tests ended with v3.6, so avoid v4 and v5)
and XAMPP 7.4.33 (also old! but to retain compatibility with Joomla 3.9)
provides altogether a working combination