Why are we getting "ERROR: column t0.min_recurring_amount does not exist" when navigating through Monetization options ?

We have on boarded the Monetization on our Private Cloud setup. But we are seeing the following error when navigating through the Monetization tabs.

Server Error. 
ERROR: column t0.min_recurring_amount does not exist {prepstmnt 1474265504 SELECT t0.ID, t0.CREATED, t0.CREATED_BY, t0.UPDATED, t0.UPDATED_BY, t0.CREDIT_LIMIT, t0.DESCRIPTION, t0.DISPLAY_NAME, t0.MIN_RECURRING_AMOUNT, t0.MIN_TOPUP_AMOUNT, t0.NAME, t2.ID, t2.CREATED, t2.CREATED_BY, t2.UPDATED, t2.UPDATED_BY, t2.APPROVE_TRUSTED, t2.APPROVE_UNTRUSTED, t2.BILLING_CYCLE_TYPE, t2.COUNTRY, t2.CURRENCY, t2.DESCRIPTION, t2.IS_GROUP_ORG, t2.HAS_BILLING_ADJUSTMENT, t2.HAS_BROKER, t2.HAS_SELF_BILLING, t2.HAS_SEPARATE_INV_FOR_PROD, t2.ISSUE_NETTING_STMT, t2.LOGO_URL, t2.NAME, t2.NET_PAYMENT_ADVICE_NOTE, t2.NETTING_STMT_PER_CURRENCY, t2.ORG_TYPE, t3.ID, t3.CREATED, t3.CREATED_BY, t3.UPDATED, t3.UPDATED_BY, t3.APPROVE_TRUSTED, t3.APPROVE_UNTRUSTED, t3.BILLING_CYCLE_TYPE, t3.COUNTRY, t3.CURRENCY, t3.DESCRIPTION, t3.IS_GROUP_ORG, t3.HAS_BILLING_ADJUSTMENT, t3.HAS_BROKER, t3.HAS_SELF_BILLING, t3.HAS_SEPARATE_INV_FOR_PROD, t3.ISSUE_NETTING_STMT, t3.LOGO_URL, t3.NAME, t3.NET_PAYMENT_ADVICE_NOTE, t3.NETTING_STMT_PER_CURRENCY, t3.ORG_TYPE, t3.REG_NO, t3.HAS_SELF_BILLING_AS_EXCH_ORG, t3.SELF_BILLING_FOR_ALL_DEV, t3.IS_SEPARATE_INV_FOR_FEES, t3.STATUS, t3.SUPPORTED_BILLING_TYPE, t3.TAX_ENGINE_EXTERNAL_ID, t3.TAX_MODEL, t3.TAX_NEXUS, t3.TAX_REG_NO, t3.TIMEZONE, t3.TXN_RELAY_URL, t2.REG_NO, t2.HAS_SELF_BILLING_AS_EXCH_ORG, t2.SELF_BILLING_FOR_ALL_DEV, t2.IS_SEPARATE_INV_FOR_FEES, t2.STATUS, t2.SUPPORTED_BILLING_TYPE, t2.TAX_ENGINE_EXTERNAL_ID, t2.TAX_MODEL, t2.TAX_NEXUS, t2.TAX_REG_NO, t2.TIMEZONE, t2.TXN_RELAY_URL, t0.REPLENISH_AMOUNT, t0.STATUS, t0.IS_VIRTUAL_CURRENCY FROM SUPPORTED_CURRENCY t0 INNER JOIN ORGANIZATION t1 ON t0.ORG_ID = t1.ID LEFT OUTER JOIN ORGANIZATION t2 ON t0.ORG_ID = t2.ID LEFT OUTER JOIN ORGANIZATION t3 ON t2.PARENT_ID = t3.ID WHERE (t0.ORG_ID = ?) ORDER BY t0.UPDATED DESC LIMIT ? } [code=0, state=42703] 

Can you please check if we have missed anything at our end ?

0 5 169
5 REPLIES 5

The error indicates that the column ""SUPPORTED_CURRENCY"" is missing in the "SUPPORTED_CURRENCY" table. Add the column "SUPPORTED_CURRENCY" to the Postgres database table "SUPPORTED_CURRENCY" using the below command to resolve the issue

ALTER TABLE SUPPORTED_CURRENCY ADD COLUMN MIN_RECURRING_AMOUNT DECIMAL(14, 4); 

Looks like the upgrade/setup was not done properly. This answer does not take care about bigger problem

What version of monetization have you installed ? If you had done private cloud upgrade then you will also have to upgrade monetization postgres server as well.

Basically you will run "apigee-setup -p mo" on postgres server, then you dont need to execute explicit query to fix this. It is recommended to follow go through apigee-setup

@rajanish@apigee.com,

Thanks for your suggestion. Monetization version is 1.0.626-150708_03-90.

was that the fresh install of 1.0.626-150708_03-90?