Mon Mar 30, 2020 6:05 am
Login Register Lost Password? Contact Us


ECLWatch will not delete a logical file

Comments or questions specific to the features of ECL Watch

Thu Jun 18, 2015 12:58 pm Change Time Zone

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?
kovacsbv
 
Posts: 33
Joined: Fri Aug 05, 2011 12:53 pm

Thu Jun 18, 2015 1:10 pm Change Time Zone

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
rtaylor
Community Advisory Board Member
Community Advisory Board Member
 
Posts: 1522
Joined: Wed Oct 26, 2011 7:40 pm

Thu Jun 18, 2015 1:26 pm Change Time Zone

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.
kovacsbv
 
Posts: 33
Joined: Fri Aug 05, 2011 12:53 pm

Thu Jun 18, 2015 1:33 pm Change Time Zone

Next question: Is this file used by a query that you have published to a Roxie in the same environment?
rtaylor
Community Advisory Board Member
Community Advisory Board Member
 
Posts: 1522
Joined: Wed Oct 26, 2011 7:40 pm

Thu Jun 18, 2015 1:35 pm Change Time Zone

No.
kovacsbv
 
Posts: 33
Joined: Fri Aug 05, 2011 12:53 pm

Tue Sep 01, 2015 9:21 pm Change Time Zone

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.
kovacsbv
 
Posts: 33
Joined: Fri Aug 05, 2011 12:53 pm


Return to ECL Watch

Who is online

Users browsing this forum: No registered users and 1 guest

cron