irods-contrib / irods-cloud-browser

DFC Web Based cloud browser
BSD 2-Clause "Simplified" License
19 stars 13 forks source link

issue with query metadata tags size > 0 #187

Closed michael-conway closed 7 years ago

michael-conway commented 7 years ago

Per Randy Splinter..

  1. I have four files (10Mfile, 1Mfile, 1Mfile.1, 1Mfile.2). They have metadata tags, respectively of “Size 10”, “Size 1”, “Size 1”, and “Size 1”. From the CLI

[rsplinte@wosres1 ~]$ imeta qu -d Size '>' 0

collection: /TTU_ResData/home/rsplinte/Loopy

dataObj: 10Mtest


collection: /TTU_ResData/home/rsplinte/Loopy

dataObj: 1Mtest


collection: /TTU_ResData/home/rsplinte/Loopy

dataObj: 1Mtest.1


collection: /TTU_ResData/home/rsplinte/Loopy

dataObj: 1Mtest.2

            When I try to do the search from the cloud browser I get a pause and then the screen returns to the original and there are no results of the search.
michael-conway commented 7 years ago

From the resource server log file

Oct 4 13:33:45 pid:19085 NOTICE: Agent process 42616 started for puser=rsplinte and cuser=rsplinte from xxxxxxx

Oct 4 13:33:45 pid:42616 NOTICE: rsGenQuery: rcGenQuery failed, status = -823000

From the iCAT server log file

Oct 4 13:33:39 pid:21614 ERROR: Table for column 408 not found

Oct 4 13:33:39 pid:21614 NOTICE: _rsGenQuery: genQuery status = -823000

Oct 4 13:33:39 pid:21614 NOTICE: rsGenQuery: _rsGenQuery failed, status = -823000

michael-conway commented 7 years ago

image

michael-conway commented 7 years ago

that works with query

image

michael-conway commented 7 years ago

avus are

image

michael-conway commented 7 years ago

are there any actual differences to iCAT over WOS?

It turns out Randy's error is around

        vcsAsDataObject = dataObjectAO.findDomainByMetadataQuery(query);

Which underneath does

public static void addDataObjectSelectsToBuilder( final IRODSGenQueryBuilder builder) throws GenQueryBuilderException {

    if (builder == null) {
        throw new IllegalArgumentException("null builder");
    }

builder.addSelectAsGenQueryValue(RodsGenQueryEnum.COL_D_DATA_ID) .addSelectAsGenQueryValue(RodsGenQueryEnum.COL_D_COLL_ID) .addSelectAsGenQueryValue(RodsGenQueryEnum.COL_COLL_NAME) .addSelectAsGenQueryValue(RodsGenQueryEnum.COL_DATA_NAME) .addSelectAsGenQueryValue(RodsGenQueryEnum.COL_DATA_REPL_NUM) .addSelectAsGenQueryValue(RodsGenQueryEnum.COL_DATA_VERSION) .addSelectAsGenQueryValue(RodsGenQueryEnum.COL_DATA_TYPE_NAME) .addSelectAsGenQueryValue(RodsGenQueryEnum.COL_DATA_SIZE) .addSelectAsGenQueryValue( RodsGenQueryEnum.COL_D_RESC_GROUP_NAME) .addSelectAsGenQueryValue(RodsGenQueryEnum.COL_D_RESC_NAME) .addSelectAsGenQueryValue(RodsGenQueryEnum.COL_D_DATA_PATH) .addSelectAsGenQueryValue(RodsGenQueryEnum.COL_D_OWNER_NAME) .addSelectAsGenQueryValue(RodsGenQueryEnum.COL_D_OWNER_ZONE) .addSelectAsGenQueryValue(RodsGenQueryEnum.COL_D_REPL_STATUS) .addSelectAsGenQueryValue(RodsGenQueryEnum.COL_D_DATA_STATUS) .addSelectAsGenQueryValue(RodsGenQueryEnum.COL_D_DATA_CHECKSUM) .addSelectAsGenQueryValue(RodsGenQueryEnum.COL_D_EXPIRY) .addSelectAsGenQueryValue(RodsGenQueryEnum.COL_D_MAP_ID) .addSelectAsGenQueryValue(RodsGenQueryEnum.COL_D_COMMENTS) .addSelectAsGenQueryValue(RodsGenQueryEnum.COL_D_CREATE_TIME) .addSelectAsGenQueryValue(RodsGenQueryEnum.COL_D_MODIFY_TIME);

}

I'm wondering if there are issues iwth resc group name and resc name, for example, that might be wrapped up in WOS? Just a thought, it's getting a -832000 table not found, but running against plain ole 4.1.8 it runs as expected...