Relational Index(es) not working (AREV Specific)
At 07 MAR 2000 01:45:21PM Paul Marfia wrote:
I have a client with a problem with his relational index(es). Everytime we try to rebuild them, we get:
'!' Line 1. B10 Variable has not been assigned a value. Zero Used. Line 1 '!' broke because a run time error was encountered.
I've removed and reinstalled the relational indexes. Deleted the related to and related from fields and reentered them. I've removes all indexes and deleted the !Tablename and let it recreate. This happens with a table with 3000 keys related to the 25,000 record table and with a table with no keys related to the 25,000 record table. I can rebuild the Btree on the key of the 25000 record table with no problem. The Cross-reference index appears to be okay as well.
Any clues.
Paul
At 07 MAR 2000 02:39PM Warren wrote:
Check the size of the records. Relational indexes are stored in the data file and don't split on size like the btree records in the !file, and as such are subject to the 64K limit. Sort of like the same problem with Quickdex.
At 10 MAR 2000 11:04AM Paul wrote:
As I said, it blows up without *any* related records in the table, so it's not the 64K limit.
Thanks for responding with *something*, anyway.
I thought this (forum) would be a waste of time, and I was right.
At 10 MAR 2000 11:45AM Don Bakke wrote:
Paul,
It's a shame that you feel that way. Just so happens we've encountered this exact problem and (at least for us) have figured out how to build the indexes without hitting this error.
But since this is just a waste a time I'll keep my comments to myself.
At 10 MAR 2000 01:55PM Dr. Pangloss wrote:
Fine, call RTI tech support and PAY $250 for an incident report.
Let's hope your client finds you equally as useless as you find this forum.
At 11 MAR 2000 03:44PM Warren wrote:
Did you ever hear of the self-fulfilling prophecy? Gosh, golly, now nobody is going to help you with that chip on you shoulder.
If you had put your snide comments in your original post sure wouldn't have answered you.
You asked for a clue, not a solution.
Based on the scanty information you supplied I gave you the most likely 'clue' as to what was going on. Since you're not willing to work with us on this problem you're back to square one - on your own.
AMF!
At 11 MAR 2000 05:44PM [email protected] wrote:
Don (et al)
Come on guys .. paul has been around a long time and helped out here. You know how frustrating this stuff can be .. especially since you haven't seen RTI speak up here ..
If you have a good answer please help him out
Thanks
[email protected] onmouseover=window.status=imagine … rising to the occasion and helping ..;return(true)"
David Tod Sigafoos ~ SigSolutions
cell: 503-341-2983
At 11 MAR 2000 07:43PM Don Bakke wrote:
DSig,
I'm familiar with Paul's history on this website. Unfortunately most of it is negative. FWIW, he is the only person (twice now) that I have responded to in this way. My disposition can usually tolerate unprofessional or immature attitudes, but at some point I have to draw a line in order to promote sensibility.
Not that I would have ever condoned his post, but it would have been more understandable if he had not received any response or the responses he received were unhelpful after a reasonable amount of time. Instead, he piped off after one response in only 72 hours (or less AFAIK.)
Sorry, this won't fly.
At 11 MAR 2000 10:39PM [email protected] wrote:
Don,
what ever ..
[email protected] onmouseover=window.status=imagine … opinions that seem to scare;return(true)"
David Tod Sigafoos ~ SigSolutions
cell: 503-341-2983
At 12 MAR 2000 09:26AM [url=http://www.sprezzatura.com]The Sprezzatura Group[/url] wrote:
For you, Dave….
Since the error is happening in !, odds are that one of the fields is indeed over 64K.
Best thing is to gen the !! code, copy to a subroutine, then set !code up to call subroutine so you can see true break line and contents. Answer should be clear then.
[/i]World leaders in all things RevSoft[/i]
At 12 MAR 2000 09:32AM [email protected] - [url=http://www.sprezzatura.com]The Sprezzatura Group[/url] wrote:
On a different side of Paul, his help during the ARev 3.12 beta cycle was so invaluable that I added his name into one of the Easter egg credits. FWIW……
[/i]World leaders in all things RevSoft[/i]
At 12 MAR 2000 12:54PM Don Bakke wrote:
FWIW…
When we've encountered this problem it is usually when multiple relational indexes are being built. When we build them one at a time (a tedious process when there are over a million records) this seems to have a very good success rate.
At 12 MAR 2000 09:15PM [email protected] wrote:
You'are the man .. errr .. men .. err .. group
[email protected] onmouseover=window.status=imagine … opinions that seem to scare;return(true)"
David Tod Sigafoos ~ SigSolutions
cell: 503-341-2983