Description of problem: Unexpected error: Couldn't find Organization with ID=1 [WHERE "organizations"."task_id" IS NULL] occurred when failed deletion for the default org 'ACME_Corporation'. Version-Release number of selected component (if applicable): Subscription Asset Manager Version: 1.2.5-1h.el6_3 How reproducible: 100% Steps to Reproduce: 1. Create a user and assign the default Organization 'ACME_Corporation' to it. 2. Delete the default Organization 'ACME_Corporation'. 3. Back to user name list, click on the user name that assigned to the default Organization 'ACME_Corporation' in step 1, click on Environment sub tab. Actual results: 1. After failed deletion for the default org 'ACME_Corporation'. Pops-up the following message and cannot create the org 'ACME_Corporation' again: Organization 'ACME_Corporation' already exists and either has been scheduled for deletion or failed deletion. 2. Unexpected error: Couldn't find Organization with ID=1 [WHERE "organizations"."task_id" IS NULL] occurred when failed deletion for the default org 'ACME_Corporation'. 3. The default org 'ACME_Corporation' failed deletion from the backend db. Only can create the org 'ACME_Corporation' again on the WEB GUI & CLI after deleting the record from db by manual: # LANG=en_US.UTF-8 psql -d katelloschema -U katellouser Password for user katellouser: psql (8.4.13) Type "help" for help. katelloschema-> \dt organizations List of relations Schema | Name | Type | Owner --------+---------------+-------+------------- public | organizations | table | katellouser (1 row) katelloschema=> SELECT * FROM organizations; id | name | description | label | created_at | updated_at | task_id | sy stem_info_keys ----+------------------+-------------------------------+--------------------------- -----------+----------------------------+----------------------------+---------+--- --------------- 8 | test-org-pt | test purpose | test-org-pt | 2012-11-16 09:13:07.483353 | 2012-11-16 09:13:07.483353 | | -- - [] 1 | ACME_Corporation | ACME_Corporation Organization | ACME_Corporation | 2012-11-14 08:57:53.75969 | 2012-11-28 07:15:24.235321 | 73 | -- - [] katelloschema=> DELETE FROM organizations WHERE name='ACME_Corporation'; DELETE 1 Expected results: 1. No scuh unexpected error. 2. The default org 'ACME_Corporation' should be deleted from Web GUI and DB successfully. Additional info:
*** This bug has been marked as a duplicate of bug 881568 ***