Advance Reporting Subscription not enabled

[chetan037]

I have configured the advanced reporting on the Magento website (community version 2.3.2). after 3-4 days status is showing pending.

I have configured all the things and reauthorize the Integration user but the user is still in reauthorizing mode.

Anyone, please guide how Advanced reporting will work.

Please its urgent to me Thanks

[Meetanshi]

Hello @chetan037 

Please follow the guide https://docs.magento.com/m2/ce/user_guide/reports/advanced-reporting.html

If you are still getting the issue, please check the Magento log and PHP log.

Further, if you are still having the issue, please contact Advanced Reporting.

Hope it helps.

[Sunil Patel]

Hello @chetan037 

you can use below step for this

1) run below query
delete from flag where flag_code='analytics_previous_base_url'; 
2) Go to 
 Store >> Configuration  >> General >> Advanced Reporting 
https://www.screencast.com/t/YEQbaKv9Gh first disabled and do enabled again.

3) 
Go to
Store >> Configuration >> Main Website >> General >> Web >> Base URL & Secure Base URL  (make sure admin url and default website url same)
Store >> Configuration >> Default Config >> General >> Web >> Base URL & Secure Base URL(make sure admin url and default website url same)

4) go to admin System >> Integration 
https://www.screencast.com/t/L8GrKS5L 

5) you need to click reauthorization on Magento Analytics user  
do reauthorization again for analytics use 

6) then do a cache flush 
php bin/magento c:f config 

7) n98-magerun2 sys:cron:run analytics_subscribe 
run above command to create account https://dashboard.rjmetrics.com/ 
check system.log file
for me giving below error
report.WARNING: Subscription for MBI service has been failed. An error occurred during token exchange: {"message":"Handshake request failed

So i find ip of MBI and added into whitelist IP

 how to find IP :
go to /log/access.log and search integration/tokensDialog  from that row you will find IP address

8) n98-magerun2 sys:cron:run analytics_update 

9) n98-magerun2 sys:cron:run analytics_collect_data 

My actual answer :- https://magento.stackexchange.com/questions/273162/magento2-3-advance-reporting-shows-404/273605#273...

hope it will help you.

if works then mark as a solution

[chetan037]

@Sunil Patel 

Thanks so much for your reply.

I have checked your answer and checked the database table "flag". I didn't find such flag code as you mentioned. please see attached screenshot

[Sunil Patel]

Hello @chetan037 

Then no issue go ahead with other step.

If works then mark as solution

[hfbustilloecaa]

Delete your actual integration user and create a new with the name “Magento Analytics” with the email and password the the user profile of your admin bagento backend.

Select API-Analytics and save . Do magento flush and reauthorize user just created.

Then go to terminal and do cd public_html

do the 3 following statements:

./n98-magerun2.phar sys:cron:run analytics_subscribe

./n98-magerun2.phar sys:cron:run analytics_update

/n98-magerun2.phar sys:cron:run analytics_collect_data

do magento flush again

Advanced reporting should work now

[hfbustilloecaa]

Delete your actual integration user and create a new with the name “Magento Analytics” with the email and password the the user profile of your admin bagento backend.

Select API-Analytics and save . Do magento flush and reauthorize user just created.

Then go to terminal and do cd public_html

do the 3 following statements:

./n98-magerun2.phar sys:cron:run analytics_subscribe

./n98-magerun2.phar sys:cron:run analytics_update

/n98-magerun2.phar sys:cron:run analytics_collect_data

do magento flush again

Advanced reporting should work now

[PuraVida]

We do not have any Magento Analytics User in System-Extensions-Integrations. 
When is this API user created? After enabling the advanced reporting?