Forums (Obsolete)

Member

laurence-ecentricarts - 3/27/2013 4:29:26 PM

On-line Marketing Top 10 reports missing in site upgraded from 5.5R2

Compared to a fresh install of Kentico 6, a site upgraded from 5.5 R2 is missing many of the reports in On-line marketing.

My question: how can I get the full set of report types in the upgraded site that are available in a fresh Kentico 6 site?

Details are below.

The site license is Ultimate for both the upgraded site and the fresh Kentico 6 Corporate site. When I navigate to CMS Desk > On-line marketing, the page shows 5 widgets.
* Number of visits - last 30 days
* Campaign hits - last 30 days
* Conversions value - last 30 days
* Top 10 landing pages - last 30 days
* Top 10 exit pages - last 30 days

The first 3 are OK in both sites, showing graphs in the Analytics Chart Viewer widget.

The last 2 are broken in the upgraded site. They are Analytics table viewer widgets and show this error text:

[ReportTable.ascx] Error loading the data: Object reference not set to an instance of an object.

The widget properties dialog shows the reason: No Table is selected in the dropdown under Table properties.

When I compare to a fresh Kentico 6 Corporate site, those widgets are set to use the "TOP 10 pages" report with different parameters. That report is NOT available in the site upgraded from Kentico 5.5 R2.

When I explore that "Table" dropdown, the fresh Kentico 6 Corporate site has 246 items to select. The upgraded site has only 68 items.

Somehow, when upgraded from Kentico 5.5 R2, the site did not have the full set of Kentico 6 items added.

The database tables are "Reporting_Reports", "Reporting_ReportCategories", etc.

Please advise: how can I add all the missing types of reports (tables, graphs etc.) to the site which was upgraded from Kentico 5.5 R2?


Kentico Customer Success	kentico_martind2 - 3/30/2013 12:39:59 PM RE:On-line Marketing Top 10 reports missing in site upgraded from 5.5R2 Hello Laurence, as first.. could you please apply the latest hotfix for v6? A similar bug was alredy fixed in that version. Let me know if that helps. Best regards, Martin Danko


Member	laurence-ecentricarts - 4/2/2013 12:21:26 PM RE:On-line Marketing Top 10 reports missing in site upgraded from 5.5R2 Hi, Martin. The site is already hotfixed to 6.0.58 SP1 - the highest / final version. Would re-running the SQL script from one of the earlier hotfixes create the missing report definitions in the database? If so, which script from which hotfix? Thanks, Laurence

Kentico Support

kentico_jurajo - 4/2/2013 3:08:55 PM

RE:On-line Marketing Top 10 reports missing in site upgraded from 5.5R2

Hi,

The SQL script is cumulative - so it covers all the previous scripts. IT is very strange it did not helped in your case.

If possible, I would use the "New site wizard" option in Site Manager and import the sample Corporate site - this should import also given objects to the db/refresh the DB entries.

If not possible, I would e.g. install a fresh copy of version 7, exported given reports and objects and import them into your site.

Another way is to try to re-create them manually - in the past, I had to re-create just one of them, according to the fresh installation (the same code name, etc.) and then it got refreshed and all other appeared in the UI.

Best regards,
Juraj Ondrus


Member	laurence-ecentricarts - 4/2/2013 3:17:13 PM RE:On-line Marketing Top 10 reports missing in site upgraded from 5.5R2 I think exporting the reports etc. from a fresh Kentico Corporate site install and importing to the customer's site is probably the easiest. Thanks, Juraj. Cheers, Laurence