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.
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
- Find the MEMBER_ID value for the E-site store from the STOREENT table in the database of the authoring environment.
- 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. - 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);
- Restart the transaction server in the LIVE environment.