Can anyone please explain what the arev SYSOBJ program IDX_SET is and what it is used for.
A client has had a process fall over with the following error message "IDX_SETS line 1505 B17 subscript value out of range" and I am not sure what it means. I think it has someing to do with indexing.
Also any sugestions on how to correct the problem would be welcome.
You are most probably dealing with a pre 3.12 AREV release. The solution is to upgrade to 3.12. Prior to that, there was a bug in indexing that caused that problem as well as several others, such as not returning the correct records in a SELECT. There is an article about it on my website in the FAQ section.
Many thanks Larry, I have looked at the document on youe site. However the arev version is already 3.12
IDX_SETS is an assembler routine that helps in the creation and building of indexes. Failure is sometimes associated with memory errors.
World Leaders in all things RevSoft
The error you are getting points to a memory error of sorts. I get that error B17 and have traced it to a system variable that has exceeded 64kb. In the particular instance the application was building an error variable that was about 32 bytes long. When the array hit 2100 records or so it burped with a B17 error.
Indexes are supposed to be able to exceed 64KB in ARev 3.12 so it looks like you will need to contact ARev.