Error 11881 is being returned when executing the WRITE-JSON() method on a dynamic ProDataset that has been passed to an internal procedure

Error 11881 is being returned when executing the WRITE-JSON() method on a dynamic ProDataset that has been passed to an internal procedure.

Jun 25, 2015
Knowledge

Title

URL Name

Error-11881-is-being-returned-when-executing-the-WRITE-JSON-method-on-a-dynamic-ProDataset-that-has-been-passed-to-an-internal-procedure

Article Number

000176632

Environment

Product: OpenEdge Version: 11.5.x OS: All supported platforms

Question/Problem Description

Error 11881 is being returned when executing the WRITE-JSON() method on a dynamic ProDataset that has been passed to an internal procedure.
Error 11881 is being returned when executing the WRITE-JSON() method on a dynamic ProDataset that has been passed to an internal procedure with the BY-VALUE option.

Steps to Reproduce

Clarifying Information

The issue can be reproduced with the following ABL code:

/*******************/
DEFINE VARIABLE dsData AS HANDLE NO-UNDO.
DEFINE VARIABLE lcBefore AS LONGCHAR NO-UNDO.

CREATE DATASET dsData.

dsData:READ-JSON("FILE", "dsData.json", "EMPTY").
dsData:WRITE-JSON("LONGCHAR", lcBefore).

MESSAGE "Before calling intProc"
VIEW-AS ALERT-BOX INFO BUTTONS OK.

RUN intProc (INPUT DATASET-HANDLE dsData).

PROCEDURE intProc:
DEFINE INPUT PARAMETER DATASET-HANDLE hdsBeforeData.
DEFINE VARIABLE lcBefore AS LONGCHAR NO-UNDO.

hdsBeforeData:WRITE-JSON("LONGCHAR", lcBefore).
END PROCEDURE.
/*******************/

The dsData.json file contains the following content:

{
"dsData": {
"ttData": [
{
"key": "12345",
"name": "Test",
"rdatarowid": "AAAAAAAFIY8=",
"ttUrl": [
{
"cType": "operations",
"cVerb": "GET,PUT,DELETE",
"cUrl": "/rest/Test",
"cRequest": null
}
]
}
]
}
}

Error Message

Unable to auto-generate a query predicate with no relation join fields in the data-relation. (11881)

Defect Number

Defect PSC00335097

Enhancement Number

Cause

Resolution

Until the fix is available, use the workaround below.

Workaround

Pass the ProDataset to the internal procedure using the BY-REFERENCE option. For example:

RUN intProc (INPUT DATASET-HANDLE dsData BY-REFERENCE).

Alternatively, pass the ProDataset using a HANDLE parameter as opposed to a DATASET-HANDLE parameter. For example:

/*******************/
DEFINE VARIABLE dsData AS HANDLE NO-UNDO.
DEFINE VARIABLE lcBefore AS LONGCHAR NO-UNDO.

CREATE DATASET dsData.

dsData:READ-JSON("FILE", "dsData.json", "EMPTY").
dsData:WRITE-JSON("LONGCHAR", lcBefore).

MESSAGE "Before calling intProc"
VIEW-AS ALERT-BOX INFO BUTTONS OK.

RUN intProc (INPUT dsData).

PROCEDURE intProc:
DEFINE INPUT PARAMETER hdsBeforeData AS HANDLE.
DEFINE VARIABLE lcBefore AS LONGCHAR NO-UNDO.

hdsBeforeData:WRITE-JSON("LONGCHAR", lcBefore).
END PROCEDURE.
/*******************/

Please keep in mind that normally when you pass a ProDataset using a DATASET-HANDLE parameter it creates a copy of the ProDataset within your internal procedure, but when using the BY-REFERENCE option or a HANDLE parameter it keeps referencing the same ProDataset object.

Notes

Keyword Phrase

Last Modified Date

6/25/2015 9:20 AM

Error 11881 is being returned when executing the WRITE-JSON() method on a dynamic ProDataset that has been passed to an internal procedure

Files(0)

Was this article helpful?

Was this article helpful?

Error 11881 is being returned when executing the WRITE-JSON() method on a dynamic ProDataset that has been passed to an internal procedure

Information

Related Articles