EG Data Grid Error

[Slash]

Hi, all

     I use the EG client to read the remote SAS server's data and  add a Query Builder node to the workspace. I want to select a variable's distinct value, just like this:

proc sql;

createtable work.query_for_dg_t_c_sfs_smsinf as

selectdistinct t1.returncontent1

from work.query_for_dg_t_c_sfs_smsinf_0000 t1;

quit;

When I open then output data, an error occurs!

1. System.Runtime.InteropServices.COMException (0x8001012E): <?xml version="1.0" ?><Exceptions><Exception><SASMessage severity="Error">Failed to transcode data from U_EUC_CN_CE to U_UTF8_CE encoding because it contained characters which are not supported by your SAS session encoding.  Please review your encoding= and locale= SAS system options to ensure that they can accommodate the data that you want to process. A portion of the source string, in hex representation is:</SASMessage></Exception><Exception><SASMessage severity="None">7a926c4: 33 2b 35 c4 fa b5 c4 ce d2 ce ca d2 bb cf c2 ce |3+5.............|</SASMessage></Exception><Exception><SASMessage severity="None">7a926d4: aa ca b2 c3 b4 3b ce d2 c9 cf b8 f6 d4 c2 be cd |.....;..........|</SASMessage></Exception><Exception><SASMessage severity="Error">某些代码点没有转码。</SASMessage></Exception></Exceptions>

   at SAS.IDataSet.ReadRecords(Int32 Flags, Int32 BindKey, Array& PositionBookmark, Int32 NumberRowsToRead, Int32 RowsOffset, Array& CharacterValues, Array& NumericValues, Array& MissingNumericValues, Array& Bookmarks, Int32& Status)

   at SAS.EG.DataAccess.DataModel.DaForSasData.CommonReadPage(Int32 record, Boolean formatted, Int32 readFlags, Int32 offset, Byte[] positionBookmark, Byte[]& bookmarks, Int32& recordsRead)

   at SAS.EG.DataAccess.DataModel.DaForSasData.ReadPage(Int32 record, Boolean formatted)

   at SAS.EG.DataAccess.DataModel.DaForSasData.GetCell(Int32 record, Int32 fieldIndex, Boolean formatted)

   at SAS.EG.DataAccess.DataModel.DaForSasData.GetNativeValue(Int32 fieldIndex)

   at SAS.EG.DataAccess.DataModel.DataAccessor.GetFormattedAndNativeCellValue(Int32 columnIndex, String& formattedValue, Object& nativeValue)

   at SAS.EG.GridDataModelInterface.GridDataModelInterfaceClass.GetFormattedAndRawValue(Int32 rowIndex, Int32 columnIndex, Object& rawValue)

   at SAS.EG.DataGrid.DataGridClass.getCellValue(Int32 RowIndex, Int32 ColIndex, Object& rawValue)

   at SAS.EG.DataGrid.DataGridClass.OnQueryCellInfo(GridQueryCellInfoEventArgs e)

[TomKari · Accepted solution]

This isn't an area I'm an expert in, but I'm pretty sure the problem is that your server file contains characters that are causing problems for the SAS session initiated by Enterprise Guide.

If you google 'Failed to transcode data' you'll get a lot of hits that describe this problem. Here are a couple of links that might get you started:

http://support.sas.com/documentation/cdl/en/nlsref/61893/HTML/default/viewer.htm#a002604646.htm

http://www.sascommunity.org/wiki/Tips:Handling_Transcoding_Error

Tom

[Slash]

Thanks!