2018-11-28 10:40:01,906 9672 CRITICAL ? odoo.service.server: Failed to initialize database `abc`

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

2018-11-28 10:40:01,906 9672 CRITICAL ? odoo.service.server: Failed to initialize database `abc`

pavan95
Hello Community,

Anyone has configured odoo with postgres? Please guide me with the below
error.

We have been experiencing an error while configuring the odoo(odoo 11.0)
application to the postgres(postgres 10.5) database. We have done the
configuration in two approaches.

First Approach:

All the objects in the database 'abc' are defined in the "public" schema. In
this approach, the application is configured successfully without errors.

Second Approach:

The objects in the database "abc" are moved to custom schema named "xyz".
Then we're facing this error "2018-11-28 10:40:01,906 9672 CRITICAL ?
odoo.service.server: Failed to initialize database `abc`" . In detail it is
throwing the error "relation ir_%%  exists".

Please help us to cope up with this error.

Looking forward to hear from you. Thanks in Advance!.



Regards,

Pavan



--
Sent from: http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html

Reply | Threaded
Open this post in threaded view
|

Re: 2018-11-28 10:40:01,906 9672 CRITICAL ? odoo.service.server: Failed to initialize database `abc`

Adrian Klaver-4
On 11/28/18 7:16 AM, pavan95 wrote:

> Hello Community,
>
> Anyone has configured odoo with postgres? Please guide me with the below
> error.
>
> We have been experiencing an error while configuring the odoo(odoo 11.0)
> application to the postgres(postgres 10.5) database. We have done the
> configuration in two approaches.
>
> First Approach:
>
> All the objects in the database 'abc' are defined in the "public" schema. In
> this approach, the application is configured successfully without errors.
>
> Second Approach:
>
> The objects in the database "abc" are moved to custom schema named "xyz".
> Then we're facing this error "2018-11-28 10:40:01,906 9672 CRITICAL ?
> odoo.service.server: Failed to initialize database `abc`" . In detail it is
> throwing the error "relation ir_%%  exists".
>
> Please help us to cope up with this error.

At a guess the ORM is configured to look in public.*

To find out if there is a way to change this I would suggest the Odoo forum:

https://www.odoo.com/forum/help-1

>
> Looking forward to hear from you. Thanks in Advance!.
>
>
>
> Regards,
>
> Pavan
>
>
>
> --
> Sent from: http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html
>
>


--
Adrian Klaver
[hidden email]

Reply | Threaded
Open this post in threaded view
|

Re: 2018-11-28 10:40:01,906 9672 CRITICAL ? odoo.service.server: Failed to initialize database `abc`

Andreas Kretschmer-3
In reply to this post by pavan95


Am 28.11.2018 um 16:16 schrieb pavan95:
> The objects in the database "abc" are moved to custom schema named "xyz".
> Then we're facing this error "2018-11-28 10:40:01,906 9672 CRITICAL ?
> odoo.service.server: Failed to initialize database `abc`" . In detail it is
> throwing the error "relation ir_%%  exists".

have you checked if this relation exists? Have you set search_path to
xyz instead of the default public?


Regards, Andreas

--
2ndQuadrant - The PostgreSQL Support Company.
www.2ndQuadrant.com