Pervasive PSQL Rebuild Problem

[Bernie Hunt]

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

[nelsonsoft]

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

[Leonard]

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"

Post by Bernie Hunt
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

[Bernie Hunt]

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

Post by Leonard
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"

Post by Bernie Hunt
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