Customer reported that when they open any diagram in Prolaborate they are facing no access to diagram in Prolaborate.
Hi Customer name,
Thank you for contacting Prolaborate support.
We understand that you're encountering the "No Access to the Diagram" error. To investigate the issue, kindly provide the following information:
1. Is Prolaborate hosted on a MySQL or MS SQL database?
2. Please let us know the version of Prolaborate you are using.
3. Are you encountering this error for specific packages or for all diagrams?
By providing the above information, we can better understand the situation and work towards resolving the issue.
If you have any questions or concerns, please don't hesitate to let us know. We are here to assist you.
Note: If customer responded they are using My sql need to provide the second response
Hi customer name,
Thank you for providing the requested information. It appears that the issue might be related to the attribute values in the MySQL server. In order to troubleshoot the issue kindly follow the outlined steps below:
1. Press the Win + R keys simultaneously to open the Run dialog box.
2. Enter "%programdata%" and click "OK."
This will take you to the ProgramData folder.
3. Locate the MySQL folder, usually found at C:\ProgramData\MySQL\.
4. Open the folder named "MySQL Server [your server version]," such as "MySQL Server 8.0."
5. Look for the "my.ini" file and open it using Notepad or any preferred text editor.
Within the "my.ini" file, please check and update the following settings:
- **max_allowed_packet size:** If the value is less than 100, kindly update it to 1024 or a higher value.
Please check your sql-mode or sql_mode value in MySQL configuration. If it contains ONLY_FULL_GROUP_BY, please remove it.
Once you have made these adjustments, be sure to save the "my.ini" file.
And please note that after applying these modifications, it's essential to restart the SQL service to ensure that the changes take effect.
By doing the above steps will resolve the access issue to your diagrams in Prolaborate. If you encounter any further challenges or have additional questions, please don't hesitate to contact us.
NO Access To Diagram, Prolaborate, My sql, Only_full_Group_By, My sql Server, max_allowed_packet, How to increase max_allowed_packet