Deleting Partners

Asked by FlxStuJha

Hey guys, I keep on getting this error

null value in column "partner_id" violates not-null constraint
CONTEXT: SQL statement "UPDATE ONLY "public"."res_company" SET "partner_id" = NULL WHERE $1 OPERATOR(pg_catalog.=) "partner_id""

When I try to delete standard partner tiny sprl from my partner list.
I hope you guys know more about this problem, and may have already fixed it. There are no cases linked to this partner, and I can't remove it from the partner categories linked to it either. When I choose all categories, and select "-", then save the project, it'll show them in the list again after I saved it. Also, it keeps on kicking up the amount of directories, while showing only two.
" << First < Previous [1 - 5 of 257] Next > Last >> " While it still only shows two as it should.

It's really annoying because I need Tiny to leave my list (Because we're going to set up a helpdesk using OpenERP, and possibly support it to other companies).

Question information

Language:
English Edit question
Status:
Answered
For:
Odoo Server (MOVED TO GITHUB) Edit question
Assignee:
No assignee Edit question
Last query:
Last reply:

This question was originally filed as bug #546026.

Revision history for this message
Parthiv Patel (parthiv-patel-deactivatedaccount) said :
#1

Hi,

As TINY SPRL is the first partner or the "company partner" which you have
set while doing setup, It has references in company as well. You should try
to set another partner in COMPANY form to resolve this. Hope this will help.

Regards,
Parthiv

On Wed, Mar 24, 2010 at 7:31 PM, FlxStuJha <email address hidden>wrote:

> Public bug reported:
>
> Hey guys, I keep on getting this error
>
>
> null value in column "partner_id" violates not-null constraint
> CONTEXT: SQL statement "UPDATE ONLY "public"."res_company" SET "partner_id"
> = NULL WHERE $1 OPERATOR(pg_catalog.=) "partner_id""
>
>
> When I try to delete standard partner tiny sprl from my partner list.
> I hope you guys know more about this problem, and may have already fixed
> it. There are no cases linked to this partner, and I can't remove it from
> the partner categories linked to it either. When I choose all categories,
> and select "-", then save the project, it'll show them in the list again
> after I saved it. Also, it keeps on kicking up the amount of directories,
> while showing only two.
> " << First < Previous [1 - 5 of 257] Next > Last >> " While it
> still only shows two as it should.
>
> It's really annoying because I need Tiny to leave my list (Because we're
> going to set up a helpdesk using OpenERP, and possibly support it to
> other companies).
>
> ** Affects: account-banking
> Importance: Undecided
> Status: New
>
> --
> Deleting Partners
> https://bugs.launchpad.net/bugs/546026
> You received this bug notification because you are subscribed to
> OpenObject.
>
> Status in Account Banking Framework: New
>
> Bug description:
> Hey guys, I keep on getting this error
>
>
> null value in column "partner_id" violates not-null constraint
> CONTEXT: SQL statement "UPDATE ONLY "public"."res_company" SET "partner_id"
> = NULL WHERE $1 OPERATOR(pg_catalog.=) "partner_id""
>
>
> When I try to delete standard partner tiny sprl from my partner list.
> I hope you guys know more about this problem, and may have already fixed
> it. There are no cases linked to this partner, and I can't remove it from
> the partner categories linked to it either. When I choose all categories,
> and select "-", then save the project, it'll show them in the list again
> after I saved it. Also, it keeps on kicking up the amount of directories,
> while showing only two.
> " << First < Previous [1 - 5 of 257] Next > Last >> " While it
> still only shows two as it should.
>
> It's really annoying because I need Tiny to leave my list (Because we're
> going to set up a helpdesk using OpenERP, and possibly support it to other
> companies).
>
>
>

--
Thanks & Regards,
Parthiv Patel

Revision history for this message
Jay Vora (Serpent Consulting Services) (jayvora) said :
#2

Hello Jeff,

Kindly have some patience. This is the messages caused by the AVAILABLE link to main company.

As Said by Parthiv, you need to remove the partner ref. from company.

We will improve the integrity error messages by the next version.
Hope this helps.

Thanks.

Can you help with this problem?

Provide an answer of your own, or ask FlxStuJha for more information if necessary.

To post a message you must log in.