cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
elbart
‎10-11-2017
  • 9 Posts
  • 0 Likes Given
  • 1 Solutions
  • 0 Likes Received

Re: SAS - SAP Integration Problem, Unicode

by Fluorite | Level 6 in SAS Data Management
‎09-26-2017 11:38 AM
‎09-26-2017 11:38 AM
I solved this problem. I have changed encoding in sasv9.cfg files in Workspace Server directory and SASApp server directory.   Thanks for help!  ... View more

Re: SAS - SAP Integration Problem, Unicode

by Fluorite | Level 6 in SAS Data Management
‎09-26-2017 09:02 AM
‎09-26-2017 09:02 AM
SASKiwi, I tried to change encoding to UTF-8 in "C:\Program Files\SASHome\SASFoundation\9.3\sasv9.cfg" file with no effect for SAS Data Integration Studio. With proc options option=encoding; run; it showed WCYRILLIC again. This article http://support.sas.com/resources/papers/Multilingual_Computing_with_SAS_94.pdf advises to make changes in Java font configuration files for SAS DIS. What kind of changes should I make there (in this "C:\Program Files\Java\jre6\lib\fontconfig.properties.src" file as I understand)? I tried to find wcyrillic font anywhere there, but found nothing. ... View more

Re: SAS - SAP Integration Problem, Unicode

by Fluorite | Level 6 in SAS Data Management
‎09-21-2017 11:30 AM
‎09-21-2017 11:30 AM
My Encoding session is WCYRILIC. I am using pass through facility (with coding) to import columns from HANA, but how to define that variables are send in SQL_WLONGCHAR?    I have only one ODBC driver that fit my needs for Hana connection. No idea what else can I use instead.  ... View more

Re: SAS - SAP Integration Problem, Unicode

by Fluorite | Level 6 in SAS Data Management
‎09-21-2017 11:22 AM
‎09-21-2017 11:22 AM
SASKiwi, My Encoding session is WCYRILIC. I tried to change "C:\Program Files\SASHome\SASFoundation\9.3\sasv9.cfg" file to utf-8, but after relaunching SAS DI it showed wcyrillic again. Could you tell how to change it correctly? ... View more

Re: SAS - SAP Integration Problem, Unicode

by Fluorite | Level 6 in SAS Data Management
‎09-20-2017 04:51 AM
‎09-20-2017 04:51 AM
ChrisNZ, Yes I am quite sure that this driver supports Unicode transfer.  (here is the topic on SAP forum https://archive.sap.com/discussions/thread/3882688). The problem is that SAS can't convert Unicode symbols - looks more like that, to my mind.  ... View more

SAS - SAP Integration Problem, Unicode

by Fluorite | Level 6 in SAS Data Management
‎09-19-2017 07:35 AM
‎09-19-2017 07:35 AM
Hello everyone!   I am experiencing the same problem as a person in this theme: (https://communities.sas.com/t5/Base-SAS-Programming/SAP-HANA/m-p/277026/highlight/true#M55574) When I try to connect to SAP Hana database with ODBC connector using connection string in SAS DI, it throws an error:   ERROR: CLI cursor fetch error: [SAP AG][LIBODBCHDB DLL][HDBODBC] General error;-10427 Conversion of parameter/column (3) from data type NVARCHAR to ASCII failed   This error is definitely the Unicode one, because I can’t import some columns with Unicode symbols while others are well imported.   When I connect to SAP Hana with Metadata Server, it imports all needed tables, but throws an error which is attached. Could somebody explain step by step approach to solve this problem?   Many thanks in advance. ... View more

Re: Scheduled Job rewrites wrong data, Help please!

by Fluorite | Level 6 in SAS Data Management
‎02-13-2016 10:54 AM
‎02-13-2016 10:54 AM
Well, the problem was solved by deleting all the suspicious jobs and rebuilding them again.  Thanks for everyone who replied.  ... View more

SAS VA, Audit Visual Analytics, Help Needed

by Fluorite | Level 6 in SAS Visual Analytics
‎01-29-2016 11:12 AM
‎01-29-2016 11:12 AM
Dear SAS Community!   Help with Audit Visual Analytics SAS Report is needed.  I accidently deleted a table AUDIT_VISUALANALYTICS from SAS VA Tables and it is disappeared from the folder SAS Visual Analytics/Autoload/EVDMLA. Could somebody help to restore it?   Many thanks in advance! Regards, Alexey ... View more

Scheduled Job rewrites wrong data, Help please!

by Fluorite | Level 6 in SAS Data Management
‎01-23-2016 09:03 AM
‎01-23-2016 09:03 AM
Hello community!  The problem is about rewriting contents of a table in SAS Data Integration Studio.  We have a Job scheduled to run every day. Every morning the table contents is almost empty and contains rows that has nothing to do with the right one. Than if I am running the job manually it works perfectly fine. I have already tried to redeploy scheduling and make a reverse analysis to understand where this data comes from but it didn’t help.   Any suggestions will be very welcome!   P.S. Didn't find a branch of a forum where can I write questions about SAS DI and have chosen the most close to my mind.   ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎10-11-2017 09:57 AM
Quick links