# ERROR:  relation "conf\_setting" does not exist at character 158

**URL:** <https://forum.ansible.com/t/error-relation-conf-setting-does-not-exist-at-character-158/27852>\
**Category:** AWX Project\
**Created:** [June 22, 2018, 4:53pm UTC](https://forum.ansible.com/t/error-relation-conf-setting-does-not-exist-at-character-158/27852 "2018-06-22T16:53:51Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Sudheer\_Jejamma](https://avatars.discourse-cdn.com/v4/letter/s/96bed5/32.png) [@Sudheer\_Jejamma](https://forum.ansible.com/u/Sudheer_Jejamma)\
**Post date:** [June 22, 2018, 4:53pm UTC](https://forum.ansible.com/t/error-relation-conf-setting-does-not-exist-at-character-158/27852/1 "2018-06-22T16:53:51Z")

</div>

Hi Team,

I’m getting the following error in postgres logs. Can someone please help me understand why we are getting this error ?

ERROR: relation “conf\_setting” does not exist at character 158  
STATEMENT: SELECT “conf\_setting”.“id”, “conf\_setting”.“created”, “conf\_setting”.“modified”, “conf\_setting”.“key”, “conf\_setting”.“value”, “conf\_setting”.“user\_id” FROM “conf\_setting” WHERE (“conf\_setting”.“user\_id” IS NULL AND “conf\_setting”.“key” = ‘SOCIAL\_AUTH\_SAML\_ENABLED\_IDPS’) ORDER BY “conf\_setting”.“id” ASC LIMIT 1

Thanks,  
Sudheer.

---

<div class="post-metadata">

**Author:** ![Christian\_Adams](https://avatars.discourse-cdn.com/v4/letter/c/ba8739/32.png) [@Christian\_Adams](https://forum.ansible.com/u/Christian_Adams)\
**Post date:** [June 22, 2018, 5:50pm UTC](https://forum.ansible.com/t/error-relation-conf-setting-does-not-exist-at-character-158/27852/2 "2018-06-22T17:50:10Z")

</div>

Hi Sudheer,

Which version of awx are you seeing this problem in? You can find this by running `make VERSION` in your cloned awx directory.

Thanks,  
Christian

---

<div class="post-metadata">

**Author:** ![Sudheer\_Jejamma](https://avatars.discourse-cdn.com/v4/letter/s/96bed5/32.png) [@Sudheer\_Jejamma](https://forum.ansible.com/u/Sudheer_Jejamma)\
**Post date:** [June 22, 2018, 5:55pm UTC](https://forum.ansible.com/t/error-relation-conf-setting-does-not-exist-at-character-158/27852/3 "2018-06-22T17:55:41Z")

</div>

Hi Christian,

Please find the following details.

Awx version:1.0.6.7  
Postgres version: 9.6

Thanks,  
Sudheer.

---

<div class="post-metadata">

**Author:** ![AlanCoding](https://sea1.discourse-cdn.com/ansible/user_avatar/forum.ansible.com/alancoding/32/301_2.png) [@AlanCoding](https://forum.ansible.com/u/AlanCoding)\
**Post date:** [June 27, 2018, 12:16pm UTC](https://forum.ansible.com/t/error-relation-conf-setting-does-not-exist-at-character-158/27852/4 "2018-06-27T12:16:41Z")

</div>

Speaking speculatively, this looks like an error that could be related to migration ordering / dependency resolution.

Could you tell us what your migration pathway was to get here?

---

<div class="post-metadata">

**Author:** ![Sudheer\_Jejamma](https://avatars.discourse-cdn.com/v4/letter/s/96bed5/32.png) [@Sudheer\_Jejamma](https://forum.ansible.com/u/Sudheer_Jejamma)\
**Post date:** [June 27, 2018, 8:00pm UTC](https://forum.ansible.com/t/error-relation-conf-setting-does-not-exist-at-character-158/27852/5 "2018-06-27T20:00:18Z")

</div>

Hi Alan,

I’m getting this error when I’m trying to migrate to different awx version with same Database Dump. I’m able to see this error while migrating from 1.0.4 to 1.0.5 also 1.0.5 to 1.0.6.

Thanks,  
Sudheer.