prefeitura-rio/pipelines

[infra] cx_Oracle.DatabaseError: ORA-00972: identifier is too long

Closed this issue · 0 comments

Resolver pipeline: https://prefect.dados.rio/default/flow-run/17c5b81b-6f15-4555-a79d-63221cd32839?logs

Executing query: 
    with af46eb30bda3e4aeb837e585b64bb6b32 as (SELECT * FROM C_ERGON.VW_DLK_ERG_FITA_BANCO)
    select * from af46eb30bda3e4aeb837e585b64bb6b32
    where MES_ANO >= '2022-04-01'
Task 'database_execute': Exception encountered during task execution!
Traceback (most recent call last):
  File "/opt/venv/lib/python3.9/site-packages/prefect/engine/task_runner.py", line 876, in get_task_run_state
    value = prefect.utilities.executors.run_task_with_timeout(
  File "/opt/venv/lib/python3.9/site-packages/prefect/utilities/executors.py", line 454, in run_task_with_timeout
    return task.run(*args, **kwargs)  # type: ignore
  File "/opt/hostedtoolcache/Python/3.9.13/x64/lib/python3.9/site-packages/pipelines/utils/dump_db/tasks.py", line 113, in database_execute
  File "/opt/venv/lib/python3.9/site-packages/pipelines/utils/dump_db/db.py", line 299, in execute_query
    self._cursor.execute(query)
cx_Oracle.DatabaseError: ORA-00972: identifier is too long