Desktop productivity for business analysts and programmers

EG Data Grid Error

Accepted Solution Solved
Reply
Contributor
Posts: 67
Accepted Solution

EG Data Grid Error

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!

EG_ERROR2.jpg


  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)



Accepted Solutions
Solution
‎06-08-2013 09:22 AM
PROC Star
Posts: 1,146

Re: EG Data Grid Error

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

View solution in original post


All Replies
Solution
‎06-08-2013 09:22 AM
PROC Star
Posts: 1,146

Re: EG Data Grid Error

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

Contributor
Posts: 67

Re: EG Data Grid Error

Thanks!

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 1053 views
  • 0 likes
  • 2 in conversation