Hello team, I am using below code to unload and load data in cas   cas casauto sessopts=(caslib="test123"); caslib mycaslib datasource=(srctype='sqlserver' user='xxxxxxx' password='xxxxxxxx' sqlserver_dsn="xxxxxxx" schema=dbo catalog=*); PROC CASUTIL; droptable CASDATA="Event_calltype_analysis_rpt" INCASLIB="test123"; QUIT; caslib _all_ assign; proc casutil; load casdata="Event_calltype_analysis_rpt" incaslib="mycaslib" outcaslib="test123" casout="Event_calltype_analysis_rpt" promote; quit; However, I am getting below warning  NOTE: Performing serial LoadTable action using SAS Data Connector to SQL Server. WARNING: WARNING: [SAS][ODBC SQL Server Wire Protocol driver]Fractional truncation. Error in column 37.   Warning count is too much     Column 37 is    How to resolve this issue. Thanks in advance ... View more

Hello,  I am working with SAS Viya 3.5, in that i have existing created job  Sample: Unload cas-shared-default Public data Sample: load cas-shared-default Public data   to configure this job first load unload data on daily basis i have some doubt as below. First lets discuss about unloading the data, as per the steps, we have to make changes in the Argument, so once click on argument tab following screen appears, in server name, we selected Cas Server, Further data is in public library so incaslib selected, where to assign the table name which we have to unload from public library. what is use of filter tab. I configured below manner, and I am getting below log,   -------------------------------------------------- -------------------------------------------------- ----------JOB INFORMATION---------- Job Created: 2024-04-13T10:11.121Z Job ID: e8e07de8-a900-4fb2-85b8-3dbfb73f2c89 Heartbeat interval: PT0.3S Job expires after: PT168H Running as: Sas Log file: /files/files/d44a07ee-74bb-4ee8-a90d-3aa1ff556094 [ 2024-04-13T10:11.121Z-results.log ] Arguments: Options: { "enabled" : true, "type" : "UNLOAD", "settings" : { "unloadAccessThreshold" : "PT45S", "successJobId" : "" }, "selectors" : [ { "serverName" : "cas-shared-default", "inputCaslib" : "test123", "outputCaslib" : null, "filter" : "eq(name,’SAMPLE_DATA_PREP’)", "settings" : { } } ] } -------------------------------------------------- Created session cas-shared-default: e6c0f370-32c7-8640-bc0e-fdd312b7d189 (CAS Manager:Sat Apr 13 15:41:16 2024) Using session e6c0f370-32c7-8640-bc0e-fdd312b7d189 Server: cas-shared-default Input caslib: test123 Effective Settings: { "successJobId" : "", "unloadAccessThreshold" : "PT45S" } ----------UNLOAD STARTING---------- ----------UNLOAD COMPLETE---------- ----------SUMMARY---------- 0 TABLES PROCESSED ----------CLEANUP STARTING---------- Session deleted: cas-shared-default: e6c0f370-32c7-8640-bc0e-fdd312b7d189 ----------CLEANUP COMPLETE---------- Final Job State: completed Log file:/files/files/d44a07ee-74bb-4ee8-a90d-3aa1ff556094 Similarly  I want clarity regarding Loading the data. Please anyone could help to resolve the same.   Thanks in advance.   ... View more

Dear Team,   My Sas 9.4 application taking too much time to execute code and after addressing issue, it is observed that IO throughput rate is not up to mark which is  recommended 100-125 Mb/sec.   Application IO Throughput rate is as below, STATISTICS read throughput rate: 68.41 megabytes/second per physical core write throughput rate: 4.35 megabytes/second per physical core.   Application is configured on Linux 8 core server having 8 gb Ram      I have also check NMON output for 24 hrs, and it is likely saying that issue is with IO throughput rate. So how to increase throughput rate at OS/Storage level. Anyone could please help me to resolve the same. ... View more

Hi team,    I have dashboard in SAS VA, in Admin Login and other users able to see dashboard properly as shown in below, however one user having below interface, unnecessary forward arrow added to this reports name since this user only have read access. I am using SAS VA 8.3 version. ... View more

Hi Team,   I have scheduled below code to load and unload the data in caslib PROC CASUTIL; droptable CASDATA="Event_calltype_analysis_rpt" INCASLIB="Mers_Report"; QUIT; proc casutil; load data=Report.Event_calltype_analysis_rpt promote; /* 2 */ contents casdata="Event_calltype_analysis_rpt"; run;   However, whenever I used above code to load the data then my Marathi font data got missing while visualisation data. I have attached snap of this scenario.     And whenever I am doing data loading by manually then this data reflecting properly. why this happening. (same screenshot attached. This is expected output)           ... View more

For Checking the user History who has access the SAS VA Dashboard, I have checked Report Data Service and from that I am able to check which user was login. But how to find out IP address of any user logged in SAS VA Report. I am using SAS VA V.03.05 ... View more