Question:

When installed server and client separately on different ports. Exported and imported the car file to new server. Everything seems to work fine except for the data sources that are cached.

When cache them into MS SQL db, and tried to use same Status and Tracking tables and also created new ones.

 
However, any data preview of cache refresh does not work.

Below is the error.

Error 
Unable to retrieve result from data source "/shared/SIBP/Data sources/BI/SIBPBI" during query 
execution. Failed query: "SELECT 
[SIBPBI].[dbo].[TDV_cache_status].[status],[SIBPBI].[dbo].[TDV_cache_status].[cachekey],CAST([SIBPBI].[dbo].[TDV_cache_status].[starttime] 
AS DATETIME2),[SIBPBI].[dbo].[TDV_cache_status].[serverid] FROM 
[SIBPBI].[dbo].[TDV_cache_status] WHERE ([SIBPBI].[dbo].[TDV_cache_status].[status] IN 
('P','I','A') AND [SIBPBI].[dbo].[TDV_cache_status].[clusterid] IS NULL AND 
[SIBPBI].[dbo].[TDV_cache_status].[serverid] = 'SIKP0VIBPBI01.poslovno.local-9600-864626559' AND 
[SIBPBI].[dbo].[TDV_cache_status].[resourceid] = '/shared/SIBP/Data/Dimensions/D_Obrati' AND 
[SIBPBI].[dbo].[TDV_cache_status].[parameters] IS NULL)". [data-3923000] 
Cause: 26 [Log ID: 992507cd-9d34-4e27-bf28-a4bc399d4b89]

Fix/Solution:

The quick fix is to disable the config setting in studio > Administration > Configuration

/sources/sqlserver/performance/enablePassThruOptimizations