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: 
_Olga_
‎02-15-2018
  • 7 Posts
  • 1 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: Chat in SAS EGRC

by Calcite | Level 5 in SAS Risk Management
‎02-01-2018 01:14 AM
‎02-01-2018 01:14 AM
I mean, that I don't need email letters in SAS EGRC, but chat messages in SAS EGRC 🙂 ... View more

Chat in SAS EGRC

by Calcite | Level 5 in SAS Risk Management
‎01-31-2018 09:53 AM
‎01-31-2018 09:53 AM
Hello,   Could you tell me, is chat mechanism in product SAS EGRC? I don't need email letters, but chat messages.   Thanks.   ... View more

Error ORA-03113: end-of-file on communication channel

by Calcite | Level 5 in SAS Programming
‎03-22-2017 02:39 AM
‎03-22-2017 02:39 AM
Hello!   I have next problem. How can I solve it? Thanks for help.   Table libOra.table has 24 991 461 records.   Code: libname libOra ORACLE SCHEMA=myschema PATH=mypath USER='myuser' PASSWORD="mypass"; libname libSAS '/mypath';   data libSAS.table (compress=char); set libOra.table; run;　   Log: ERROR: Error fetching from cursor. ORACLE error is ORA-03113: end-of-file on communication channel NOTE: The DATA step has been abnormally terminated. NOTE: The SAS System stopped processing this step because of errors. NOTE: There were 17448750 observations read from the data set libOra.table. WARNING: The data set libSAS.table may be incomplete.　 When this step was stopped there were 17448750 observations and 34 　　　　　　　　　variables. NOTE: Compressing data set libSAS.table decreased size by 81.80 percent. 　　　　　　Compressed is 397068 pages; un-compressed would require 2181094 pages. WARNING: Data set libSAS.table was not replaced because this step was stopped. NOTE: DATA statement used (Total process time): 　　　　　 real time　　　　　　　　　　 13:23:03.33 　　　　　 cpu time　　　　　　　　　　　 15:16.03 ... View more

Re: Error in SAS

by Calcite | Level 5 in SAS Programming
‎03-23-2016 07:55 AM
‎03-23-2016 07:55 AM
I need to create table mytest not in SAS, but in Oracle (see my new comment above). It's gives the same error:  ORA-12801: error signaled in parallel query server P012 ORA-01652: unable to extend temp segment by 4096 in tablespace SAS   Reset of sort_area_size doesn't help. Any suggessions? ... View more

Re: Error in SAS

by Calcite | Level 5 in SAS Programming
‎03-23-2016 07:41 AM
‎03-23-2016 07:41 AM
Yes, it's not error in SAS, but in Oracle. I tried to create table mytest in PL/SQL Developer, but source table bmv_tlb_tmp is big (it has 288'304'610 records). I've tried to reset parameter sort_area_size to 1048576000 or to 204857600, but it cause error: ORA-12801: error signaled in parallel query server P012 ORA-01652: unable to extend temp segment by 4096 in tablespace SAS   Code: alter session set sort_area_size=204857600; create table mytest as select distinct              EID,              FIO_SEARCH,              CAMP,              RECALC_DATE,              DATE_UPTO,              O_CARD_SALARY,              LAST_ANKETA_REF,              LAST_ANKETA_BR,              OFFER_ID,              OFFER_STATUS_ID,              OFFER_STATUS_CD,              FD,              max(FD) over (partition by FIO_SEARCH, OFFER_STATUS_CD) max_FD from bmv_tlb_tmp; How to fix the error? ... View more

Re: Error in SAS

by Calcite | Level 5 in SAS Programming
‎03-22-2016 07:54 AM
‎03-22-2016 07:54 AM
I've edited the code. ... View more

Error in SAS

by Calcite | Level 5 in SAS Programming
‎03-22-2016 07:18 AM
‎03-22-2016 07:18 AM
Hello!   The code below causes ERROR: ORACLE execute error: ORA-12801: error signaled in parallel query server P029 ORA-01652: unable to extend temp segment by 4096 in tablespace SAS.    How to fix this error?   proc sql; connect to oracle (PATH=mypath USER='sas' PASSWORD="mypass"); execute(create table table1 as select ...) by oracle; execute(create table table2 as select ...) by oracle; execute(create table table3 as select ...) by oracle; execute(create table table4 as select ...) by oracle; execute(create table table5 as select ...) by oracle; execute(create table table6 as select ...) by oracle; execute(create table table7 as select ...) by oracle; quit; ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎02-15-2018 03:09 PM
  • Contact User via MSN
  • Contact User via AIM
  • Contact User via Skype
Likes given to
View All
Quick links