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.

7041 Errors when creating indexes on Netware 6.5

4 posts in ,  NetWareNetworking Xbase++ Last posting was on 2006-05-22 15:38:00.0Z
Kevin Brown Posted on 2006-05-18 13:57:12.0Z
From: "Kevin Brown" <kevin@esc.co.uk>
Newsgroups: Advantage.NetWare,Advantage.Networking,advantage.Xbase++
Subject: 7041 Errors when creating indexes on Netware 6.5
Date: Thu, 18 May 2006 14:57:12 +0100
Lines: 580
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="----=_NextPart_000_0006_01C67A8B.5870D430"
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2869
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2869
NNTP-Posting-Host: 217.35.101.18
Message-ID: <446c7c68@solutions.advantagedatabase.com>
X-Trace: 18 May 2006 07:53:44 -0700, 217.35.101.18
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!217.35.101.18
Xref: solutions.advantagedatabase.com Advantage.NetWare:2170 Advantage.Networking:604 Advantage.Xbase++:531
Article PK: 1131608

Hi,
 
We are using ADS 7.1 and XBase 1.82 in an XPSP2 Client, Netware 6.5 Server environment.
 
We are seeing a fair bit of instability (dbseeks failing 1 in 50 times & the like) so have taken to scrutinising the ADS error log and clearing any problems we find. The problem below is one we cannot seem to find any real reason or rhyme for. If anyone can help I'd be grateful
 
We are copying a table (with COPY FILE) to another directory and then creating two temporary indexes on those files. Every time we create a temporary index like this we get five errors in the ADS error log similar to this...
 
DATE TIME THREAD_NUM ERR_CLASS ERROR_CODE ADS_SOURCE SRC_LINE CNNCT_NUM CNNCT_NAME FILENAME ADS_VER ENVIRONMNT OS_VERSION 03/05/06 16:42:28 527 0 1 resrc.c 1162     JUMP:DATA\TEMP\GAT_REVU.DBF 7.1.0.1 NetWare 5.70 03/05/06 16:42:28 527 0 255 resrc.c 1163     JUMP:DATA\TEMP\GAT_REVU.DBF 7.1.0.1 NetWare 5.70 03/05/06 16:42:28 527 1003 7041 index.c 3587     JUMP:DATA\TEMP\GAT_REVU.DBF 7.1.0.1 NetWare 5.70 03/05/06 16:42:28 527 1003 7041 index.c 7106 0   JUMP:DATA\TEMP\GAT_REVU.DBF 7.1.0.1 NetWare 5.70 03/05/06 16:42:28 527 1003 7041 index.c 564 0   JUMP:DATA\TEMP\GAT_REVU.DBF 7.1.0.1 NetWare 5.70
 
If we copy the file to the SAME directory with a different name and then create the indexes in this directory too we don't get these messages. To do this system wide would be a challange to say the very least so we are looking for a more easily implemented solution or at least to understand WHY this is happening.
 
The  code creating this error message sequence is the INDEX TO command in the following code snippet...
 
 
COPY FILE (m->sys_data + "FIN_REVU.DBF") TO ;
                (m->temp_data + m->sys_user + "_REVU.DBF")
index1 = m->temp_data + m->sys_user + "_rev1.IDX"
INDEX ON rec_type + STR(group,3,1) TO &index1
SET INDEX TO &index1 
 
In this code ....
m->sys_data = "\\FS1\JUMP\DATA\ "
m->temp_data = "\\FS1\JUMP\DATA\TEMP\ "
m->sys_user = "GAT"
rec_type & group are fields
 
As I say if we make m->temp_data = m->sys_data we get no errors.
 
Any guidance appreciated!
 
Kevin Brown
 


Peter Funk <pfunk Posted on 2006-05-18 14:35:08.0Z
Date: Thu, 18 May 2006 14:35:08 +0000 (UTC)
Message-ID: <864d0bcb3aa28c8486d1adbb269@devzone.advantagedatabase.com>
From: Peter Funk <pfunk@_no_spam_sybase.com>
Subject: Re: 7041 Errors when creating indexes on Netware 6.5
Newsgroups: Advantage.NetWare,Advantage.Networking,Advantage.Xbase++
References: <446c7c68@solutions.advantagedatabase.com>
MIME-Version: 1.0
Content-Transfer-Encoding: 8bit
Content-Type: text/plain; charset=iso-8859-1; format=flowed
X-Newsreader: JetBrains Omea Reader 936.5
NNTP-Posting-Host: 10.24.38.105
X-Trace: 18 May 2006 08:31:37 -0700, 10.24.38.105
Lines: 13
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!10.24.38.105
Xref: solutions.advantagedatabase.com Advantage.NetWare:2171 Advantage.Networking:605 Advantage.Xbase++:532
Article PK: 1131606

Hello Kevin,
Does the index creation work? The ACE client will first attempt to open
the index before creating it. This is to prevent overwriting an existing
index if it is not open. We've already limited the cases in which this is
done (based on index type, rights checking setting, path of the new index,
etc), but in some situations we do this to be safe. If the index creation
is working, you can ignore those 5 error entries.

Regards,
Peter Funk
Advantage R&D


Kevin Brown Posted on 2006-05-19 10:40:27.0Z
From: "Kevin Brown" <kevin@esc.co.uk>
Newsgroups: Advantage.NetWare,Advantage.Networking,Advantage.Xbase++
References: <446c7c68@solutions.advantagedatabase.com> <864d0bcb3aa28c8486d1adbb269@devzone.advantagedatabase.com>
Subject: Re: 7041 Errors when creating indexes on Netware 6.5
Date: Fri, 19 May 2006 11:40:27 +0100
Lines: 44
X-Newsreader: Microsoft Outlook Express 6.00.2900.2869
X-RFC2646: Format=Flowed; Response
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2869
NNTP-Posting-Host: 217.35.101.18
Message-ID: <446d9fd0@solutions.advantagedatabase.com>
X-Trace: 19 May 2006 04:37:04 -0700, 217.35.101.18
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!217.35.101.18
Xref: solutions.advantagedatabase.com Advantage.NetWare:2174 Advantage.Networking:607 Advantage.Xbase++:533
Article PK: 1131612

Hi Peter,

Yes, index creation works fine. However we are experiencing a number of
seemingly random crashes during DBGoTop, DBSeek, DBCloseArea, DBClearScope,
DBUseArea and DBSetFilter. Our plan was to eliminate any and all error
messages from the logs in an attempt to "tidy up" before seeking further
support. These 7041's were the last of the errors and we have eliminated
most of these even by moving files around. Unfortunately the crashes
persist.

Our application is an Xbase++ hybrid conversion of a Clipper program
consisting of several hundred thousand lines of code running in a 37Mb EXE
and is used by 100+ users daily generating an average of around 25 million
ADS operations every day on 600+ DBF files with 1100+ IDX's. On a typical
day we are seeing 3-4 crashes. Generally the error message from Xbase++ is
BASE/5 Internal data structures corrupted and there is no directly
associated ADS error message.

If you have any suggestions for further diagnosing these problems I would be
grateful.

All the best
Kevin

"Peter Funk" <pfunk@_no_spam_sybase.com> wrote in message
news:864d0bcb3aa28c8486d1adbb269@devzone.advantagedatabase.com...
> Hello Kevin,
> Does the index creation work? The ACE client will first attempt to open
> the index before creating it. This is to prevent overwriting an existing
> index if it is not open. We've already limited the cases in which this is
> done (based on index type, rights checking setting, path of the new index,
> etc), but in some situations we do this to be safe. If the index creation
> is working, you can ignore those 5 error entries.
>
> Regards,
> Peter Funk
> Advantage R&D
>
>


Peter Funk <pfunk Posted on 2006-05-22 15:38:00.0Z
Date: Mon, 22 May 2006 15:38:00 +0000 (UTC)
Message-ID: <864d0bcb3b198c84b9a8c9ff783@devzone.advantagedatabase.com>
From: Peter Funk <pfunk@_no_spam_sybase.com>
Subject: Re: 7041 Errors when creating indexes on Netware 6.5
Newsgroups: Advantage.NetWare,Advantage.Networking,Advantage.Xbase++
References: <446d9fd0@solutions.advantagedatabase.com>
MIME-Version: 1.0
Content-Transfer-Encoding: 8bit
Content-Type: text/plain; charset=iso-8859-1; format=flowed
X-Newsreader: JetBrains Omea Reader 936.5
NNTP-Posting-Host: 10.24.38.105
X-Trace: 22 May 2006 09:34:28 -0700, 10.24.38.105
Lines: 11
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!10.24.38.105
Xref: solutions.advantagedatabase.com Advantage.NetWare:2175 Advantage.Networking:611 Advantage.Xbase++:534
Article PK: 1131613

Hello Kevin,
Investigating and/or fixing all the errors in the ADS error log is a good
start. Unfortunately, I'm not familiar enough with XBase & Clipper to give
you any further debugging advice. Maybe some folks who use XBase/Clipper
and ADS can chime in.

Regards,
Peter Funk
Advantage R&D