I know awx application itsself work only in postgres environment.
I need to complete the oracle integration part as a part of my development activity.
Can some one please help me on this?
Steps followed
Trying to migrate from Postgres database to Oracle database with the existing code. we replaced the variables and the connections from postgres sql to Oracle in Dockerfile.j2 under templates and in settings.py. I found
there is a very notable amount of Postgres-specific ORM code in awx, as well as usage of postgres-specific features (such as advisory locks) that simply won’t work with oracle due to implementation discrepancies between the two
What all the other files we need to change to make it work with oracle
Synchronizing apps without migrations
File “/usr/bin/awx-manage”, line 11, in
load_entry_point(‘awx==4.0.0’, ‘console_scripts’, ‘awx-manage’)()
File “/var/lib/awx/venv/awx/lib64/python3.6/site-packages/awx/init.py”, line 140, in manage
execute_from_command_line(sys.argv)
File “/var/lib/awx/venv/awx/lib64/python3.6/site-packages/django/core/management/init.py”, line 364, in execute_from_command_line
utility.execute()
File “/var/lib/awx/venv/awx/lib64/python3.6/site-packages/django/core/management/init.py”, line 356, in execute
self.fetch_command(subcommand).run_from_argv(self.argv)
File “/var/lib/awx/venv/awx/lib64/python3.6/site-packages/django/core/management/base.py”, line 283, in run_from_argv
self.execute(*args, **cmd_options)
File “/var/lib/awx/venv/awx/lib64/python3.6/site-packages/django/core/management/base.py”, line 330, in execute
output = self.handle(*args, **options)
File “/var/lib/awx/venv/awx/lib64/python3.6/site-packages/awx/main/management/commands/run_dispatcher.py”, line 121, in handle
reaper.reap()
File “/var/lib/awx/venv/awx/lib64/python3.6/site-packages/awx/main/dispatch/reaper.py”, line 36, in reap
me = instance or Instance.objects.me()
File “/var/lib/awx/venv/awx/lib64/python3.6/site-packages/awx/main/managers.py”, line 114, in me
if node.exists():
File “/var/lib/awx/venv/awx/lib64/python3.6/site-packages/django/db/models/query.py”, line 673, in exists
return self.query.has_results(using=self.db)
File “/var/lib/awx/venv/awx/lib64/python3.6/site-packages/django/db/models/sql/query.py”, line 517, in has_results
return compiler.has_results()
File “/var/lib/awx/venv/awx/lib64/python3.6/site-packages/django/db/models/sql/compiler.py”, line 858, in has_results
return bool(self.execute_sql(SINGLE))
File “/var/lib/awx/venv/awx/lib64/python3.6/site-packages/django/db/models/sql/compiler.py”, line 899, in execute_sql
raise original_exception
File “/var/lib/awx/venv/awx/lib64/python3.6/site-packages/django/db/models/sql/compiler.py”, line 889, in execute_sql
cursor.execute(sql, params)
File “/var/lib/awx/venv/awx/lib64/python3.6/site-packages/django/db/backends/utils.py”, line 64, in execute
return self.cursor.execute(sql, params)
File “/var/lib/awx/venv/awx/lib64/python3.6/site-packages/django/db/utils.py”, line 94, in exit
six.reraise(dj_exc_type, dj_exc_value, traceback)
File “/var/lib/awx/venv/awx/lib64/python3.6/site-packages/django/utils/six.py”, line 685, in reraise
raise value.with_traceback(tb)
File “/var/lib/awx/venv/awx/lib64/python3.6/site-packages/django/db/backends/utils.py”, line 64, in execute
return self.cursor.execute(sql, params)
File “/var/lib/awx/venv/awx/lib64/python3.6/site-packages/django/db/backends/oracle/base.py”, line 497, in execute
return self.cursor.execute(query, self._param_generator(params))
django.db.utils.DatabaseError: ORA-00942: table or view does not exist
2019-06-07 06:47:54,072 INFO exited: dispatcher (exit status 1; not expected)
2019-06-07 06:47:55,075 INFO spawned: ‘dispatcher’ with pid 244
Can some one please help me on this?