Hi everyone.. running into an issue with setting u...
# ingestion
t
Hi everyone.. running into an issue with setting up a Microsoft SQL Server ingestion as the password for the database (stored in secrets) has special characters like @+\{ and I'm getting Json errors while building the job
m
what is the error message?
t
I'm getting
Copy code
RUN_INGEST - {'errors': [],
 'exec_id': '0fa878f0-3d3c-4145-8cf0-8e92bb61b13d',
 'infos': ['2022-10-06 13:35:46.910135 [exec_id=0fa878f0-3d3c-4145-8cf0-8e92bb61b13d] INFO: Starting execution for task with name=RUN_INGEST',
           '2022-10-06 13:35:46.931038 [exec_id=0fa878f0-3d3c-4145-8cf0-8e92bb61b13d] INFO: Caught exception EXECUTING '
           'task_id=0fa878f0-3d3c-4145-8cf0-8e92bb61b13d, name=RUN_INGEST, stacktrace=Traceback (most recent call last):\n'
           '  File "/usr/local/lib/python3.10/site-packages/acryl/executor/execution/default_executor.py", line 123, in execute_task\n'
           '    task_event_loop.run_until_complete(task_future)\n'
           '  File "/usr/local/lib/python3.10/asyncio/base_events.py", line 646, in run_until_complete\n'
           '    return future.result()\n'
           '  File "/usr/local/lib/python3.10/site-packages/acryl/executor/execution/sub_process_ingestion_task.py", line 69, in execute\n'
           '    recipe: dict = SubProcessTaskUtil._resolve_recipe(validated_args.recipe, ctx, self.ctx)\n'
           '  File "/usr/local/lib/python3.10/site-packages/acryl/executor/execution/sub_process_task_common.py", line 91, in _resolve_recipe\n'
           '    json_recipe = json.loads(resolved_recipe)\n'
           '  File "/usr/local/lib/python3.10/json/__init__.py", line 346, in loads\n'
           '    return _default_decoder.decode(s)\n'
           '  File "/usr/local/lib/python3.10/json/decoder.py", line 337, in decode\n'
           '    obj, end = self.raw_decode(s, idx=_w(s, 0).end())\n'
           '  File "/usr/local/lib/python3.10/json/decoder.py", line 353, in raw_decode\n'
           '    obj, end = self.scan_once(s, idx)\n'
           'json.decoder.JSONDecodeError: Invalid \\escape: line 1 column 264 (char 263)\n']}
m
Thanks, we’ll take a look
g
Was there a solution to this? I'm running into the same error for a Snowflake Ingestion