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 in backup

8 posts in Xbase++ Last posting was on 2012-03-20 22:37:08.0Z
Lucas Posted on 2012-03-14 11:55:02.0Z
From: "Lucas" <lucasdebeltran@gmail.com>
Newsgroups: Advantage.Xbase++
Subject: error in backup
Date: Wed, 14 Mar 2012 12:55:02 +0100
Lines: 86
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5931
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.6157
NNTP-Posting-Host: 213.37.39.254
Message-ID: <4f6086d2@solutions.advantagedatabase.com>
X-Trace: 14 Mar 2012 04:53:54 -0700, 213.37.39.254
Path: solutions.advantagedatabase.com
Xref: solutions.advantagedatabase.com Advantage.Xbase++:1167
Article PK: 1141000

Hello,

I have set up a Data Dictionary, c:\test\lucas.add.

And in this dictionary, I added the dbf tables placed in c:\test\ais


I try to do a backup as:

adsbackup -pYourPasswordHere -cansi "c:\test\lucas.add" "C:\seguridad"

But I got the following error for each table:
Error 3010: Unknown alias name used with field name in index key
expression.


But I am able to use and browse the tables via Internet using AIS, which is
the feature I need:


function Main()

Request ADS,ADSKeyCount,ADSKeyNo,OrdKeyCount,OrdKeyNo, AdsGetRelKeyPos,
AdsSetRelKeyPos

RddRegister( "ADS", 1 )
RddSetDefault( "ADS" )

//setting up server type
// 1 = Local Server (no client / server)
// 2 = Remote Server
// 3 = Local + Remot
// 4 = Internet Server
// 5 = Local + Internet
// 6 = Remote+Internet
// 7 = Local + Remote + Internet , best choice
adsSetServerType( 4 ) // ? adsSetServerType( ADS_REMOTE_SERVER )

//setting up the file types
// 1 = DBFNTX
// 2 = DBFCDX
// 3 = ADSADI
adsSetFileType( ADS_CDX ) // o ADS_CDX




IF AdsConnect60( \\213.201.10.20:6262\test\lucas.add, 4, "lucas",
"lucas")

MsgInfo("Esta ahora conectado al Sevidor AIS "+CRLF+CRLF+;
"You are now connected to AIS Server","Bienvenido / Welcome /
Versi?n "+ADSVersion())


ELSE

MsgStop("Se ha rechazado la conexi?n al servidor AIS, por favor
intente mas tarde"+CRLF+CRLF+;
"Conection to AIS Server rejected, please, try again later","AIS
Error")
QUIT

ENDIF



use ARTICULO shared new alias "ARTICULO"
DbGoTop()

XBrowse() // Quick browse!!!

dbcloseall()
quit

return nil


Thank you very much.

Best regards,

Lucas


Pascal Boivin Posted on 2012-03-14 13:10:14.0Z
From: "Pascal Boivin" <pascal.boivin@nbautomation.com>
Subject: Re: error in backup
Newsgroups: Advantage.Xbase++
References: <4f6086d2@solutions.advantagedatabase.com>
User-Agent: XanaNews/1.19.1.320
Message-ID: <xn0hvkxf63jhbw000@devzone.advantagedatabase.com>
X-Ref: DevZone.AdvantageDatabase.com ~XNS:000000F3
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 69.70.11.19
Date: 14 Mar 2012 06:10:14 -0700
X-Trace: 14 Mar 2012 06:10:14 -0700, 69.70.11.19
Lines: 17
Path: solutions.advantagedatabase.com
Xref: solutions.advantagedatabase.com Advantage.Xbase++:1171
Article PK: 1141004

Hi

A possible cause:

Table INVOICE.DBF
CUSTNO CHAR(12)
...

Index file INVOICE.CDX
TAG CUSTNO1 EXPR: INVOICE->CUSTNO
vs
TAG CUSTNO2 EXPR: CUSTNO

The tag CUSTNO1 may cause an error if the table is not open with
"INVOICE" alias. This may be the case with AdsBackup.

How are written your index expression?


Lucas Posted on 2012-03-14 13:23:00.0Z
From: "Lucas" <lucasdebeltran@gmail.com>
Newsgroups: Advantage.Xbase++
References: <4f6086d2@solutions.advantagedatabase.com> <xn0hvkxf63jhbw000@devzone.advantagedatabase.com>
Subject: Re: error in backup
Date: Wed, 14 Mar 2012 14:23:00 +0100
Lines: 34
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5931
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.6157
NNTP-Posting-Host: 213.37.39.254
Message-ID: <4f609b70@solutions.advantagedatabase.com>
X-Trace: 14 Mar 2012 06:21:52 -0700, 213.37.39.254
Path: solutions.advantagedatabase.com
Xref: solutions.advantagedatabase.com Advantage.Xbase++:1172
Article PK: 1141007

Pacal.

Thanks for reply.

This is the way:

USE ("TRANSPO") EXCLUSIVE NEW ALIAS "TRANSPO"
PACK

INDEX ON FIELD->TRANSPO TO ("TRANSPO") FOR !Deleted()
DbCloseAll()


"Pascal Boivin" <pascal.boivin@nbautomation.com> escribi? en el mensaje
news:xn0hvkxf63jhbw000@devzone.advantagedatabase.com...

> Hi
>
> A possible cause:
>
> Table INVOICE.DBF
> CUSTNO CHAR(12)
> ...
>
> Index file INVOICE.CDX
> TAG CUSTNO1 EXPR: INVOICE->CUSTNO
> vs
> TAG CUSTNO2 EXPR: CUSTNO
>
> The tag CUSTNO1 may cause an error if the table is not open with
> "INVOICE" alias. This may be the case with AdsBackup.
>
> How are written your index expression?


Pascal Boivin Posted on 2012-03-14 15:13:04.0Z
From: "Pascal Boivin" <pascal.boivin@nbautomation.com>
Subject: Re: error in backup
Newsgroups: Advantage.Xbase++
References: <4f6086d2@solutions.advantagedatabase.com> <xn0hvkxf63jhbw000@devzone.advantagedatabase.com> <4f609b70@solutions.advantagedatabase.com>
User-Agent: XanaNews/1.19.1.320
Message-ID: <xn0hvl0oz7zl59000@devzone.advantagedatabase.com>
X-Ref: DevZone.AdvantageDatabase.com ~XNS:000000F4
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 69.70.11.19
Date: 14 Mar 2012 08:13:04 -0700
X-Trace: 14 Mar 2012 08:13:04 -0700, 69.70.11.19
Lines: 4
Path: solutions.advantagedatabase.com
Xref: solutions.advantagedatabase.com Advantage.Xbase++:1174
Article PK: 1141005

Are you using xHarbour?

I don't use xHarbour so I can only guess. Maybe xHarbour is storing
"FIELD" as the alias name in the index.


Lucas Posted on 2012-03-14 15:52:56.0Z
From: "Lucas" <lucasdebeltran@gmail.com>
Newsgroups: Advantage.Xbase++
References: <4f6086d2@solutions.advantagedatabase.com> <xn0hvkxf63jhbw000@devzone.advantagedatabase.com> <4f609b70@solutions.advantagedatabase.com> <xn0hvl0oz7zl59000@devzone.advantagedatabase.com>
Subject: Re: error in backup
Date: Wed, 14 Mar 2012 16:52:56 +0100
Lines: 16
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5931
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.6157
NNTP-Posting-Host: 213.37.39.254
Message-ID: <4f60be94$1@solutions.advantagedatabase.com>
X-Trace: 14 Mar 2012 08:51:48 -0700, 213.37.39.254
Path: solutions.advantagedatabase.com
Xref: solutions.advantagedatabase.com Advantage.Xbase++:1175
Article PK: 1141008

Yes, I use Harbour.

But the forum is dead.

Is there a way to backup only .dbf, no index?.

Thanks.

"Pascal Boivin" <pascal.boivin@nbautomation.com> escribi? en el mensaje
news:xn0hvl0oz7zl59000@devzone.advantagedatabase.com...

> Are you using xHarbour?
>
> I don't use xHarbour so I can only guess. Maybe xHarbour is storing
> "FIELD" as the alias name in the index.


Lucas Posted on 2012-03-15 12:47:26.0Z
From: "Lucas" <lucasdebeltran@gmail.com>
Newsgroups: Advantage.Xbase++
References: <4f6086d2@solutions.advantagedatabase.com> <xn0hvkxf63jhbw000@devzone.advantagedatabase.com> <4f609b70@solutions.advantagedatabase.com> <xn0hvl0oz7zl59000@devzone.advantagedatabase.com> <4f60be94$1@solutions.advantagedatabase.com>
Subject: Re: error in backup
Date: Thu, 15 Mar 2012 13:47:26 +0100
Lines: 29
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5931
X-RFC2646: Format=Flowed; Response
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.6157
NNTP-Posting-Host: 213.37.39.254
Message-ID: <4f61e494@solutions.advantagedatabase.com>
X-Trace: 15 Mar 2012 05:46:12 -0700, 213.37.39.254
Path: solutions.advantagedatabase.com
Xref: solutions.advantagedatabase.com Advantage.Xbase++:1176
Article PK: 1141009

Hello:

I remove FIELD-> and I still get the error.

Any clue please?.

Thank you.


"Lucas" <lucasdebeltran@gmail.com> escribi? en el mensaje
news:4f60be94$1@solutions.advantagedatabase.com...

> Yes, I use Harbour.
>
> But the forum is dead.
>
> Is there a way to backup only .dbf, no index?.
>
> Thanks.
>
> "Pascal Boivin" <pascal.boivin@nbautomation.com> escribi? en el mensaje
> news:xn0hvl0oz7zl59000@devzone.advantagedatabase.com...
>> Are you using xHarbour?
>>
>> I don't use xHarbour so I can only guess. Maybe xHarbour is storing
>> "FIELD" as the alias name in the index.
>
>


Pascal Boivin Posted on 2012-03-15 13:59:49.0Z
From: "Pascal Boivin" <pascal.boivin@nbautomation.com>
Subject: Re: error in backup
Newsgroups: Advantage.Xbase++
References: <4f6086d2@solutions.advantagedatabase.com> <xn0hvkxf63jhbw000@devzone.advantagedatabase.com> <4f609b70@solutions.advantagedatabase.com> <xn0hvl0oz7zl59000@devzone.advantagedatabase.com> <4f60be94$1@solutions.advantagedatabase.com> <4f61e494@solutions.advantagedatabase.com>
User-Agent: XanaNews/1.19.1.320
Message-ID: <xn0hvmdcr5df63000@devzone.advantagedatabase.com>
X-Ref: DevZone.AdvantageDatabase.com ~XNS:000000F5
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 69.70.11.19
Date: 15 Mar 2012 06:59:49 -0700
X-Trace: 15 Mar 2012 06:59:49 -0700, 69.70.11.19
Lines: 4
Path: solutions.advantagedatabase.com
Xref: solutions.advantagedatabase.com Advantage.Xbase++:1177
Article PK: 1141010

> Any clue please?.

If no other reply here, you can write to advantage@sybase.com and send
them a sample dictionnary.


Mark Wilkins Posted on 2012-03-20 22:37:08.0Z
From: "Mark Wilkins" <a@b.c>
Newsgroups: Advantage.Xbase++
References: <4f6086d2@solutions.advantagedatabase.com> <xn0hvkxf63jhbw000@devzone.advantagedatabase.com> <4f609b70@solutions.advantagedatabase.com>
In-Reply-To: <4f609b70@solutions.advantagedatabase.com>
Subject: Re: error in backup
Date: Tue, 20 Mar 2012 16:37:08 -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: 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: <4f69063f$1@solutions.advantagedatabase.com>
X-Trace: 20 Mar 2012 15:35:43 -0700, 10.6.193.219
Path: solutions.advantagedatabase.com
Xref: solutions.advantagedatabase.com Advantage.Xbase++:1178
Article PK: 1141011

I looked at the code that parses the key expression for the index, and it
supposed to handle the "field->" alias syntax. In fact, I just built an
index with the expression "field->transpo", and it worked fine and the
backup utility worked as well. So it seems there must be some other alias
included in the key expression. You might open the data dictionary with
Advantage Data Architect and look at the table properties for that table.
Go to the "Additional Index Definitions" tab and see what the key expression
is.

Mark Wilkins
Advantage R&D

"Lucas" <lucasdebeltran@gmail.com> wrote in message
news:4f609b70@solutions.advantagedatabase.com...
> Pacal.
>
> Thanks for reply.
>
> This is the way:
>
> USE ("TRANSPO") EXCLUSIVE NEW ALIAS "TRANSPO"
> PACK
>
> INDEX ON FIELD->TRANSPO TO ("TRANSPO") FOR !Deleted()
> DbCloseAll()
>
>