Problem Note 59008: An "Open cursor error..." occurs when using SAS/ACCESS® Interface to OLE DB configured for UTF-8 encoding to query OLAP cubes
 |  |  |  |  |
You encounter a problem when you run the SQL procedure pass-through facility to query a Microsoft SQL Server cube in SAS/ACCESS Interface to OLE DB configured for UTF-8 encoding. Here is an example:
PROC SQL;
CONNECT TO OLEDB (PROVIDER=MSOLAP PROPS=('INITIAL CATALOG'='PPCube1_New' 'DATA SOURCE'='isaprddbsws002.app.vic:49168'
UID='sasgenval' PW=XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX));
CREATE TABLE WORK.PPCube1_SLICE_1 AS
SELECT * FROM CONNECTION TO OLEDB (
MDX:: SELECT NON EMPTY {
[Measures].[Cost] } PROPERTIES MEMBER_CAPTION
ON COLUMNS, NON EMPTY CrossJoin(CrossJoin(CrossJoin({
[S1Org].[S1Org].[S1Org_L7].Members }, {
[S1GrpChart].[S1GrpChart].[S1GrpChart_L7].Members }), {
[Period].[Period].[All].Children }), CrossJoin({
[S3BizSgmt].[S3BizSgmt].[S3BizSgmt_L2].Members }, {
[FCVC].[FCVC].[All].Children })) PROPERTIES MEMBER_CAPTION
ON ROWS
FROM [PPCube1]);
When you run this code, the following error occurs:
ERROR: Open cursor error: WORK pM?
You might also see this error in the log:
****ERROR***** Failed to transcode data
A workaround is to change the session encoding to Wlatin1.
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS/ACCESS Interface to OLE DB | Microsoft® Windows® for x64 | 9.4_M2 | 9.4 TS1M2 | ||
| Microsoft Windows 8 Enterprise 32-bit | 9.4_M2 | 9.4_M5 | 9.4 TS1M2 | 9.4 TS1M5 | ||
| Microsoft Windows 8 Enterprise x64 | 9.4_M2 | 9.4_M5 | 9.4 TS1M2 | 9.4 TS1M5 | ||
| Microsoft Windows 8 Pro 32-bit | 9.4_M2 | 9.4_M5 | 9.4 TS1M2 | 9.4 TS1M5 | ||
| Microsoft Windows 8 Pro x64 | 9.4_M2 | 9.4_M5 | 9.4 TS1M2 | 9.4 TS1M5 | ||
| Microsoft Windows 8.1 Enterprise 32-bit | 9.4_M2 | 9.4_M5 | 9.4 TS1M2 | 9.4 TS1M5 | ||
| Microsoft Windows 8.1 Enterprise x64 | 9.4_M2 | 9.4_M5 | 9.4 TS1M2 | 9.4 TS1M5 | ||
| Microsoft Windows 8.1 Pro 32-bit | 9.4_M2 | 9.4_M5 | 9.4 TS1M2 | 9.4 TS1M5 | ||
| Microsoft Windows 8.1 Pro x64 | 9.4_M2 | 9.4_M5 | 9.4 TS1M2 | 9.4 TS1M5 | ||
| Microsoft Windows 10 | 9.4_M2 | 9.4_M5 | 9.4 TS1M2 | 9.4 TS1M5 | ||
| Microsoft Windows Server 2008 | 9.4_M2 | 9.4 TS1M2 | ||||
| Microsoft Windows Server 2008 R2 | 9.4_M2 | 9.4 TS1M2 | ||||
| Microsoft Windows Server 2008 for x64 | 9.4_M2 | 9.4 TS1M2 | ||||
| Microsoft Windows Server 2012 Datacenter | 9.4_M2 | 9.4_M5 | 9.4 TS1M2 | 9.4 TS1M5 | ||
| Microsoft Windows Server 2012 R2 Datacenter | 9.4_M2 | 9.4_M5 | 9.4 TS1M2 | 9.4 TS1M5 | ||
| Microsoft Windows Server 2012 R2 Std | 9.4_M2 | 9.4_M5 | 9.4 TS1M2 | 9.4 TS1M5 | ||
| Microsoft Windows Server 2012 Std | 9.4_M2 | 9.4_M5 | 9.4 TS1M2 | 9.4 TS1M5 | ||
| Windows 7 Enterprise 32 bit | 9.4_M2 | 9.4_M5 | 9.4 TS1M2 | 9.4 TS1M5 | ||
| Windows 7 Enterprise x64 | 9.4_M2 | 9.4_M5 | 9.4 TS1M2 | 9.4 TS1M5 | ||
| Windows 7 Home Premium 32 bit | 9.4_M2 | 9.4_M5 | 9.4 TS1M2 | 9.4 TS1M5 | ||
| Windows 7 Home Premium x64 | 9.4_M2 | 9.4_M5 | 9.4 TS1M2 | 9.4 TS1M5 | ||
| Windows 7 Professional 32 bit | 9.4_M2 | 9.4_M5 | 9.4 TS1M2 | 9.4 TS1M5 | ||
| Windows 7 Professional x64 | 9.4_M2 | 9.4_M5 | 9.4 TS1M2 | 9.4 TS1M5 | ||
| Windows 7 Ultimate 32 bit | 9.4_M2 | 9.4_M5 | 9.4 TS1M2 | 9.4 TS1M5 | ||
| Windows 7 Ultimate x64 | 9.4_M2 | 9.4_M5 | 9.4 TS1M2 | 9.4 TS1M5 | ||
A fix for this issue for SAS/ACCESS Interface to OLE DB 9.4_M2 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/Z26.html#59008| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2016-12-22 15:44:17 |
| Date Created: | 2016-09-19 16:05:51 |