[infra] cx_Oracle.DatabaseError: ORA-00972: identifier is too long
Closed this issue · 0 comments
d116626 commented
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