[RikoOnWeb]

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.

[mirtheil]

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.

[CaseyD]

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!!!

[mirtheil]

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.

[CaseyD]

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!!!