Wednesday, August 20, 2008

ERR_BASIC_RATEPLAN error

The company just offered a new plan to customers and a new rateplan was created for this offer. However, after the plan was saved and the pipeline restarted, the pipeline crashed and has the following error in its log: ERR_BASIC_RATEPLAN

It turned out that the 'Basic' checkbox shows up as checked when you first open the Pricing Center Pipeline Toolbox. As it is checked, you tend to leave it as it is. But if you check in the database, it is not set. This could be a bug in the Pricing Center interface that has something to do with the locale as some of the other guys do not have this problem.

To verify if 'Basic' is set in the database, check the ifw_rateplan table given the rateplan name. Then, with the result of this query, check ifw_rateplan_ver and look at the 'Basic' field. It should be set to 1. If it is not set to 1, then open the pipeline toolbox and modify the created rateplan. Manually check/uncheck/check the checkbox and save the changes. Verify the result in the database. The pipeline should come up now.

No comments: