If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > Pervasive.SQL > The chunk offset is too big(Btrieve Error 103)

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old
Registered User
 
Join Date: Nov 2007
Posts: 3
The chunk offset is too big(Btrieve Error 103)

I am trying to replace part of description text in a table by running this query:

UPDATE job_operations SET description = REPLACE(description, '1234', '5678') WHERE description LIKE '%1234%'

It ends with error:
"[LNA][Pervasive][ODBC Engine Interface][Data Record Manager]The chunk offset is too big(Btrieve Error 103)"
The column description is defined as Char(30) and my version of Pervasive is 9.52.

I can't find solution anywhere, so I am trying my luck here. Thank you very much for any help.
Reply With Quote
  #2 (permalink)  
Old
Registered User
 
Join Date: Dec 2001
Posts: 1,071
Usually that means that the DDFs don't match the data files.
Most of the time it's because there's a variable length field in the data file but it's not defined in the DDFs.
Are these files/DDFs from a third party vendor? If so, you should contact them to get updated DDFs.
__________________
Mirtheil Software
Certified Pervasive Developer
Certified Pervasive Technician
Custom Btrieve/VB development
http://www.mirtheil.com
I do not answer questions by email. Please post on the forum.
Reply With Quote
  #3 (permalink)  
Old
Registered User
 
Join Date: Oct 2008
Posts: 2
Hi There.
I'm currently on Pervasive version 9.60. When I try edit a field in an existing database I get the following error:
'[LNA][Pervasive][ODBC Engine Interface][Data Record manager] The chunk offset is too big[BTrieve Error 103]'
And cannot save my changes. However, if I install the same data on another machine I do not get this error! Its using the same DDF's saved within the database. Are there any other setting that I can check? I have tried uninstalling Pervasive as well as the 3rd party product (Softline Pastel) and I still get this error when I reinstall.
PLEASE HELP!!!
Reply With Quote
  #4 (permalink)  
Old
Registered User
 
Join Date: Dec 2001
Posts: 1,071
Casey,
As I stated before:
Quote:
Usually that means that the DDFs don't match the data files.
Most of the time it's because there's a variable length field in the data file but it's not defined in the DDFs.
Are these files/DDFs from a third party vendor? If so, you should contact them to get updated DDFs.
Reinstalling PSQL won't help in this case. It's not a configuration or invalid install issue.

You should start a new thread on something like this.
__________________
Mirtheil Software
Certified Pervasive Developer
Certified Pervasive Technician
Custom Btrieve/VB development
http://www.mirtheil.com
I do not answer questions by email. Please post on the forum.
Reply With Quote
  #5 (permalink)  
Old
Registered User
 
Join Date: Oct 2008
Posts: 2
BTrieve Error 103

Hi There,

Thanks for your reply.

I have managed to correct the error by doing the following:
1) Un-install 3rd Party product
2) Un-install Pervasive
3) Backup Pervasive Regedit files
4) Delete Pervasive Regedit files
5) Restart machine
6) Re-install 3rd Party product & Pervasive

All works fine and I'm able to amend required files within Pervasive.

Thanks anyhow!!!
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On