dbTalk Databases Forums  

Pervasive PSQL Rebuild Problem

comp.databases.btrieve comp.databases.btrieve


Discuss Pervasive PSQL Rebuild Problem in the comp.databases.btrieve forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Bernie Hunt
 
Posts: n/a

Default Pervasive PSQL Rebuild Problem - 02-13-2006 , 09:32 AM






I have a table that generates a "Numeric value out of range" error when I
try to open it in the PSQL Control Center. All the other tables are fine.
I'm trying to run a Rebuild and I keep getting the error;

Rebuild-82: Login to database failed. MicroKernel status 3103 was returned.

I found some references to problem with network attached drives, so I moved
all the data onto the local workstation. Still the same results.

Any idea on how to fix this?

The bigger issue it corrected the Numberic value out of range error, so if
I'm headed off in a wrong direction, advice on that would also be helpful.

Thanks!
Bernie





Reply With Quote
  #2  
Old   
nelsonsoft
 
Posts: n/a

Default Re: Pervasive PSQL Rebuild Problem - 02-14-2006 , 01:15 PM






It sounds like you may have some binary data that is not correct for
how it is defined in the DDF files. You can download BtSearch32 at
www.nssdd.com and review the data types and view the data to see if you
see any problems.

Gil


Reply With Quote
  #3  
Old   
Leonard
 
Posts: n/a

Default Re: Pervasive PSQL Rebuild Problem - 02-16-2006 , 08:59 AM



Running rebuild will not change the "Numeric value out of range"
message. The rebuild utility will only reorginize the data that is i
the file, it will not change any of the values in the data. It also
does not operate at the SQL level whihc would be where that error
message is coming from.

Gil is ocrrect is saying the the DDFs or Data Definition Files which
is the SQL schema for what physically exists in the Btrieve file
probably does not properly match the data type that is in the Btrieve
file. Although with certain data types is it possible that the DDFs
are correct and that the data in the file is a value that is not valid
for the data type.

Leonard

On Mon, 13 Feb 2006 10:32:33 -0500, "Bernie Hunt"
<bhunt (AT) optonline (DOT) net> wrote:

Quote:
I have a table that generates a "Numeric value out of range" error when I
try to open it in the PSQL Control Center. All the other tables are fine.
I'm trying to run a Rebuild and I keep getting the error;

Rebuild-82: Login to database failed. MicroKernel status 3103 was returned.

I found some references to problem with network attached drives, so I moved
all the data onto the local workstation. Still the same results.

Any idea on how to fix this?

The bigger issue it corrected the Numberic value out of range error, so if
I'm headed off in a wrong direction, advice on that would also be helpful.

Thanks!
Bernie





Reply With Quote
  #4  
Old   
Bernie Hunt
 
Posts: n/a

Default Re: Pervasive PSQL Rebuild Problem - 02-23-2006 , 02:03 PM



Thanks to both of you. I found a proper set of DDF files. They were for a
Lytec 2001 version that was mismarked as the 1998 or 1999 version. I
forget. With the corrected DDF files, it worked like a charge.

Thanks guys!

Bernie


Leonard <lharvey (AT) austin (DOT) rr.com> wrote in
news:vr49v1phim04dlb5jqgskb8cjarg3n6c11 (AT) 4ax (DOT) com:

Quote:
Running rebuild will not change the "Numeric value out of range"
message. The rebuild utility will only reorginize the data that is i
the file, it will not change any of the values in the data. It also
does not operate at the SQL level whihc would be where that error
message is coming from.

Gil is ocrrect is saying the the DDFs or Data Definition Files which
is the SQL schema for what physically exists in the Btrieve file
probably does not properly match the data type that is in the Btrieve
file. Although with certain data types is it possible that the DDFs
are correct and that the data in the file is a value that is not valid
for the data type.

Leonard

On Mon, 13 Feb 2006 10:32:33 -0500, "Bernie Hunt"
bhunt (AT) optonline (DOT) net> wrote:

I have a table that generates a "Numeric value out of range" error
when I try to open it in the PSQL Control Center. All the other tables
are fine. I'm trying to run a Rebuild and I keep getting the error;

Rebuild-82: Login to database failed. MicroKernel status 3103 was
returned.

I found some references to problem with network attached drives, so I
moved all the data onto the local workstation. Still the same results.

Any idea on how to fix this?

The bigger issue it corrected the Numberic value out of range error,
so if I'm headed off in a wrong direction, advice on that would also
be helpful.

Thanks!
Bernie






Reply With Quote
Reply




Thread Tools
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

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.