When a CSR tried to display the Plans of the customer in Customer Center, the Plans tab will just display a blank pane. When CM pinlog is checked, the following error showed up:
map_poid_to_table_info("product_t", 5402881) failed, err 4
The strange thing is that the ID in the error above is not the ID of a product, rather it is the ID of a deal in the database.
I asked about the history of BRM in the company regarding products/deals in the database and was told that somebody deleted plans,deals and the account's purchased products in the database a while back. A solution was already implemented to recreate those plans,deals and purchased products, but there were still some related issues cropping up and this was one of them.
The table account_products_t was examined for the accounts that were reported to not display the plans. There were objects in that table that has blank values for the following fields: plan_type and deal_type . This should not be an issue if the plan/deal ID is 0, however, the plan/deal IDs for the records were valid.
The fix was to populate the blank fields. For example, a record has valid deal/plan IDs but blank deal/plan type. These blank fields were just inserted with the values: '/plan' for missing plan type and '/deal' for missing deal type. The plans were now able to display in the Customer Center.
Subscribe to:
Post Comments (Atom)
1 comment:
Hi there!
I am installing BRM and have this show-stopper issue -
In the Customer Center, when I create a consumer or business account, my Primary currency drop-down list is blank, so I am not able to create a customer.
Can you please contact me at krish_mohan at intuit dot com?
Thanks
Krish
Post a Comment