LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (September 2010, week 2)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:         Wed, 8 Sep 2010 22:58:23 -0400
Reply-To:     Arthur Tabachneck <art297@NETSCAPE.NET>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Arthur Tabachneck <art297@NETSCAPE.NET>
Subject:      Re: CLI Fetch error Invalid datetime format
Comments: To: Gema Barkanic <Gema.Barkanic@CIGNA.COM>

Gima,

You didn't indicate which operating system you were on. You might find the direction you need by doing the following Google search:

http://www.google.ca/search? hl=en&rlz=1R2SKPB_enCA369&as_q=odbc+CLI+cursor+extended+fetch+error+oracle+ datetime&as_epq=&as_oq=&as_eq=&num=10&lr=&as_filetype=&ft=i&as_sitesearch=s upport.sas.com&as_qdr=all&as_rights=&as_occt=any&cr=&as_nlo=&as_nhi=&safe=i mages

or, in short form: http://xrl.us/bhym6u

HTH, Art --------- On Wed, 8 Sep 2010 20:50:05 -0400, Barkanic, Gema 1915 <Gema.Barkanic@CIGNA.COM> wrote:

>I'm getting a CLI Fetch error whhile reading in an ODBC file. Is there a way to override this so I can at least read the data in. I know the problem is with a certain variable. Thanks, Gema > >This is the actual error I'm getting: > > > >ERROR: CLI cursor extended fetch error: [Oracle][ODBC]Invalid datetime format. >NOTE: The data step has been abnormally terminated. >NOTE: Missing values were generated as a result of performing an operation on missing values. > Each place is given by: (Number of times) at (Line):(Column). > 495288 at 17:11 3 at 18:13 >NOTE: The SAS System stopped processing this step because of errors. >NOTE: There were 2373000 observations read from the data set PROD.MEMBDGIS. >WARNING: The data set MAIN.MEMBERLEVEL may be incomplete. When this step was stopped there > were 9160 observations and 49 variables. >NOTE: Compressing data set MAIN.MEMBERLEVEL decreased size by 99.05 percent. > Compressed is 87 pages; un-compressed would require 9160 pages. >WARNING: Data set MAIN.MEMBERLEVEL was not replaced because this step was stopped. >NOTE: DATA statement used (Total process time): > real time 10:33.34 >2 The SAS System 17:52 Tuesday, September 7, 2010 > > cpu time 1:54.86 > > > >Gema Barkanic >Health Data Specialist >412-747-7537 >412- 473- 7694 (home office M and F) >gema.barkanic@cigna.com > >aConfidential, unpublished property of CIGNA. Do not duplicate or distribute. Use and distribution limited solely to authorized personnel. (c) Copyright 2010 CIGNA > > >-------------------------------------------------------------------------- ---- >CONFIDENTIALITY NOTICE: If you have received this email in error, please immediately notify the sender by e-mail at the address shown. This email transmission may contain confidential information. This information is intended only for the use of the individual(s) or entity to whom it is intended even if addressed incorrectly. Please delete it from your files if you are not the intended recipient. Thank you for your compliance. Copyright 2010 CIGNA > ========================================================================== ==


Back to: Top of message | Previous page | Main SAS-L page