Results 1 to 5 of 5
  1. #1
    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.

  2. #2
    Join Date
    Dec 2001
    Posts
    1,075
    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.

  3. #3
    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!!!

  4. #4
    Join Date
    Dec 2001
    Posts
    1,075
    Casey,
    As I stated before:
    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.

  5. #5
    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!!!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •