Rocket jBASE

We are in testing a new server where we've installed jBASE 5.8.  We migrated everything from the old server running jBASE 5.7 and are concerned about indexes.

Although we rebuilt all the indexes the LIST-INDEX command does not display the indexes on jBASE 5.8

Using the INVOICE file as an example, on jBASE 5.7, "LIST-INDEX INVOICE" displays the following:

INDEX definitions for file INVOICE at 11:22:28  06 JUL 2023          PAGE    1

INDEX NAME LOCALE NAME SORT KEYS. LOOKUP.... INDEX DEFINITION...................

@18        C           AR         D2/        BY-AR OCONV(19,\D2/\)
@28        C           AR         D2/        BY-AR OCONV(32,\D2/\)
@29        C           AR         D2/        BY-AR OCONV(33,\D2/\)
@3         C           AL                    BY 2
@50        C           AL                    BY 50
A154       C           AL                    BY 154
A19        C           AR                    BY-AR 19
A210       C           AR                    BY-AR 210
A32        C           AR                    BY-AR 32
A33        C           AR                    BY-AR 33
W-BY       C           AL                    BY 22

 11 Records Listed

On jBASE 5.8, "LIST-INDEX INVOICE" displays nothing.

I rebuilt the indexes using the following command: rebuild-index -a INVOICE and it displayed the following and ran for quite some time.

Building index records in file '/jbase/accounts/MISIQ/jbase_root/INVOICE' ...

When I do a select on that file in 5.7 it returns as expected correctly.  The select on 5.7 does not return anything.

Any ideas on what I might have done wrong?

Thanks.

Jim,

There seems to be an incompatibility between jBASE 5.7.x indexes and jBASE 5.8.x indexes.

We would recommend that you delete the INVOICE]I file, rebuild the indexes and try again.

We assume that you already have a script for rebuilding indexes, but if you do not, there are utilities for both indexes and triggers;

PN5_60668 (rocketsoftware.com)

If this works, you would need to do the same for all other files with indexes

Mike

We are in testing a new server where we've installed jBASE 5.8.  We migrated everything from the old server running jBASE 5.7 and are concerned about indexes.

Although we rebuilt all the indexes the LIST-INDEX command does not display the indexes on jBASE 5.8

Using the INVOICE file as an example, on jBASE 5.7, "LIST-INDEX INVOICE" displays the following:

INDEX definitions for file INVOICE at 11:22:28  06 JUL 2023          PAGE    1

INDEX NAME LOCALE NAME SORT KEYS. LOOKUP.... INDEX DEFINITION...................

@18        C           AR         D2/        BY-AR OCONV(19,\D2/\)
@28        C           AR         D2/        BY-AR OCONV(32,\D2/\)
@29        C           AR         D2/        BY-AR OCONV(33,\D2/\)
@3         C           AL                    BY 2
@50        C           AL                    BY 50
A154       C           AL                    BY 154
A19        C           AR                    BY-AR 19
A210       C           AR                    BY-AR 210
A32        C           AR                    BY-AR 32
A33        C           AR                    BY-AR 33
W-BY       C           AL                    BY 22

 11 Records Listed

On jBASE 5.8, "LIST-INDEX INVOICE" displays nothing.

I rebuilt the indexes using the following command: rebuild-index -a INVOICE and it displayed the following and ran for quite some time.

Building index records in file '/jbase/accounts/MISIQ/jbase_root/INVOICE' ...

When I do a select on that file in 5.7 it returns as expected correctly.  The select on 5.7 does not return anything.

Any ideas on what I might have done wrong?

Thanks.