Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

ADS data dictionary and index problem

6 posts in Xbase++ Last posting was on 2008-03-19 09:59:14.0Z
Toma? Grom Posted on 2008-02-11 11:00:13.0Z
From: "Toma? Grom" <tomaz.grom@siol.net>
Newsgroups: Advantage.Xbase++
Subject: ADS data dictionary and index problem
Date: Mon, 11 Feb 2008 12:00:13 +0100
Lines: 47
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: 89.212.202.125
Message-ID: <47b029bd@solutions.advantagedatabase.com>
X-Trace: 11 Feb 2008 03:55:57 -0700, 89.212.202.125
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!89.212.202.125
Xref: solutions.advantagedatabase.com Advantage.Xbase++:920
Article PK: 1140768

My customer have ADS server installed for about 4 months.

Mostly he is astonished about response acceleration, because FOXCDX in LAN
and 8 clients was really poor in comparison to ADS.

But lately it happend second time, that the app does not show any data any
more.

I found, it is index problem. When I looked throuh ARC utility, there is a
data table in the dictionary, but no index order, except natural one.

Index file is otherwise present in the same directory as corresponding data
table.

When trying to reindex with my app with
(nRet:=DllCall( PAdsDllHandle, DLL_STDCALL, "AdsCreateIndex",;)

progress bar shows normal speed, while creating first tag, all others are
made in a second.

That is a sign for me, that something is wrong. Namely following tags are
are normaly produced quicker, than first one, but still not in a moment.

If I look the problematic table again with ARC, there is no index in the
data dictionary.

Then I need to remove such table from the data dictionary and append it
again. After reindexing it is all right.

It does not happen to every data table in my database. Only to some. Not
allways to same tables.

My question is:
1. What could possibly happen to jumble the ADS server to loose or corrupt
index ?
2. Why the ads procedure does not complyin while creating new index, but at
the end index is not created.?
3. Is anybody encountered symilar problem in the past ?
4. Is it possible, that there could be phisical memory problem on the server
or operating system problem (MS SRV2000) or any interference of some other
software to ruin the database occasionaly ?

Best regards

Toma?


Toma? Grom Posted on 2008-02-11 11:42:35.0Z
From: "Toma? Grom" <tomaz.grom@siol.net>
Newsgroups: Advantage.Xbase++
References: <47b029bd@solutions.advantagedatabase.com>
Subject: Re: ADS data dictionary and index problem
Date: Mon, 11 Feb 2008 12:42:35 +0100
Lines: 26
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: 89.212.202.125
Message-ID: <47b033a6@solutions.advantagedatabase.com>
X-Trace: 11 Feb 2008 04:38:14 -0700, 89.212.202.125
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!89.212.202.125
Xref: solutions.advantagedatabase.com Advantage.Xbase++:921
Article PK: 1140769

One more observartion.

When I detech the table from data dictionary and then append it again, then
reindex, whether with my program or ARC reindex process, everything seems to
work fine. There is no error or warning.

But still some requests on that table from my program are correct and some
not.

Only after I detech the table form dictionary, phisicaly delete the .CDX
file, attach the table again and create a completely new index file, it is
all right again.

So neither ADS, neither ARC neither indexing or reindexing process itself
does not encounter any problem, but still the problem remains somehow in
some extent inside the index (.CDX) file.

Ads if of version 8.1.

Very strange ?

Best regards

Toma?


Toma? Grom Posted on 2008-02-11 19:42:02.0Z
From: "Toma? Grom" <tomaz.grom@siol.net>
Newsgroups: Advantage.Xbase++
References: <47b029bd@solutions.advantagedatabase.com> <6c56a92238a628ca3ac5c8af6813@devzone.advantagedatabase.com>
Subject: Re: ADS data dictionary and index problem
Date: Mon, 11 Feb 2008 20:42:02 +0100
Lines: 78
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: 89.212.202.125
Message-ID: <47b0a409@solutions.advantagedatabase.com>
X-Trace: 11 Feb 2008 12:37:45 -0700, 89.212.202.125
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!89.212.202.125
Xref: solutions.advantagedatabase.com Advantage.Xbase++:923
Article PK: 1140770


> Not necessarily. ADS must do a complete table scan to build an index.
> After the first index, the table may be completely in memory cache and
> allow significantely faster index builds.

Yes, that is true. For example first tag of 10 takes 20 seconds and then
every next one about 5 seconds. But that happens in normal circumstances
when index remains good and stable.
But my obsevation talks about ubnormal index creatin, when no error occures,
first tag is produced 20 seconds and than all other 9 one secon all
together.
That is an iformation from me to ADS developement team to determine, what is
going on. That must be some kind of bug.
When I look afterwards through ARC utility into that table, there is no
index present. Only natural order is available, although the index file is
present beside the .DBF in the same map.

> It sounds like you are sometimes using the table via the database and
> sometimes as a free table. Once a table is part of a database, you should
> not perform any operations against the table directly.

No, as far as I know. Those tables are part of my customer database, but are
connected to dictionary, placed on server any nobody do not know, where they
resides and how to approach them directly. It there would be an uknown
itruder to ruin the header of a table or index, can I examine the header
somehow ?

> Show the procedure. I doubt that ADS created an index only to dispose of
> it.

SQLProgressCallBack(0, ThreadID())
IF lUnique
nAceDllCallRet := DllCall( PAdsDllHandle, DLL_STDCALL, "AdsCreateIndex",
nTableHandle, cFileName+".cdx", cTagName, Strtran(cStructure,Chr(39),
Chr(34)), Strtran(cFor,Chr(39),Chr(34)), , ADS_COMPOUND + ADS_UNIQUE,
@nIndexHandle)
ELSE
nAceDllCallRet := DllCall( PAdsDllHandle, DLL_STDCALL, "AdsCreateIndex",
nTableHandle, cFileName+".cdx", cTagName, Strtran(cStructure,Chr(39),
Chr(34)), Strtran(cFor,Chr(39),Chr(34)), , ADS_COMPOUND, @nIndexHandle)
ENDIF
IF nAceDllCallRet < 0
DisplayWarn(oDialog,{"Warning ........: " +
Alltrim(Str(nAceDllCallRet))}, 2)
ENDIF

I can reindex it even with ARC reindex process. I only need to delete the
table from data dictionary and append it again without phisically delete the
.CDX file.
Then ARC sees the tags, can reindex them, but they are only partly usable,
as I allready mentioned. I can get some data from some parts of my program,
but from others not. On the other hand I can see the data in every tag
position frorm the ARC. No index tag acctualy hide them completely, as it
can be suspected. Really strange.
I have the other customer, that runs the same program on SBS2003 few months
longer, than problematic one, but with no problem.

> Finally, don't forget that your recent character set change on the ADS
> server requires all indexes to be rebuilt by ADS.

Yes, thanks.
But that was on my domestic test database. Really do not know, how it
happens, that setting was wrong.

In my customers database, that is under discussion now, I did not make any
collation or other character change. When trouble appears, I only need to
additionaly phisicaly delete the index and append the database back to the
dictionary, create a new one and after that it works regularity again.
It was all right for months, only last month it happened twice, so I
suspected the memory failure or something.

Than you Rodd

Best regards

Toma?


Toma? Grom Posted on 2008-02-15 15:03:20.0Z
From: "Toma? Grom" <tomaz.grom@siol.net>
Newsgroups: Advantage.Xbase++
References: <47b029bd@solutions.advantagedatabase.com> <6c56a92238a628ca3ac5c8af6813@devzone.advantagedatabase.com> <47b0a409@solutions.advantagedatabase.com>
Subject: Re: ADS data dictionary and index problem
Date: Fri, 15 Feb 2008 16:03:20 +0100
Lines: 7
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: 89.212.202.125
Message-ID: <47b5a8b4@solutions.advantagedatabase.com>
X-Trace: 15 Feb 2008 07:59:00 -0700, 89.212.202.125
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!89.212.202.125
Xref: solutions.advantagedatabase.com Advantage.Xbase++:924
Article PK: 1140771

It has happened again ?

Best regards

Toma?


Lev Pinskiy Posted on 2008-03-04 20:46:11.0Z
Date: Tue, 04 Mar 2008 15:46:11 -0500
From: Lev Pinskiy <levp@rossusa.com>
Organization: Ross Computer Systems, Inc.
User-Agent: Thunderbird 2.0.0.12 (Windows/20080213)
MIME-Version: 1.0
Newsgroups: Advantage.Xbase++
Subject: Re: ADS data dictionary and index problem
References: <47b029bd@solutions.advantagedatabase.com> <6c56a92238a628ca3ac5c8af6813@devzone.advantagedatabase.com> <47b0a409@solutions.advantagedatabase.com>
In-Reply-To: <47b0a409@solutions.advantagedatabase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 8bit
NNTP-Posting-Host: 72.43.191.100
Message-ID: <47cdb36e@solutions.advantagedatabase.com>
X-Trace: 4 Mar 2008 13:39:10 -0700, 72.43.191.100
Lines: 46
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!72.43.191.100
Xref: solutions.advantagedatabase.com Advantage.Xbase++:926
Article PK: 1140773

I have a similar issue with some of our ADS-enabled customers.

On average once a week (but sometimes several days in a row), some
updated/appended records would be missing from index keys, but
"magically appear" 2 hours later!

However, if index file is deleted and rebuilt, all is well again
(without 2 hour wait).

One such customer has ADS 7.1, another ADS 8.1.
Both DO NOT have a data dictionary.
I do think that they both have MS SBS 2003 - is there something running
on SBS that could damage index files??

Naturally, I checked error- and event logs (Windows and ADS), and both
are clean.

Another coincidence is that we seem to have started to have this issue
ever since I added more tags to the compound index file (CDX format).
It went from 4 to 7 tags, but this still should be well below the limit,
right? Does the total key length matter maybe?

I would understand a corrupted index file, but it appears to "heal"
itself after 2 hours - how does one explain that? Can collation
differences create such situation (then why not every day)?

Any guesses are really appreciated...

--
Lev Pinskiy

Toma? Grom wrote:
[snip]
> Then ARC sees the tags, can reindex them, but they are only partly usable,
> as I allready mentioned. I can get some data from some parts of my program,
> but from others not. On the other hand I can see the data in every tag
> position frorm the ARC. No index tag acctualy hide them completely, as it
> can be suspected. Really strange.
[snip]
> In my customers database, that is under discussion now, I did not make any
> collation or other character change. When trouble appears, I only need to
> additionaly phisicaly delete the index and append the database back to the
> dictionary, create a new one and after that it works regularity again.
> It was all right for months, only last month it happened twice, so I
> suspected the memory failure or something.


Tomaz Grom Posted on 2008-03-19 09:59:14.0Z
From: "Tomaz Grom" <tomaz.grom@siol.net>
Newsgroups: Advantage.Xbase++
References: <47b029bd@solutions.advantagedatabase.com> <6c56a92238a628ca3ac5c8af6813@devzone.advantagedatabase.com> <47b0a409@solutions.advantagedatabase.com> <47cdb36e@solutions.advantagedatabase.com>
Subject: Re: ADS data dictionary and index problem
Date: Wed, 19 Mar 2008 10:59:14 +0100
Lines: 9
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: 89.212.202.125
Message-ID: <47e0e2f3@solutions.advantagedatabase.com>
X-Trace: 19 Mar 2008 03:54:59 -0700, 89.212.202.125
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!89.212.202.125
Xref: solutions.advantagedatabase.com Advantage.Xbase++:932
Article PK: 1140779

Thank you, Lev Pinskiy,

It seems we are alone it this situation.

My problem appears on SRV2000, but on SBS2003 not. But shorely this is not
the case, but maybe some other software, or hardware.
We also checked the events log with no success.