RFC_READ_TABLE query leads to Parser Error

[decide2022]

Dear all,

I have been querying data for some years now, with a coding like this.

with open("/users/____/OneDrive - BASF/desktop/dev/sap-cobalt/saplog/credentialsZ2L.json") as f:
    credentials = json.load(f)
    
AUART = ['ZTE']
VKORG = ['D050']
VTWEG = ['53']
SPART = ['01']
VKGRP = ['300']
VKBUR = ['0300']

table = 'VBAK'

fields = [
    'VBELN',
    'ERDAT',
    'ERNAM',
    'KNUMV',
    'BSTNK',
    'KNKLI',
    'VSBED'
    ]

wheres = ['MANDT = 100',
    ['ERDAT', 'in', ERDAT],
    ['AUART', 'in', AUART],
    ['VKORG', 'in', VKORG],
    ['VTWEG', 'in', VTWEG],
    ['SPART', 'in', SPART],
    ['VKGRP', 'in', VKGRP],
    ['VKBUR', 'in', VKBUR]

]

with cobalt.Connection(**credentials) as conn:
    VBAK_data = conn.query(table, fields, wheres, max_rows = 0)
    print(VBAK_data)

This worked out until some weeks ago.
Since some weeks I am getting the following error message:

File ___\cobalt\cobalt.py:253, in Connection._query(self, table, fields, wheres, max_rows, from_row, field_info, delimiter)
    251 if options:
    252     kwargs["OPTIONS"] = options
--> 253 result = self.call("RFC_READ_TABLE", **kwargs)
    254 logger.info("Ran RFC_READ_TABLE")
    256 # Parse query results

File src\pyrfc\_cyrfc.pyx:937, in pyrfc._cyrfc.Connection.call()

File src\pyrfc\_cyrfc.pyx:710, in pyrfc._cyrfc.Connection._error()

ABAPApplicationError: 5 (rc=5): key=OPTION_NOT_VALID, message=ID:SAIS Type:E Number:000 DB_Error onVBAK:Der Parser lieferte den Fehler: Das Mandantenfeld [MSG: class=SAIS, type=E, number=000, v1-4:=DB_Error on;VBAK;:;Der Parser lieferte den Fehler: Das Mandantenfeld]

The connection is still working, I can still get table descriptions, but no data.

Has anyone an idea, whether something was changed in parsing on SAP side?
Has someone maybe some suggestions, how to possibly modify my selections (the wheres-clause) please?

I would be happy to be able to use my queries in the future as well.

best regards,

Andreas

[bsrdjan]

Hello Andreas,

what is actually cobalt, it looks like some sort of PyRFC wrapper?

I would suggest reaching out for support from cobalt package team because query method is cobalt specific, does not exist in PyRFC

Kind regards,
Srdjan

[decide2022]

Hello Srdjan,

Yes, it is a wrapper for PyRFC.
I have found out, that the query function does some parsing for querying table fields. The parser error goes together with some SAP-upgrade in nov-23.
I am in contact with the support for module cobalt.

Thank you for the hint:-)