PWX-14607 Internal error: Invalid Serialization/mutex handle passed to function

There was space issue in the unix box. Once we freed the space, did not get this error again.

Informatica Metadata Query For Parameter File

SELECT DISTINCT

      B.SUBJECT_AREA,

      B.TASK_NAME AS SES_WF_NAME,

      A.ATTR_VALUE AS PRM_FILE_PATH

FROM

       REP_TASK_ATTR A,

       REP_ALL_TASKS B

WHERE

        A.ATTR_ID IN (1,4)

        AND A.TASK_ID = B.TASK_ID

        AND A.ATTR_VALUE IS NOT NULL

ORDER BY 1,2 ASC

-------------------------------------------------------------------------------------------------

SELECT
     *
 FROM
     (
         SELECT
             attr_id,
             b.subject_area,
             b.task_name    AS ses_wf_name,
             a.attr_value   AS prm_file_path,
             ROW_NUMBER() OVER(
                 PARTITION BY a.task_id
                 ORDER BY
                     a.version_number DESC
             ) AS rn
         FROM
             rep_task_attr a,
             rep_all_tasks b
         WHERE
             a.attr_id IN (
                 1,
                 4
             )
             AND a.task_id = b.task_id
             AND a.attr_value IS NOT NULL
             AND b.subject_area = 'RAW_DATA'
     )
 WHERE
     rn = 1