Just wondered if anyone had seen this before – trying to copy and paste a device profile in UMS, get an SQLException error when pasting. Logs show this error: “Caused by: java.sql.SQLException: An SQL data change is not permitted for a read-only connection, user or database.” I’m using the embedded database though so wouldn’t have manually configured the SQL connection, so can’t see how it would be read-only? Thanks in advance for any ideas.
Can you create a Directory under profiles or does it fail too?
Which UMS Version are you using?
Are you using an AD user or a local one?
Can you check Disk space on your UMS Server?
Hey Sebastien, thanks for the quick reply.
Creating new directory fails with the same error.
UMS is 6.06.100
Local user account
Disk space loads free (101GB)
What are the full server specs?
VM, 2 core @ 2.2GHz, 8GB RAM but only using 5.5GB of it. server does run a small number of other things, but was checked against UMS sysreqs before install and looked ok. CPU doing next to nothing on it
Did you install the web app?
IGEL KB – kb.igel.com/endpointmgmt-6.06/en/installation-requirements-37281947.html IGEL UMS Installation Requirements
I would recommend increasing the RAM to at least 9GB, rebooting the server, and running the database optimization on it.
Before rebooting the server and changing the specs:
please close all consoles
restart the Service IgelRMGUIServer
and start the DB Optimization here:
trying that now, ta. looks like it’s strugging to stop the service but we’ll see. no idea if related, but catalina.log is 1.8GB and too big to open in anything, which seems odd in itself.
(service did stop cleanly in the end, running optimisation now)
yep, that’s fixed it. thanks very much folks, awesome as always.
Continue reading and comment on the thread ‘Error: “Caused by: java.sql.SQLException”… trying to copy and paste a device profile in UMS’. Not a member? Join Here!
Learn more, search the IGEL Knowledge Base
Ask a question or comment on the above messasge thread?Join or log in to the IGEL Community to ask us anything and meet other IGEL customers, partners, and EUC enthusiasts.
Submit a question, or Join Today!
Popular Message Threads
- USB webcams in combination with RDP on IGEL OS?
- After upgrading to IGEL OS 11.04.200.01 my Citrix Storefront configuration does not work anymore – Error adding store: AM_ERROR_AUTH_NETWORK_ERROR
- How to Install IGEL OS via a Bootable USB Drive
- Any plans to support Teams Optimization Pack for VMware?
- IGEL UMS Universal Update Error: “could not resolve host name”
- Citrix session crashes with black screen, any advice and how do I find logging?
- IGEL OS on Raspberry Pi?