Binary dump issues

[paulsg]

When trying to binary dump a table getting the message below: -

19:45:41 Usr 10: Using index 97 for dump of table <tablename>. (6101)
19:45:41 Usr 10: Record not found 3384743, return = -1. (5107)

On roughly 6 database tables.

I have run an idxfix taking option 3 still having the same problem.

Any help/assistance would be appreciated.

 

[TomBascom]

When trying to binary dump a table getting the message below: -

19:45:41 Usr 10: Using index 97 for dump of table <tablename>. (6101)
19:45:41 Usr 10: Record not found 3384743, return = -1. (5107)

On roughly 6 database tables.

I have run an idxfix taking option 3 still having the same problem.

Any help/assistance would be appreciated.

Can you dump successfully with an alternate index? (Add "-index idx#" to the proutil command...)

 

[paulsg]

Thanks Tom, I will give that a go and let you know how I get on.

 

[paulsg]

Tom - thanks for your assistance. Unfortunately the proutil dbname -C dump tablename useindex did not resolve the issue.

I have eventually resolved the issue. I believe that the structure file was corrupted. Do not know how. I recreated the structure file and now all is OK.

Thanks again.

 

[Casper]

you mean that prostrct list helped you to get rid of the 5107 error? That is hard to believe for me, what did you exactly do?

Casper.