• If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Announcement

Collapse
No announcement yet.

Datasource doesn't validate anymore

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Datasource doesn't validate anymore

    Hi,
    I have a datasource that validated before, but now it doesn't. In NAB the preview of the SQL statement (step 1) stays 'validating'. When I press next I get the same.
    The grid still shows, only the pagination is broken "no data to display" where the count is shown.
    I am running on the latest version. No error in the error app, no message in QSYSOPR, nothing in VVGENLOG.

    See SQL statement below.

    Regards,
    Theo

    Code:
    WITH libifs(ifsfullname, ifsoid) AS (
    SELECT
    trim(fullname),
    oid
    FROM
    ludodta.libbes AS l2
    )
    SELECT
    l.name AS l_name,
    l.tags AS l_tags,
    l.type AS l_type,
    l.descript AS l_descript,
    l.oid AS l_oid,
    l.addedby AS l_addedby,
    l.addedon AS l_addedon,
    l.path AS l_path,
    l.extention AS l_extention,
    l.fullname AS l_fullname,
    l.keytype AS l_keytype,
    l.keyvalue1 AS l_keyvalue1,
    l.keyvalue2 AS l_keyvalue2,
    l.contractor AS l_contractor,
    l.changedby AS l_changedby,
    l.changedon AS l_changedon,
    z.access_timestamp AS z_access_timestamp,
    z.data_change_timestamp AS z_data_change_timestamp,
    z.last_used_timestamp AS z_last_used_timestamp,
    z.days_used_count AS z_days_used_count,
    z.allocated_size AS z_allocated_size,
    z.data_size AS z_data_size
    FROM
    libifs AS i
    CROSS JOIN LATERAL (
    SELECT
    *
    FROM
    ludodta.libbes AS x
    WHERE
    (i.ifsoid = x.oid)
    ) AS l
    CROSS JOIN LATERAL (
    SELECT
    *
    FROM
    TABLE(
    qsys2.ifs_object_statistics(
    start_path_name => i.ifsfullname,
    subtree_directories => 'NO'
    )
    )
    ) AS z
    WHERE
    (
    issuperuser() = 'J'
    or l.contractor in (
    SELECT
    *
    FROM
    TABLE(authorisedcontractor())
    )
    )
    ORDER BY
    l.addedon DESC

  • #2
    Hi Theo,

    Think we found the issue and it should be fixed in the next Valence 6 update (after 6.0.20201222).

    Thanks for the information

    Comment

    Working...
    X