# Need Help with awx 9.3.0 migration to 13.0.0 **URL:** \ **Category:** AWX Project\ **Tags:** awx\ **Created:** [August 10, 2020, 8:40pm UTC](https://forum.ansible.com/t/need-help-with-awx-9-3-0-migration-to-13-0-0/33578 "2020-08-10T20:40:51Z")\ **Posts on this page:** 2\ **Page:** 1
**Author:** ![Michael\_Nhan](https://avatars.discourse-cdn.com/v4/letter/m/58f4c7/32.png) [@Michael\_Nhan](https://forum.ansible.com/u/Michael_Nhan)\ **Post date:** [August 10, 2020, 8:40pm UTC](https://forum.ansible.com/t/need-help-with-awx-9-3-0-migration-to-13-0-0/33578/1 "2020-08-10T20:40:51Z")
Having some issue migrating from awx 9.3.0 to 13.0.0. Have updated/migrated from 6.0.0 to 9.0.1 and to 9.3.0 with no issues. But trying to go to a later version is erroring out. Current awx installation: 9.3.0 on openshift external postgresql 10 database database user: awx trying to update to 10.0 or 13.0 gives me the same error. Any help would greatly be appreciated. > “stderr\_lines”: [ > > “2020-08-10 19:27:09,621 DEBUG rbac\_migrations Migrating systemjobtemplate to new organization field”, > > > “2020-08-10 19:27:09,621 DEBUG rbac\_migrations Class systemjobtemplate has no organization migration”, > > “2020-08-10 19:27:09,621 DEBUG rbac\_migrations Migrating inventorysource to new organization field”, > > “2020-08-10 19:27:09,631 INFO rbac\_migrations Organization migration on inventorysource affected 10 rows.”, > > “2020-08-10 19:27:09,631 DEBUG rbac\_migrations Migrating jobtemplate to new organization field”, > > “2020-08-10 19:27:09,637 INFO rbac\_migrations Organization migration on jobtemplate affected 59 rows.”, > > “2020-08-10 19:27:09,637 DEBUG rbac\_migrations Migrating workflowjobtemplate to new organization field”, > > “2020-08-10 19:27:09,641 DEBUG rbac\_migrations Migrating workflowapprovaltemplate to new organization field”, > > “2020-08-10 19:27:09,641 DEBUG rbac\_migrations Class workflowapprovaltemplate has no organization migration”, > > “2020-08-10 19:27:09,641 DEBUG rbac\_migrations Migrating project to new organization field”, > > “2020-08-10 19:27:09,698 INFO rbac\_migrations Organization migration on project affected 13 rows.”, > > “2020-08-10 19:27:09,698 INFO rbac\_migrations Unified organization migration completed in 0.0775 seconds”, > > “2020-08-10 19:27:09,698 DEBUG rbac\_migrations Migrating projectupdate to new organization field”, > > “2020-08-10 19:27:09,729 INFO rbac\_migrations Organization migration on projectupdate affected 626 rows.”, > > “2020-08-10 19:27:09,730 DEBUG rbac\_migrations Migrating workflowapproval to new organization field”, > > “2020-08-10 19:27:09,730 DEBUG rbac\_migrations Class workflowapproval has no organization migration”, > > “2020-08-10 19:27:09,730 DEBUG rbac\_migrations Migrating inventoryupdate to new organization field”, > > “2020-08-10 19:27:09,754 INFO rbac\_migrations Organization migration on inventoryupdate affected 508 rows.”, > > “2020-08-10 19:27:09,754 DEBUG rbac\_migrations Migrating job to new organization field”, > > “2020-08-10 19:27:09,766 INFO rbac\_migrations Organization migration on job affected 197 rows.”, > > “2020-08-10 19:27:09,766 DEBUG rbac\_migrations Migrating systemjob to new organization field”, > > “2020-08-10 19:27:09,767 DEBUG rbac\_migrations Class systemjob has no organization migration”, > > “2020-08-10 19:27:09,767 DEBUG rbac\_migrations Migrating adhoccommand to new organization field”, > > “2020-08-10 19:27:09,773 INFO rbac\_migrations Organization migration on adhoccommand affected 2 rows.”, > > “2020-08-10 19:27:09,773 DEBUG rbac\_migrations Migrating workflowjob to new organization field”, > > “2020-08-10 19:27:09,778 INFO rbac\_migrations Unified organization migration completed in 0.0791 seconds”, > > “Traceback (most recent call last):”, > > " File "/usr/bin/awx-manage", line 8, in ", > > " sys.exit(manage())", > > " File "/var/lib/awx/venv/awx/lib/python3.6/site-packages/awx/ **init**.py", line 152, in manage", > > " execute\_from\_command\_line(sys.argv)", > > " File "/var/lib/awx/venv/awx/lib/python3.6/site-packages/django/core/management/ **init**.py", line 381, in execute\_from\_command\_line", > > " utility.execute()", > > " File "/var/lib/awx/venv/awx/lib/python3.6/site-packages/django/core/management/ **init**.py", line 375, in execute", > > " self.fetch\_command(subcommand).run\_from\_argv(self.argv)", > > " File "/var/lib/awx/venv/awx/lib/python3.6/site-packages/django/core/management/base.py", line 323, in run\_from\_argv", > > " self.execute(\*args, \*\*cmd\_options)", > > " File "/var/lib/awx/venv/awx/lib/python3.6/site-packages/django/core/management/base.py", line 364, in execute", > > " output = self.handle(\*args, \*\*options)", > > " File "/var/lib/awx/venv/awx/lib/python3.6/site-packages/django/core/management/base.py", line 83, in wrapped", > > " res = handle\_func(\*args, \*\*kwargs)", > > " File "/var/lib/awx/venv/awx/lib/python3.6/site-packages/django/core/management/commands/migrate.py", line 234, in handle", > > " fake\_initial=fake\_initial,", > > " File "/var/lib/awx/venv/awx/lib/python3.6/site-packages/django/db/migrations/executor.py", line 117, in migrate", > > " state = self.\_migrate\_all\_forwards(state, plan, full\_plan, fake=fake, fake\_initial=fake\_initial)", > > " File "/var/lib/awx/venv/awx/lib/python3.6/site-packages/django/db/migrations/executor.py", line 147, in \_migrate\_all\_forwards", > > " state = self.apply\_migration(state, migration, fake=fake, fake\_initial=fake\_initial)", > > " File "/var/lib/awx/venv/awx/lib/python3.6/site-packages/django/db/migrations/executor.py", line 245, in apply\_migration", > > " state = migration.apply(state, schema\_editor)", > > " File "/var/lib/awx/venv/awx/lib/python3.6/site-packages/django/db/migrations/migration.py", line 124, in apply", > > " operation.database\_forwards(self.app\_label, schema\_editor, old\_state, project\_state)", > > " File "/var/lib/awx/venv/awx/lib/python3.6/site-packages/django/db/migrations/operations/special.py", line 190, in database\_forwards", > > " self.code(from\_state.apps, schema\_editor)", > > " File "/var/lib/awx/venv/awx/lib/python3.6/site-packages/awx/main/migrations/0109\_v370\_job\_template\_organization\_field.py", line 16, in rebuild\_jt\_parents", > > " rebuild\_role\_parentage(apps, schema\_editor, models=(‘jobtemplate’,))", > > " File "/var/lib/awx/venv/awx/lib/python3.6/site-packages/awx/main/migrations/\_rbac.py", line 280, in rebuild\_role\_parentage", > > " content\_object = ct\_model.objects.get(pk=role.object\_id)", > > " File "/var/lib/awx/venv/awx/lib/python3.6/site-packages/django/db/models/manager.py", line 82, in manager\_method", > > " return getattr(self.get\_queryset(), name)(\*args, \*\*kwargs)", > > " File "/var/lib/awx/venv/awx/lib/python3.6/site-packages/django/db/models/query.py", line 408, in get", > > " self.model.\_meta.object\_name", > > “ **fake**.DoesNotExist: JobTemplate matching query does not exist.”, > > “command terminated with exit code 1” Michael ---
**Author:** ![Michael\_Nhan](https://avatars.discourse-cdn.com/v4/letter/m/58f4c7/32.png) [@Michael\_Nhan](https://forum.ansible.com/u/Michael_Nhan)\ **Post date:** [August 18, 2020, 2:56pm UTC](https://forum.ansible.com/t/need-help-with-awx-9-3-0-migration-to-13-0-0/33578/2 "2020-08-18T14:56:16Z")
using a new install of 9.3.0 and turning on full logging in postgresql I was able to figure out what was being done during the db migration to 13.0. I was able to manually migrate my 9.3.0 db to 13.0 using the same query and dml to complete 0109\_v370\_job\_template\_organization\_field.py . The rest of the migration was then successful via awx-manage migrate.