[[https://www.revelation.com/|Sign up on the Revelation Software website to have access to the most current content, and to be able to ask questions and get answers from the Revelation community]]


==== IDX_SETS (AREV Specific) ====
=== At 19 APR 2007 01:39:55AM Barry Stevens wrote: ===
 
{{tag>"AREV Specific"}}
 
<QUOTE>
Have a client that is expriencing the follwing problems/situation.

Is this a sign of PC error or Data problems.



run report1 (File1):



FS445: IDX_SETS. Function 4 returned error code 28932



Shutdown reboot:



reran



FS445:IDX_SETS  fuction 8 error code -7

FS 448

Fatal internal error 



Rebuild indexes for report's file



Run OK





Run report2 (File2):



FS445 IDX_SETS error



reran *Report1*



IDX_SETS line 5322    B17 subscripts value out of range 





Rebuild report2 file2 indexes

reruns report2 - same error
</QUOTE>
----

=== At 19 APR 2007 01:48AM support@sprezzatura.com wrote:  ===

<QUOTE>In what can only be described as stunning irony given our problems with DEP and 2.1 recommendations, we recently - through a long process of painful elimination and logical leg work- discovered that switching AREV to the UD Driver eliminated our IDX_SETS errors.



support@sprezzatura.com

The Sprezzatura Group Web Site

[i]World Leaders in all things RevSoft[/i]

[img]http://www.sprezzatura.com/zz.gif[/img]

</QUOTE>

----

=== At 19 APR 2007 04:00AM Barry Stevens wrote:  ===

<QUOTE>So is this is a compatibily problem with newer PCs and/or MSoft XP updates.?



Is AREV affected by DEP?

</QUOTE>

----

=== At 19 APR 2007 06:00AM [url=http://www.sprezzatura.com]The Sprezzatura Group[/url] wrote:  ===

<QUOTE>Well it started biting us at a site that had run happily for years - so we're guessing yes.



[url=http://www.sprezzatura.com]The Sprezzatura Group[/url]

[i]World leaders in all things RevSoft[/i]

[img]http://www.sprezzatura.com/zz.gif[/img]

</QUOTE>

----

=== At 24 APR 2007 08:55PM Barry Stevens wrote:  ===

<QUOTE>The reports in question had a select using 2 indexed fields.

Changed to 2 selects with 1 index in the first and ran ok.



Removed all indexes (ensured no !filename existed)

Add all indexes and rebuild.



Still got idx_sets error.



Made the 1 index 2 part select permanent in all reports.

Now runs fine.



Do not have a clue why it was suddenly a problem.

</QUOTE>


[[https://www.revelation.com/revweb/oecgi4p.php/O4W_HANDOFF?DESTN=O4W_RUN_FORM&INQID=NONWORKS_READ&SUMMARY=1&KEY=8A06D988CA275BDA852572C2001F1F2B|View this thread on the  forum...]]