KNOWLEDGE BASE

Restore Fails With Error "running 'restore Commit' Failed"


Published: 20 Aug 2020
Last Modified Date: 20 Aug 2020

Issue

Tableau Server restore fails during file move from staging to dataengine with the following error:

ERROR com.tableausoftware.commandline.SwitchCommand - Failed to execute command restore
java.lang.IllegalStateException: Command Line operation failed to execute

Environment

  • Tableau Server 2020.2

Resolution

Workaround
1. Go to the folder where "GeocodingData.hyper" file exists under Tableau Server install folder e.g, "~\Tableau\Tableau Server\data\tabsvc\dataengine\geocoding\xx\xx\xxxxx-xxxx-xxxx-xxxx-xxxxxxxxxx".
2. Right click on GeocodingData.hyper > Properties.
3. Un-check "Read-only".
4. Click OK.
5. Try restore again.

Cause

The GeocodingData.hyper file that is stored in the dataengine\geocoding directory is sometimes marked read-only to protect them from modification. This issue is under investigation by Tableau development team.

Additional Information

control-filestore.log
-------------------------------------------
2020-07-08 16:24:55.058 +0900 12184 main : ERROR com.tableausoftware.commandline.SwitchCommand - Failed to execute command restore
java.lang.IllegalStateException: Command Line operation failed to execute
at com.tableausoftware.commandline.SwitchCommand$1.run(SwitchCommand.java:200)
at com.tableausoftware.commandline.SimpleCommand.execute(SimpleCommand.java:47)
at com.tableausoftware.commandline.SwitchCommand.execute(SwitchCommand.java:148)
at com.tableausoftware.service.control.ControlServiceApp.execute(ControlServiceApp.java:171)
at com.tableausoftware.service.control.ControlServiceApp.executeCommandWithApp(ControlServiceApp.java:157)
at com.tableausoftware.service.control.ControlServiceApp.executeCommandWithApp(ControlServiceApp.java:124)
at com.tableausoftware.filestore.FileStoreApp.main(FileStoreApp.java:63)
Caused by: java.lang.reflect.InvocationTargetException
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at com.tableausoftware.commandline.SwitchCommand$1.run(SwitchCommand.java:193)
... 6 more
Caused by: java.lang.RuntimeException: java.nio.file.AccessDeniedException: D:\Program Files\Tableau\Tableau Server\data\tabsvc\dataengine\geocoding\4b\8d\7ecf9e47-f737-4f64-85cd-6be19d0182da\GeocodingData.hyper
at com.tableausoftware.filestore.FileStoreRestore.commit(FileStoreRestore.java:112)
at com.tableausoftware.service.control.BaseTableauServiceCommands.restore(BaseTableauServiceCommands.java:190)
... 11 more
Caused by: java.nio.file.AccessDeniedException: D:\Program Files\Tableau\Tableau Server\data\tabsvc\dataengine\geocoding\4b\8d\7ecf9e47-f737-4f64-85cd-6be19d0182da\GeocodingData.hyper
at sun.nio.fs.WindowsException.translateToIOException(WindowsException.java:83)
at sun.nio.fs.WindowsException.rethrowAsIOException(WindowsException.java:97)
at sun.nio.fs.WindowsException.rethrowAsIOException(WindowsException.java:102)
at sun.nio.fs.WindowsFileCopy.move(WindowsFileCopy.java:376)
at sun.nio.fs.WindowsFileSystemProvider.move(WindowsFileSystemProvider.java:287)
at java.nio.file.Files.move(Files.java:1395)
at com.tableausoftware.filestore.FileStoreRestore$1.visitFile(FileStoreRestore.java:148)
at com.tableausoftware.filestore.FileStoreRestore$1.visitFile(FileStoreRestore.java:130)
at java.nio.file.Files.walkFileTree(Files.java:2670)
at java.nio.file.Files.walkFileTree(Files.java:2742)
at com.tableausoftware.filestore.FileStoreRestore.moveDirectoryToDirectory(FileStoreRestore.java:130)
at com.tableausoftware.filestore.FileStoreRestore.commit(FileStoreRestore.java:108)
... 12 more
------------------------------------------
 
Did this article resolve the issue?