json.decoder.JSONDecodeError: Expecting property name enclosed in double quotes: line 1 column 2 (char 1)

[Amitabh-Priyadarshi-Bayer]

15:41:37,974 datashaper.workflow.workflow INFO executing verb create_community_reports
15:41:53,22 httpx INFO HTTP Request: POST https://agvisorapimtest.azure-api.net/openapi-test/openai/deployments/gpt-4-32k/chat/completions?api-version=2023-05-15 "HTTP/1.1 200 OK"
15:41:53,28 graphrag.llm.openai.utils ERROR error loading json, json={{    "title": "Product Team: Mansz and Jrman",    "summary": "The community revolves around Product Team, which includes key members such as Mansz and Jrman. Both Mansz and Jrman are Specialists and contribute significantly to the development of a specific tool. The Product Team is also likely involved in the Community Discussion and makes Application Announcements.",    "rating": 7.0,    "rating_explanation": "The impact severity rating is high due to the significant role the Team plays in the development of a specific tool.",    "findings": [        {{            "summary": "Role of Mansz and Jrman",            "explanation": "Mansz and Jrman are Specialists and are key members of the Team. They contribute significantly to the development of a specific tool. Their roles within the team are crucial for the successful development and implementation of the tool. [Data: Entities (72, 71), Relationships (97, 96, 103, 102)]"        }},        {{            "summary": "Team's involvement in the community",            "explanation": "The Team is likely involved in the Community Discussion and makes Application Announcements. This suggests that the team plays an active role in the community, contributing to discussions and informing others about updates to the application. Their involvement in these activities could have a significant impact on the community. [Data: Relationships (93, 95)]"        }},        {{            "summary": "Other members of the Team",            "explanation": "The Team also includes other members such as Mwski and Willer. Their roles within the team could also be significant in the development of the tool. However, more information is needed to fully understand their contributions. [Data: Relationships (104, 105)]"        }}    ]}}
Traceback (most recent call last):
  File "/opt/conda/lib/python3.10/site-packages/graphrag/llm/openai/utils.py", line 93, in try_parse_json_object
    result = json.loads(input)
  File "/opt/conda/lib/python3.10/json/__init__.py", line 346, in loads
    return _default_decoder.decode(s)
  File "/opt/conda/lib/python3.10/json/decoder.py", line 337, in decode
    obj, end = self.raw_decode(s, idx=_w(s, 0).end())
  File "/opt/conda/lib/python3.10/json/decoder.py", line 353, in raw_decode
    obj, end = self.scan_once(s, idx)
json.decoder.JSONDecodeError: Expecting property name enclosed in double quotes: line 1 column 2 (char 1)
15:41:53,29 graphrag.llm.openai.openai_chat_llm WARNING error parsing llm json, retrying
15:41:53,743 httpx INFO HTTP Request: POST https://agvisorapimtest.azure-api.net/openapi-test/openai/deployments/gpt-4-32k/chat/completions?api-version=2023-05-15 "HTTP/1.1 200 OK"
15:41:53,744 graphrag.llm.openai.utils ERROR error loading json, json={output_text}
Traceback (most recent call last):
  File "/opt/conda/lib/python3.10/site-packages/graphrag/llm/openai/openai_chat_llm.py", line 124, in _manual_json
    json_output = try_parse_json_object(output)
  File "/opt/conda/lib/python3.10/site-packages/graphrag/llm/openai/utils.py", line 93, in try_parse_json_object
    result = json.loads(input)
  File "/opt/conda/lib/python3.10/json/__init__.py", line 346, in loads
    return _default_decoder.decode(s)
  File "/opt/conda/lib/python3.10/json/decoder.py", line 337, in decode
    obj, end = self.raw_decode(s, idx=_w(s, 0).end())
  File "/opt/conda/lib/python3.10/json/decoder.py", line 353, in raw_decode
    obj, end = self.scan_once(s, idx)
json.decoder.JSONDecodeError: Expecting property name enclosed in double quotes: line 1 column 2 (char 1)

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "/opt/conda/lib/python3.10/site-packages/graphrag/llm/openai/utils.py", line 93, in try_parse_json_object
    result = json.loads(input)
  File "/opt/conda/lib/python3.10/json/__init__.py", line 346, in loads
    return _default_decoder.decode(s)
  File "/opt/conda/lib/python3.10/json/decoder.py", line 337, in decode
    obj, end = self.raw_decode(s, idx=_w(s, 0).end())
  File "/opt/conda/lib/python3.10/json/decoder.py", line 353, in raw_decode
    obj, end = self.scan_once(s, idx)
json.decoder.JSONDecodeError: Expecting property name enclosed in double quotes: line 1 column 2 (char 1)
15:41:53,746 graphrag.index.graph.extractors.community_reports.community_reports_extractor ERROR error generating community report
Traceback (most recent call last):
  File "/opt/conda/lib/python3.10/site-packages/graphrag/llm/openai/openai_chat_llm.py", line 124, in _manual_json
    json_output = try_parse_json_object(output)
  File "/opt/conda/lib/python3.10/site-packages/graphrag/llm/openai/utils.py", line 93, in try_parse_json_object
    result = json.loads(input)
  File "/opt/conda/lib/python3.10/json/__init__.py", line 346, in loads
    return _default_decoder.decode(s)
  File "/opt/conda/lib/python3.10/json/decoder.py", line 337, in decode
    obj, end = self.raw_decode(s, idx=_w(s, 0).end())
  File "/opt/conda/lib/python3.10/json/decoder.py", line 353, in raw_decode
    obj, end = self.scan_once(s, idx)
json.decoder.JSONDecodeError: Expecting property name enclosed in double quotes: line 1 column 2 (char 1)

[Amitabh-Priyadarshi-Bayer]

Alonso Guevara (@AlonsoGuevara)

in setting.yaml, prompt filename for community report is "prompts/community_report.txt"
I updated double braces '{{' to single { in "community_report.txt" but it still creating the json with double '{{'.

community_report:
  prompt: "prompts/community_report.txt"
  max_length: 4000
  max_input_length: 12000

Also, in indexing-engine.log in "community_reports" section,
its showing "prompt": null and not showing the filename as 'prompts/community_report.txt', which is mentioned in setting.yaml

"community_reports": {
      "llm": {
          "api_key": "REDACTED, length 32",
          "type": "azure_openai_chat",
          "model": "gpt-4-32k (0613)",
          "max_tokens": 4000,
          "request_timeout": 180.0,
          "api_base": "***",
          "api_version": "2023-05-15",
          "proxy": null,
          "cognitive_services_endpoint": null,
          "deployment_name": "gpt-4-32k",
          "model_supports_json": false,
          "tokens_per_minute": 0,
          "requests_per_minute": 0,
          "max_retries": 10,
          "max_retry_wait": 10.0,
          "sleep_on_rate_limit_recommendation": true,
          "concurrent_requests": 25
      },
      "parallelization": {
          "stagger": 0.3,
          "num_threads": 50
      },
      "async_mode": "threaded",
      "prompt": null,
      "max_length": 2000,
      "max_input_length": 8000,
      "strategy": null

Alonso Guevara (@AlonsoGuevara) need urgent help.

[Svetlana (maslenkovas)]

I had the same issue (graphrag.llm.openai.utils ERROR error loading json, json={{ "title": "Transformer Neural Networks and AI", ) and it was related to the double quoted generated community_reports. When I changed double quotes to single quotes in prompts/community_report.txt the error got resolved for me and i got "🚀 All workflows completed successfully." . So I might assume that the error in your case in the fact that you have "prompt": null . Probably there is an error in config reading.