TYPE
importer.control.rawDataAnalyser.rawDataAnalyser
Outputs
Process has no outputs.
Log
Traceback (most recent call last):
File "/usr/local/lib/python3.14/site-packages/django/db/backends/utils.py", line 103, in _execute
return self.cursor.execute(sql)
~~~~~~~~~~~~~~~~~~~^^^^^
psycopg2.errors.UndefinedTable: relation "sources.q__0000001000039" does not exist
LINE 2: SELECT COUNT(*) FROM sources.q__0000001000039 obj ;
^
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/var/www/simplex4data/envsql/cursor.py", line 23, in execute
self.cur.execute(sqlCmd,params)
~~~~~~~~~~~~~~~~^^^^^^^^^^^^^^^
File "/usr/local/lib/python3.14/site-packages/django/db/backends/utils.py", line 122, in execute
return super().execute(sql, params)
~~~~~~~~~~~~~~~^^^^^^^^^^^^^
File "/usr/local/lib/python3.14/site-packages/django/db/backends/utils.py", line 79, in execute
return self._execute_with_wrappers(
~~~~~~~~~~~~~~~~~~~~~~~~~~~^
sql, params, many=False, executor=self._execute
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
)
^
File "/usr/local/lib/python3.14/site-packages/django/db/backends/utils.py", line 92, in _execute_with_wrappers
return executor(sql, params, many, context)
File "/usr/local/lib/python3.14/site-packages/django/db/backends/utils.py", line 100, in _execute
with self.db.wrap_database_errors:
^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/usr/local/lib/python3.14/site-packages/django/db/utils.py", line 91, in __exit__
raise dj_exc_value.with_traceback(traceback) from exc_value
File "/usr/local/lib/python3.14/site-packages/django/db/backends/utils.py", line 103, in _execute
return self.cursor.execute(sql)
~~~~~~~~~~~~~~~~~~~^^^^^
django.db.utils.ProgrammingError: relation "sources.q__0000001000039" does not exist
LINE 2: SELECT COUNT(*) FROM sources.q__0000001000039 obj ;
^
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/var/www/simplex4data/importer/control/rawDataAnalyser.py", line 92, in execute
self.prepare(cur)
~~~~~~~~~~~~^^^^^
File "/var/www/simplex4data/importer/control/rawDataAnalyser.py", line 105, in prepare
count = OP.pattern('getObjects',params, cur)
File "/var/www/simplex4data/envsql/operators.py", line 227, in pattern
return execFunc(cur,pattern['text'].format(**patParams),sqlParams)
File "/var/www/simplex4data/envsql/operators.py", line 484, in execFunc
return cur.execute(sqlCmd,params)
~~~~~~~~~~~^^^^^^^^^^^^^^^
File "/var/www/simplex4data/envsql/cursor.py", line 34, in execute
raise type(e)('[].[]: [] Caused by SQL command "[]" with params []'.format(*args)) from e
django.db.utils.ProgrammingError: psycopg2.errors.UndefinedTable: relation "sources.q__0000001000039" does not exist
LINE 2: SELECT COUNT(*) FROM sources.q__0000001000039 obj ;
^
Caused by SQL command "1:
2: SELECT COUNT(*) FROM sources.q__0000001000039 obj ;
3: " with params None
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/usr/local/lib/python3.14/site-packages/django/db/backends/utils.py", line 105, in _execute
return self.cursor.execute(sql, params)
~~~~~~~~~~~~~~~~~~~^^^^^^^^^^^^^
psycopg2.errors.InFailedSqlTransaction: current transaction is aborted, commands ignored until end of transaction block
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/var/www/simplex4data/envsql/cursor.py", line 23, in execute
self.cur.execute(sqlCmd,params)
~~~~~~~~~~~~~~~~^^^^^^^^^^^^^^^
File "/usr/local/lib/python3.14/site-packages/django/db/backends/utils.py", line 122, in execute
return super().execute(sql, params)
~~~~~~~~~~~~~~~^^^^^^^^^^^^^
File "/usr/local/lib/python3.14/site-packages/django/db/backends/utils.py", line 79, in execute
return self._execute_with_wrappers(
~~~~~~~~~~~~~~~~~~~~~~~~~~~^
sql, params, many=False, executor=self._execute
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
)
^
File "/usr/local/lib/python3.14/site-packages/django/db/backends/utils.py", line 92, in _execute_with_wrappers
return executor(sql, params, many, context)
File "/usr/local/lib/python3.14/site-packages/django/db/backends/utils.py", line 100, in _execute
with self.db.wrap_database_errors:
^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/usr/local/lib/python3.14/site-packages/django/db/utils.py", line 91, in __exit__
raise dj_exc_value.with_traceback(traceback) from exc_value
File "/usr/local/lib/python3.14/site-packages/django/db/backends/utils.py", line 105, in _execute
return self.cursor.execute(sql, params)
~~~~~~~~~~~~~~~~~~~^^^^^^^^^^^^^
django.db.utils.InternalError: current transaction is aborted, commands ignored until end of transaction block
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/var/www/simplex4data/dispatcher/__init__.py", line 198, in doExecute
self.execute(cur,outQueue)
~~~~~~~~~~~~^^^^^^^^^^^^^^
File "/var/www/simplex4data/importer/control/rawDataAnalyser.py", line 96, in execute
dispatcher.unscheduleFromProcess(self.proc.s,self.proc.o,tab.c,tab.o,cur)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/var/www/simplex4data/dispatcher/__init__.py", line 286, in unscheduleFromProcess
envsql.process.removeInOrOut(cur,[
~~~~~~~~~~~~~~~~~~~~~~~~~~~~^^^^^^
's':sourceId,
^^^^^^^^^^^^^
...<4 lines>...
'depO':objId,
^^^^^^^^^^^^^
])
^^
File "/var/www/simplex4data/envsql/process.py", line 260, in removeInOrOut
OP.pattern('updateValues',myParams,cur,sqlParams)
~~~~~~~~~~^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/var/www/simplex4data/envsql/operators.py", line 227, in pattern
return execFunc(cur,pattern['text'].format(**patParams),sqlParams)
File "/var/www/simplex4data/envsql/operators.py", line 484, in execFunc
return cur.execute(sqlCmd,params)
~~~~~~~~~~~^^^^^^^^^^^^^^^
File "/var/www/simplex4data/envsql/cursor.py", line 34, in execute
raise type(e)('[].[]: [] Caused by SQL command "[]" with params []'.format(*args)) from e
django.db.utils.InternalError: psycopg2.errors.InFailedSqlTransaction: current transaction is aborted, commands ignored until end of transaction block
Caused by SQL command "1: UPDATE reality.Y__0000000000000 obj set z = statement_timestamp() where obj.o1=%s AND obj.o2=%s AND obj.c2=%s AND obj.s2=%s AND obj.c=%s AND obj.s=%s AND obj.z=%s ;
2: " with params (168, 39, 43, 10, '61', 10, 'infinity')