web stats
Accessing Derby DB: XSLAE Error - Control File - Mirth Community

Go Back   Mirth Community > Mirth Connect > Support

Reply
 
Thread Tools Display Modes
  #1  
Old 06-20-2018, 06:50 AM
OverMyHead OverMyHead is offline
What's HL7?
 
Join Date: Jun 2018
Posts: 2
OverMyHead is on a distinguished road
Default Accessing Derby DB: XSLAE Error - Control File

This is a new one for me; hoping there's someone out there that's seen this before with Apache Derby and can provide some guidance.

Using Squirrel SQL, I've navigated tables in the past and reset passwords without an issue. Any updates required MIRTH to be brought down, but that wasn't a problem. Now, however, I'm receiving an error when attempting to connect to the database:

ERROR XSLAE: Control file at ...\appdata\mirthdb\log\log.ctrl cannot be written or updated.

Anyone know what might cause this? Can still access Derby just fine with Mirth running. It doesn't appear to be a file-permission or location issue. Just can't access the control file from Squirrel.

Thoughts?
Reply With Quote
  #2  
Old 06-20-2018, 07:12 PM
OverMyHead OverMyHead is offline
What's HL7?
 
Join Date: Jun 2018
Posts: 2
OverMyHead is on a distinguished road
Thumbs up Resolved: Local Administrator Privileges / Filesystem

Credit to Tony G. (@agermano) on Slack for the quick answer.

Since the Derby instance was local and run from a local Squirrel SQL, the account needed administrative privileges to access/write to the control file. This Mirth Connect instance is hosted on Windows Server 2012r2. While the account used was an administrator, Squirrell SQL was not run with the flag set by default.

Solution: Run Squirrel SQL with elevated privileges. ("Run As Administrator" on Windows O/S or "sudo" in Linux.)
Reply With Quote
Reply

Tags
derby, error, password reset, squirrel, xslae

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -8. The time now is 04:32 AM.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2019, vBulletin Solutions, Inc.
Mirth Corporation