ECLWatch will not delete a logical file

[kovacsbv]

Hi, I am trying to delete a logical file from ECLWatch and I get errors when trying to do so.

Code: Select all

.::2015061106.boca__browse

Cannot delete .::2015061106.boca__browse on thor: [ 25: SDS: IPropertyTree exception SDS Reply Error : SDS: IPropertyTree exception IPropertyTree: xpath parse error XPath Exception: Qualifier expected e.g. [..] in xpath = 2015061106_46boca_95_95browse ^ in xpath '/_Locks/SuperOwnerLock/2015061106_46boca_95_95browse']

I tried it with dfuplus as well:

Code: Select all


$ dfuplus action=remove server=http://10.0.1.2 name=.::2015061106.boca__browse dstcluster=thor username="username" password='secret'

Removing .::2015061106.boca__browse
Cannot delete .::2015061106.boca__browse: [ 25: SDS: IPropertyTree exception
SDS Reply Error  : SDS: IPropertyTree exception
IPropertyTree: xpath parse error
XPath Exception: Qualifier expected e.g. [..]
in xpath = 2015061106_46boca_95_95browse
           ^ in xpath '/_Locks/SuperOwnerLock/2015061106_46boca_95_95browse']



I also tried it with ~.::, ~::, and ~ for the prefix.

Can anybody suggest a solution? Anybody know what this error means?

[rtaylor]

The word "SuperOwnerLock" in the error message makes me wonder if the file you're trying to delete is a sub-file in a superfile. If so, that's the reason. You need to first remove the file from the superfile before deleting it.

HTH,

Richard

[kovacsbv]

I went into ECLWatch, and had two superfiles in Thor (which are normally transitory). I cleared them both out, and filtered by "Not in superfiles". The same file was available. I then tried re-deleting it, and got the same error.

[rtaylor]

Next question: Is this file used by a query that you have published to a Roxie in the same environment?

[kovacsbv]

No.

[kovacsbv]

Turns out this was a bug. It's fixed in JIRA 13981, which is incorporated in version 5.4.0. You cannot delete logical files starting with a digit in versions of HPCC before this fix without using special tools.