Retrieve a value from a dictionary in stderr

Archives Ansible Project
1

I’m using a module which returns some information in the module’s register stderr variable when the module encounters an issue.

Using - debug: var=sql_delete.stderr returns:

ok: [ibmi01] => {
“sql_delete.stderr”: {
“ccsid”: “1146”,
“curuser”: “GROBINSO”,
“dftccsid”: “1146”,
“error”: “*** error DELETE FROM ANSIBLIB.QCUSTCDT WHERE CDTLMT < 9999.00”,
“jobipc”: “*na”,
“jobipcskey”: “FFFFFFFF”,
“jobname”: “QSQSRVR”,
“jobnbr”: “002988”,
“jobuser”: “QUSER”,
“paseccsid”: “0”,
“syslibl”: “QSYS QSYS2 QHLPSYS QUSRSYS”,
“usrlibl”: “QGPL QTEMP”,
“version”: “XML Toolkit 1.9.2”,
“xmlhint”: “02000:100:Row not found for DELETE.”,
“xmlhint1”: “02000:100:Row not found for DELETE.”
}
}

I want to retrieve the value in the xmlhint item.

When i try and access that value by using:

sql_delete.stderr.xmlhint

I get a variable not found error.

I’ve tried from_json, dict2items and dict2list but can’t seem to reference the xmlhint, or any other key values, within stderr.

How do I reference the xmlhint value in sql_delete.stderr?

2

What type is the attribute *stderr*? Try

  - debug:
      msg: "{{ sql_delete.stderr|type_debug }}"

If the type is string convert it to dictionary first, e.g

  - debug:
      msg: "{{ _stderr.xmlhint }}"
    vars:
      _stderr: "{{ sql_delete.stderr|from_yaml }}"

3

Attribute type returns:

“msg”: “AnsibleUnsafeText”

  • debug:
    msg: “{{ sql_delete }}”

returns:

ok: [ibmi01] => {
“msg”: {
“changed”: false,
“delta”: “0:00:00.325885”,
“end”: “2021-03-14 23:05:33.098261”,
“failed”: true,
“msg”: “non-zero return code:255”,
“rc”: 255,
“sql”: “DELETE FROM ANSIBLIB.QCUSTCDT WHERE CDTLMT < 9999.00”,
“start”: “2021-03-14 23:05:32.772376”,
“stderr”: “{‘error’: ‘*** error DELETE FROM ANSIBLIB.QCUSTCDT WHERE CDTLMT < 9999.00’, ‘version’: ‘XML Toolkit 1.9.2’, ‘xmlhint’: ‘02000:100:Row not found for DELETE.’, ‘xmlhint1’: ‘02000:100:Row not found for DELETE.’, ‘jobipc’: ‘*na’, ‘jobipcskey’: ‘FFFFFFFF’, ‘jobname’: ‘QSQSRVR’, ‘jobuser’: ‘QUSER’, ‘jobnbr’: ‘007433’, ‘curuser’: ‘GROBINSO’, ‘ccsid’: ‘1146’, ‘dftccsid’: ‘1146’, ‘paseccsid’: ‘0’, ‘syslibl’: ‘QSYS QSYS2 QHLPSYS QUSRSYS’, ‘usrlibl’: ‘QGPL QTEMP’}”,
“stderr_lines”: [
“{‘error’: ‘*** error DELETE FROM ANSIBLIB.QCUSTCDT WHERE CDTLMT < 9999.00’, ‘version’: ‘XML Toolkit 1.9.2’, ‘xmlhint’: ‘02000:100:Row not found for DELETE.’, ‘xmlhint1’: ‘02000:100:Row not found for DELETE.’, ‘jobipc’: ‘*na’, ‘jobipcskey’: ‘FFFFFFFF’, ‘jobname’: ‘QSQSRVR’, ‘jobuser’: ‘QUSER’, ‘jobnbr’: ‘007433’, ‘curuser’: ‘GROBINSO’, ‘ccsid’: ‘1146’, ‘dftccsid’: ‘1146’, ‘paseccsid’: ‘0’, ‘syslibl’: ‘QSYS QSYS2 QHLPSYS QUSRSYS’, ‘usrlibl’: ‘QGPL QTEMP’}”
],
“stdout”: “”,
“stdout_lines”:
}
}