btree.extract and FS445 (Indexing)
At 16 AUG 2011 01:42:18AM David Goddard wrote:
OI v9.2.1
A call to btree.extract to look up a btree index is returning error FS445 via get_status function. Can't find any reference to FS445.
Any clues to what this error means.
At 16 AUG 2011 02:31AM David Goddard wrote:
Looks like it's connected to using the new IDX SETS value in SYSENV
E.G. The CFG_IDX_SETS record in sysenv had IDX_SETS2 in field 1. I changed this back to the orginal idx_sets by changing the value to IDX_SETS1 and the FS445 error goes away.
Further testing revealed that it's only the first call to btree.extract that fails. Subsequent calls to btree.extract work ok.
Still clueless on what a FS445 means though.:sad:
David Goddard
Revelation Software Australia
At 16 AUG 2011 04:11AM Andrew McAuley wrote:
Glad to be of limited help ;)
EQU FS_IDX_SETS_ERROR$ TO 445 ;* 1 - Error codes returned from IDX_SETS
World leaders in all things RevSoft
At 16 AUG 2011 04:27AM David Goddard wrote:
Aha, the old FSERRORS_400 insert trick.
Nice pick up thanks Andrew. Old habits die hard. Was looking in REVERROR.DAT.
Still no closer to an answer…
:sad:
Dave G
At 16 AUG 2011 07:46AM aaron kaplan wrote:
Further testing revealed that it's only the first call to btree.extract that fails. Subsequent calls to btree.extract work ok.
Any MFS on the file besides SI?
World leaders in all things RevSoft
At 16 AUG 2011 07:48AM David Goddard wrote:
No other MFS's.
Dave G
At 31 AUG 2011 01:07AM bshumsky wrote:
No other MFS's.
Dave G
Hi, David. It looks like btree.extract puts more detail about the error into the @FILE.ERROR variable. Can you check that out and see what it contains?
- Bryan Shumsky
At 16 AUG 2011 06:55PM Matthew Crozier wrote:
Pre OI 9, an FS445 would usually indicate that there weren't sufficient rights in the Sort Directory (typically DATAVOL) for temporary work files to be created. I don't know if that is still the case with the new IDX_SETS in OI9, or not.
HTH, M@
[img]http://www.vernonsystems.com/images/logo_main_ani.gif[/img]
At 17 AUG 2011 06:51AM David Goddard wrote:
G;day Bryan
@FILE.ERROR<1> = 445
@FILE.ERROR<2,1> = 1
@FILE.ERROR<2,2> = -1
Does that help?
Dave G
At 17 JUN 2012 11:48PM Matthew Crozier wrote:
FWIW, I just stumbled across this by not having IdxSets.dll available. (I'd renamed it just for testing).
BTW, it appears that ClientSetup.exe in OI 9.3.1 registers IdxSets v1.2 - not v1.3 !? I found that any changes I made to CFG_IDX_SETS were going unnoticed - until I explicitly ran idxSets_setup.exe to install v1.3. And then!, it seems that the system would only revert to IDX_SETS1 if field 2 (not field 1) of CFG_IDX_SETS was set to 'IDX_SETS1'. This differs from what I've seen up here on the website.
Cheers, M@
[img]http://www.vernonsystems.com/images/logo_main_ani.gif[/img]
At 01 NOV 2021 06:48PM Mark Boorman wrote:
I've found myself receiving this same error from a btree.extract and I can't quite glean a resolution from this post.
Does anyone know what the actual solution is?
The scenario is, the btree.extract works if the search parameter consists of just one indexed field and one value to search for. Add either another value or another field and the FS445:@vm:1:@vm:-1 error presents itself.
Sure, the equates tell me "Error Codes returned from IDX_Sets" but that doesn't help me.
At 01 NOV 2021 07:03PM Andrew McAuley wrote:
I've found myself receiving this same error from a btree.extract and I can't quite glean a resolution from this post.
Does anyone know what the actual solution is?
The scenario is, the btree.extract works if the search parameter consists of just one indexed field and one value to search for. Add either another value or another field and the FS445:@vm:1:@vm:-1 error presents itself.
Sure, the equates tell me "Error Codes returned from IDX_Sets" but that doesn't help me.
The fact that it works with a single column and fails with multiple, suggests, as does the error message, that the problem is with IDX_SETS. Have you run client set up on this workstation?
World leaders in all things RevSoft
At 01 NOV 2021 07:03PM Andrew McAuley wrote:
Post removed by author
At 01 NOV 2021 07:03PM Andrew McAuley wrote:
Post removed by author
At 01 NOV 2021 07:19PM Mark Boorman wrote:
Thanks Andrew.
I didn't know what a problem with idx_sets meant.
The problem is occurring on the clients server and they've been using the app for ten years or more so running the clientsetup doesn't stand out unless something has changed they haven't told us about.
Of course, that's possible.
I'll follow that line of questioning.
At 02 NOV 2021 06:30AM Andrew McAuley wrote:
Could be a permission change issue. Try running PROCMON at the time the error occurs and see what's going on.
World leaders in all things RevSoft