This sounds like the same issue as reported in this post.

Let's keep this to a single thread, please post to this thread

Thanks

Jonathan

Hi, It sounds like Protege server is still loading your Essential repository. The server is only ready to use (or stop!) after it has posted Protege server ready to accept connections... to the window in which it is running - or in its log. How does your Protege project respond when running in stand...

The RMI registry will start up without much trouble but what you're seeing is a failure to connect to it. I think this is all related to this post which will describe how to tweak the ports on which the RMI Registry and the Protege Server will communicate, which is important if you need to access th...

Let's bring this together with this post

Jonathan

Hi, Good to hear that you’ve got Protege talking to the database! If you’ve got the client talking to the server, with both running locally and connecting via localhost, then you’ve done most of the setup. Let me ask, is the a firewall between your remote client and the Protege Server? If so, the Pr...

Hi, In this post New multi-language catalogue posts , we've released a preview of the new catalogues, that sort with support for multi-language. The examples are for Business Domain Catalogue and Business Capability Catalogue but show how the new versions will work. We'd be very interested to hear a...

Hi Daiana, Thanks for the update. Can I confirm with you that you have copied the JDBC 4 driver into a file called ‘driver.jar’ in your Protege root folder? It might be simpler to do this than try to convince Protege to look in another location. The two parameters for the database are easiest set in...

Hi Daiana, Out of the box, Protege will support a range of JDBC databases but it is sensitive to versions. MySQL 5.5 is supported but with an update to some Java parameters for Protege, it can support MySQL 5.6 / 5.7. PostgreSQL and MS SQLServer also work with Protege. To get later versions of MySQL...

Hi Julian, MySQL 8.0 is not currently supported. We can support MySQL 5.6 / 5.7 and out of the box, MySQL 5.5. To support MySQL 5.6, we need to define some extra Java properties to the Protege environment. You can add these to your Protege start up script (run_protege.bat / run_protege.sh). There ar...

That's great to hear.

Thanks for posting back with the solution!

Jonathan

Thanks for the update, Julian.

Sounds like you have made progress, there.
Have you now got the Essential Open Source platform running?

Jonathan

Following up on my last post, the Essential Cloud security framework does not include functionality for rule-based security classifications, driven by specific slot values on instances. The complexity of using such a scheme is not to be underestimated but we'll add this to the future requirements! T...

Hi,

Have you configured the URL for your Viewer on the settings tab and confirmed that the Import Utility can communicate with it?

Jonathan

Hi Julian, Thanks for posting the additional error screenshots. I've spotted a clue in there and I think it's all to do with the Project file that you are trying to convert to be backed by the database. That is, Protege server seems to be having trouble with the project "Pizza". Keeping al...

Hi Karen, You can use the classifications to secure access to Views, Classes, Slots on a Class or Instances and make these to control whether a user can EDIT or READ (or a combination!) those elements. However, I think what you're describing is to go further and apply classifications dynamically bas...

Hello, Thanks for your question. When importing things like Application Dependencies, you can (and should) make use of derived instances in the Import Activities wherever you can as this reduces the amount of content that must be captured in the data-capture spreadsheet. In your example, to capture ...

Hi, Following up on my last post, we’ve developed new versions of the catalogue views that are designed to support any Unicode characters. The rendering of the index is slightly different as it is dynamically calculated from the list of instances that appear in the catalogue. I’ve tested this with s...

Hi, Thanks for posting the screenshots. From the second screenshot, it looks like there is an error with the definition of the CODEBASE_URL parameter. It seems that you have it set to: set CODEBASE_URL=file:/C:/program%%20files/protege_3.5/protege.jar It _should_ read: set CODEBASE_URL=file:/C:/prog...

We recognise this issue and have a new version of these catalogue views in development now. These are designed to support any Unicode language.

These are updates to the open source Views, so I'll post a preview of them here so that you can test them out over the next day or so.

Jonathan

Hi, Just to be clear, you have already installed the correct version of Protege? If not... Currently, the installer does not include the Protege 3.5 installer. You must download and run this before you run the Essential Installer. You can find a link to the correct installer for you (the link works ...

Hi, I’ve been trying to replicate this issue but without success. Could you take me through in some more detail what you have to apply the Launch Pad? In summary: You should move the files in the Launchpad_v3/Essential Open Source Users/Essential_Launchpad_View_Pack_v3 into your Essential Viewer in ...

Hi, Yes, there are a few more components in the installer now! It looks like what's happened is that the Server Components have not been deployed to the expected location. What you're seeing is the out-of-the-box Meta Project as supplied with the base Protege platform. You can re-run the installer, ...

Hi Julian, There’s a common pattern to the JDBC driver configuration but the details do vary from database server to database server. However, regardless of the database server, you need to specify: User name which is the user account defined within your database, for Protege server to use Password ...

Hi Dag, Thanks for this. It sounds familiar to me, although it does seem to be taking longer than I have experienced before. Let me start by confirming my understanding of your scenario. You have the Essential Open Source environment deployed to a Windows platform running on AWS. You have installed ...

Thanks for raising this. The catalogue view is grouping all the elements by Latin characters and not including the Cyrillic ones. Although it won’t resolve the issue, do the Cyrillic names appear under any of the catalogue categories? We’ll take this away and work on a resolution that will work for ...

Thanks Pavel

That’s great. We’ll get this into the next release.

Jonathan

Hi, Thanks for posting. In the installer, the following variables are referenced: USER_HOME PROTEGE_HOME TOMCAT_HOME SERVER_HOME IMPORT_UTILITY_HOME INSTALL_PATH These are set during the execution of the installer via the installer GUI (in GUI-mode) or via the command line in headless mode, rather t...

Hi Gunther, It does sound like Git might be causing you some trouble. This exception is happening as the Viewer is clearing it's cache when finishing the publish process. In addition to graph_images/*.png, you'll need to exclude: graph_images/uml graph_images/pageCache graph_images/pageCache/applica...

Thanks very much for getting back to me Gunter, The issue is that one of the files in the generated DUP has invalid XML character, which is a bug in the Import Utility. I have made a fix to the Import Utility and tested this with characters such as the é in your Import Activity description and it wo...

Hi Gunther, Thanks for posting back. I’ve had a look at your test files with the following results: When I unzipped your ‘test_import_270218_134039.zip’ and renamed the resulting ZIP as a DUP, I replicated the error that you report. However, when I created a new Import Activity in my Import Utility,...

Hi,

The first link is the recommended approach.

The second is maintained to help users troubleshoot any issues with their multi-user install.

Jonathan

Hi, The link that you've included is for the original, manual install process, which did start with a large ZIP file. The later releases (v3.x+) use a wizard-based installer, which is what you should have downloaded from the Downloads page. Please follow these guides to using the installer . Jonathan

Hi Sven, Thanks for posting. It is worth checking for any error messages that your might be seeing at both the Protege and the Viewer (Tomcat) side. In Protege, check the 'console' window - that separate window that appears with the Protege GUI on MS Windows. There may be some system reports shown t...

Hi, You are quite right, there is no direct link between the Application server, that is hosting the repository in Protege and the Web Application Server that is hosting the Essential Viewer. Rather we use the explicit 'publish' process to send published snapshots of the 'live' repository to the Vie...

Hi,

From the error message that you are seeing, I think you have some 'invalid' characters in the source data that you are importing. The usual suspects to look for in your source data are "smart" quotes and similar non-standard characters, typically from MS Excel

Jonathan

This looks like a duplicate of the thread I just replied to.

Let me know if that is not the case

Jonathan

Hi, Thanks for your post and in particular the trace of the errors. I actually think that this is NOT a path problem but a permissions issue. From the trace, it seems that the call to 'prunsrv' is failing because it cannot open the Service Manager (presumably the Windows service manager) to install ...

Yes,
In Essential Cloud, there is a "grab-handle" at the bottom right of each form entry field. Click and pull the field to increase its size to your needs.

Regards

Jonathan

Hi Tudor,   You found one of the cases where the distinction of Protégé as a relationship modelling tool rather than a diagramming tool is most evident, i.e. it wasn’t really designed for this sort of case.    For anyone reading this not sure what we’re talking about, if you create a static architec...

Hi Tshitshi, Thanks for your post. There’s definitely an issue loading the ‘ear_sandbox_-_sandbox_611_repository.pprj’ project, according to your logs, which is in your Dev_Sandbox611 environment. This is probably worth checking out. This looks like you are using the open-source version of the Impor...

Hi Sven, Thanks for sending the log files. There’s not a lot to go in there, so let me ask you some more questions: - As the screenshot is showing progress at 100%, has the Viewer been updated with your demo content? - What happens in Essential Viewer? Has it received the update or has the snapshot ...

Thanks for contacting us. We’ve build Essential to try to make it as easy as possible to integrate content from a wide range of sources. The point about 3rd-party integration on the website is describing the overall capabilities of the platform. Within the open-source platform, the most commonly use...

Hi, The report that you've mentioned has that name in the View source file, is the Business Process Analysis for Business Domain: e.g. Business Process Analysis for Business Domain demo Thanks also for the feedback about the two Information Representation Attribute Types mentioned in the release not...

Thanks Tshitshi,

This is a minor omission in the update pack. There should indeed be a slot on the Information Representation class to enable you to use this classification.

We're building an update now and will get this out shortly as an EUP.

Thanks again for your help

Regards

Jonathan

Hi Stepan, All of our ‘supporting’ libraries, e.g. there’s one called ‘standardFunctions.py’ already have the UTF-8 encoding statement at the top of the script file. Indeed, we have been importing Chinese and Arabic for many versions of Import Utility via the Excel interface, which depend on the sam...

The Essential toolset is designed to operated in a 3-tier architecture. The installation process is as described in the Installation guide , replacing “localhost” with the relevant hostname of each of the servers. Specifically, - When configuring the Protege project to become a “Protege Database”, m...

Hi Stepan, Thanks very much for sharing your experience with one of the service interfaces of the Import Utility! You can use the autoImportXML service with either a local repository within the Import Utility or with a server-based Protege repository. This is controlled in the same way as with other...

Hi David, Sorry for the delay in getting back to you. This is most likely down to which of the SQLServer JDBC drivers that you are using. There are two included in the package that you download from Microsoft. I think it's worth trying the v4 driver first. e.g. I have previously copied file 'sqljdbc...

Hi David, Thanks for your post. Your connection parameters do seem to be looking good. One thing to check with SQL Server is which version of the JDBC driver you are using. There are 2 versions and it’s important to make sure these are aligned. For example, I have used ‘sqljdbc4.jar’ a number of tim...

Hi, Thanks for posting. There are a number of invalid characters that we explicitly strip from the content before it is imported via the Import Utility. Several of Microsoft Office’s “smart characters” are excluded because they use character codes that are not valid Unicode characters. Are your miss...

Hi Stepan, Thanks for posting. These security classes are primarily intended to be used by the Essential Cloud platform, which provides very fine-grained security and access control. Using Protege in the open-source edition, these are not used or observed whilst editing the repository. Protege simpl...

Thanks very much for letting us know about this. I've seen something similar when we moved to a new Java release and it's something that we'll address for Java 9. We do know that all the software runs well in Java 8 and we're using that every day, here. If it's an option for you, please try Java 8 a...

Hi, This is a known configuration issue with the Import Utility that is included in the Version 6.0 release. The pre-loaded Essential Repository is a version 5.0 repository and as you say does not work well with the Version 6.0 Essential Viewer. The idea with the Import Utility is that you can impor...

Hi, Your definition of Business Capability is pretty close to what we have defined in the Essential Meta Model. Business Capabilities are conceptual - they’re a “what” thing - but can be defined at any level of granularity that you need. So, you could have very coarse-grain Business Capabilities tha...

Thanks very much for the feedback and great to hear that you managed to significantly reduce the runtime.

Well done, spotting and resolving the UTF-8 / Unicode issue - it is definitely important if you have any characters that are outside of the ASCII character set range.

Jonathan

Hi Prem, Thanks for giving us some more background about what you’re aiming for with the ServiceNow content. It sounds like this could be done as a single once-off initial load and then ongoing updates of changes. In terms of updating your repository content for Technology Products, Suppliers, etc. ...

Hi Prem, I’ve re-worked the script library that is used by the Import Utility to query and update the Protege repository in a different way. I’m seeing significant performance improvements with this new version of the ‘standardFunctions.py’ file. I realised that there are some issues with using map(...

Hi, Thanks for your post. Could you explain precisely what you mean by "Business Function" and what it is that you want to model using this? It might sound like a bad question but as we have encountered so many different uses of terms like this, when we're clear what it is that you need to...

Hi Prem, Thanks for your question. Although Protege performs well once you’ve got the project loaded, the load-time in server mode - using RMI - can often be long. Network performance is also a key factor in this and it would be worth checking to see whether your Import Utility is running on the sam...

Hi Prem, Thanks for this feedback. On your issues with the unicode characters sets, you have done precisely the correct thing. The sample transform on which you have based your XML import is quite basic and is not set up to handle things like unicode. However, the ‘standardFunctions.py’ is shared be...

Hi, Thanks very much for your suggestion. There are a couple of things that I would like to suggest on this. The first is that there is an outer-level search that you could use - EssentialGetInstance() - that uses a cascade of different approaches for finding the correct instance. def EssentialGetIn...

Hi, Yes it is possible and this is how the import utility interacts with a Protege Server project. However, because of the high volume of interactions that take place over RMI, the performance will be noticeably affected compared to interacting directly with the Protege API. There is certainly an ov...

Hi, Thanks very much for posting the details of the error messages. One thing that jumps out is that there is not enough memory available to the environment in this configuration. We should resolve this - even though the specific error message seems to be in a different area. To add more memory to t...

Hi Jason, Unfortunately not. Protege server doesn’t really have a proper password reset workflow. You can make the change without having to restart the server by connecting to the Protege server in administrator mode. This will reload your Protege client with all the administration tabs and capabili...

Hi Carlos,

That's excellent news.

Thanks very much for letting us know!

Jonathan

Hi - Following up on John's post (to which we need to know the answer), it would also help to understand more about how far you had got when you get this message. More specifically, are you setting up a server-based environment or, more simply, opening your repository in Protege client, in stand-alo...

Hi Carlos, We have just released version 6.0.2 of the Essential Open Source software, which includes changes to address this issue. You can download this from our Downloads page . Please note that we have had to rename our installers to use a '.install' suffix. Once you have downloaded the installer...

Hi Prem, We have just released version 6.0.2 of the Essential Open Source software, which includes changes to address this issue. You can download this from our Downloads page . Please note that we have had to rename our installers to use a '.install' suffix. Once you have downloaded the installer -...

We have just released version 6.0.2 of the Essential Open Source software. You can download this from our Downloads page . Please note that we have had to rename our installers to use a '.install' suffix. Once you have downloaded the installer - in your case 'essentialinstallupgrade602' - you must r...

The problem has been identified and I have a resolved version of the Import Utility in our development environment.

We'll get a new version of the Import Utility prepared and released this week

Regards

Jonathan

Hi,

Thanks for posting this issue.

I've been able to replicate this issue and we're working on a resolution.

I'll post back when we have more

Jonathan

Thanks for posting this, Prem. I think you've discovered a bug! I can see what's causing it and I'll get that resolved - we're preparing a new release of the Import Utility right now, so this is excellent timing. Can you confirm that the error message changes depending on whether you try an Excel or...

Hi Carlos, Thanks for posting all these details. I think that there are 2 issues in here. One seems to be to do with the version of Apache POI and that is something that we are working on here at The Essential Project and I think that is what is causing the SMALLER_BIG_BLOCK_SIZE_DETAILS error. The ...

Thanks for confirming what you are experiencing. Another request from me: Could you locate your log file (e.g., /opt/tomcat2/logs/catalina.out) and just after you see the SMALLER_BIG_BLOCK_SIZE_DETAILS message, read the end of catalina.out and look for any exception messages. Please send us the exce...

Hi, Thanks for letting us know about this. Could you tell me specifically which View template you are using, please? If you look in the browser address bar, you should see a URL that contains a parameter called 'XSL' and this is specifies which View template is being used, e.g. 'XSL=essential_utilit...

Yes, I tried this with Excel v15 (2017).

If there are any cells that the Import Utility might try to read that still contain "CONCAT()" that would cause the issue.

Regards

Jonathan

Hi Tshitshi, We're going to continue to work on this but I just tried something that will resolve the issue for you now. If you replace your uses of the 'CONCAT()' function with 'CONCATENATE()', the import should work as you need it to. I have been able to replicate the issue that you are seeing whe...

UPDATE: One of the things I'd found when researching this ZK issue was about having multiple versions of libraries in available to the application. I've found that we are carrying two versions of a POI library. Could you try navigating to the <TOMCAT WEB APPS>/essential_import_utility/WEB-INF/lib fo...

Thanks for posting back. We've tested with Chrome, Firefox, IE and Safari and are not able to replicate this, unfortunately. It's interesting about the sessions, though. Can you check whether there are any session cookies set on your browser that the Import Utility - more specifically Tomcat - has s...

Thanks very much for sharing this with us. I have been able to replicate the behaviour (and error) that you are seeing. It looks like some of the functions that Excel uses, e.g. the CONCAT that you are using have been updated in the latest / later release and this is causing a problem in the Import ...

Hi Carlos, Thanks for posting. Is the error message you are seeing the same as that posted in this thread? Could you tell me more about your environment, please? Thanks for including the Java settings but it would help to know the following: - Operating system on which you are running the Import Uti...

Thanks very much for posting back on this, Sandeep. I’ve also tried out a fresh install of the v1.6.5 Import Utility on Tomcat 8 but I cannot replicate the error that you are seeing. One thought, as this is a fresh installation of the Import Utility, is it a fresh installation of Tomcat, too? It cou...

Hi Tshitshi, Thanks for your post. We use a lot of computed cell values in our data capture spreadsheets when we use the Import Utility ourselves, so I wonder if there is something different about this particular cell / column? It looks like the Import Utility is raising the error at the first row -...

Hi Andy,

This is certainly still on the list of out-of-the-box Views to include but unfortunately it didn’t make it into the latest release.

Jonathan

Hi, Thanks for your post. Unfortunately, I wouldn't expect the SmartConnection approach to resolve this. Could you confirm precisely which version of the Import Utility application that you are using, please? The latest release is version 1.6.5 - shown in the footer on the bottom left of the login p...

Hi Andy, Thanks for your post. What Colin has shown here are Views that are extended versions of the out-of-the-box Views. Currently, what you get in the open-source version is limited to 2 or so levels - however, as Colin says, the repository is ready to manage as many levels of detail that you mig...

Thanks very much for the update. That is not quite what I would expect to see after an upgrade. We use the upgrade packs ourselves in order to build each new ‘baseline’ release of the repository. Your Resource_Optimisation section looks like it has upgraded correctly but the “Skills_Management” sect...

Hi Venkat, Thanks for posting. Firstly, Essential Architecture Manager will not work with Protege 5.x. Rather you should use Protege 3.5 (which you can download from here http://protege.stanford.edu/download/protege/3.5/installanywhere/Web_Installers/) As an aside, Protege 4.x+ is a different tool t...

Hi Prem, Thanks for posting back. Could you tell me which version of the meta model you were using before you ran the upgrade to version 6? If you open your repository in Protege and navigate to EA_Class -> About_Essential -> Meta_Model_Version, you'll see an instance that describes your current ver...

Thanks for getting back to me, Jeff - and thanks for your perseverance! I’ve spent some time looking at this View and example models that work with this and those that are not and I think there are some things that we need to look at (on the Essential Project side) with this, that may have affected ...

Hi Jeff, Thanks for your post. It is certainly the Technology Component Usages that you should be classifying using the “Front End Tier”, “Middle Tier” and “Back End Tier” taxonomy terms. Each of these usages must be a usage that features in the Technology Product Build Architecture instance that de...

Thanks for posting. From what you've recorded from the Protege console during start up and the fact that you can see the help document in the menu, the Snapshot tab is installed correctly. From the Project -> Configure menu, you should see a panel like that in the attached picture: Screen Shot 2017-...

Hi, This is the view that is called "Business Reference Model" on the View Library. Looking at the View Template, the key to this View is that we need to specify the root capability that anchors the model. In the repository, you should find a class called Report_Constant (EA_Class -> EA_Su...

Hi Rick, That "Is persisted" checkbox is used to say that the data is being persisted - that is, the Application 'saves' the data that is selected on the relationship. The relationships capture the context in which the data is being used by the application. If your application saves the da...

Hi, Thanks for posting about this. The two issues that you describe are related. Both concern publishing to your specified Viewer environment. To confirm whether the Import Service is actually performing the import successfully, you can set the “Publish after import?” option to “No”. In this case th...

Hi, Thanks for posting this. I’ve just managed to replicate your scenario but I’d like to check your configuration matches what I have done. I created a new Production Environment in the “Target Environments” section and set the “Deployment Type” for this new environment to “Server”. Then, when I tr...

Hi Rick, Thanks for posting. This view embodies the following concepts: - an Application persists information (Information Representation instances) elements through its ‘uses_information_representation’ slot when the “persists information” flag is set to ‘true’ (app_pro_persists_info_rep). The key ...

Hi Rick, Assuming that what you’re looking for is an additional column on the table that shows the Objective Type, 2 changes to the file : business/core_bl_bus_perf_model.xsl are required. First, in the template, BusinessObjectivesCatalogue, at around line 210, you need to create the new column for ...

Appears to be a duplicate.

Closing this thread

Excellent!

Thanks for the update. Do let us know how you get on!

Jonathan