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: 
AmitSri
‎05-22-2018
  • 96 Posts
  • 18 Likes Given
  • 1 Solutions
  • 16 Likes Received

How to improve the performance of loading data into cas from db: Viya ...

by Pyrite | Level 9 in Administration and Deployment
‎03-28-2018 09:14 AM
1 Like
‎03-28-2018 09:14 AM
1 Like
I am trying to load 30gb of data from Denedo to SAS and this is running very slow. As 10gb of data loading from denedo took 12.5hrs and 5gb data loading took 6hrs. Are there any factors that can be changed in any of the config files to have a better performance in loading data. Please suggest. Thanks!! ... View more

Re: How to load the ; delimited file into CAS

by Pyrite | Level 9 in Developers
‎03-28-2018 09:12 AM
‎03-28-2018 09:12 AM
Okay.. I will do it this way. Thanks A lot!! ... View more

How to load the ; delimited file into CAS

by Pyrite | Level 9 in Developers
‎03-28-2018 04:13 AM
‎03-28-2018 04:13 AM
I wanted to load the ; elimited data into CAS. The data looks like:     servicedvehiclesid;daykey;throughputsid;outletcode;outletname;baumusterkey 1;20140;679;0081;abc Company;123 1;20140;978679;00001;mMo Company;208 7;40331;00509;002;gtr Company;5846   I am trying to load this data as: proc casutil;    load casdata="export.csv"   incaslib="DBDATA"                              importoptions=(filetype="csv" delimiter = ";" getnames="true")         casout="export_110GB" outcaslib="DBDATA" promote; run;   I am getting the error as: ERROR: At least one row of input data is invalid: too many columns. ERROR: The action stopped due to errors.   If you have Any suggestions on the coding part or error, Please revert. Thanks!! ... View more

Re: Error: Table testdata variable ? offset exceeds the varying data b...

by Pyrite | Level 9 in SAS Viya
‎03-27-2018 03:14 AM
‎03-27-2018 03:14 AM
Okay...Got it. Thank you Alex!! ... View more

Re: Error: Table testdata variable ? offset exceeds the varying data b...

by Pyrite | Level 9 in SAS Viya
‎03-26-2018 07:56 AM
‎03-26-2018 07:56 AM
Hi Alex, Thanks for that!! Yes, As soon as I searched for this error in google, I found this link. I had gone through this link before posting the query. However, I could not understand it, as its stating about a hotfix. How, can I get this hotfix to be done here? I wanted to know about performing the hotfix for this. Thanks!! ... View more

Error: Table testdata variable ? offset exceeds the varying data buffe...

by Pyrite | Level 9 in SAS Viya
‎03-26-2018 06:47 AM
‎03-26-2018 06:47 AM
Hi,   I am getting this error while loading a table from Mysql to cas.   We have SAS?ACCESS interface to odbc.Through this, I am trying to pull the data from mysql using a DSN defined in odbc.ini.   here are the queries I used.   caslib sqldata datasource=(srctype="odbc" username="read_only_test_user"   password="xxxxxxxxxxxx" odbc_dsn="MYSQL_DENODO_DIRECT" dm_unicode="utf-16") global; proc casutil;    list files incaslib="sqldata";   proc casutil;    load casdata="test_portugal"   incaslib="SQLDATA"                              casout="test_portugal" outcaslib="DBDATA" ; run;     And im getting the below error:  ERROR: Table test_portugal variable ? offset exceeds the varying data buffer.  ERROR: The action stopped due to errors.   Is this related to the SAS/ACCESS interface. Do we need to have SAS?ACCESSinterface to MySql for this. I hope thats not required as we are anyways connecting to mysql using ODBC DSN.   Please clarify. Thanks!! ... View more

Re: ERROR: Could not open file to flush memory contents.sas viya 3.3

by Pyrite | Level 9 in Developers
‎03-21-2018 03:25 AM
‎03-21-2018 03:25 AM
And when I try this: proc casutil; load casdata="/db_data/test_1235.csv" incaslib="DBDATA" importoptions=(filetype="csv" delimiter="," getnames="true") casout="test_12345" outcaslib="DBDATA" promote; run; ERROR: Path '/db_data/test_1235.csv' for caslib 'DBDATA' appears to be an absolute path. Paths should be relative to the caslib root. ERROR: The action stopped due to errors. ... View more

Re: ERROR: Could not open file to flush memory contents.sas viya 3.3

by Pyrite | Level 9 in Developers
‎03-21-2018 03:07 AM
‎03-21-2018 03:07 AM
Okay.. The file is located at /db_data. proc casutil; load casdata="root/db_data/test_1235.csv" incaslib="DBDATA" casout="test_12345" outcaslib="DBDATA" promote; run; ERROR: Failed to open the file root/db_data/test_1235.csv. Make sure the file exists and that you have permission to read the file. Note that Cloud Analytic Services attempts to open a file that is not stored in HDFS. ERROR: The action stopped due to errors. But, the file has 777permissions. And, now I am getting the error as: ... View more

Re: ERROR: Could not open file to flush memory contents.sas viya 3.3

by Pyrite | Level 9 in Developers
‎03-20-2018 09:42 AM
‎03-20-2018 09:42 AM
Yes, While loading I have given the full name. proc casutil; load casdata="test_1235.csv" incaslib="DBDATA" importoptions=(filetype="csv" delimiter="," getnames="true") casout="test_1235" outcaslib="DBDATA" promote; run; and while saving it says file does not exist. ... View more

Re: ERROR: Could not open file to flush memory contents.sas viya 3.3

by Pyrite | Level 9 in Developers
‎03-20-2018 09:03 AM
‎03-20-2018 09:03 AM
Hi Alex, I had done this, and got rid of that error. However, When I execute this: proc casutil; load casdata="test_1235.csv" incaslib="DBDATA" importoptions=(filetype="csv" delimiter="," getnames="true") casout="test_1235" outcaslib="DBDATA" promote; run; proc casutil; save casdata="test_12345" incaslib="DBDATA" casout="test" outcaslib="DBDATA"; run; ERROR: The file or path 'test_12345' is not available in the file system. ERROR: Table 'test_12345' could not be loaded. ERROR: Failure opening table 'test_12345': A table could not be loaded. ERROR: The action stopped due to errors. NOTE: The Cloud Analytic Services server processed the request in 0.000122 seconds. ERROR: Failed to save the table "test_12345" from the "DBDATA" caslib to the "DBDATA" caslib. When I try to load the file again, it says ERROR: The table TEST_1235 already exists in caslib DBDATA. ERROR: The action stopped due to errors.but its not saving the table. ... View more

ERROR: Could not open file to flush memory contents.sas viya 3.3

by Pyrite | Level 9 in Developers
‎03-20-2018 03:32 AM
‎03-20-2018 03:32 AM
Hi, When I try to load a csv file of 1gb into caslib, im getting the below error. What does this error mean? Thanks!!   1          OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;  72           73         proc casutil;  NOTE: The UUID '146fa91a-5361-f54a-91ff-c53d52ea3a52' is connected using session MYSESSION.  74         load casdata="20180226_all_markets_export_5gb_without_header.csv" incaslib="testload"  75         casout="20180226_all_markets_export_5gb_without_header" outcaslib="testload" promote;  ERROR: Could not open file to flush memory contents.  ERROR: Could not open file to flush memory contents. Permission denied  ERROR: The action stopped due to errors.  NOTE: The Cloud Analytic Services server processed the request in 41.482808 seconds.  76         run;    77           78         OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;  91          ... View more

Re: deployment fatal

by Pyrite | Level 9 in Administration and Deployment
‎03-19-2018 04:46 AM
‎03-19-2018 04:46 AM
Hi @JuanS_OCS No, the log didnot give any other details apart from this. ... View more

Re: how to bring a service up when died -sas viya 3.2

by Pyrite | Level 9 in Administration and Deployment
‎03-15-2018 11:31 AM
‎03-15-2018 11:31 AM
Thank you for looking into it. Yes, I had raised a request at tech support on this. ... View more

Re: how to bring a service up when died -sas viya 3.2

by Pyrite | Level 9 in Administration and Deployment
‎03-15-2018 09:06 AM
‎03-15-2018 09:06 AM
Hi Alex, No we had not setit up now. We initially configured LDAP settings using env manager. The current scenario in our project is, our client wants us to use 3.3 version. Since, 3.2 is running fine, We had created a new vm to install 3.3 without disturbing 3.2. But, since both are using the same IP, to work on one VM, we have to bring the other vm down.And as in 3.3 we are currently facing ODBC connection issue, we had broght the 3.2 vm bak for the business perspective. When we brought the 3.2vm back, I am not sure what the admin had done on this, however all the ldapservices were not running. So he had just set it back (the all.yml file and sitedefault.yml files of OpenLdap), Then we tried starting the services and facing the current issue. Thanks!! ... View more

Re: how to bring a service up when died -sas viya 3.2

by Pyrite | Level 9 in Administration and Deployment
‎03-15-2018 08:29 AM
‎03-15-2018 08:29 AM
Its a single-machine deployment and we configured an OpenLdap using ansible we had set it up. Thanks!! ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎05-22-2018 07:20 AM
Likes given to
View All
Likes from
View All
Quick links