Topics

31

PCS Frequently Asked Questions / [Cloud] Access EA models using SQL clients

« on: March 10, 2020, 12:49:50 am »

You can only query the EA models using EA. Direct access to EA databases is not permitted.

32

PCS Frequently Asked Questions / [Cloud] How is the data shared with the customer once the cloud service ends?

« on: March 10, 2020, 12:49:46 am »

We can share the EA models as eapx files or SQL file dumps as per your requirements

33

PCS Frequently Asked Questions / [Cloud] Host EA models on Postgres database in AWS

« on: March 10, 2020, 12:43:25 am »

Yes, PostgreSQL engine versions from 9.3 to 11.5 are supported by AWS

34

PCS Frequently Asked Questions / [Charts] "No Elements Found" issue

« on: March 10, 2020, 12:02:44 am »

Here are the scenarios that could lead to this error and steps to handle it:

EA database on Microsoft SQL server:

Is the Data Type ntext rather than nvarchar in the attribute table? (Refer below screenshot).


If it's ntext, you need to upgrade the schema to the latest version and this issue should be resolved.

We have two options to resolve this issue.

Option #1:

• Take a backup of the EA repository without fail
• Visit this link and download the database schema under Updating earlier DBMS schemas section. Ensure to choose the right schema!
  
• Run the upgrade schema
• Do an integrity check
• Check if you are able to access this model using EA and Prolaborate without any issues

Option #2:

• Create an empty database
• Visit this link and download the database schema under Enterprise Architect Schema Creation Scripts section. Ensure to choose the right schema
• Run the latest DB schema
• Do a project transfer from existing DB to this one (EA should be handling all the conversions smoothly)
• Configure this DB in PCS and Prolaborate. Check if everything is working fine

EA Database on PostgreSQL server
Run this query on each of your EA databases:

Code: [Select]

create extension hstore
EA database on Firebird server
It will not work in Prolaborate as that database server is not supported yet.
You can host your EA models on a supported database server.

No elements present in the selected packges
Ensure there are indeed objects available inside the packages that you have selected on the left.

35

PCS Suggestions and Requests / Search elements based on Alias in Prolaborate

« on: February 27, 2020, 07:22:21 pm »

Request: Is there a way to search based on aliases in Prolaborate?

Response: We have added this item to our product backlog. Here is the Prolaborate link for the reference: https://team.prolaborate.com/xvfzu

36

PCS Frequently Asked Questions / Upgrade Prolaborate from V3.0.x

« on: February 12, 2020, 05:18:17 pm »

Please follow these steps to upgrade from V3.0.x:
Prerequisite: Pro Cloud Server license certificate should be available. Instructions to get it without interrupting current usage can be found in this link under section "Updating Licensed Pro Cloud Server Installations to version 4"

• It is recommended to take a backup of Prolaborate folder and database
• Visit this link and download Prolaborate and Pro Cloud Server (PCS) Installers using the credentials in your Pro Cloud Server document
• Install PCS and restart Sparx Systems Professional Cloud service.
• Add the License Certificate (.crt) to PCS
• Enable Pro Features for the database managers configured in PCS, if not enabled already
• Stop all Prolaborate services and processes (All services and processes starting with Prolaborate and websocketd process) from Task Manager
• From the downloaded Prolaborate folder, run Setup.exe as administrator and complete the installation. Note there would be a brief wait time after you click on Next.
• Check Prolaborate Versions in the Health Checks page. If there is a mismatch between current and latest versions, run the latest database schema on the Prolaborate database from the Release Notes page based on the database server used for Prolaborate.
• [Mandatory] In the Password Security SQL file shared by Prolaborate team, update emailid with the email id of a Prolaborate admin and run it in your Prolaborate database. Choose the SQL / MySQL query file based on the database server you are using for Prolaborate.
• [Mandatory] Open ProlaborateServiceManagement.exe (Typically located at C:\ProgramFiles(x86)\Prolaborate\ProlaborateServiceManagement). Click on Reset Password.
• [Mandatory] Enter the New Password you want to set for all Prolaborate users; enter the email id used in the query above and the new password set using the query, and then click on Save. New Password will be set for all Prolaborate users. This will not impact Active Directory users.
• Restart Prolaborate and Prolaborate Mailer services

Note:

• Password algorithm and rules have been changed to improve security and so, steps 9, 10, and 11 need to be mandatorily carried out.
• For better performance, few validations have been introduced in the Charts widget of Dashboard. They need to be reconfigured if they are showing an error after upgrade
• If you are using the other features of Pro Cloud Server not related to Prolaborate(say Integrations), please make changes as per this link and ensure everything is working fine
• (Critical) If you are using the Prolaborate macro for Confluence, schedule your upgrade of Prolaborate and the macro together. The latest version of Prolaborate is compatible with only the latest version of the macro.
• (Critical) After the upgrade of macro, do not change Default Repository. If you want to change, all the EA information that has been embedded using the macro needs to be reconfigured.
• As the profiles in Create Elements are linked with the profiles in Modeling languages, the standalone profiles will not be available anymore.

37

PCS Frequently Asked Questions / Upgrade Prolaborate from V3.1.x

« on: February 12, 2020, 05:15:23 pm »

Please follow these steps to upgrade from V3.1.x:
Prerequisite: Pro Cloud Server license certificate should be available. Instructions to get it without interrupting current usage can be found in this link under section "Updating Licensed Pro Cloud Server Installations to version 4"

• It is recommended to take a backup of Prolaborate folder and database
• Visit this link and download Prolaborate and Pro Cloud Server (PCS) Installers using the credentials in your Pro Cloud Server document
• Install PCS and restart Sparx Systems Professional Cloud service.
• Add the License Certificate (.crt) to PCS
• Enable Pro Features for the database managers configured in PCS, if not enabled already
• Stop all Prolaborate services and processes (All services and processes starting with Prolaborate and websocketd process) from Task Manager
• From the downloaded Prolaborate folder, run Setup.exe as administrator and complete the installation. Note there would be a brief wait time after you click on Next.
• Check Prolaborate Versions in the Health Checks page. If there is a mismatch between current and latest versions, run the latest database schema on the Prolaborate database from the Release Notes page based on the database server used for Prolaborate.

Note:

• For better performance, few validations have been introduced in the Charts widget of Dashboard. They need to be reconfigured if they are showing an error after upgrade
• If you are using the other features of Pro Cloud Server not related to Prolaborate(say Integrations), please make changes as per this link and ensure everything is working fine
• (Critical) If you are using the Prolaborate macro for Confluence, schedule your upgrade of Prolaborate and the macro together. The latest version of Prolaborate is compatible with only the latest version of the macro.
• (Critical) After the upgrade of macro, do not change Default Repository. If you want to change, all the EA information that has been embedded using the macro needs to be reconfigured.
• As the profiles in Create Elements are linked with the profiles in Modeling languages, the standalone profiles will not be available anymore.

38

PCS Frequently Asked Questions / [Cloud] How are the connections secured?

« on: January 29, 2020, 06:18:46 pm »

With the cloud services, EA users will be able to access the models using Cloud Connection and Business users will be able to access the models using Prolaborate with just a browser.

Both these connections are secured using HTTPS.

39

PCS Frequently Asked Questions / [Reviews] How can I change the review from Archived to Active state?

« on: January 27, 2020, 11:38:18 pm »

Edit the archived review and extend the review end date. This would automatically move the archived review to Active state.

40

PCS Frequently Asked Questions / Tagged value dropdowns in Prolaborate

« on: January 27, 2020, 11:21:31 pm »

This is one of the reasons why we built the Modeling Languages feature.

All you have to do is upload the xml of your MDG in Prolaborate from the Modeling Languages page and the dropdowns will automatically start appearing in Prolaborate.

41

PCS Frequently Asked Questions / [User Management] Role-based admin access in Prolaborate

« on: January 27, 2020, 11:18:29 pm »

Role-based admin access can be defined using Feature Sets capability in User Groups. (Learn more here)

42

PCS Frequently Asked Questions / [User Management] Role-based EA model access in Prolaborate

« on: January 27, 2020, 11:17:32 pm »

Role-based access to EA models can be defined using Access Permissions (Learn more here).

43

PCS Frequently Asked Questions / [Installation] Prolaborate installer is not running

« on: January 27, 2020, 11:14:02 pm »

Are you trying to run Prolaborate.msi file?

Are you seeing an error saying the installer requires Administrator Privileges?

If the answers are Yes to both questions, please run Setup.exe file with admin privileges and the installer should run fine

44

PCS Frequently Asked Questions / [Sections] Error on retrieving artifacts

« on: January 27, 2020, 11:11:54 pm »

This error shows up due to the following reasons.

• When Prolaborate is not able to get the required information from Pro Cloud Server
• If there is no content in the database.

If you have loaded the model into EA database, please check the following and try to resolve the issue.

• Restart the Sparx Systems Professional Cloud service from task manager.
• Are you able to see the EA model in the Project browser window using Cloud Connection of EA and in the Prolaborate as well?

If you have not loaded the model, please upload the model into EA database and check.

45

PCS Frequently Asked Questions / [SSO] Prolaborate is not able to connect with SAML SSO app

« on: January 27, 2020, 11:10:01 pm »

The following information is needed for further analysis:

• Name of the SSO app or IDP
• IDP’s source link
• Metadata XML file
• Screenshot of the following:
  
  • Browser after clicking on Login with SSO from the Prolaborate login page
  • Manage Users, SAML settings, Repositories pages in Prolaborate
  • Attributes configuration from IDP
• Log files:
  
  • Go to this location C:\Program Files (x86)\Prolaborate\WebApplication\VirtualAssets\ErrorLogs and delete all the log files
  • Click on Login with SSO from Prolaborate
  • Log in with credentials from IDP
  • You will be redirected to Prolaborate Repositories page
  • Share log files