Hi,
I downloaded the latest version of HXTT_DBF 7.1.015 dated 10/15/2020, and while reads an updates are working fine (VFP database), we are getting errors on inserts.
The error is Error: 9215, which when looked up gives Error:9215, Severity: 16, Query notification delivery failed to encode message. Delivery failed for notification ‘%.*ls’.
Can you verify?
--- Kevin
|
Your 9215 error should be from Service Broker of SQL Server.
9215 16 Query notification delivery failed to encode message. Delivery failed for notification '%.*ls'.
You can try "reindex all on thatTable" to see whether your issue disappear.
|
We reindexed all tables and the error persisted. We were able to isolate the error to one table. When we removed the indexes from that table, we are able to do inserts. We added indexes back one by one, and were able to insert until we added an index on a particular column (ponum). We then get the following error messages:
Error: Failed to insert a new record into table mmshifts:Failed to insert new record into table mmshifts because of duplicate key or corrupted index file:Please reindex index expression ponum: Failed to find a child node at:703488 in his parent node.
SQLState: 23000
ErrorCode: 143360
Error: Failed to insert new record into table mmshifts because of duplicate key or corrupted index file:Please reindex index expression ponum: Failed to find a child node at:703488 in his parent node.
SQLState: 23000
ErrorCode: 143360
Error: Please reindex index expression ponum: Failed to find a child node at:703488 in his parent node.
SQLState: 23000
ErrorCode: 143360
The index on that column is a regular index. Is there a way to send you the applicable tables?
|
You can zip it and email support@hxtt.com
|
Main
webmaster@hxtt.com