Organization User doesn't get assigned to default Account Plan

Document ID : KB000008610
Last Modified Date : 14/02/2018
Show Technical Document Details
Issue:

When creating an "Organization" manually or creating a user with "registeredUser" or "orgAdmin" roles, the user isn't assigned to a default account plan (Bronze Account Plan).

Notice the query output from lrs DB on portal:

mysql> select o.orgid, o.name, op.propertyname, op.propertyValue from cmsorganization o left outer join cmsorganizationproperties op on op.orgid = o.orgid and op.propertyname='accountplan' order by orgid;

+-------+----------------+--------------+-------------------------------------------+

| orgid   | name              | propertyname| propertyValue                                         |

+-------+----------------+--------------+-------------------------------------------+

|    78 | developer1_org | AccountPlan  | //localhost:37080/CMS/Repository/lrs-2812 |

|    79 | developer3_org | AccountPlan  | //localhost:37080/CMS/Repository/lrs-2812 |

|    80 | test_mauallyCreatedOrg | NULL         | NULL                                               |

|    81 | test_org       | AccountPlan  | //localhost:37080/CMS/Repository/lrs-2812     |

+-------+----------------+--------------+-------------------------------------------+

"test_mauallyCreatedOrg"' doesn't have values for "propertyname" or "propertyValue"

The accepted values come from lrs.cmsorganizationproperties table.

If the "cmsorganization" table doesn't have a record of an organization, it will not be assigned to an account plan.

In the above database query, we see below we are missing values for record ID of 80 

Example Contents of the cmsorganizationproperties table:

mysql> select * from cmsorganizationproperties\G;

*************************** 1. row ***************************

        orgid: 78

propertyValue: //localhost:37080/CMS/Repository/lrs-2812

 propertyName: AccountPlan

 

*************************** 3. row ***************************

        orgid: 79

propertyValue: //localhost:37080/CMS/Repository/lrs-2812

 propertyName: AccountPlan

*************************** 4. row ***************************

        orgid: 81

propertyValue: //localhost:37080/CMS/Repository/lrs-2812

 propertyName: AccountPlan

*************************** 5. row ***************************

       

 

 

Environment:
Api Portal 3.5
Resolution:

In order to have an organization automatically assigned to a default account plan, we need to create a registered user via portal, Sign Up (register) page.

Another option is to manually add additional record into a DB but we usually do not recommend editing the DB since it can cause issues.

Continuing with the example from earlier:

 from cmsorganizationproperties;

+-------+-------------------------------------------+--------------+

| orgid   | propertyValue                                     | propertyName |

+-------+-------------------------------------------+--------------+

|    78 | //localhost:37080/CMS/Repository/lrs-2812 | AccountPlan  |

|    79 | //localhost:37080/CMS/Repository/lrs-2812 | AccountPlan  |

|    80 | //localhost:37080/CMS/Repository/lrs-2812 | AccountPlan  |

|    81 | //localhost:37080/CMS/Repository/lrs-2812 | AccountPlan  |

 

Have it in mind,  please take a backup before any changes, and be ready to revert changes in case of an issue or restore DB in case reverted change don't work.