Home › Forums › NexJ Studio › Tools › Tutorial error: Biz model fundamentals -> Enumerations -> Upgrade the database

Tagged: 

Viewing 5 reply threads
  • Author
    Posts
    • June 13, 2019 at 10:35 am #10650
      Jimmy TJimmy T
      Participant

      I was cruising through the Enumerations tutorial (Link Removed), but hit a snag when time came to Upgrade the database. Never encountered such issues upgrading the database before (having completed all the previous Business Fundamentals tutorials) (an error dialog does come up when publishing (it says “compilation of java classes in project ‘training’ requires a java 6 JDK. Add this jdk in Eclipse Java preferences.”, but I wasn’t able to add the JDK in Java Preferences, and previous publish operations completed anyway). I’m including the whole output below (it’s pretty long), as I have no idea what I did wrong, it seemed like a pretty straightforward tutorial. Hope you can help!

      Thanks
      Jimmy

       

      0
    • June 13, 2019 at 12:50 pm #10663
      Trevor BallTrevor Ball
      Participant

      This looks like ECRM-28556, which we cancelled because even the reporter was unable to reproduce it. I’d like to get a look at your database if it’s still intact and available.

      I had a quick look at the code in question, and it looks fine to me. The only thing I can really think of so far is that perhaps if you reuse a database from a previous incarnation, perhaps the recreate doesn’t eliminate all traces of Client Insights being enabled.

      0
      • June 13, 2019 at 1:55 pm #10683
        Jimmy TJimmy T
        Participant

        How would you like me to provide the database – from SQL Server Management Studio, should I backup, export, copy, something else?

        0
        • June 13, 2019 at 3:17 pm #10699
          Trevor BallTrevor Ball
          Participant

          Actually, if you could just provide the results of this query, that should be sufficient:
          <pre class=”lang:tsql decode:true crayon-selected”>select * from NJSystemPreference

          0
          • June 13, 2019 at 3:25 pm #10701
            Jimmy TJimmy T
            Participant

            Results of select * from NJSystemPreference

            0
    • June 13, 2019 at 1:01 pm #10665
      Shahzad Qureshishahzad.qureshi
      Keymaster

      Hi,

      Could you please tell me which version of Java do you have installed currently? and please also elaborate on what you mean by “but I wasn’t able to add the JDK in Java Preferences”.

      It would be helpful if you could post a screenshot of Studio settings Window/Preferences/Java/Installed JREs

      0
      • June 13, 2019 at 2:02 pm #10685
        Jimmy TJimmy T
        Participant

        Please see screenshot; I also show what happens when I try to add a jdk.

         

        0
    • June 13, 2019 at 1:09 pm #10674
      Trevor BallTrevor Ball
      Participant

      Could you please also provide the contents of your environment file (and properties file if applicable)? Is it exactly the same one you initially recreated with? If not, please also provide what you recreated with.

      0
      • June 13, 2019 at 2:10 pm #10695
        Jimmy TJimmy T
        Participant

        I “installed” nexj studio by extracting “nexj-studio-13.0-training.zip”.

        Sorry, I’m just starting with NexJ studio, so can you please specify the paths where I can find the environment file and properties file (say, relative to nexjstudio.exe)

        0
        • June 13, 2019 at 3:14 pm #10697
          Trevor BallTrevor Ball
          Participant

          The environment and properties files are in the project folder in your chosen workspace, in the env folder. It will be important to know which you used when you recreated and which you used when you upgraded (especially if you didn’t use the same one(s) both times).

          0
    • June 13, 2019 at 3:33 pm #10710
      Jimmy TJimmy T
      Participant

      Found the attached files in C:\nexj_studio\13.0-training\training\models\training\env

      I haven’t modified these files; they were just the files that came with “nexj-studio-13.0-training.zip” that Dhruv provided.

      0
    • June 13, 2019 at 5:13 pm #10712
      Trevor BallTrevor Ball
      Participant

      Thanks for the additional info. The mystery is how Client Insights was ever enabled given these environment/properties files, because it shouldn’t have been. Were these the only environment/properties files ever used in this database, or is it possible that it had been recreated and/or updated using any other environment/properties files at some point?

      I’ll do more investigation and if I can find a way to reproduce this myself, I’ll reopen ECRM-28556, but to resolve your issue and allow you to proceed, I think the simplest thing is going to be forcing disablement of Client Insights, using this query:

      I would NOT recommend this in a production environment, or even a long-term development or QA environment, but for a training/sandbox environment it should be fine, especially if you have no plans to use the Client Insights feature.

      After this update query, you should be able to proceed with your upgrade.

      0
      • June 13, 2019 at 6:32 pm #10714
        Jimmy TJimmy T
        Participant

        Yes, that worked, thanks.

        I am just following the tutorials, haven’t done anything else. I don’t even know what Client Insights is, let alone how to turn it on… :^) So I don’t know how it got enabled.

        0
  • Author
    Posts
Viewing 5 reply threads
  • You must be logged in to reply to this topic.