Main   Products   Offshore Outsourcing   Customers   Partners   ContactUs  
JDBC Databases
  HXTT Access v7.1
  HXTT Cobol v5.0
  HXTT DBF v7.1
 
  Buy Now
  Support
  Download
  Document
  FAQ
  HXTT Excel v6.1
  HXTT Paradox v7.1
  HXTT PDF v2.0
  HXTT Text(CSV) v7.1
  HXTT Word v1.1
  HXTT XML v4.0
Offshore Outsourcing
Free Resources
  Firewall Tunneling
  Search Indexing Robot
  Conditional Compilation
  Password Recovery for MS Access
  Password Recovery for Corel Paradox
  Checksum Tool for MD5
  Character Set Converter
  Pyramid - Poker of ZYH
   
   
   
Heng Xing Tian Tai Lab of Xi'an City (abbr, HXTT)

HXTT DBF
Broken inserts
Kevin Penrose
2020-10-16 08:13:58.0
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
Re:Broken inserts
HXTT Support
2020-10-16 21:02:06.0
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.
Re:Re:Broken inserts
Kevin M Penrose
2020-10-20 07:20:54.0
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?

Re:Re:Re:Broken inserts
HXTT Support
2020-10-22 00:18:58.0
You can zip it and email support@hxtt.com

Search Key   Search by Last 50 Questions




Google
 

Email: webmaster@hxtt.com
Copyright © 2003-2019 Heng Xing Tian Tai Lab of Xi'an City. | All Rights Reserved. | Privacy | Legal | Sitemap