search

doableware / djongo

Django and MongoDB database connector
https://www.djongomapper.com
GNU Affero General Public License v3.0
1.88k stars 354 forks source link

arguments to $lookup must be strings #52

Closed ayakut closed 6 years ago

ayakut commented 6 years ago

Hi @nesdis ,

Please, could you take a look o next error? Thank you for your contribution and dedication!

Request Method: GET

http://127.0.0.1:8000/workflow/ 1.11.7 OperationFailure arguments to $lookup must be strings, pipeline: [ { $match: { id: { $ne: null, $exists: true } } }, { $lookup: { from: "viewflow_process", localField: "U1.id", foreignField: "process_id", as: "viewflow_process" } }, { $unwind: "$viewflow_process" }, { $match: { $and: [ { U1.flow_class: { $in: [ "flows/flows.hotel_mapping.SingleHotelMapping", "flows/flows.main_onboarding.MainOnBoardingFlow", "flows/flows.hotel_mapping.ProviderScan" ] } }, { owner_id: { $eq: 1 } }, { U1.flow_class: { $in: [ "flows/flows.hotel_mapping.SingleHotelMapping", "flows/flows.main_onboarding.MainOnBoardingFlow", "flows/flows.hotel_mapping.ProviderScan" ] } }, { owner_id: { $eq: 1 } }, { status: { $eq: "ASSIGNED" } }, { status: { $eq: "ASSIGNED" } } ] } }, { $project: { process_id: true } } ] is type array C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\pymongo\helpers.py in _check_command_response, line 210 C:\Users\alexk\development\projects\python\venvs\fifa_mongo\Scripts\python.exe 3.6.2 ['C:/Users/alexk/development/projects/python/fifa_mongo', 'C:\Program Files\JetBrains\PyCharm 2017.2.3\helpers\pydev', 'C:\Users\alexk\development\projects\python\fifa_mongo', 'C:\Program Files\JetBrains\PyCharm 2017.2.3\helpers\pydev', 'C:\Users\alexk\.PyCharm2017.3\system\cythonExtensions', 'C:\Users\alexk\development\projects\python\venvs\fifa_mongo\Scripts\python36.zip', 'C:\Users\alexk\AppData\Local\Programs\Python\Python36\DLLs', 'C:\Users\alexk\AppData\Local\Programs\Python\Python36\lib', 'C:\Users\alexk\AppData\Local\Programs\Python\Python36', 'C:\Users\alexk\development\projects\python\venvs\fifa_mongo', 'C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages', 'C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\setuptools-28.8.0-py3.6.egg', 'C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\pip-9.0.1-py3.6.egg', 'c:\users\alexk\development\projects\python\djongo', 'C:\Program Files\JetBrains\PyCharm ' '2017.2.3\helpers\pycharm_matplotlib_backend', 'C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\IPython\extensions', 'C:\Users\alexk\development\projects\python\fifa_mongo'] Wed, 17 Jan 2018 17:52:22 +0000

image

nesdis commented 6 years ago

Are you using the latest version? In the stack trace i dont see the failing sql. Please post the trace back as well. This is usually the traceback that python prints in the console

On 17-Jan-2018 11:30 PM, "ayakut" notifications@github.com wrote:

Hi @nesdis https://github.com/nesdis ,

Please, could you take a look o next error? Thank you for your contribution and dedication! Request Method: GET http://127.0.0.1:8000/workflow/ 1.11.7 OperationFailure arguments to $lookup must be strings, pipeline: [ { $match: { id: { $ne: null, $exists: true } } }, { $lookup: { from: "viewflow_process", localField: "U1.id", foreignField: "process_id", as: "viewflow_process" } }, { $unwind: "$viewflow_process" }, { $match: { $and: [ { U1.flow_class: { $in: [ "flows/flows.hotel_mapping.SingleHotelMapping", "flows/flows.main_onboarding.MainOnBoardingFlow", "flows/flows.hotel_mapping.ProviderScan" ] } }, { owner_id: { $eq: 1 } }, { U1.flow_class: { $in: [ "flows/flows.hotel_mapping.SingleHotelMapping", "flows/flows.main_onboarding.MainOnBoardingFlow", "flows/flows.hotel_mapping.ProviderScan" ] } }, { owner_id: { $eq: 1 } }, { status: { $eq: "ASSIGNED" } }, { status: { $eq: "ASSIGNED" } } ] } }, { $project: { processid: true } } ] is type array C:\Users\alexk\development\projects\python\venvs\fifa mongo\lib\site-packages\pymongo\helpers.py in _check_commandresponse, line 210 C:\Users\alexk\development\projects\python\venvs\fifa mongo\Scripts\python.exe 3.6.2 ['C:/Users/alexk/development/projects/python/fifa_mongo', 'C:\Program Files\JetBrains\PyCharm 2017.2.3\helpers\pydev', 'C:\Users\alexk\development\projects\python\fifa_mongo', 'C:\Program Files\JetBrains\PyCharm 2017.2.3\helpers\pydev', 'C:\Users\alexk.PyCharm2017.3\system\cythonExtensions', 'C:\Users\alexk\development\projects\python\venvs\fifa_mongo\Scripts\python36.zip', 'C:\Users\alexk\AppData\Local\Programs\Python\Python36\DLLs', 'C:\Users\alexk\AppData\Local\Programs\Python\Python36\lib', 'C:\Users\alexk\AppData\Local\Programs\Python\Python36', 'C:\Users\alexk\development\projects\python\venvs\fifa_mongo', 'C:\Users\alexk\development\projects\python\venvs\fifamongo\lib\site-packages', 'C:\Users\alexk\development\projects\python\venvs\fifa mongo\lib\site-packages\setuptools-28.8.0-py3.6.egg', 'C:\Users\alexk\development\projects\python\venvs\fifa_ mongo\lib\site-packages\pip-9.0.1-py3.6.egg', 'c:\users\alexk\development\projects\python\djongo', 'C:\Program Files\JetBrains\PyCharm ' '2017.2.3\helpers\pycharm_matplotlibbackend', 'C:\Users\alexk\development\projects\python\venvs\fifa mongo\lib\site-packages\IPython\extensions', 'C:\Users\alexk\development\ projects\python\fifa_mongo'] Wed, 17 Jan 2018 17:52:22 +0000

[image: image] https://user-images.githubusercontent.com/2535670/35058508-d23ba84e-fbc0-11e7-993b-272bedc8f617.png

— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub https://github.com/nesdis/djongo/issues/52, or mute the thread https://github.com/notifications/unsubscribe-auth/AQO4BAODertDG5kEgSsWPKoucjTsZFIsks5tLjUqgaJpZM4Rhv2_ .

ayakut commented 6 years ago

Hi @nesdis ,

I'm using the version 1.2.14. image

image

Here is traceback:

Connected to pydev debugger (build 173.4127.16) pydev debugger: process 8716 is connecting Performing system checks... System check identified no issues (0 silenced). January 18, 2018 - 17:52:11 Django version 1.11.7, using settings 'settings_dev' Starting development server at http://127.0.0.1:8000/ Quit the server with CTRL-BREAK. [18/Jan/2018 17:52:20] "GET / HTTP/1.1" 302 0 FAILED SQL: SELECT "viewflow_process"."id", "viewflow_process"."flow_class", "viewflow_process"."status", "viewflow_process"."created", "viewflow_process"."finished" FROM "viewflow_process" WHERE "viewflow_process"."id" IN (SELECT U0."process_id" AS Col1 FROM "viewflow_task" U0 INNER JOIN "viewflow_process" U1 ON (U0."process_id" = U1."id") WHERE (U1."flow_class" IN (%(0)s, %(1)s, %(2)s) AND U0."owner_id" = %(3)s AND U0."status" = %(4)s)) ORDER BY "viewflow_process"."created" DESC OrderedDict([('ok', 0.0), ('errmsg', 'arguments to $lookup must be strings, pipeline: [ { $match: { id: { $ne: null, $exists: true } } }, { $lookup: { from: "viewflow_process", localField: "U1.id", foreignField: "process_id", as: "viewflow_process" } }, { $unwind: "$viewflow_process" }, { $match: { $and: [ { U1.flow_class: { $in: [ "flows/flows.hotel_mapping.SingleHotelMapping", "flows/flows.hotel_mapping.ProviderScan", "flows/flows.main_onboarding.MainOnBoardingFlow" ] } }, { owner_id: { $eq: 1 } }, { U1.flow_class: { $in: [ "flows/flows.hotel_mapping.SingleHotelMapping", "flows/flows.hotel_mapping.ProviderScan", "flows/flows.main_onboarding.MainOnBoardingFlow" ] } }, { owner_id: { $eq: 1 } }, { status: { $eq: "ASSIGNED" } }, { status: { $eq: "ASSIGNED" } } ] } }, { $project: { process_id: true } } ] is type array'), ('code', 4570), ('codeName', 'Location4570')]) 2018-01-18 17:52:27 ERROR django.request ##: Internal Server Error: /workflow/ Traceback (most recent call last): File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\core\handlers\exception.py", line 41, in inner response = get_response(request) File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\core\handlers\base.py", line 217, in _get_response response = self.process_exception_by_middleware(e, request) File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\core\handlers\base.py", line 215, in _get_response response = response.render() File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\response.py", line 107, in render self.content = self.rendered_content File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\response.py", line 84, in rendered_content content = template.render(context, self._request) File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\backends\django.py", line 66, in render return self.template.render(context) File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\base.py", line 207, in render return self._render(context) File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\test\utils.py", line 107, in instrumented_test_render return self.nodelist.render(context) File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\base.py", line 990, in render bit = node.render_annotated(context) File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\base.py", line 957, in render_annotated return self.render(context) File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\loader_tags.py", line 177, in render return compiled_parent._render(context) File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\test\utils.py", line 107, in instrumented_test_render return self.nodelist.render(context) File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\base.py", line 990, in render bit = node.render_annotated(context) File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\base.py", line 957, in render_annotated return self.render(context) File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\loader_tags.py", line 177, in render return compiled_parent._render(context) File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\test\utils.py", line 107, in instrumented_test_render return self.nodelist.render(context) File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\base.py", line 990, in render bit = node.render_annotated(context) File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\base.py", line 957, in render_annotated return self.render(context) File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\loader_tags.py", line 177, in render return compiled_parent._render(context) File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\test\utils.py", line 107, in instrumented_test_render return self.nodelist.render(context) File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\base.py", line 990, in render bit = node.render_annotated(context) File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\base.py", line 957, in render_annotated return self.render(context) File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\loader_tags.py", line 177, in render return compiled_parent._render(context) File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\test\utils.py", line 107, in instrumented_test_render return self.nodelist.render(context) File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\base.py", line 990, in render bit = node.render_annotated(context) File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\base.py", line 957, in render_annotated return self.render(context) File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\loader_tags.py", line 177, in render return compiled_parent._render(context) File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\test\utils.py", line 107, in instrumented_test_render return self.nodelist.render(context) File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\base.py", line 990, in render bit = node.render_annotated(context) File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\base.py", line 957, in render_annotated return self.render(context) File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\loader_tags.py", line 72, in render result = block.nodelist.render(context) File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\base.py", line 990, in render bit = node.render_annotated(context) File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\base.py", line 957, in render_annotated return self.render(context) File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\loader_tags.py", line 72, in render result = block.nodelist.render(context) File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\base.py", line 990, in render bit = node.render_annotated(context) File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\base.py", line 957, in render_annotated return self.render(context) File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\loader_tags.py", line 72, in render result = block.nodelist.render(context) File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\base.py", line 990, in render bit = node.render_annotated(context) File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\base.py", line 957, in render_annotated return self.render(context) File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\loader_tags.py", line 72, in render result = block.nodelist.render(context) File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\base.py", line 990, in render bit = node.render_annotated(context) File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\base.py", line 957, in render_annotated return self.render(context) File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\loader_tags.py", line 72, in render result = block.nodelist.render(context) File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\base.py", line 990, in render bit = node.render_annotated(context) File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\base.py", line 957, in render_annotated return self.render(context) File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\defaulttags.py", line 322, in render return nodelist.render(context) File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\base.py", line 990, in render bit = node.render_annotated(context) File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\base.py", line 957, in render_annotated return self.render(context) File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\defaulttags.py", line 322, in render return nodelist.render(context) File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\base.py", line 990, in render bit = node.render_annotated(context) File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\base.py", line 957, in render_annotated return self.render(context) File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\material\templatetags\material_form.py", line 142, in render return template.render(context_flatten(context)) File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\backends\django.py", line 66, in render return self.template.render(context) File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\base.py", line 207, in render return self._render(context) File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\test\utils.py", line 107, in instrumented_test_render return self.nodelist.render(context) File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\base.py", line 990, in render bit = node.render_annotated(context) File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\base.py", line 957, in render_annotated return self.render(context) File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\material\templatetags\material_form.py", line 203, in render value = self.nodelist.render(context).strip() File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\base.py", line 990, in render bit = node.render_annotated(context) File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\base.py", line 957, in render_annotated return self.render(context) File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\defaulttags.py", line 322, in render return nodelist.render(context) File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\base.py", line 990, in render bit = node.render_annotated(context) File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\base.py", line 957, in render_annotated return self.render(context) File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\material\templatetags\material_form.py", line 203, in render value = self.nodelist.render(context).strip() File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\base.py", line 990, in render bit = node.render_annotated(context) File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\base.py", line 957, in render_annotated return self.render(context) File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\defaulttags.py", line 216, in render nodelist.append(node.render_annotated(context)) File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\base.py", line 957, in render_annotated return self.render(context) File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\material\templatetags\material_form_internal.py", line 81, in render return Field(element.name).render(context, options) File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\material\base.py", line 229, in render return template.render(context.flatten()) File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\backends\django.py", line 66, in render return self.template.render(context) File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\base.py", line 207, in render return self._render(context) File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\test\utils.py", line 107, in instrumented_test_render return self.nodelist.render(context) File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\base.py", line 990, in render bit = node.render_annotated(context) File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\base.py", line 957, in render_annotated return self.render(context) File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\material\templatetags\material_form.py", line 200, in render _render_parts(context, children) File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\material\templatetags\material_form.py", line 31, in _render_parts value = partnode.render(context) File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\material\templatetags\material_form.py", line 200, in render _render_parts(context, children) File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\material\templatetags\material_form.py", line 31, in _render_parts value = partnode.render(context) File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\material\templatetags\material_form.py", line 203, in render value = self.nodelist.render(context).strip() File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\base.py", line 990, in render bit = node.render_annotated(context) File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\base.py", line 957, in render_annotated return self.render(context) File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\defaulttags.py", line 166, in render values = self.sequence.resolve(context, True) File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\base.py", line 736, in resolve new_obj = func(obj, arg_vals) File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\material\templatetags\material_form_internal.py", line 207, in select_options for option in bound_field.field.widget.choices: File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\forms\models.py", line 1139, in iter for obj in queryset: File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\viewflow\managers.py", line 148, in iterator for process in base_iterator: File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\viewflow\managers.py", line 94, in iter for process in base_iterator: File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\db\models\query.py", line 62, in iter for row in compiler.results_iter(results): File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\db\models\sql\compiler.py", line 839, in results_iter for rows in results: File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\db\models\sql\compiler.py", line 1284, in cursor_iter sentinel): File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\db\models\sql\compiler.py", line 1283, in for rows in iter((lambda: cursor.fetchmany(GET_ITERATOR_CHUNK_SIZE)), File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\db\utils.py", line 101, in inner return func(args, kwargs) File "c:\users\alexk\development\projects\python\djongo\djongo\cursor.py", line 50, in fetchmany ret.append(self.result.next()) File "c:\users\alexk\development\projects\python\djongo\djongo\sql2mongo.py", line 838, in next return next(self._result_generator) File "c:\users\alexk\development\projects\python\djongo\djongo\sql2mongo.py", line 851, in iter raise e File "c:\users\alexk\development\projects\python\djongo\djongo\sql2mongo.py", line 844, in iter yield from iter(self._query) File "c:\users\alexk\development\projects\python\djongo\djongo\sql2mongo.py", line 561, in iter self._cursor = self._get_cursor() File "c:\users\alexk\development\projects\python\djongo\djongo\sql2mongo.py", line 642, in _get_cursor cur = self.db_ref[self.left_table].aggregate(pipeline) File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\pymongo\collection.py", line 1918, in aggregate collation=collation) File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\pymongo\collection.py", line 232, in _command collation=collation) File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\pymongo\pool.py", line 477, in command collation=collation) File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\pymongo\network.py", line 116, in command parse_write_concern_error=parse_write_concern_error) File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\pymongo\helpers.py", line 210, in _check_command_response raise OperationFailure(msg % errmsg, code, response) pymongo.errors.OperationFailure: arguments to $lookup must be strings, pipeline: [ { $match: { id: { $ne: null, $exists: true } } }, { $lookup: { from: "viewflow_process", localField: "U1.id", foreignField: "process_id", as: "viewflow_process" } }, { $unwind: "$viewflow_process" }, { $match: { $and: [ { U1.flow_class: { $in: [ "flows/flows.hotel_mapping.SingleHotelMapping", "flows/flows.hotel_mapping.ProviderScan", "flows/flows.main_onboarding.MainOnBoardingFlow" ] } }, { owner_id: { $eq: 1 } }, { U1.flow_class: { $in: [ "flows/flows.hotel_mapping.SingleHotelMapping", "flows/flows.hotel_mapping.ProviderScan", "flows/flows.main_onboarding.MainOnBoardingFlow" ] } }, { owner_id: { $eq: 1 } }, { status: { $eq: "ASSIGNED" } }, { status: { $eq: "ASSIGNED" } } ] } }, { $project: { process_id: true } } ] is type array FAILED SQL: SELECT "viewflow_process"."id", "viewflow_process"."flow_class", "viewflow_process"."status", "viewflow_process"."created", "viewflow_process"."finished" FROM "viewflow_process" WHERE "viewflow_process"."id" IN (SELECT U0."process_id" AS Col1 FROM "viewflow_task" U0 INNER JOIN "viewflow_process" U1 ON (U0."process_id" = U1."id") WHERE (U1."flow_class" IN (%(0)s, %(1)s, %(2)s) AND U0."owner_id" = %(3)s AND U0."status" = %(4)s)) ORDER BY "viewflow_process"."created" DESC LIMIT 21 OrderedDict([('ok', 0.0), ('errmsg', 'arguments to $lookup must be strings, pipeline: [ { $match: { id: { $ne: null, $exists: true } } }, { $lookup: { from: "viewflow_process", localField: "U1.id", foreignField: "process_id", as: "viewflow_process" } }, { $unwind: "$viewflow_process" }, { $match: { $and: [ { U1.flow_class: { $in: [ "flows/flows.hotel_mapping.SingleHotelMapping", "flows/flows.hotel_mapping.ProviderScan", "flows/flows.main_onboarding.MainOnBoardingFlow" ] } }, { owner_id: { $eq: 1 } }, { U1.flow_class: { $in: [ "flows/flows.hotel_mapping.SingleHotelMapping", "flows/flows.hotel_mapping.ProviderScan", "flows/flows.main_onboarding.MainOnBoardingFlow" ] } }, { owner_id: { $eq: 1 } }, { status: { $eq: "ASSIGNED" } }, { status: { $eq: "ASSIGNED" } } ] } }, { $project: { process_id: true } } ] is type array'), ('code', 4570), ('codeName', 'Location4570')]) FAILED SQL: SELECT "viewflow_process"."id", "viewflow_process"."flow_class", "viewflow_process"."status", "viewflow_process"."created", "viewflow_process"."finished" FROM "viewflow_process" WHERE "viewflow_process"."id" IN (SELECT U0."process_id" AS Col1 FROM "viewflow_task" U0 INNER JOIN "viewflow_process" U1 ON (U0."process_id" = U1."id") WHERE (U1."flow_class" IN (%(0)s, %(1)s, %(2)s) AND U0."owner_id" = %(3)s AND U0."status" = %(4)s)) ORDER BY "viewflow_process"."created" DESC LIMIT 21 OrderedDict([('ok', 0.0), ('errmsg', 'arguments to $lookup must be strings, pipeline: [ { $match: { id: { $ne: null, $exists: true } } }, { $lookup: { from: "viewflow_process", localField: "U1.id", foreignField: "process_id", as: "viewflow_process" } }, { $unwind: "$viewflow_process" }, { $match: { $and: [ { U1.flow_class: { $in: [ "flows/flows.hotel_mapping.SingleHotelMapping", "flows/flows.hotel_mapping.ProviderScan", "flows/flows.main_onboarding.MainOnBoardingFlow" ] } }, { owner_id: { $eq: 1 } }, { U1.flow_class: { $in: [ "flows/flows.hotel_mapping.SingleHotelMapping", "flows/flows.hotel_mapping.ProviderScan", "flows/flows.main_onboarding.MainOnBoardingFlow" ] } }, { owner_id: { $eq: 1 } }, { status: { $eq: "ASSIGNED" } }, { status: { $eq: "ASSIGNED" } } ] } }, { $project: { process_id: true } } ] is type array'), ('code', 4570), ('codeName', 'Location4570')]) [18/Jan/2018 17:52:32] "GET /workflow/ HTTP/1.1" 500 810537 2018-01-18 17:52:35 WARNING django.request ##: Not Found: /favicon.ico [18/Jan/2018 17:52:35] "GET /favicon.ico HTTP/1.1" 404 11861

nesdis commented 6 years ago

@ayakut I have now fixed this. Please clone the latest commit

ayakut commented 6 years ago

Hi @nesdis ,

Ok. Will do!

ayakut commented 6 years ago

Hi @nesdis , I pull the last state of the Djongo project. Here are list of my requirements:

amqp==2.2.1 billiard==3.5.0.3 cassandra-driver==3.11.0 celery==4.1.0 Django==1.11.7 django-celery==3.2.1 django-celery-beat==1.0.1 django-celery-results==1.0.1 django_countries==4.6.1 django_extensions==1.9.0 django-filter==1.0.4 eventlet==0.21.0 fuzzywuzzy==0.15.1 kombu==4.1.0 pandas==0.21.0 python-Levenshtein==0.12.0 pytz==2017.2 requests==2.18.4 simpleflake==0.1.5 simplejson==3.12.0 vine==1.1.4 xlrd==1.1.0 django_debug_toolbar==1.8 ipython==6.1.0 django-webtest==1.9.2 -e file:///C:/Users/alexk/development/projects/python/djongo/#egg=djongo

Performed : pip install -r requirements/dev.txt

... Installing collected packages: djongo Found existing installation: djongo 1.2.16 Uninstalling djongo-1.2.16: Successfully uninstalled djongo-1.2.16 Running setup.py develop for djongo Successfully installed djongo

Then I'm trying to start my app and get next:

"C:\Program Files\JetBrains\PyCharm 2017.2.3\bin\runnerw.exe" C:\Users\alexk\development\projects\python\venvs\fifa_mongo\Scripts\python.exe "C:\Program Files\JetBrains\PyCharm 2017.2.3\helpers\pydev\pydevd.py" --multiproc --qt-support=auto --client 127.0.0.1 --port 55471 --file C:/Users/alexk/development/projects/python/fifa_mongo/manage.py runserver 8000
pydev debugger: process 17788 is connecting

Connected to pydev debugger (build 173.4127.16)
pydev debugger: process 9832 is connecting

Unhandled exception in thread started by <_pydev_bundle.pydev_monkey._NewThreadStartupWithTrace object at 0x000002D24C9CA390>
Traceback (most recent call last):
  File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\db\utils.py", line 115, in load_backend
    return import_module('%s.base' % backend_name)
  File "C:\Users\alexk\AppData\Local\Programs\Python\Python36\lib\importlib\__init__.py", line 126, in import_module
    return _bootstrap._gcd_import(name[level:], package, level)
  File "<frozen importlib._bootstrap>", line 978, in _gcd_import
  File "<frozen importlib._bootstrap>", line 961, in _find_and_load
  File "<frozen importlib._bootstrap>", line 950, in _find_and_load_unlocked
  File "<frozen importlib._bootstrap>", line 655, in _load_unlocked
  File "<frozen importlib._bootstrap_external>", line 678, in exec_module
  File "<frozen importlib._bootstrap>", line 205, in _call_with_frames_removed
  File "c:\users\alexk\development\projects\python\djongo\djongo\base.py", line 14, in <module>
    from .cursor import Cursor
  File "c:\users\alexk\development\projects\python\djongo\djongo\cursor.py", line 2, in <module>
    from sql2mongo.query import Result
ModuleNotFoundError: No module named 'sql2mongo'

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "C:\Program Files\JetBrains\PyCharm 2017.2.3\helpers\pydev\_pydev_bundle\pydev_monkey.py", line 589, in __call__
    return self.original_func(*self.args, **self.kwargs)
  File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\utils\autoreload.py", line 228, in wrapper
    fn(*args, **kwargs)
  File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\core\management\commands\runserver.py", line 117, in inner_run
    autoreload.raise_last_exception()
  File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\utils\autoreload.py", line 251, in raise_last_exception
    six.reraise(*_exception)
  File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\utils\six.py", line 685, in reraise
    raise value.with_traceback(tb)
  File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\utils\autoreload.py", line 228, in wrapper
    fn(*args, **kwargs)
  File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\__init__.py", line 27, in setup
    apps.populate(settings.INSTALLED_APPS)
  File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\apps\registry.py", line 108, in populate
    app_config.import_models()
  File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\apps\config.py", line 202, in import_models
    self.models_module = import_module(models_module_name)
  File "C:\Users\alexk\AppData\Local\Programs\Python\Python36\lib\importlib\__init__.py", line 126, in import_module
    return _bootstrap._gcd_import(name[level:], package, level)
  File "<frozen importlib._bootstrap>", line 978, in _gcd_import
  File "<frozen importlib._bootstrap>", line 961, in _find_and_load
  File "<frozen importlib._bootstrap>", line 950, in _find_and_load_unlocked
  File "<frozen importlib._bootstrap>", line 655, in _load_unlocked
  File "<frozen importlib._bootstrap_external>", line 678, in exec_module
  File "<frozen importlib._bootstrap>", line 205, in _call_with_frames_removed
  File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\contrib\auth\models.py", line 4, in <module>
    from django.contrib.auth.base_user import AbstractBaseUser, BaseUserManager
  File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\contrib\auth\base_user.py", line 52, in <module>
    class AbstractBaseUser(models.Model):
  File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\db\models\base.py", line 124, in __new__
    new_class.add_to_class('_meta', Options(meta, app_label))
  File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\db\models\base.py", line 325, in add_to_class
    value.contribute_to_class(cls, name)
  File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\db\models\options.py", line 214, in contribute_to_class
    self.db_table = truncate_name(self.db_table, connection.ops.max_name_length())
  File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\db\__init__.py", line 33, in __getattr__
    return getattr(connections[DEFAULT_DB_ALIAS], item)
  File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\db\utils.py", line 211, in __getitem__
    backend = load_backend(db['ENGINE'])
  File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\db\utils.py", line 134, in load_backend
    raise ImproperlyConfigured(error_msg)
django.core.exceptions.ImproperlyConfigured: 'djongo' isn't an available database backend.
Try using 'django.db.backends.XXX', where XXX is one of:
    'mysql', 'oracle', 'postgresql', 'sqlite3'
Error was: No module named 'sql2mongo'

What version of the Django I should use?

ayakut commented 6 years ago

Hi @nesdis ,

I've reinstalled all dependencies, including your project from the remote repo, not from local. Now, there is no such error. Continue the testing....

ayakut commented 6 years ago

Hi @nesdis ,

Here are new errors:

Traceback from PyCharm

"C:\Program Files\JetBrains\PyCharm 2017.2.3\bin\runnerw.exe" C:\Users\alexk\development\projects\python\venvs\fifa_mongo\Scripts\python.exe "C:\Program Files\JetBrains\PyCharm 2017.2.3\helpers\pydev\pydevd.py" --multiproc --qt-support=auto --client 127.0.0.1 --port 55933 --file C:/Users/alexk/development/projects/python/fifa_mongo/manage.py runserver 8000
pydev debugger: process 8408 is connecting

Connected to pydev debugger (build 173.4127.16)
pydev debugger: process 16904 is connecting

Performing system checks...

System check identified no issues (0 silenced).
January 24, 2018 - 19:13:24
Django version 1.11.7, using settings 'settings_dev'
Starting development server at http://127.0.0.1:8000/
Quit the server with CTRL-BREAK.
[24/Jan/2018 19:13:29] "GET / HTTP/1.1" 302 0
[24/Jan/2018 19:13:32] "GET /workflow/ HTTP/1.1" 302 0
[24/Jan/2018 19:13:33] "GET /accounts/login/?next=/workflow/ HTTP/1.1" 200 12534
[24/Jan/2018 19:13:33] "GET /static/material/fonts/material-design-icons/material-icons.css HTTP/1.1" 200 970
[24/Jan/2018 19:13:33] "GET /static/material/css/materialize.css HTTP/1.1" 200 170409
[24/Jan/2018 19:13:33] "GET /static/material/css/materialize.forms.css HTTP/1.1" 200 4605
[24/Jan/2018 19:13:33] "GET /static/material/css/materialize.frontend.css HTTP/1.1" 200 10584
[24/Jan/2018 19:13:33] "GET /static/material/css/responsive.dataTables.css HTTP/1.1" 200 4667
[24/Jan/2018 19:13:33] "GET /static/material/css/jquery.datetimepicker.css HTTP/1.1" 200 18987
[24/Jan/2018 19:13:33] "GET /static/material/css/fixedHeader.dataTables.css HTTP/1.1" 200 318
[24/Jan/2018 19:13:34] "GET /static/material/css/perfect-scrollbar.css HTTP/1.1" 200 5594
[24/Jan/2018 19:13:34] "GET /static/debug_toolbar/css/toolbar.css HTTP/1.1" 200 20322
[24/Jan/2018 19:13:34] "GET /static/material/js/turbolinks.js HTTP/1.1" 200 35293
[24/Jan/2018 19:13:34] "GET /static/material/js/jquery.activeNavigation.js HTTP/1.1" 200 1458
[24/Jan/2018 19:13:34] "GET /static/material/js/jquery.formset.js HTTP/1.1" 200 8479
[24/Jan/2018 19:13:34] "GET /static/material/js/perfect-scrollbar.jquery.js HTTP/1.1" 200 47259
[24/Jan/2018 19:13:34] "GET /static/material/js/jquery.autocomplete.js HTTP/1.1" 200 32713
[24/Jan/2018 19:13:34] "GET /static/material/js/jquery.datetimepicker.full.js HTTP/1.1" 200 103643
[24/Jan/2018 19:13:34] "GET /static/material/js/dataTables.select.js HTTP/1.1" 200 31069
[24/Jan/2018 19:13:34] "GET /static/material/js/dataTables.checkboxes.js HTTP/1.1" 200 23798
[24/Jan/2018 19:13:34] "GET /static/material/js/dataTables.fixedHeader.js HTTP/1.1" 200 16767
[24/Jan/2018 19:13:34] "GET /static/material/js/jquery.js HTTP/1.1" 200 268039
[24/Jan/2018 19:13:34] "GET /static/material/js/dataTables.responsive.js HTTP/1.1" 200 37323
[24/Jan/2018 19:13:34] "GET /static/material/js/materialize.forms.js HTTP/1.1" 200 6595
[24/Jan/2018 19:13:34] "GET /static/material/js/materialize.frontend.js HTTP/1.1" 200 1214
[24/Jan/2018 19:13:34] "GET /static/debug_toolbar/js/jquery_pre.js HTTP/1.1" 200 136
[24/Jan/2018 19:13:34] "GET /static/debug_toolbar/js/jquery_post.js HTTP/1.1" 200 118
[24/Jan/2018 19:13:34] "GET /static/material/js/jquery.dataTables.js HTTP/1.1" 200 448547
[24/Jan/2018 19:13:34] "GET /static/debug_toolbar/js/toolbar.js HTTP/1.1" 200 12552
[24/Jan/2018 19:13:34] "GET /static/material/js/materialize.js HTTP/1.1" 200 386955
[24/Jan/2018 19:13:34] "GET /static/debug_toolbar/img/ajax-loader.gif HTTP/1.1" 200 404
[24/Jan/2018 19:13:34] "GET /static/debug_toolbar/css/print.css HTTP/1.1" 200 29
[24/Jan/2018 19:13:34] "GET /static/material/imgs/background.svg HTTP/1.1" 200 73468
[24/Jan/2018 19:13:34] "GET /static/material/fonts/material-design-icons/MaterialIcons-Regular.woff2 HTTP/1.1" 200 44300
[24/Jan/2018 19:13:34] "GET /static/material/fonts/roboto/Roboto-Regular.woff2 HTTP/1.1" 200 64832
[24/Jan/2018 19:13:34] "GET /static/material/fonts/roboto/Roboto-Light.woff2 HTTP/1.1" 200 64268
[24/Jan/2018 19:13:40] "POST /accounts/login/?next=/workflow/ HTTP/1.1" 302 0
2018-01-24 19:13:45 ERROR django.request ##: Internal Server Error: /workflow/
Traceback (most recent call last):
  File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\djongo\sql2mongo.py", line 850, in __iter__
    yield from iter(self._query)
  File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\djongo\sql2mongo.py", line 563, in __iter__
    self._cursor = self._get_cursor()
  File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\djongo\sql2mongo.py", line 644, in _get_cursor
    cur = self.db_ref[self.left_table].aggregate(pipeline)
  File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\pymongo\collection.py", line 2181, in aggregate
    **kwargs)
  File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\pymongo\collection.py", line 2088, in _aggregate
    client=self.__database.client)
  File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\pymongo\pool.py", line 496, in command
    collation=collation)
  File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\pymongo\network.py", line 125, in command
    parse_write_concern_error=parse_write_concern_error)
  File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\pymongo\helpers.py", line 146, in _check_command_response
    raise OperationFailure(msg % errmsg, code, response)
pymongo.errors.OperationFailure: arguments to $lookup must be strings, pipeline: [ { $match: { process_id: { $ne: null, $exists: true } } }, { $lookup: { from: "viewflow_process", localField: "process_id", foreignField: "id", as: "viewflow_process" } }, { $unwind: "$viewflow_process" }, { $match: { $and: [ { viewflow_process.flow_class: { $in: [ "flows/flows.hotel_mapping.ProviderScan", "flows/flows.main_onboarding.MainOnBoardingFlow", "flows/flows.hotel_mapping.SingleHotelMapping" ] } }, { owner_id: { $eq: 1 } }, { viewflow_process.flow_class: { $in: [ "flows/flows.hotel_mapping.ProviderScan", "flows/flows.main_onboarding.MainOnBoardingFlow", "flows/flows.hotel_mapping.SingleHotelMapping" ] } }, { owner_id: { $eq: 1 } }, { status: { $eq: "ASSIGNED" } }, { status: { $eq: "ASSIGNED" } } ] } }, { $project: { process_id: true } } ] is type array

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
  File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\core\handlers\exception.py", line 41, in inner
    response = get_response(request)
  File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\core\handlers\base.py", line 217, in _get_response
    response = self.process_exception_by_middleware(e, request)
  File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\core\handlers\base.py", line 215, in _get_response
    response = response.render()
  File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\response.py", line 107, in render
    self.content = self.rendered_content
  File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\response.py", line 84, in rendered_content
    content = template.render(context, self._request)
  File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\backends\django.py", line 66, in render
    return self.template.render(context)
  File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\base.py", line 207, in render
    return self._render(context)
  File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\test\utils.py", line 107, in instrumented_test_render
    return self.nodelist.render(context)
  File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\base.py", line 990, in render
    bit = node.render_annotated(context)
  File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\base.py", line 957, in render_annotated
    return self.render(context)
  File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\loader_tags.py", line 177, in render
    return compiled_parent._render(context)
  File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\test\utils.py", line 107, in instrumented_test_render
    return self.nodelist.render(context)
  File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\base.py", line 990, in render
    bit = node.render_annotated(context)
  File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\base.py", line 957, in render_annotated
    return self.render(context)
  File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\loader_tags.py", line 177, in render
    return compiled_parent._render(context)
  File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\test\utils.py", line 107, in instrumented_test_render
    return self.nodelist.render(context)
  File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\base.py", line 990, in render
    bit = node.render_annotated(context)
  File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\base.py", line 957, in render_annotated
    return self.render(context)
  File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\loader_tags.py", line 177, in render
    return compiled_parent._render(context)
  File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\test\utils.py", line 107, in instrumented_test_render
    return self.nodelist.render(context)
  File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\base.py", line 990, in render
    bit = node.render_annotated(context)
  File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\base.py", line 957, in render_annotated
    return self.render(context)
  File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\loader_tags.py", line 177, in render
    return compiled_parent._render(context)
  File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\test\utils.py", line 107, in instrumented_test_render
    return self.nodelist.render(context)
  File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\base.py", line 990, in render
    bit = node.render_annotated(context)
  File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\base.py", line 957, in render_annotated
    return self.render(context)
  File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\loader_tags.py", line 177, in render
    return compiled_parent._render(context)
  File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\test\utils.py", line 107, in instrumented_test_render
    return self.nodelist.render(context)
  File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\base.py", line 990, in render
    bit = node.render_annotated(context)
  File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\base.py", line 957, in render_annotated
    return self.render(context)
  File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\loader_tags.py", line 72, in render
    result = block.nodelist.render(context)
  File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\base.py", line 990, in render
    bit = node.render_annotated(context)
  File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\base.py", line 957, in render_annotated
    return self.render(context)
  File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\loader_tags.py", line 72, in render
    result = block.nodelist.render(context)
  File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\base.py", line 990, in render
    bit = node.render_annotated(context)
  File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\base.py", line 957, in render_annotated
    return self.render(context)
  File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\loader_tags.py", line 72, in render
    result = block.nodelist.render(context)
  File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\base.py", line 990, in render
    bit = node.render_annotated(context)
  File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\base.py", line 957, in render_annotated
    return self.render(context)
  File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\loader_tags.py", line 72, in render
    result = block.nodelist.render(context)
  File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\base.py", line 990, in render
    bit = node.render_annotated(context)
  File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\base.py", line 957, in render_annotated
    return self.render(context)
  File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\loader_tags.py", line 72, in render
    result = block.nodelist.render(context)
  File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\base.py", line 990, in render
    bit = node.render_annotated(context)
  File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\base.py", line 957, in render_annotated
    return self.render(context)
  File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\defaulttags.py", line 322, in render
    return nodelist.render(context)
  File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\base.py", line 990, in render
    bit = node.render_annotated(context)
  File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\base.py", line 957, in render_annotated
    return self.render(context)
  File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\defaulttags.py", line 322, in render
    return nodelist.render(context)
  File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\base.py", line 990, in render
    bit = node.render_annotated(context)
  File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\base.py", line 957, in render_annotated
    return self.render(context)
  File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\material\templatetags\material_form.py", line 142, in render
    return template.render(context_flatten(context))
  File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\backends\django.py", line 66, in render
    return self.template.render(context)
  File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\base.py", line 207, in render
    return self._render(context)
  File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\test\utils.py", line 107, in instrumented_test_render
    return self.nodelist.render(context)
  File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\base.py", line 990, in render
    bit = node.render_annotated(context)
  File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\base.py", line 957, in render_annotated
    return self.render(context)
  File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\material\templatetags\material_form.py", line 203, in render
    value = self.nodelist.render(context).strip()
  File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\base.py", line 990, in render
    bit = node.render_annotated(context)
  File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\base.py", line 957, in render_annotated
    return self.render(context)
  File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\defaulttags.py", line 322, in render
    return nodelist.render(context)
  File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\base.py", line 990, in render
    bit = node.render_annotated(context)
  File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\base.py", line 957, in render_annotated
    return self.render(context)
  File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\material\templatetags\material_form.py", line 203, in render
    value = self.nodelist.render(context).strip()
  File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\base.py", line 990, in render
    bit = node.render_annotated(context)
  File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\base.py", line 957, in render_annotated
    return self.render(context)
  File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\defaulttags.py", line 216, in render
    nodelist.append(node.render_annotated(context))
  File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\base.py", line 957, in render_annotated
    return self.render(context)
  File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\material\templatetags\material_form_internal.py", line 81, in render
    return Field(element.name).render(context, **options)
  File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\material\base.py", line 229, in render
    return template.render(context.flatten())
  File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\backends\django.py", line 66, in render
    return self.template.render(context)
  File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\base.py", line 207, in render
    return self._render(context)
  File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\test\utils.py", line 107, in instrumented_test_render
    return self.nodelist.render(context)
  File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\base.py", line 990, in render
    bit = node.render_annotated(context)
  File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\base.py", line 957, in render_annotated
    return self.render(context)
  File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\material\templatetags\material_form.py", line 200, in render
    _render_parts(context, children)
  File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\material\templatetags\material_form.py", line 31, in _render_parts
    value = partnode.render(context)
  File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\material\templatetags\material_form.py", line 200, in render
    _render_parts(context, children)
  File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\material\templatetags\material_form.py", line 31, in _render_parts
    value = partnode.render(context)
  File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\material\templatetags\material_form.py", line 203, in render
    value = self.nodelist.render(context).strip()
  File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\base.py", line 990, in render
    bit = node.render_annotated(context)
  File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\base.py", line 957, in render_annotated
    return self.render(context)
  File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\defaulttags.py", line 166, in render
    values = self.sequence.resolve(context, True)
  File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\base.py", line 736, in resolve
    new_obj = func(obj, *arg_vals)
  File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\material\templatetags\material_form_internal.py", line 207, in select_options
    for option in bound_field.field.widget.choices:
  File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\forms\models.py", line 1139, in __iter__
    for obj in queryset:
  File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\viewflow\managers.py", line 148, in iterator
    for process in base_iterator:
  File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\viewflow\managers.py", line 94, in __iter__
    for process in base_iterator:
  File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\db\models\query.py", line 62, in __iter__
    for row in compiler.results_iter(results):
  File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\db\models\sql\compiler.py", line 839, in results_iter
    for rows in results:
  File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\db\models\sql\compiler.py", line 1284, in cursor_iter
    sentinel):
  File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\db\models\sql\compiler.py", line 1283, in <lambda>
    for rows in iter((lambda: cursor.fetchmany(GET_ITERATOR_CHUNK_SIZE)),
  File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\db\utils.py", line 101, in inner
    return func(*args, **kwargs)
  File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\djongo\cursor.py", line 50, in fetchmany
    ret.append(self.result.next())
  File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\djongo\sql2mongo.py", line 844, in __next__
    return next(self._result_generator)
  File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\djongo\sql2mongo.py", line 854, in __iter__
    raise exe from e
djongo.sql2mongo.SQLDecodeError: FAILED SQL: SELECT "viewflow_process"."id", "viewflow_process"."flow_class", "viewflow_process"."status", "viewflow_process"."created", "viewflow_process"."finished" FROM "viewflow_process" WHERE "viewflow_process"."id" IN (SELECT U0."process_id" AS Col1 FROM "viewflow_task" U0 INNER JOIN "viewflow_process" U1 ON (U0."process_id" = U1."id") WHERE (U1."flow_class" IN (%(0)s, %(1)s, %(2)s) AND U0."owner_id" = %(3)s AND U0."status" = %(4)s)) ORDER BY "viewflow_process"."created" DESCPymongo error: OrderedDict([('ok', 0.0), ('errmsg', 'arguments to $lookup must be strings, pipeline: [ { $match: { process_id: { $ne: null, $exists: true } } }, { $lookup: { from: "viewflow_process", localField: "process_id", foreignField: "id", as: "viewflow_process" } }, { $unwind: "$viewflow_process" }, { $match: { $and: [ { viewflow_process.flow_class: { $in: [ "flows/flows.hotel_mapping.ProviderScan", "flows/flows.main_onboarding.MainOnBoardingFlow", "flows/flows.hotel_mapping.SingleHotelMapping" ] } }, { owner_id: { $eq: 1 } }, { viewflow_process.flow_class: { $in: [ "flows/flows.hotel_mapping.ProviderScan", "flows/flows.main_onboarding.MainOnBoardingFlow", "flows/flows.hotel_mapping.SingleHotelMapping" ] } }, { owner_id: { $eq: 1 } }, { status: { $eq: "ASSIGNED" } }, { status: { $eq: "ASSIGNED" } } ] } }, { $project: { process_id: true } } ] is type array'), ('code', 4570), ('codeName', 'Location4570')])
[24/Jan/2018 19:13:51] "GET /workflow/ HTTP/1.1" 500 823964
2018-01-24 19:13:54 WARNING django.request ##: Not Found: /favicon.ico
[24/Jan/2018 19:13:54] "GET /favicon.ico HTTP/1.1" 404 11861

TraceBack from browser:

Environment:

Request Method: GET
Request URL: http://127.0.0.1:8000/workflow/

Django Version: 1.11.7
Python Version: 3.6.2
Installed Applications:
['django.contrib.admin',
 'django.contrib.auth',
 'django.contrib.contenttypes',
 'django.contrib.sessions',
 'django.contrib.messages',
 'django.contrib.staticfiles',
 'django_celery_results',
 'django_extensions',
 'material',
 'material.frontend',
 'viewflow',
 'viewflow.frontend',
 'fifa.flows',
 'debug_toolbar']
Installed Middleware:
['debug_toolbar.middleware.DebugToolbarMiddleware',
 'debug_toolbar.middleware.DebugToolbarMiddleware',
 'django.middleware.security.SecurityMiddleware',
 'django.contrib.sessions.middleware.SessionMiddleware',
 'django.middleware.common.CommonMiddleware',
 'django.middleware.csrf.CsrfViewMiddleware',
 'django.contrib.auth.middleware.AuthenticationMiddleware',
 'django.contrib.messages.middleware.MessageMiddleware',
 'django.middleware.clickjacking.XFrameOptionsMiddleware']

Template error:
In template C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\material\templates\material\fields\django_select.html, error at line 18
   FAILED SQL: SELECT "viewflow_process"."id", "viewflow_process"."flow_class", "viewflow_process"."status", "viewflow_process"."created", "viewflow_process"."finished" FROM "viewflow_process" WHERE "viewflow_process"."id" IN (SELECT U0."process_id" AS Col1 FROM "viewflow_task" U0 INNER JOIN "viewflow_process" U1 ON (U0."process_id" = U1."id") WHERE (U1."flow_class" IN (%(0)s, %(1)s, %(2)s) AND U0."owner_id" = %(3)s AND U0."status" = %(4)s)) ORDER BY "viewflow_process"."created" DESCPymongo error: OrderedDict([('ok', 0.0), ('errmsg', 'arguments to $lookup must be strings, pipeline: [ { $match: { process_id: { $ne: null, $exists: true } } }, { $lookup: { from: "viewflow_process", localField: "process_id", foreignField: "id", as: "viewflow_process" } }, { $unwind: "$viewflow_process" }, { $match: { $and: [ { viewflow_process.flow_class: { $in: [ "flows/flows.hotel_mapping.ProviderScan", "flows/flows.main_onboarding.MainOnBoardingFlow", "flows/flows.hotel_mapping.SingleHotelMapping" ] } }, { owner_id: { $eq: 1 } }, { viewflow_process.flow_class: { $in: [ "flows/flows.hotel_mapping.ProviderScan", "flows/flows.main_onboarding.MainOnBoardingFlow", "flows/flows.hotel_mapping.SingleHotelMapping" ] } }, { owner_id: { $eq: 1 } }, { status: { $eq: "ASSIGNED" } }, { status: { $eq: "ASSIGNED" } } ] } }, { $project: { process_id: true } } ] is type array'), ('code', 4570), ('codeName', 'Location4570')])   8 :         <label{% attrs bound_field 'label' %}
   9 :             for="{{ bound_field.id_for_label }}"
   10 :         {% endattrs %}>{{ bound_field.label }}</label>
   11 :         {% endpart %}
   12 :         {% part field control %}
   13 :         <select{% attrs bound_field 'widget' default field.widget.attrs %}
   14 :             id="id_{{ bound_field.html_name }}"
   15 :             name="{{ bound_field.html_name }}"
   16 :             {% if bound_field.errors %}class="invalid"{% endif %}
   17 :         {% endattrs %}>
   18 :             {% part field options %} {% for group, items in bound_field|select_options %} 
   19 :             {% if group %}<optgroup label="{{ group }}">{% endif %}{% for choice, value, selected in items %}
   20 :             <option {% if value == None or value == '' %}value{% else %}value="{{ value|unlocalize }}"{% endif %}{% if selected %} selected="selected"{% endif %}>{% if value == None or value == '' %}{{ form_select_empty_label|default:choice }}{% else %}{{ choice }}{% endif %}</option>{% endfor %}
   21 :             {% if group %}</optgroup>{% endif %}{% endfor %}{% endpart %}
   22 :         </select>
   23 :         {% endpart %}
   24 :         {% part field help_text %}{% if field.help_text %}
   25 :             <div class="help-block">{{ bound_field.help_text|safe }}</div>
   26 :         {% endif %}{% endpart %}{% part field errors %}
   27 :         {% if bound_field.errors %}
   28 :             {% include  'material/field_errors.html' %}

Traceback:

File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\djongo\sql2mongo.py" in __iter__
  850.             yield from iter(self._query)

File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\djongo\sql2mongo.py" in __iter__
  563.             self._cursor = self._get_cursor()

File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\djongo\sql2mongo.py" in _get_cursor
  644.             cur = self.db_ref[self.left_table].aggregate(pipeline)

File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\pymongo\collection.py" in aggregate
  2181.                                    **kwargs)

File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\pymongo\collection.py" in _aggregate
  2088.                 client=self.__database.client)

File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\pymongo\pool.py" in command
  496.                            collation=collation)

File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\pymongo\network.py" in command
  125.                 parse_write_concern_error=parse_write_concern_error)

File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\pymongo\helpers.py" in _check_command_response
  146.             raise OperationFailure(msg % errmsg, code, response)

The above exception (arguments to $lookup must be strings, pipeline: [ { $match: { process_id: { $ne: null, $exists: true } } }, { $lookup: { from: "viewflow_process", localField: "process_id", foreignField: "id", as: "viewflow_process" } }, { $unwind: "$viewflow_process" }, { $match: { $and: [ { viewflow_process.flow_class: { $in: [ "flows/flows.hotel_mapping.ProviderScan", "flows/flows.main_onboarding.MainOnBoardingFlow", "flows/flows.hotel_mapping.SingleHotelMapping" ] } }, { owner_id: { $eq: 1 } }, { viewflow_process.flow_class: { $in: [ "flows/flows.hotel_mapping.ProviderScan", "flows/flows.main_onboarding.MainOnBoardingFlow", "flows/flows.hotel_mapping.SingleHotelMapping" ] } }, { owner_id: { $eq: 1 } }, { status: { $eq: "ASSIGNED" } }, { status: { $eq: "ASSIGNED" } } ] } }, { $project: { process_id: true } } ] is type array) was the direct cause of the following exception:

File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\core\handlers\exception.py" in inner
  41.             response = get_response(request)

File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\core\handlers\base.py" in _get_response
  217.                 response = self.process_exception_by_middleware(e, request)

File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\core\handlers\base.py" in _get_response
  215.                 response = response.render()

File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\response.py" in render
  107.             self.content = self.rendered_content

File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\response.py" in rendered_content
  84.         content = template.render(context, self._request)

File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\backends\django.py" in render
  66.             return self.template.render(context)

File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\base.py" in render
  207.                     return self._render(context)

File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\test\utils.py" in instrumented_test_render
  107.     return self.nodelist.render(context)

File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\base.py" in render
  990.                 bit = node.render_annotated(context)

File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\base.py" in render_annotated
  957.             return self.render(context)

File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\loader_tags.py" in render
  177.             return compiled_parent._render(context)

File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\test\utils.py" in instrumented_test_render
  107.     return self.nodelist.render(context)

File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\base.py" in render
  990.                 bit = node.render_annotated(context)

File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\base.py" in render_annotated
  957.             return self.render(context)

File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\loader_tags.py" in render
  177.             return compiled_parent._render(context)

File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\test\utils.py" in instrumented_test_render
  107.     return self.nodelist.render(context)

File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\base.py" in render
  990.                 bit = node.render_annotated(context)

File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\base.py" in render_annotated
  957.             return self.render(context)

File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\loader_tags.py" in render
  177.             return compiled_parent._render(context)

File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\test\utils.py" in instrumented_test_render
  107.     return self.nodelist.render(context)

File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\base.py" in render
  990.                 bit = node.render_annotated(context)

File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\base.py" in render_annotated
  957.             return self.render(context)

File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\loader_tags.py" in render
  177.             return compiled_parent._render(context)

File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\test\utils.py" in instrumented_test_render
  107.     return self.nodelist.render(context)

File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\base.py" in render
  990.                 bit = node.render_annotated(context)

File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\base.py" in render_annotated
  957.             return self.render(context)

File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\loader_tags.py" in render
  177.             return compiled_parent._render(context)

File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\test\utils.py" in instrumented_test_render
  107.     return self.nodelist.render(context)

File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\base.py" in render
  990.                 bit = node.render_annotated(context)

File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\base.py" in render_annotated
  957.             return self.render(context)

File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\loader_tags.py" in render
  72.                 result = block.nodelist.render(context)

File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\base.py" in render
  990.                 bit = node.render_annotated(context)

File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\base.py" in render_annotated
  957.             return self.render(context)

File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\loader_tags.py" in render
  72.                 result = block.nodelist.render(context)

File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\base.py" in render
  990.                 bit = node.render_annotated(context)

File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\base.py" in render_annotated
  957.             return self.render(context)

File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\loader_tags.py" in render
  72.                 result = block.nodelist.render(context)

File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\base.py" in render
  990.                 bit = node.render_annotated(context)

File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\base.py" in render_annotated
  957.             return self.render(context)

File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\loader_tags.py" in render
  72.                 result = block.nodelist.render(context)

File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\base.py" in render
  990.                 bit = node.render_annotated(context)

File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\base.py" in render_annotated
  957.             return self.render(context)

File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\loader_tags.py" in render
  72.                 result = block.nodelist.render(context)

File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\base.py" in render
  990.                 bit = node.render_annotated(context)

File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\base.py" in render_annotated
  957.             return self.render(context)

File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\defaulttags.py" in render
  322.                 return nodelist.render(context)

File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\base.py" in render
  990.                 bit = node.render_annotated(context)

File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\base.py" in render_annotated
  957.             return self.render(context)

File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\defaulttags.py" in render
  322.                 return nodelist.render(context)

File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\base.py" in render
  990.                 bit = node.render_annotated(context)

File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\base.py" in render_annotated
  957.             return self.render(context)

File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\material\templatetags\material_form.py" in render
  142.             return template.render(context_flatten(context))

File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\backends\django.py" in render
  66.             return self.template.render(context)

File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\base.py" in render
  207.                     return self._render(context)

File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\test\utils.py" in instrumented_test_render
  107.     return self.nodelist.render(context)

File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\base.py" in render
  990.                 bit = node.render_annotated(context)

File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\base.py" in render_annotated
  957.             return self.render(context)

File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\material\templatetags\material_form.py" in render
  203.         value = self.nodelist.render(context).strip()

File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\base.py" in render
  990.                 bit = node.render_annotated(context)

File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\base.py" in render_annotated
  957.             return self.render(context)

File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\defaulttags.py" in render
  322.                 return nodelist.render(context)

File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\base.py" in render
  990.                 bit = node.render_annotated(context)

File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\base.py" in render_annotated
  957.             return self.render(context)

File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\material\templatetags\material_form.py" in render
  203.         value = self.nodelist.render(context).strip()

File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\base.py" in render
  990.                 bit = node.render_annotated(context)

File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\base.py" in render_annotated
  957.             return self.render(context)

File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\defaulttags.py" in render
  216.                     nodelist.append(node.render_annotated(context))

File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\base.py" in render_annotated
  957.             return self.render(context)

File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\material\templatetags\material_form_internal.py" in render
  81.             return Field(element.name).render(context, **options)

File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\material\base.py" in render
  229.                 return template.render(context.flatten())

File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\backends\django.py" in render
  66.             return self.template.render(context)

File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\base.py" in render
  207.                     return self._render(context)

File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\test\utils.py" in instrumented_test_render
  107.     return self.nodelist.render(context)

File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\base.py" in render
  990.                 bit = node.render_annotated(context)

File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\base.py" in render_annotated
  957.             return self.render(context)

File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\material\templatetags\material_form.py" in render
  200.         _render_parts(context, children)

File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\material\templatetags\material_form.py" in _render_parts
  31.             value = partnode.render(context)

File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\material\templatetags\material_form.py" in render
  200.         _render_parts(context, children)

File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\material\templatetags\material_form.py" in _render_parts
  31.             value = partnode.render(context)

File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\material\templatetags\material_form.py" in render
  203.         value = self.nodelist.render(context).strip()

File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\base.py" in render
  990.                 bit = node.render_annotated(context)

File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\base.py" in render_annotated
  957.             return self.render(context)

File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\defaulttags.py" in render
  166.                 values = self.sequence.resolve(context, True)

File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\template\base.py" in resolve
  736.                 new_obj = func(obj, *arg_vals)

File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\material\templatetags\material_form_internal.py" in select_options
  207.     for option in bound_field.field.widget.choices:

File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\forms\models.py" in __iter__
  1139.         for obj in queryset:

File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\viewflow\managers.py" in iterator
  148.             for process in base_iterator:

File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\viewflow\managers.py" in __iter__
  94.             for process in base_iterator:

File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\db\models\query.py" in __iter__
  62.         for row in compiler.results_iter(results):

File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\db\models\sql\compiler.py" in results_iter
  839.         for rows in results:

File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\db\models\sql\compiler.py" in cursor_iter
  1284.                          sentinel):

File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\db\models\sql\compiler.py" in <lambda>
  1283.         for rows in iter((lambda: cursor.fetchmany(GET_ITERATOR_CHUNK_SIZE)),

File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\django\db\utils.py" in inner
  101.                 return func(*args, **kwargs)

File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\djongo\cursor.py" in fetchmany
  50.                 ret.append(self.result.next())

File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\djongo\sql2mongo.py" in __next__
  844.         return next(self._result_generator)

File "C:\Users\alexk\development\projects\python\venvs\fifa_mongo\lib\site-packages\djongo\sql2mongo.py" in __iter__
  854.             raise exe from e

Exception Type: SQLDecodeError at /workflow/
Exception Value: FAILED SQL: SELECT "viewflow_process"."id", "viewflow_process"."flow_class", "viewflow_process"."status", "viewflow_process"."created", "viewflow_process"."finished" FROM "viewflow_process" WHERE "viewflow_process"."id" IN (SELECT U0."process_id" AS Col1 FROM "viewflow_task" U0 INNER JOIN "viewflow_process" U1 ON (U0."process_id" = U1."id") WHERE (U1."flow_class" IN (%(0)s, %(1)s, %(2)s) AND U0."owner_id" = %(3)s AND U0."status" = %(4)s)) ORDER BY "viewflow_process"."created" DESCPymongo error: OrderedDict([('ok', 0.0), ('errmsg', 'arguments to $lookup must be strings, pipeline: [ { $match: { process_id: { $ne: null, $exists: true } } }, { $lookup: { from: "viewflow_process", localField: "process_id", foreignField: "id", as: "viewflow_process" } }, { $unwind: "$viewflow_process" }, { $match: { $and: [ { viewflow_process.flow_class: { $in: [ "flows/flows.hotel_mapping.ProviderScan", "flows/flows.main_onboarding.MainOnBoardingFlow", "flows/flows.hotel_mapping.SingleHotelMapping" ] } }, { owner_id: { $eq: 1 } }, { viewflow_process.flow_class: { $in: [ "flows/flows.hotel_mapping.ProviderScan", "flows/flows.main_onboarding.MainOnBoardingFlow", "flows/flows.hotel_mapping.SingleHotelMapping" ] } }, { owner_id: { $eq: 1 } }, { status: { $eq: "ASSIGNED" } }, { status: { $eq: "ASSIGNED" } } ] } }, { $project: { process_id: true } } ] is type array'), ('code', 4570), ('codeName', 'Location4570')])
nesdis commented 6 years ago

@ayakut do you still face this issue with latest version 1.2.20?

nesdis commented 6 years ago

Will assume this issue is closed. Please raise a new ticket if you face a new issue.