Known Issue-Prolaborate_Customize

Known Issue-Prolaborate_Customize

Q1:Prolaborate Server Cloning.

Issue

If the AWS instance on which prolaborate was running was taken a snapshot and if it was restored in a differnt server will prolaborate work?

Resolution

If the two prolaborate instances are running on a same database it will work seamlessly.
If the prolaborate version changes it may not function properly with a single DB as the schemas for each prolabroate versions will vary.

Response

Hi <Customer Name>,

Thanks for reaching out to prolaborate support.

You could run two Prolaborate instances connected to the same database. However please make sure you run the same versions of Prolaborate since the DB schemas are different for each versions. If you still wish to run two different version with same database in a same server shouldn't be a problem, but we don't personally advise it because due to the database schema differences, some features may not work in the older version.

Please feel free to reach us for any clarification.
Ticket ID: #9148
Subject: Is prolaborate 5.2 available? May address connection issue for our QQ users
Department: Sparx Platform Support

Q2:Delete Users by Type in Prolaborate.

​Description

This KB provides a SQL query format to delete users by email ID and user type in Prolaborate. The query is useful for scenarios where user deletion is required based on specific criteria.

Steps to Resolve

Note: Before executing the query, ensure you have a backup of the Prolaborate database.

1. Use the following query format to delete users:
DELETE FROM users WHERE Email IN ('EmailID1', 'EMailID2') AND UserRole_Id = 'User Type'
   - `EmailID1`, `EmailID2`: User email IDs to be deleted.
   - `User Type`: Either 'IDENTITY-PROVIDER-USER' or 'SYSTEM-USER' based on the user type.

2. Replace the placeholder values with the actual user email IDs and type.
Example: DELETE FROM users WHERE Email IN ('ari@mail.com', 'ari1@mail.com') AND UserRole_Id = 'IDENTITY-PROVIDER-USER'
Note: This query is intended for advanced users. If you have any concerns or require assistance, please contact the Sparx Systems Prolaborate support team.

Tags

aws snapshot, users by type, server cloning, derver cloning,  aws, delete, cloning

    • Related Articles

    • Troubleshooting - Manage Users

      Q1: Change User's Login Email to a Different Email Address Description The customer has submitted a request to update the login account from PCuthbert@meaa.mea.com to AUmat@meaa.mea.com. Step by Step instructions Step 1: Log in to your Prolaborate ...

    • FAQ - Prolaborate V5

      Q1: Will the Admin Account and Support Account Consume a License? Answer The admin@prolaborate.com account is an inbuilt user automatically included during Prolaborate installation.Regarding the support@prolaborate.com account, please note that the ...

    • FAQ's - Managing Users

      Q1: How to remove users from Prolaborate? and what are the implications of deleting a user? Answer In order to delete a user from Prolaborate, you have to navigate to Menu > User and License Management. Click on More and Select 'Delete'. Please note ...

    • Known Issues - Charts

      Q1: Roadmap Displaying EA GUID Values When Grouping by RefGUID Property Description The customer reports that when grouping the roadmap items by a property of type 'RefGUID', the roadmap shows the EA GUID values of the referenced elements. We were ...

    • Known Issue - Floating License Server

      Q1: Failure to Launch EA Due to FLS Keys Limit Exceeded FLS connection indicates "Provided Credentials have exceeded the key limits for this key type" Description The customer has informed us that upon launching EA, an error message appears stating, ...