Btree index error (OpenInsight 32-bit)
At 25 JUL 2022 08:52:21PM cmeyer wrote:
I have a employee_details file with a 2 part key, Employee_No*Date.
The employee_no has a btree index.
List EMPLOYEE_DETAILS with EMPLOYEE_NO = 231 → No records listed (WRONG)
List EMPLOYEE_DETAILS with EMPLOYEE_NO = 7 → 4 records listed (CORRECT)
Remove the EMPLOYEE_NO btree index
List EMPLOYEE_DETAILS with EMPLOYEE_NO = 231 → 4 records listed (CORRECT)
Rebuilt the index without success.
Ran client_setup No change.
Copied data to my laptop→ No problem 4 records selected (CORRECT)
How can I tell if the OI9.4 patch V6 has been applied at the client.
Client running OI9.4.0 with UD 4.6.0
Any advice would be grateful.
Chris
At 26 JUL 2022 12:07AM Donald Bakke wrote:
I have a employee_details file with a 2 part key, Employee_No*Date.
The employee_no has a btree index.
List EMPLOYEE_DETAILS with EMPLOYEE_NO = 231 → No records listed (WRONG)
List EMPLOYEE_DETAILS with EMPLOYEE_NO = 7 → 4 records listed (CORRECT)
Remove the EMPLOYEE_NO btree index
List EMPLOYEE_DETAILS with EMPLOYEE_NO = 231 → 4 records listed (CORRECT)
Rebuilt the index without success.
Ran client_setup No change.
Copied data to my laptop→ No problem 4 records selected (CORRECT)
How can I tell if the OI9.4 patch V6 has been applied at the client.
Client running OI9.4.0 with UD 4.6.0
Any advice would be grateful.
Chris
Is CFG_IDX_SETS configured the same in both systems?
At 27 JUL 2022 03:25AM cmeyer wrote:
Thanks Don, but both systems have the same CFG_IDX_SETS.
Tried setting field 2 to IDX_SETS1 but did NOT fix the btree issue.
Chris
At 27 JUL 2022 03:28AM Andrew McAuley wrote:
It is a longshot, but what are the contents of upgrade.log?
World leaders in all things RevSoft
At 27 JUL 2022 03:43AM cmeyer wrote:
I have asked Richard for the authorization codes to upgrade the client from from OI9.4 to OI9.4.6 and upgrade the UD from UD4.6 to UD4.7.2 and hope that will fix the issue.
Chris