Skip to content

Some AdoScript CC commands do not return a correct result when the right dataType is selected in a request to /dao/execute

When deployed as part of the ADOxxWeb API the /dao/execute operation seems to have issues with the dataType parameter. Depending on the code, for some variables from CC commands that are integer or string in AdoScript these work with the proper dataType parameter (integer or string). For other variables from CC commands the response instead has null as the value when the associated dataType is selected (integer for integer, string for string). However, a proper value is returned (at least in some of) those cases when dataType is set to error.

This issue happens both through Swagger and when performing HTTP requests directly (through Bruno).

Example where it works as expected:

  • AdoScript: CC "Core" GET_ALL_MODEL_VERSIONS
  • AdoScriptResultVariable: modelversionids
  • dataType: string
  • URL for POST request: http://localhost:8080/ADOxxWEBAPI/services/rest/dao/execute?AdoScript=CC%20%22Core%22%20GET_ALL_MODEL_VERSIONS&AdoScriptResultVariable=modelversionids&dataType=string
  • Response:
    {
      "result": "90853 90879 91201 91215",
      "ecode": "0",
      "duration": 130,
      "startTime": "19.09.2025,09:54:44",
      "endTime": "19.09.2025,09:54:44",
      "script": {
        "script": "CC \"Core\" GET_ALL_MODEL_VERSIONS\r\nSET adowsresponse:(modelversionids + \"@@@\" + STR ecode)",
        "name": null,
        "waitTime": "30000",
        "executeTime": "30000",
        "retries": "1",
        "userType": "usertype_one",
        "dataType": "string",
        "dbname": "adoxx18lbrs"
      },
      "errorText": "No error",
      "success": true
    }

Example where it doesn't work as expected:

  • AdoScript: CC "Application" GET_PATH
  • AdoScriptResultVariable: path
  • dataType: string
  • URL for POST request: http://localhost:8080/ADOxxWEBAPI/services/rest/dao/execute?AdoScript=CC%20%22Application%22%20GET_PATH&AdoScriptResultVariable=path&dataType=string
  • Response:
    {
      "result": null,
      "ecode": null,
      "duration": 92,
      "startTime": "19.09.2025,09:55:21",
      "endTime": "19.09.2025,09:55:21",
      "script": {
        "script": "CC \"Application\" GET_PATH\r\nSET adowsresponse:(path + \"@@@\" + STR ecode)",
        "name": null,
        "waitTime": "30000",
        "executeTime": "30000",
        "retries": "1",
        "userType": "usertype_one",
        "dataType": "string",
        "dbname": "adoxx18lbrs"
      },
      "errorText": "Unknown error",
      "success": false
    }

Example where the "doesn't work as expected" gives the correct result when using the wrong dataType:

  • AdoScript: CC "Modeling" GET_ACT_MODEL
  • AdoScriptResultVariable: path
  • dataType: error
  • URL for POST request: http://localhost:8080/ADOxxWEBAPI/services/rest/dao/execute?AdoScript=CC%20%22Application%22%20GET_PATH&AdoScriptResultVariable=path&dataType=error
  • Response:
    {
      "result": "c:\\Other Programs\\ADOxx_1.8.0 with awssrv",
      "ecode": "0",
      "duration": 91,
      "startTime": "19.09.2025,09:55:42",
      "endTime": "19.09.2025,09:55:42",
      "script": {
        "script": "CC \"Application\" GET_PATH\r\nSET adowsresponse:(path)",
        "name": null,
        "waitTime": "30000",
        "executeTime": "30000",
        "retries": "1",
        "userType": "usertype_one",
        "dataType": "error",
        "dbname": "adoxx18lbrs"
      },
      "errorText": "No error",
      "success": true
    }

Some other commands that have this issue:

  • CC "Application" GET_USER
  • CC "Modeling" GET_ACT_MODEL
Edited by Patrik Burzynski