Question
Capgemini America INC.
US
Last activity: 12 Jun 2018 9:11 EDT
Unable to launch 'AutoLoan' Microsite that is included in the sample Customer Relationship Management application within Pega Marketing for Financial Services
i have installed the complete PMFS stack along with the sample CRM application. As we know, within this sample CRM application, a sample Auto Loan microsite functionality has been configured to provide prequalified Auto loan offers to anonymous visitors and customers.
i am not able to open the microsite even after updating the MicrosoteURL DSS. secondly, i am not able to log into the sample CRM application as none of the available operators within the given sample AGs are accessible.
Can someone help wrt what i might be missing?
Accepted Solution
Pegasystems Inc.
IN
Hi Sauvik,
You need to remove the Admin and Read-only user credentials from the ExternalMktData DB record.
After this import the sampledata and it will get imported successfully.
Regards,
Vikash
Capgemini America INC.
US
Hi, after doing further research I was able to figure out that PegaCRM_Marketing 07.31 application which is one of the built on for PegaMarketingFS_CRMSample • 07.31 is basically missing from the stack. please see the screenshot attached. if i try to click and open the app, it is opening a new form rather than the app itself. that is the reason, i am not able to use any of the operators AGs to log into PegaMarketingFS_CRMSample • 07.31. moreover, as this PegaCRM_Marketing 07.31 is not there, the MS is not opening despite having the ms.war properly installed.
can you please suggest/help as to what is the best and quickest way to get the PegaCRM_Marketing 07.31 app and any other app that it is built on with.
Pegasystems Inc.
US
Glad to hear that you figured out what you were missing. The PegaCRM_Marketing 07.31 application is a sample marketing application shipped in the CRM media file "PegaCRM_7.31.zip". You can find it in Resource Kit folder with the name "PegaCRMMarketingSample.zip".
In order to install this, you need to have to first run from the SampleDB folder PegaCRMSample_DDL.jar and PegaCRMSample_DMLjar.
Capgemini America INC.
US
Hi,
Thank you so much, that was really helpful . my team did try to follow the steps and successfully imported the DDL and DML file. the server was also restarted. however, while importing PegaCRMMarketingSample.zip, it is throwing the following error.
[5/4/2018 12:55 AM] Behura, Smruti:
Encountered an issue applying DDL: GRANT SELECT on EXTERNALMKTDATA.CRM_VW_CAMPAIGN_ORGANIZATION to EXTERNALMKTDATA : Database-General Problem executing SQL to update database schema 1720 42000 ORA-01720: grant option does not exist for 'PEGA731DATA.CRM_INDEX_ADDRESS' DatabaseException caused by prior exception: java.sql.SQLSyntaxErrorException: ORA-01720: grant option does not exist for 'PEGA731DATA.CRM_INDEX_ADDRESS' | SQL Code: 1720 | SQL State: 42000 -- See the log for additional information.
can you please let me know what my team is missing?
Capgemini America INC.
US
Hi Harvey, it would be really great if you can help me with the issue i have mentioned above. i am quite stuck at this point.
Pegasystems Inc.
US
Hi
Encountered an issue applying DDL: GRANT SELECT on EXTERNALMKTDATA.CRM_VW_CAMPAIGN_ORGANIZATION to EXTERNALMKTDATA : Database-General Problem executing SQL to update database schema 1720 42000 ORA-01720: grant option does not exist for 'PEGA731DATA.CRM_INDEX_ADDRESS' DatabaseException caused by prior exception: java.sql.SQLSyntaxErrorException: ORA-01720: grant option does not exist for 'PEGA731DATA.CRM_INDEX_ADDRESS' | SQL Code: 1720 | SQL State: 42000 -- See the log for additional information.
Can you confirm that the table 'PEGA731DATA.CRM_INDEX_ADDRESS' exists in your system? If the table exists, check who the owner of the table is. Most likely, you are trying to runt he grant command using the externalmktdata user who is not the owner of the crm_index_address table and so does not have privilege to grant access to the table.
You will need to give the grant access to the user.
Capgemini America INC.
US
I was actually using the externalmktdata to provide the grant. as far as i remember, owner of crm_index_address is pegadata, but i will recheck.
when you say, i need to give the grant access to the user, who that user is? can you please specify?
You have been a great help so far, i am sure i am only a little away from getting it done successfully.
Pegasystems Inc.
US
You need to give the externalmktdata user the grant privilege. pegadata has the grant privilege already since its the table owner, but your script is executed as externalmktdata and so that user will need the privilege.
Capgemini America INC.
US
Hi Hervey,
We already tried that. From pegadata we gave grant to externalmktdata then we gave the externalmktdata.view grant to pegadata. please see the screenshot attached. It shows grant succeeded for crmindexaddress but shows error for the view grant.
Pegasystems Inc.
US
Your grant succeeded. Now it is complaining about a different table. It is now complaining about Pega731Data.SAPLUS_WORK_ORG. Do the same for this table as your did for the previous one.
Capgemini America INC.
US
Hi Hervey,
We already did this step as well. The team did write the query again, grant is succeeded for the saplus_work_org, but giving the same error when they are trying to give grant for the main issue
Screenshot attached.. appreciate your help to resolve the matter.
Pegasystems Inc.
US
Also can you log into Pega and make sure that the ExternalMKTDATA database rule that the advanced tab has PegaDATA added to the list of other databases that should be reachable by views in this database?
Capgemini America INC.
US
Checked the Database ExternalMKTData and it does have the PegaData added in the advanced tab. for the other part, i have asked my team to provide the grant properly to Pega731Data.SAPLUS_WORK_ORG. I will let you know the result tomorrow morning.
Pegasystems Inc.
US
Try the following:
Change the owner of CRM_VW_CAMPAIGN_ORGANIZATION to PEGA731DATA. Run the grant script. Then change the owner back to EXTERNALMKTDATA.
Capgemini America INC.
US
Team checked for owner change queries, but it seems changing owner is risky, most of the queries regarding owner change is giving some sort of complexity later,This might damage the instance. Is it possible for you to please provide the owner change query that you recommend to use for oracle DB?
Pegasystems Inc.
US
If you are on Oracle DB, then we will need to change the approach. Your team is right that they should not manually change the table owners.
Please try the following:
1. Log in to the DB as PEGA731DATA.
2. Run: GRANT SELECT ON PEGA731DATA.SAFS_WORK_ORG TO EXTERNALMKTDATA
3. Log out and log into the DB with EXTERNALMKTDATA
4. Run: GRANT SELECT ON EXTERNALMKTDATA.CRM_VM_CAMPAIGN_ORGANIZATION TO PEGA731DATA
Can you also provide me the ddl for EXTERNALMKTDATA.CRM_VM_CAMPAIGN_ORGANIZATION?
Thanks.
Capgemini America INC.
US
Team did log in as pega731data and executed the following commands in SQL developer, the grant action succeeded
then, they logged in as externalmktdata on command prompt but the second query shows a result that the table or view does not exist.
Below is the screenshot.
I will be sending you the ddl as requested shortly
Pegasystems Inc.
US
Based on this DDL, what you need is the following:
1. Log in to the DB as PEGA731DATA.
2. Run: GRANT SELECT ON PEGA731DATA.SAFS_WORK_ORG TO EXTERNALMKTDATA; (DONE)
3. Run: GRANT SELECT ON PEGA731DATA.CRM_INDEX_ADDRESS TO EXTERNALMKTDATA;
3. Log out and log into the DB with EXTERNALMKTDATA
4. Run the DDL to CREATE OR REPLACE FORCE VIEW "EXTERNALMKTDATA"."CRM_VW_CAMPAIGN_ORGANIZATION"...
4. Run: GRANT SELECT ON EXTERNALMKTDATA.CRM_VM_CAMPAIGN_ORGANIZATION TO PEGA731DATA;
Capgemini America INC.
US
Hervey,
We did all the steps, but the error is still there. I have even opened up a SR-C32567, but no response so far.
Pegasystems Inc.
US
It is now just complaining that your table or view does not exist when trying to grant the select on the view. Can you see the view in the DB?
Can you try manually run a commit command before running the grant select?
Capgemini America INC.
US
Hi Hervey,
After create and replace command team can still see the view in the view section, also they did a manual commit re-enteredered the grant query,
The same error is still coming
Accepted Solution
Pegasystems Inc.
IN
Hi Sauvik,
You need to remove the Admin and Read-only user credentials from the ExternalMktData DB record.
After this import the sampledata and it will get imported successfully.
Regards,
Vikash