Hi, I'm used to create a new task for example:
scheduler.queue_task( "a_task", pvars = dict(csid=row.id, csname=row.name, action=row.action), ... ) In the past (version 2.10.1), everything was fine. Within the current version (2.14.6) I have some trouble. See this code for example: for row in db(db.scheduler_task.group_name == "agents").select( db.scheduler_task.ALL): ... pvars = json.loads(row.vars) ... will raise this exception: ... File "/usr/local/lib/python2.7/json/decoder.py", line 384, in raw_decode raise ValueError("No JSON object could be decoded") ValueError: No JSON object could be decoded The reason is a quoted string in column 'VARS' in table 'SCHEDULER_TASK' (no quotes in web2py's old version 2.10.1). A new value for 'VARS' with quotes for example: '{"action": "script", "csname": "list", "csid": 121}' I can skip the quotes with a trick: pvars = json.loads(row.vars[1:-1]) But, it is not a general solution. The same problem appears for column 'ARGS' in scheduler.py when I process the tasks: File "/export/home/armadm/dev01/release/web2py/gluon/scheduler.py", line 311, in executor args = _decode_list(loads(task.args)) File "/usr/local/lib/python2.7/json/__init__.py", line 338, in loads return _default_decoder.decode(s) File "/usr/local/lib/python2.7/json/decoder.py", line 366, in decode obj, end = self.raw_decode(s, idx=_w(s, 0).end()) File "/usr/local/lib/python2.7/json/decoder.py", line 384, in raw_decode raise ValueError("No JSON object could be decoded") ValueError: No JSON object could be decoded I use Oracle as database: SQL> desc scheduler_task Name Null? Type ----------------------------------------- -------- ---------------------------- ID NOT NULL NUMBER ... ARGS VARCHAR2(512) VARS VARCHAR2(512) Any ideas? Thx, Erwn -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.