Products

Home Forums Model Expert queries configuring Model and validation

Home Forums Model Expert queries configuring Model and validation

Viewing 10 posts - 1 through 10 (of 10 total)
  • Author
    Posts
  • #10430
    Marie Due
    Participant

    Hi dear Support team
    we use ea with postgresql
    we just installed model expert. and when we want to generate package dashboard
    it seemed that we need OLEDB for postgresql, but after some confirmation of dialog boxex we can see dashboard (some parts is loaded from database missing due to errors)
    we get the following error and after click OK
    microsoft dotnet framework raise the next one
    the first error is
    —————————
    Enterprise Architect
    —————————
    Microsoft OLE DB Provider for ODBC Drivers [0x80004005]

    ERROR: function cstr(integer) does not exist;
    Error while executing the query
    —————————
    [ OK ]
    —————————
    and the net one from dotnet framework is attached
    it seemed that we have inconsistent data in our model, if yes is there any model evaluator?

    Attachments:
    #10432
    Ian Mitchell
    Keymaster

    Hi Marie
    This looks like an incompatibility between DBMS types – it always seems to be postgrSQL which causes the problems!
    I am investigating….

    #10433
    Ian Mitchell
    Keymaster

    OK – found the problem. Seems like postgreSQL does casting of variables slightly diffrently to SQlServer and the other DBMSs.
    I THINK I have fixed this, but I haven’t tested every bit of SQL, so please re-post here is you find any more issues.
    Sorry for the problem – issue is resolved in v2.2.3.0, now available for you to download.
    Ian

    #10440
    Marie Due
    Participant

    Hi Dear Ian
    thank you so much,
    I Downloaded v2.2.3.0 and everything is OK and none of the previous error occured,
    but in some of our package when we want to generate dashboard we get the attached error from dotnet framework “object reference not set to instance of an object”
    and after pressing continue “elements” , “Diagrams” , “Packages” , “Word Cloud” and “Complexity” is empty,
    Marie

    Attachments:
    #10442
    Ian Mitchell
    Keymaster

    Thanks Marie – is it possible for you to post an XMI of one of your packages which shows this error? I tried it on a few test cases, but your data is clearly a bit different from all of them! Please remove any confidential data from the XMI – I just need the structure.
    Thanks

    #10450
    Marie Due
    Participant

    Thanks Ian,
    I exported the package to xml as the attached file,
    but when I imported it for test in a new file based repository, there was no error.
    it seems that if I export entire model in xml then import it in a new file based repository there is no error on generating dashboards.
    anyway I attached xml file for you and If you want I can send you a backup of our model in postgresql format containing desired package
    many thanks
    Marie

    #10451
    Marie Due
    Participant

    file of previous post.

    #10452
    Marie Due
    Participant

    file attached again

    • This reply was modified 3 years, 2 months ago by Marie Due.
    Attachments:
    #10458
    Marie Due
    Participant

    Hi Ian
    whats up !?

    #10461
    Ian Mitchell
    Keymaster

    Hi Marie,
    Thanks for the test file. Good idea to send it as a Zipped .txt file – I just renamed it to .XML, and it loaded fine into my PostgreSQL test database.
    Just like when you loaded it into a new repository, it seems to create the dashboard OK. I tried to create a meta-model diagram from the dashboard, and there was a temporary error, but then it displayed OK.
    BUT
    …your test data didn’t touch quite a lot of the function Model Expert, as there are no connectors.

    When a package creates errors like this, but then they go away when the package is exported and re-imported into a new repository, this shows that there are low-level inconsistencies in the source data. Lots of these are easily removed using the Ea built-in EA integrity check (Configure / Model / Integrity / Project Integrity), but it doesn’t find everything.
    Taking a backup, exporting the package to XMI, deleting the package, then re-importing it works well, though beware if the package is heavily liked to other parts of the model.
    Less dangerous way is to try Model Expert on sub-packages, and see which one creates the error, then repeat the steps above on a much smaller scale.
    I hope this helps
    Ian

Viewing 10 posts - 1 through 10 (of 10 total)
  • You must be logged in to reply to this topic.

Compare licence prices

Choose the licence that’s right for you and your team

Prices

Download a free trial

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