Focal Point
[SOLVED] Clustered Column Store Index SQL Server 2016

This topic can be found at:
http://forums.informationbuilders.com/eve/forums/a/tpc/f/1381057331/m/6217066686

June 09, 2017, 10:25 AM
Beth (UTA)
[SOLVED] Clustered Column Store Index SQL Server 2016
We are on 8.1.05. Our DBA added some clustered column store indexes to one of our source databases and now I cannot read that data via Data Migrator. Any suggestions?

This message has been edited. Last edited by: FP Mod Chuck,


WebFOCUS 8
Windows, All Outputs
June 09, 2017, 11:35 AM
FP Mod Chuck
Hi Beth

Did you recreate the synonym after the change to the database was made?

Hope all is well with you!


Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats
June 12, 2017, 02:45 PM
Beth (UTA)
We found the problem.
Our DBA worked with IB Tech Support and did the following:
Installed the Native client from SQL 2012 installation Pack:
https://www.microsoft.com/en-u...etails.aspx?id=50402

Apparently, an important driver was missing.


WebFOCUS 8
Windows, All Outputs
June 12, 2017, 02:45 PM
Beth (UTA)
Hi Chuck, hope all is well with you also! Good to hear from you.


WebFOCUS 8
Windows, All Outputs
December 27, 2019, 02:04 PM
johnh
Hi Beth, It's been a couple of years since you posted but maybe you will get this.

On your columnstore issue, were you getting the error about the results being returned in a cursor?

I am having this problem and hope your fix will fix my issue.

Thanks,
John


WebFocus Version 8.13, Windows 2007 Service Pack 2, HTML
December 27, 2019, 02:06 PM
johnh
And Beth, one more question. Was the 'Native client from SQL 2012' installed on your WebFocus Reporting Server?


WebFocus Version 8.13, Windows 2007 Service Pack 2, HTML
January 06, 2020, 10:48 AM
FP Mod Chuck
Johnh

I have not seen Beth on FP for quite a while but I used to be the TAM there. I can't speak to the exact error, but the native client was installed on the reporting server.


Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats