Main   Products   Offshore Outsourcing   Customers   Partners   ContactUs  
JDBC Databases
  HXTT Access v7.1
  HXTT Cobol v5.0
  HXTT DBF v7.1
  HXTT Excel v6.1
  HXTT Json v1.0
  HXTT Paradox v7.1
 
  Buy Now
  Support
  Download
  Document
  FAQ
  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 Paradox
Index files
Bjarne Pedersen
2006-11-15 02:54:30
Hi,

I have some big problem with a paradox database. Im pretty sure my problem is that there is a corrupt index file (its normally the problem), but how can i see which file i need to do a "reindex" on ?

My problem come when i fire this SQL:
SELECT * FROM Gemtofh WHERE "DebKre nummer" = '0461999027' AND "Art (F,K,T,O,L)"='A' AND "Dato" ='20061114'

If i dont use the "AND "Dato" ='20061114'" part then it do return a lot of rows that contains ""Dato" ='20061114'", but when i use the part in my sql it return nothing.

Is there somehow where i can see which file to reindex ??

Bjarne
Re:Index files
HXTT Support
2006-11-15 03:15:06
>but how can i see which file i need to do a "reindex" on ?
>Is there somehow where i can see which file to reindex ??
You can know all index expressions in those index files through most of JDBC tools, for instance, DbVisualizer, AquaDataStudio, Database Pilot, SQuirreL SQL Client, and so on.
But the simplest way is to run once "reindex all on Gemtofh;", and you can use java -Xmx256m ... if your Gemtofh table has a large number of data rows.

Re:Re:Index files
Bjarne Pedersen
2006-11-15 04:38:31
When i try "reindex all on Gemtofh" i this exception:


java.sql.SQLException: Failed to reindex file for Timeout Interrupted Exception: beyond 1000 msecs. to acquire table Gemtofh
at com.hxtt.global.SQLState.SQLException(Unknown Source)
at com.hxtt.sql.bl.a(Unknown Source)
at com.hxtt.sql.bl.a(Unknown Source)
at com.hxtt.sql.ag.a(Unknown Source)
at com.hxtt.sql.ag.a(Unknown Source)
at com.hxtt.sql.ag.execute(Unknown Source)
at com.hxtt.sql.admin.i.byte(Unknown Source)
at com.hxtt.sql.admin.i.access$000(Unknown Source)
at com.hxtt.sql.admin.i$1.actionPerformed(Unknown Source)
at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
at javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)
at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
at javax.swing.DefaultButtonModel.setPressed(Unknown Source)
at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown Source)
at java.awt.Component.processMouseEvent(Unknown Source)
at javax.swing.JComponent.processMouseEvent(Unknown Source)
at java.awt.Component.processEvent(Unknown Source)
at java.awt.Container.processEvent(Unknown Source)
at java.awt.Component.dispatchEventImpl(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Window.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.EventQueue.dispatchEvent(Unknown Source)
at java.awt.EventDispatchThread.pumpOneEventForHierarchy(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.run(Unknown Source)
Re:Re:Re:Index files
Bjarne Pedersen
2006-11-15 04:44:19
My fault, sorry!
I forget the -Xmx256m.

It is now working.

Thank you for your help!

Bjarne
Re:Re:Re:Re:Index files
HXTT Support
2006-11-15 06:11:52
>java.sql.SQLException: Failed to reindex file for Timeout Interrupted
> Exception: beyond 1000 msecs. to acquire table Gemtofh
It hasn't relation with -Xmx256m. Because reindex need to open Gemtofh table exclusively, and Timeout exception means that Gemtofh table is holding by other objects:) After you restart Admin, it can hold Gemtofh exclusively.

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 | Refund | Sitemap