06-17-2019
AshwaniGupta
Calcite | Level 5
Member since
01-24-2019
- 6 Posts
- 0 Likes Given
- 0 Solutions
- 0 Likes Received
-
Latest posts by AshwaniGupta
Subject Views Posted 2098 06-14-2019 06:15 AM 2181 06-10-2019 03:20 AM 2210 06-10-2019 02:26 AM 2229 06-10-2019 12:59 AM 690 02-13-2019 04:58 AM 1022 01-24-2019 06:48 AM -
Activity Feed for AshwaniGupta
- Posted Re: DB2 libname giving error on Administration and Deployment. 06-14-2019 06:15 AM
- Posted Re: DB2 libname giving error on Administration and Deployment. 06-10-2019 03:20 AM
- Posted Re: DB2 libname giving error on Administration and Deployment. 06-10-2019 02:26 AM
- Posted DB2 libname giving error on Administration and Deployment. 06-10-2019 12:59 AM
- Posted Not getting updated data while importing formula based EXCEL SHEET on SAS Programming. 02-13-2019 04:58 AM
- Posted Want to send email with full first error message when my SAS job failed on SAS Programming. 01-24-2019 06:48 AM
06-14-2019
06:15 AM
This libname was working fine about a week ago. I checked variables files, there is no change recently. We also restart our LSF service as issue is only on LSF batch server. But still facing issue. One strange thing i experience that when i use only libname statement in job (no other code), that time its working fine, but when we tried to run select statement that time only we are facing issue. LIBNAME db2 DB2 Datasrc=XXXX SCHEMA=TXN AUTHDOMAIN="XXXXXXXX" ; ERROR: Error allocating CLI environment. ERROR: Error in the LIBNAME statement. 95 96 data test; 97 set db2.Table_name(obs=100); ERROR: Libref DB2 is not assigned.
... View more
06-10-2019
02:26 AM
Hi @nhvdwalt Yes, here is Linux. But the User Id's are same for EG/DI and LSF. Where i can find this environment variable 'LD_LIBRARY_PATH' ? I will cross check that once.
... View more
06-10-2019
12:59 AM
Hello < I am facing one DB2 libname issue. My libname getting assign perfectly while running on SAS EG or SAS DI Code editor . but when i scehdule our job and ran on SAS batch server (LSF platform process manager) it is giving issue. Below is error Msg. Libname db2_XYZ Datasrc=ABC Schema =XXX Authdomain=XXXXXX; ERROR: Error allocating CLI Environment. ERROR: Error in libname statement. .. I am surprise that the same libname connecting on EG or DI. just givinng error while running on LSF. Please help me on this.
... View more
02-13-2019
04:58 AM
Hello All, Need your help. I am facing one issue, I have one excel file with 2 sheets(tabs) in that , I am exporting data in first sheet and second sheet have formulas which is linked to first sheet. Now when i tried to import data from second sheet at that time i am not getting updated data, but when i attached that EXCEL file in mail it is giving correct updated data. Could you someone please help me to get this resolve. I tried one shortcut:- after exporting data in firstsheet, i manually open excel go to second sheet and then data-refresh all afetr that when i tried i am getting updated data, but this is not good for my code, i can not do refresh every time . Thanks in advance. Ashwani Gupta
... View more
01-24-2019
06:48 AM
Hello All, Some one please help me to get a correct code . i want to send email with first error message from log if my job get failed , if job success then no email required. I tried multiple ways but facing different - different issues.some times sends last error message, some time get first line of error but not taking second line if error string is more than one line and so on. If anyone have clean code please share . Thanks
... View more