dBase on RDS Farm

[Bobby Kearan]

Moving a program from a VDI farm to a Session based farm and getting some odd results.

Program uses dBase Plus 11.

Randomly, users will get that a "Row is in use by another user. Retrying Lock", when doing a search they will be asked to open a database, or the results will be filled with the same row repeated.

Users run program on their RDS session, data is stored on a share drive.

Any ideas on how to mitigate the issues?

 

[Bobby Kearan]

More info : when searching by a field, it seems the database is locked, so it returns the last returned row, repeating for every visible row.

For example: searching for Stock number "1150" ( which is a Soup by Betty Crocker and we have 56 in stock) the return will be like:

1100 Soup Campbells 42
1100 Soup Campbells 42
1100 Soup Campbells 42
1100 Soup Campbells 42
1100 Soup Campbells 42
1100 Soup Campbells 42
1100 Soup Campbells 42
1100 Soup Campbells 42
1100 Soup Campbells 42
1100 Soup Campbells 42

(1100 was the last result on a different search)