Adxstudio Portals Retail Portal - Import error: Create: adx_review:

Installation Progress

Adxstudio Portals Retail Portal  Import error: Create: adx_review: e4670f15-809d-e211-be82-00261883c555

There was an error during import.
Unexpected exception from plug-in (Execute): Adxstudio.Xrm.Plugins.Products.ProductReviewsAggregationPlugin: System.Security.SecurityException: Request for the permission of type 'System.Security.Permissions.SecurityPermission, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.

Faced this error during ADX retail portal deployment on on-premise CRM instance. This is a known issue in CRM 2016 that is related to installing everything on one box. The update rollup that is in preview will fix this, otherwise you can try to change your required assembly mode from sandbox to none.You can also see what isolation mode of a plugin if you open the Plugin Registration Tool.

1. open the Plugin Registration tool
2. connect to CRM instance
3. Right click on an Assembly and choose update
4. Now see the Isolation mode

https://crmbusiness.wordpress.com/2015/02/05/understanding-plugin-sandbox-mode/

https://crmbusiness.wordpress.com/2014/11/12/crm-20112013-common-plugin-errors-and-isolation-mode/
https://community.adxstudio.com/bugs/adxstudio-portals/crm-2016-retail-portal-not-working

Adxstudio Portals Retail Portal - Import error: Create: adx_review:

Installation Progress

Adxstudio Portals Retail Portal  Import error: Create: adx_review: e4670f15-809d-e211-be82-00261883c555

There was an error during import.
Unexpected exception from plug-in (Execute): Adxstudio.Xrm.Plugins.Products.ProductReviewsAggregationPlugin: System.Security.SecurityException: Request for the permission of type 'System.Security.Permissions.SecurityPermission, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.

Faced this error during ADX retail portal deployment on on-premise CRM instance. This is a known issue in CRM 2016 that is related to installing everything on one box. The update rollup that is in preview will fix this, otherwise you can try to change your required assembly mode from sandbox to none.You can also see what isolation mode of a plugin if you open the Plugin Registration Tool.

1. open the Plugin Registration tool
2. connect to CRM instance
3. Right click on an Assembly and choose update
4. Now see the Isolation mode

https://crmbusiness.wordpress.com/2015/02/05/understanding-plugin-sandbox-mode/

https://crmbusiness.wordpress.com/2014/11/12/crm-20112013-common-plugin-errors-and-isolation-mode/
https://community.adxstudio.com/bugs/adxstudio-portals/crm-2016-retail-portal-not-working

HTTP Error 500.0 - Internal Server Error - Calling LoadLibraryEx on ISAPI filter "C:\Program Files\Microsoft Dynamics CRM\Server\bin\DefaultAddonFilter.dll" failed

HTTP Error 500.0 - Internal Server Error

Calling LoadLibraryEx on ISAPI filter "C:\Program Files\Microsoft Dynamics CRM\Server\bin\DefaultAddonFilter.dll" failed

Faced this error in CRM website and found that  "Microsoft Visual C++ 2013 Redistributable(x64)" was missing or required latest version.. Downloaded latest from Microsoft download website at url

http://www.microsoft.com/en-gb/download/details.aspx?id=40784 and installed it.It resolved my issue onspot.

 

 

Non-interactive users in Dynamics CRM Online

A non-interactive user is a user account in Microsoft Dynamics CRM Online that will only be used for programmatic access to CRM (using the web services layer) such as as for integration with an ERP system or other LOB systems. A non-interactive user can not use the user interface. You can create up to  5 free non-interactive user accounts in Dynamics CRM Online.
The benefit of doing so is that non-interactive users do not require a license. Go to Settings>Security>Users – on the Administration tab, you will see the Access mode for a specific user – in Dynamics CRM Online you will see the 3 different types of access modes.

Non-interactive users are apparently something specific for Dynamics CRM Online – if you open the same screen in Dynamics CRM 2015 – you don’t see the non-interactive access mode option.

https://community.dynamics.com/crm/b/innovatingoncrm/archive/2014/09/25/crm-online-non-interactive-user

SQL Server Reporting Services is not compatible with Internet Explorer 11- Resolved

 

When I was running SQL Server 2008 R2. All these reports were working fine until we upgraded IE from 10 to 11. Every time we run a report, it will just stuck at loading forever

The following instructions implement the Chrome fix and IE11 fix into an unmodified ReportingServices.js on the Reporting server.
1)    Create a backup copy of ReportingServices.js (C:\Program Files\Microsoft SQL Server\MSRS11.MSSQLSERVER\Reporting Services\ReportManager\js)
2)    Edit ReportingServices.js Find the fixChrome function. Rename the fixChrome function to pageLoad. This causes the function to get called each time the page changes and is required to make the chrome fix actually work.
3)    Modify the pageLoad function to the following

function pageLoad()
{
    var i, el = document.getElementById("ctl32_ctl09"),
        navBar = document.getElementById('ctl32_ctl05'),
        navBarTables = navBar.getElementsByTagName('table'),
        navBarTable;

    //Fix Chrome invisible report
    if (el)
        el.style.overflow = "visible";

    //Fix IE11 Navigation Bar over multiple rows
    for (i = 0; i < navBarTables.length; i++)
    {
        navBarTable = navBarTables[i];
        if (!!navBarTable.className.match(/WidgetSetSpacer/) || !!navBarTable.className.match(/WidgetShortSpacer/))
        {
            navBarTable.style.Display = '';
        }
    }
}

Use below url or more detail..

https://connect.microsoft.com/SQLServer/feedback/details/810527/sql-server-reporting-services-is-not-compatible-with-internet-explorer-11

SSRS Summery data export issue

 

The user has requested to include the summary record in the report but to exclude the additional columns that have been appended to the data records. The other limitation they have imposed is that no other textboxes appear in the .csv file export. They only want to see the detail records with one header record at the top. The report needs to be exported as a .csv file because it exceeds the number of records which Excel can handle.

So far my research has reminded me that exporting a .csv file from SSRS exports only the data and strips out all formatting, therefore, the summary data is associated with each data record.

Here is the solution for this.

For each data element you want to exclude:

1. Open the properties menu for the TextBox with F4

2. Set the DataElementOutput property to NoOutput

   

 

SRS 2008 report which has 3 column groups which when i export to Excel the resulting excel spreadsheet has an additional total column for each of the groups.  I dont have this displayed in the report and dont want it displayed in teh excel export, is there anyway to turn this off?

SSRS 2008 report which has 3 column groups which when i export to Excel the resulting excel spreadsheet has an additional total column for each of the groups.Below is the trick for overcome this issue.

If you are running SSRS 2008 R2, you can set the total columns / cells ' visibility to =(Globals!RenderFormat.Name ="Excel") to hide them when exporting to Excel.

Following url has more in formation about rendering formats.

http://blogs.msdn.com/b/robertbruckner/archive/2010/05/02/globals-renderformat-aka-renderer-dependent-report-layout.aspx

Clear Analysis Services database cache

How to clear cache of a cube

<ClearCache xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">
<Object>
<DatabaseID>Adventure Works DW</DatabaseID>
<CubeID>Adventure Works DW</CubeID>
</Object>
</ClearCache>

How to clear cache of a Database

<ClearCache xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">
<Object>
<DatabaseID>Adventure Works DW</DatabaseID>
</Object>
</ClearCache>