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]

The quick fix is to disable the config setting as below, 
/sources/sqlserver/performance/enablePassThruOptimizations

For Oracle - Go to Studio Menu> Administration > Data Sources > Oracle sources> Performance > and set "Enable Pass Thru Optimizations"  = false. By default this set to "true"

For MS SQLServer Sources - Go to Studio Menu> Administration > Data Sources > Oracle sources> Performance > and set "Enable Pass Thru Optimizations"  = false. By default this set to "true"