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.

Error 7016 Corrupted table

8 posts in Delphi Last posting was on 2012-07-03 13:13:20.0Z
Luis Daniel Taballione Posted on 2012-06-19 14:08:23.0Z
From: "Luis Daniel Taballione" <ldtaballione@datafull.com>
Newsgroups: Advantage.Delphi
Subject: Error 7016 Corrupted table
Date: Tue, 19 Jun 2012 11:08:23 -0300
Lines: 1
MIME-Version: 1.0
Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=original
Content-Transfer-Encoding: 8bit
X-Priority: 3
X-MSMail-Priority: Normal
Importance: Normal
X-Newsreader: Microsoft Windows Live Mail 14.0.8117.416
X-MimeOLE: Produced By Microsoft MimeOLE V14.0.8117.416
NNTP-Posting-Host: 200.117.212.102
Message-ID: <4fe0879b@solutions.advantagedatabase.com>
X-Trace: 19 Jun 2012 07:07:23 -0700, 200.117.212.102
Path: solutions.advantagedatabase.com
Xref: solutions.advantagedatabase.com Advantage.Delphi:25807
Article PK: 1109385

Hello
I am having this error every day since 10 days ago. My app is using DBF with
cdx indexes and has 2 parts: one is developed in clipper (this work fine)
and another one is developed in delphi 7. This app is running since 2006.
I´m sure that I don´t opening cdx with adt as help suggering me. When I
close every app and I try to open the corrupted file with arc, the message
is showed too. To solve this problem, I use a old clipper tool (dbu.exe)
which I pack the file or copy then to other one and then rename it again.
But this, I'll have to do every day.

Some help will be appreciate.
Sorry, but my english is not good.
Luis


Mark Wilkins Posted on 2012-06-19 22:29:44.0Z
From: "Mark Wilkins" <a@b.c>
Newsgroups: Advantage.Delphi
References: <4fe0879b@solutions.advantagedatabase.com>
In-Reply-To: <4fe0879b@solutions.advantagedatabase.com>
Subject: Re: Error 7016 Corrupted table
Date: Tue, 19 Jun 2012 16:29:44 -0600
Lines: 1
Organization: Sybase
MIME-Version: 1.0
Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=response
Content-Transfer-Encoding: 8bit
X-Priority: 3
X-MSMail-Priority: Normal
Importance: Normal
X-Newsreader: Microsoft Windows Live Mail 14.0.8089.726
X-MimeOLE: Produced By Microsoft MimeOLE V14.0.8089.726
NNTP-Posting-Host: 10.6.193.219
Message-ID: <4fe0fd1a$1@solutions.advantagedatabase.com>
X-Trace: 19 Jun 2012 15:28:42 -0700, 10.6.193.219
Path: solutions.advantagedatabase.com
Xref: solutions.advantagedatabase.com Advantage.Delphi:25809
Article PK: 1109387

If you can provide the information in a set of the 7016 error log entries
(and likely any immediately preceding errors), we can look to see exactly
what part of the file that Advantage is complaining about. The 7016 error
(I think) can result from a number of different issues (e.g., in valid
header information, invalid field definition, etc.). The error log would
point us to the specific line in the code ... which can let us know the part
of the file that is bad.

Mark Wilkins
Advantage R&D

"Luis Daniel Taballione" <ldtaballione@datafull.com> wrote in message
news:4fe0879b@solutions.advantagedatabase.com...
> Hello
> I am having this error every day since 10 days ago. My app is using DBF
> with cdx indexes and has 2 parts: one is developed in clipper (this work
> fine) and another one is developed in delphi 7. This app is running since
> 2006. I´m sure that I don´t opening cdx with adt as help suggering me.
> When I close every app and I try to open the corrupted file with arc, the
> message is showed too. To solve this problem, I use a old clipper tool
> (dbu.exe) which I pack the file or copy then to other one and then rename
> it again. But this, I'll have to do every day.
>
> Some help will be appreciate.
> Sorry, but my english is not good.
> Luis


Luis Daniel Taballione Posted on 2012-06-20 02:34:42.0Z
From: "Luis Daniel Taballione" <ldtaballione@datafull.com>
Newsgroups: Advantage.Delphi
References: <4fe0879b@solutions.advantagedatabase.com> <4fe0fd1a$1@solutions.advantagedatabase.com>
In-Reply-To: <4fe0fd1a$1@solutions.advantagedatabase.com>
Subject: Re: Error 7016 Corrupted table
Date: Tue, 19 Jun 2012 23:34:42 -0300
Lines: 48
MIME-Version: 1.0
Content-Type: multipart/mixed; boundary="----=_NextPart_000_0028_01CD4E74.1BCD1390"
X-Priority: 3
X-MSMail-Priority: Normal
Importance: Normal
X-Newsreader: Microsoft Windows Live Mail 14.0.8117.416
X-MimeOLE: Produced By Microsoft MimeOLE V14.0.8117.416
NNTP-Posting-Host: 201.253.91.121
Message-ID: <4fe1368f@solutions.advantagedatabase.com>
X-Trace: 19 Jun 2012 19:33:51 -0700, 201.253.91.121
Path: solutions.advantagedatabase.com
Xref: solutions.advantagedatabase.com Advantage.Delphi:25811
Article PK: 1109395

Hi, Mark
Thank for your response.

I hope this set of errors attached can you guide. Clipper part work fine and
this one is running 24 hours. I think the problems is in Delphi part.
I have the same version installed in another client and works without
problems.

Thanks again
Luis

"Mark Wilkins" <a@b.c> wrote in message
news:4fe0fd1a$1@solutions.advantagedatabase.com...
> If you can provide the information in a set of the 7016 error log entries
> (and likely any immediately preceding errors), we can look to see exactly
> what part of the file that Advantage is complaining about. The 7016 error
> (I think) can result from a number of different issues (e.g., in valid
> header information, invalid field definition, etc.). The error log would
> point us to the specific line in the code ... which can let us know the
> part of the file that is bad.
>
> Mark Wilkins
> Advantage R&D
>
> "Luis Daniel Taballione" <ldtaballione@datafull.com> wrote in message
> news:4fe0879b@solutions.advantagedatabase.com...
>> Hello
>> I am having this error every day since 10 days ago. My app is using DBF
>> with cdx indexes and has 2 parts: one is developed in clipper (this work
>> fine) and another one is developed in delphi 7. This app is running since
>> 2006. I´m sure that I don´t opening cdx with adt as help suggering me.
>> When I close every app and I try to open the corrupted file with arc, the
>> message is showed too. To solve this problem, I use a old clipper tool
>> (dbu.exe) which I pack the file or copy then to other one and then rename
>> it again. But this, I'll have to do every day.
>>
>> Some help will be appreciate.
>> Sorry, but my english is not good.
>> Luis
>

Error7016.jpg

Mark Wilkins Posted on 2012-06-25 14:31:30.0Z
From: "Mark Wilkins" <a@b.c>
Newsgroups: Advantage.Delphi
References: <4fe0879b@solutions.advantagedatabase.com> <4fe0fd1a$1@solutions.advantagedatabase.com> <4fe1368f@solutions.advantagedatabase.com>
In-Reply-To: <4fe1368f@solutions.advantagedatabase.com>
Subject: Re: Error 7016 Corrupted table
Date: Mon, 25 Jun 2012 08:31:30 -0600
Lines: 1
Organization: Sybase
MIME-Version: 1.0
Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=original
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
Importance: Normal
X-Newsreader: Microsoft Windows Live Mail 14.0.8089.726
X-MimeOLE: Produced By Microsoft MimeOLE V14.0.8089.726
NNTP-Posting-Host: 10.6.193.219
Message-ID: <4fe875f2$1@solutions.advantagedatabase.com>
X-Trace: 25 Jun 2012 07:30:10 -0700, 10.6.193.219
Path: solutions.advantagedatabase.com
Xref: solutions.advantagedatabase.com Advantage.Delphi:25816
Article PK: 1109393

Hi Luis,

Sorry for the slow response; I have been out of the office. I also need the
version information from the error log in order to be able to tell exactly
where the error is occurring. What is in the ADS_VER, Environmnt, and
OS_Version columns?

Mark Wilkins
Advantage R&D

"Luis Daniel Taballione" <ldtaballione@datafull.com> wrote in message
news:4fe1368f@solutions.advantagedatabase.com...
> Hi, Mark
> Thank for your response.
>
> I hope this set of errors attached can you guide. Clipper part work fine
> and
> this one is running 24 hours. I think the problems is in Delphi part.
> I have the same version installed in another client and works without
> problems.
>
> Thanks again
> Luis
>


Luis Daniel Taballione Posted on 2012-07-03 03:02:30.0Z
From: "Luis Daniel Taballione" <ldtaballione@datafull.com>
Newsgroups: Advantage.Delphi
References: <4fe0879b@solutions.advantagedatabase.com> <4fe0fd1a$1@solutions.advantagedatabase.com> <4fe1368f@solutions.advantagedatabase.com> <4fe875f2$1@solutions.advantagedatabase.com>
In-Reply-To: <4fe875f2$1@solutions.advantagedatabase.com>
Subject: Re: Error 7016 Corrupted table
Date: Tue, 3 Jul 2012 00:02:30 -0300
Lines: 1
MIME-Version: 1.0
Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=response
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
Importance: Normal
X-Newsreader: Microsoft Windows Live Mail 15.4.3555.308
X-MimeOLE: Produced By Microsoft MimeOLE V15.4.3555.308
NNTP-Posting-Host: 201.253.154.83
Message-ID: <4ff2606b@solutions.advantagedatabase.com>
X-Trace: 2 Jul 2012 20:00:59 -0700, 201.253.154.83
Path: solutions.advantagedatabase.com
Xref: solutions.advantagedatabase.com Advantage.Delphi:25825
Article PK: 1109404

Hi Mark
I solved my problem. I was a network adapter failure. Thank a lots by your
interest.
Regards
Luis

"Mark Wilkins" wrote in message
news:4fe875f2$1@solutions.advantagedatabase.com...

Hi Luis,

Sorry for the slow response; I have been out of the office. I also need the
version information from the error log in order to be able to tell exactly
where the error is occurring. What is in the ADS_VER, Environmnt, and
OS_Version columns?

Mark Wilkins
Advantage R&D

"Luis Daniel Taballione" <ldtaballione@datafull.com> wrote in message
news:4fe1368f@solutions.advantagedatabase.com...
> Hi, Mark
> Thank for your response.
>
> I hope this set of errors attached can you guide. Clipper part work fine
> and
> this one is running 24 hours. I think the problems is in Delphi part.
> I have the same version installed in another client and works without
> problems.
>
> Thanks again
> Luis
>


Mark Jacobs Posted on 2012-07-03 13:13:20.0Z
From: "Mark Jacobs" <markj@critical.co.uk>
Newsgroups: Advantage.Delphi
References: <4fe0879b@solutions.advantagedatabase.com> <4fe0fd1a$1@solutions.advantagedatabase.com> <4fe1368f@solutions.advantagedatabase.com> <4fe875f2$1@solutions.advantagedatabase.com> <4ff2606b@solutions.advantagedatabase.com>
Subject: Re: Error 7016 Corrupted table
Date: Tue, 3 Jul 2012 14:13:20 +0100
Lines: 93
MIME-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: base64
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5512
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5512
NNTP-Posting-Host: 93.157.216.162
Message-ID: <4ff2ef8b@solutions.advantagedatabase.com>
X-Trace: 3 Jul 2012 06:11:39 -0700, 93.157.216.162
Path: solutions.advantagedatabase.com
Xref: solutions.advantagedatabase.com Advantage.Delphi:25826
Article PK: 1109405

You can usually spot hardware failures using the Ads Communications Stats. I posted this back in November 2008 in the Advantage General newsgroup under the title "Single computer hangs in v9.0" :-
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
The following code returns a page of info about the ADS comms for any given
path to an ADS server :-

AnsiString mjspad(int nmpd,int pw)
{
AnsiString cret=AnsiString(nmpd); int ii=cret.Length();
return (pw<=ii) ? cret.SubString(1,pw) : AnsiString::StringOfChar('
',pw-ii)+cret;
}

AnsiString getadscommsinfo(AnsiString fnm)
{
Ace::ADSHANDLE hMgmtHandle; UNSIGNED32 ulRetVal; int ii,jj; AnsiString
retv="",pth,cnel="\r\n";
ADS_MGMT_COMM_STATS adscmst; ADS_MGMT_INSTALL_INFO adsinst;
ADS_MGMT_CONFIG_PARAMS adscfg;
ADS_MGMT_CONFIG_MEMORY adsmem; ADS_MGMT_ACTIVITY_INFO adsinfo; UNSIGNED16
usSize,usz;
if (fnm.IsEmpty()) pth=GetCurrentDir(); else pth=ExtractFilePath(fnm);
ulRetVal=AdsMgConnect(pth.c_str(),NULL,NULL,&hMgmtHandle);
if (ulRetVal!=AE_SUCCESS) return "No Connection Available";
usSize=sizeof(ADS_MGMT_COMM_STATS);
ulRetVal=AdsMgGetCommStats(hMgmtHandle,&adscmst,&usSize);
if (ulRetVal!=AE_SUCCESS) { AdsMgDisconnect(hMgmtHandle); return "Could not
get Comms Information";}
usSize=sizeof(ADS_MGMT_INSTALL_INFO);
ulRetVal=AdsMgGetInstallInfo(hMgmtHandle,&adsinst,&usSize);
if (ulRetVal!=AE_SUCCESS) { AdsMgDisconnect(hMgmtHandle); return "Could not
get Install Information";}
usSize=sizeof(ADS_MGMT_CONFIG_PARAMS); usz=sizeof(ADS_MGMT_CONFIG_MEMORY);
ulRetVal=AdsMgGetConfigInfo(hMgmtHandle,&adscfg,&usSize,&adsmem,&usz);
if (ulRetVal!=AE_SUCCESS) { AdsMgDisconnect(hMgmtHandle); return "Could not
get Config Information";}
usSize=sizeof(ADS_MGMT_ACTIVITY_INFO);
ulRetVal=AdsMgGetActivityInfo(hMgmtHandle,&adsinfo,&usSize);
if (ulRetVal!=AE_SUCCESS) { AdsMgDisconnect(hMgmtHandle); return "Could not
get Activity Information";}
retv="ADS Version "+AnsiString(adsinst.aucVersionStr)+
" Serial Number "+AnsiString(adsinst.aucSerialNumber)+cnel+
"Registered to "+AnsiString(adsinst.aucRegisteredOwner)+cnel+
"Installed on "+AnsiString(adsinst.aucInstallDate)+cnel+
"Up Time "+AnsiString(adsinfo.stUpTime.usDays)+" Days "+
AnsiString(adsinfo.stUpTime.usHours)+" Hours
"+AnsiString(adsinfo.stUpTime.usMinutes)+" Minutes"+cnel+cnel+
"Packets Received "+mjspad(adscmst.ulTotalPackets,10)+cnel+
"Receive Packets Out of Seq "+mjspad(adscmst.ulRcvPktOutOfSeq,10)+"
(Packets getting lost on network)"+cnel+
"Packet Owner not Logged in "+mjspad(adscmst.ulNotLoggedIn,10)+"
(Requests issued when disconnected)"+cnel+
"Receive Requests Out of Seq "+mjspad(adscmst.ulRcvReqOutOfSeq,10)+"
(Client application problem)"+cnel+
"Check Sum Failures "+mjspad(adscmst.ulCheckSumFailures,10)+"
(Lots mean dodgy network hardware)"+cnel+
"Server Initiated Disconnects
"+mjspad(adscmst.ulDisconnectedUsers,10)+" (Client turned off, crashed or
killed)"+cnel+
"Removed Partial Connections "+mjspad(adscmst.ulPartialConnects,10)+"
(Lots mean busy network)"+cnel+
"Operations Performed "+mjspad(adsinfo.ulOperations,10)+cnel+
"Errors / Warnings
"+mjspad(adsinfo.ulLoggedErrors,10)+cnel+cnel+
"Current Users "+mjspad(adsinfo.stUsers.ulInUse,10)+"
Max."+mjspad(adsinfo.stUsers.ulMaxUsed,10)+
" Config."+mjspad(adsinst.ulUserOption,10)+" Rejected
"+mjspad(adsinfo.stUsers.ulRejected,10)+cnel+
"Connections "+mjspad(adsinfo.stConnections.ulInUse,10)+"
Max."+mjspad(adsinfo.stConnections.ulMaxUsed,10)+
" Config."+mjspad(adscfg.ulNumConnections,10)+" Rejected
"+mjspad(adsinfo.stConnections.ulRejected,10)+cnel+
"Work Areas "+mjspad(adsinfo.stWorkAreas.ulInUse,10)+"
Max."+mjspad(adsinfo.stWorkAreas.ulMaxUsed,10)+
" Config."+mjspad(adscfg.ulNumWorkAreas,10)+" Rejected
"+mjspad(adsinfo.stWorkAreas.ulRejected,10)+cnel+
"Tables "+mjspad(adsinfo.stTables.ulInUse,10)+"
Max."+mjspad(adsinfo.stTables.ulMaxUsed,10)+
" Config."+mjspad(adscfg.ulNumTables,10)+" Rejected
"+mjspad(adsinfo.stTables.ulRejected,10)+cnel+
"Index Files "+mjspad(adsinfo.stIndexes.ulInUse,10)+"
Max."+mjspad(adsinfo.stIndexes.ulMaxUsed,10)+
" Config."+mjspad(adscfg.ulNumIndexes,10)+" Rejected
"+mjspad(adsinfo.stIndexes.ulRejected,10)+cnel+
"Locks "+mjspad(adsinfo.stLocks.ulInUse,10)+"
Max."+mjspad(adsinfo.stLocks.ulMaxUsed,10)+
" Config."+mjspad(adscfg.ulNumLocks,10)+" Rejected
"+mjspad(adsinfo.stLocks.ulRejected,10)+cnel+
"Threads "+mjspad(adsinfo.stWorkerThreads.ulInUse,10)+"
Max."+mjspad(adsinfo.stWorkerThreads.ulMaxUsed,10)+
" Config."+mjspad(adscfg.usNumWorkerThreads,10)+" Rejected
"+mjspad(adsinfo.stWorkerThreads.ulRejected,10)+cnel;
AdsMgDisconnect(hMgmtHandle);
return retv;
}

You should be able to determine if the offending PC has a dodgy network card
from it. Good luck!

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
HTH,
--
~_~
Mark Jacobs


Howard Chandler Posted on 2012-06-19 21:43:45.0Z
Date: Tue, 19 Jun 2012 17:43:45 -0400
From: Howard Chandler <howard@no.spam.fiscalsoft.com>
Organization: Fiscalsoft Corporation
User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:12.0) Gecko/20120428 Thunderbird/12.0.1
MIME-Version: 1.0
Newsgroups: Advantage.Delphi
Subject: Re: Error 7016 Corrupted table
References: <4fe0879b@solutions.advantagedatabase.com>
In-Reply-To: <4fe0879b@solutions.advantagedatabase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 8bit
NNTP-Posting-Host: 64.191.184.45
Message-ID: <4fe0f25b$1@solutions.advantagedatabase.com>
X-Trace: 19 Jun 2012 14:42:51 -0700, 64.191.184.45
Lines: 27
Path: solutions.advantagedatabase.com
Xref: solutions.advantagedatabase.com Advantage.Delphi:25808
Article PK: 1109388


On 06/19/2012 10:08 AM, Luis Daniel Taballione wrote:
> Hello
> I am having this error every day since 10 days ago. My app is using DBF
> with cdx indexes and has 2 parts: one is developed in clipper (this work
> fine) and another one is developed in delphi 7. This app is running
> since 2006. I´m sure that I don´t opening cdx with adt as help suggering
> me. When I close every app and I try to open the corrupted file with
> arc, the message is showed too. To solve this problem, I use a old
> clipper tool (dbu.exe) which I pack the file or copy then to other one
> and then rename it again. But this, I'll have to do every day.
>
> Some help will be appreciate.
> Sorry, but my english is not good.
> Luis

Hi Luis,

Your english is fine.

I may be wrong, but this smells to me like a AdsTableOptions.AdsLockType
issue. In the Delphi portion of your app, did you set the AdsLockType to
Compatible for any table written to by both the Delphi code and Clipper
code?

HTH

Howard


Luis Daniel Taballione Posted on 2012-06-20 02:21:33.0Z
From: "Luis Daniel Taballione" <ldtaballione@datafull.com>
Newsgroups: Advantage.Delphi
References: <4fe0879b@solutions.advantagedatabase.com> <4fe0f25b$1@solutions.advantagedatabase.com>
In-Reply-To: <4fe0f25b$1@solutions.advantagedatabase.com>
Subject: Re: Error 7016 Corrupted table
Date: Tue, 19 Jun 2012 23:21:33 -0300
Lines: 3
MIME-Version: 1.0
Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=response
Content-Transfer-Encoding: 8bit
X-Priority: 3
X-MSMail-Priority: Normal
Importance: Normal
X-Newsreader: Microsoft Windows Live Mail 14.0.8117.416
X-MimeOLE: Produced By Microsoft MimeOLE V14.0.8117.416
NNTP-Posting-Host: 190.138.186.215
Message-ID: <4fe13370$1@solutions.advantagedatabase.com>
X-Trace: 19 Jun 2012 19:20:32 -0700, 190.138.186.215
Path: solutions.advantagedatabase.com
Xref: solutions.advantagedatabase.com Advantage.Delphi:25810
Article PK: 1109389

Hi, Howard
thanks a lot for your response.

all my tables are seted as Propietary. Do you think I should change them to
Compatible? As I said before, this app is running since 2006 and never had
problems.
With best regards
Luis

"Howard Chandler" <howard@no.spam.fiscalsoft.com> wrote in message
news:4fe0f25b$1@solutions.advantagedatabase.com...
> On 06/19/2012 10:08 AM, Luis Daniel Taballione wrote:
>> Hello
>> I am having this error every day since 10 days ago. My app is using DBF
>> with cdx indexes and has 2 parts: one is developed in clipper (this work
>> fine) and another one is developed in delphi 7. This app is running
>> since 2006. I´m sure that I don´t opening cdx with adt as help suggering
>> me. When I close every app and I try to open the corrupted file with
>> arc, the message is showed too. To solve this problem, I use a old
>> clipper tool (dbu.exe) which I pack the file or copy then to other one
>> and then rename it again. But this, I'll have to do every day.
>>
>> Some help will be appreciate.
>> Sorry, but my english is not good.
>> Luis
>
> Hi Luis,
>
> Your english is fine.
>
> I may be wrong, but this smells to me like a AdsTableOptions.AdsLockType
> issue. In the Delphi portion of your app, did you set the AdsLockType to
> Compatible for any table written to by both the Delphi code and Clipper
> code?
>
> HTH
>
> Howard