E-site store does not work in live environment after stagingprop

The E-site store does not work in live environment after the "PTL - not authorized error" for all releases prior to the Management Center for HCL Commerce version 9.1.8.0.

Note: This topic is only applicable for versions prior to Management Center for HCL Commerce version 9.1.8.0.

Problem

A new E-site store does not work in the LIVE environment after stagingprop. The transaction server log displays the following errors:

000001a3 CommerceSrvr E AccManager isAllowed CMN1501E: User -1002 does not have the authority to perform action "GetPageDesign.IBM_Store_Details" on resource "com.ibm.commerce.foundation.server.authorization.policymanager.AccessProfileProtectableProxy" for command "GetPageDesign.IBM_Store_Details".

000001a3 AbstractBaseR E com.ibm.commerce.foundation.rest.resourcehandler.AbstractBaseResourceHandler handleException(String, Exception, String, Locale) CWXFR0200E: The following exception occurred in method getPageDesign(ExpressionType expression, String storeId, String profileName, boolean single): com.ibm.commerce.pagelayout.facade.client.PageDesignException: null: You are not authorized to execute IBM_Store_Details.

Solution

  1. Find the MEMBER_ID value for the E-site store from the STOREENT table in the database of the authoring environment.
  2. Use the MEMBER_ID in the following SQL and run the SQL.
    select * from ACPLGPSUBS where ORGENTITY_ID= <MEMBER_ID>;
    Note: When you run the SQL in the database of the LIVE environment, you will find that the related access control policy data is missing.
  3. Insert the values from step 2 into ACPLGPSUBS table in the database of the LIVE environment, as shown in the following example.
    INSERT INTO ACPLGPSUBS (ACPOLGRP_ID, ORGENTITY_ID, OPTCOUNTER) VALUES (10001, <MEMBER_ID>, 1);
    INSERT INTO ACPLGPSUBS (ACPOLGRP_ID, ORGENTITY_ID, OPTCOUNTER) VALUES (10003, <MEMBER_ID>, 1);
    INSERT INTO ACPLGPSUBS (ACPOLGRP_ID, ORGENTITY_ID, OPTCOUNTER) VALUES (10004, <MEMBER_ID>, 1);
    INSERT INTO ACPLGPSUBS (ACPOLGRP_ID, ORGENTITY_ID, OPTCOUNTER) VALUES (10005, <MEMBER_ID>, 1);
  4. Restart the transaction server in the LIVE environment.