Steve - Did you install the 09/09/08 R:BASE Turbo V-8 build? If so, did you rebuild the database afterwards to recreate the index file?
Sami ____________________________ Sami Aaron Software Management Specialists 913-915-1971 [EMAIL PROTECTED] -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Wills, Steve Sent: Friday, September 12, 2008 10:42 AM To: RBASE-L Mailing List Subject: [RBASE-L] - RBv8, Problems During Refresh From Oracle Source DB I've been getting the following messages for a couple of days: <WARNING> Problems updating index file. Index file may have been corrupted. (2860) -ERROR- I/O problems - Check for a full disk. (2009) This is from a REFRESH routine that moves data from a set of Oracle production tables into my local RB reporting tables via an SCONNECT. It has been running fine for about 6 months, with only an occasional hiccup, those apparently related to "whatever" on the Oracle DB server or my connection thereto. When I encounter one of these, I just re-start the process from the last good set-point, NBD. Before I run the "REFRESH.RMD", I run a "CLEAN.RMD", to DELETE all previous data and PACK the db. Since it's a reporting db and we're not doing any versioning/history with it, I start with a clean slate whenever I do a refresh. The point is that, post-CLEAN, my RB db is pristine - unless we include any of my less-than-stellar reports, forms, etc, none of which factor into the refresh process. So, I don't think it's anything related to DUP'd values that should be unique, as the PK is defined exactly as in the production table. There is a Composite PK, but there are no NULLs in the Oracle source table in any of the PK fields. My HDD has about 83GB available and the fully populated RBase db is currently about 518MB for all 4 files, with RX2 at 473MB. Don't know what else to share and not sure what to look for or even if my focus on the particular table is where the focus should be. Any ideas? Thanks, Steve in Memphis J. Stephen Wills Program Manager, Research Informatics Office of the Vice Chancellor for Research University of Tennessee Health Science Center 62 S. Dunlap, Suite 400 Memphis, TN 38163 Office: 901-448-2389 FAX : 901-448-7133
