Hi,
In the last several weeks I have received reports from two customers
about a problem with some of our software and I am stumped as to what
is causing it. The problem only occurs on a screen that accesses the
"People" portion of our valentina database (We are using the XCMD with
Revolution and the clients are running XP). Our software only reads
from the database in the software, no writes at all. Both clients are
running Windows XP on P4 with > 3 GHZ processors. One computer has 2
GB of RAM, the other has 4GB of RAM. One is a Dell, the other is
AlienWare area-51.
I had one of the clients send me his database and a diagnose shows that
the "People" table is becoming corrupted on his computer. Below I've
included a diagnose from the db we shipped with the product followed by
a diagnose of the table form the db the customer sent me. I also
included an XML description of the table.
The Biography field is saying that it has orphan segments. I remember
running into this problem during development if I indexed a field by
words but didn't check the index box in the Valentina Carbon app.
Does anybody have any idea what might be causing such a problem? I'm
wondering if perhaps the >= 2GB of RAM might be the culprit since we
have few if any customers that would have that much RAM installed. It
is the only thing that really sticks out.
Thanks for any insight anyone has.
--
Trevor DeVore
Blue Mango Multimedia
trevor at mangomultimedia DOT com
===============================
========== ORIGINAL DIAGNOSE OF DATABASE ============
===============================
************************************************************************
* BaseObject: "People"
************************************************************************
All right.
-----> Field: "SectionAssociations' of type Text
All right.
-----> Field: "FirstName' of type VarChar
All right.
-----> Field: "Biography' of type Text
All right.
-----> Field: "Birth' of type VarChar
All right.
-----> Field: "Death' of type VarChar
All right.
-----> Field: "Notes' of type Text
All right.
-----> Field: "LastName' of type VarChar
All right.
-----> Field: "ID' of type ULong
All right.
===============================
========== DIAGNOSE OF DATABASE FROM CLIENTS COMPUTER ============
===============================
************************************************************************
* BaseObject: "People"
************************************************************************
Problems found.
-----> Field: "SectionAssociations' of type Text
All right.
-----> Field: "FirstName' of type VarChar
All right.
-----> Field: "Biography' of type Text
Problems found!
(!) Minor problem: exists 17 orphan segments.(indicate mistake in
algorithm.)
-----> Field: "Birth' of type VarChar
All right.
-----> Field: "Death' of type VarChar
All right.
-----> Field: "Notes' of type Text
All right.
-----> Field: "LastName' of type VarChar
All right.
-----> Field: "ID' of type ULong
All right.
===============================
========== XML DESCRIPTION OF TABLE ============
===============================
<BaseObjectDesc Name="People">
<FieldCount>8</FieldCount>
<FieldDesc Name="SectionAssociations">
<Type>Text</Type>
<Indexed>0</Indexed>
<Unique>0</Unique>
<Nullable>0</Nullable>
<IndexByWords>0</IndexByWords>
<Compressed>0</Compressed>
<Language>ASCII</Language>
<SegmentSize>1024</SegmentSize>
</FieldDesc>
<FieldDesc Name="FirstName">
<Type>VarChar</Type>
<Indexed>1</Indexed>
<Unique>0</Unique>
<Nullable>0</Nullable>
<IndexByWords>0</IndexByWords>
<Compressed>0</Compressed>
<MaxLength>256</MaxLength>
<Language>ASCII</Language>
</FieldDesc>
<FieldDesc Name="Biography">
<Type>Text</Type>
<Indexed>1</Indexed>
<Unique>0</Unique>
<Nullable>0</Nullable>
<IndexByWords>1</IndexByWords>
<Compressed>0</Compressed>
<Language>ASCII</Language>
<SegmentSize>1024</SegmentSize>
</FieldDesc>
<FieldDesc Name="Birth">
<Type>VarChar</Type>
<Indexed>0</Indexed>
<Unique>0</Unique>
<Nullable>0</Nullable>
<IndexByWords>0</IndexByWords>
<Compressed>0</Compressed>
<MaxLength>256</MaxLength>
<Language>ASCII</Language>
</FieldDesc>
<FieldDesc Name="Death">
<Type>VarChar</Type>
<Indexed>0</Indexed>
<Unique>0</Unique>
<Nullable>0</Nullable>
<IndexByWords>0</IndexByWords>
<Compressed>0</Compressed>
<MaxLength>256</MaxLength>
<Language>ASCII</Language>
</FieldDesc>
<FieldDesc Name="Notes">
<Type>Text</Type>
<Indexed>1</Indexed>
<Unique>0</Unique>
<Nullable>0</Nullable>
<IndexByWords>1</IndexByWords>
<Compressed>0</Compressed>
<Language>ASCII</Language>
<SegmentSize>1024</SegmentSize>
</FieldDesc>
<FieldDesc Name="LastName">
<Type>VarChar</Type>
<Indexed>1</Indexed>
<Unique>0</Unique>
<Nullable>0</Nullable>
<IndexByWords>0</IndexByWords>
<Compressed>0</Compressed>
<MaxLength>256</MaxLength>
<Language>ASCII</Language>
</FieldDesc>
<FieldDesc Name="ID">
<Type>ULong</Type>
<Indexed>1</Indexed>
<Unique>1</Unique>
<Nullable>0</Nullable>
<IndexByWords>0</IndexByWords>
<Compressed>0</Compressed>
</FieldDesc>
</BaseObjectDesc>
_______________________________________________
Valentina mailing list
Valentina@lists.macserve.net
http://lists.macserve.net/mailman/listinfo/valentina
©2005 Trevor DeVore |
