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.

Advantage 9.0 Error open SQL

3 posts in Linux Last posting was on 2008-09-11 21:39:15.0Z
fbm Posted on 2008-09-08 19:26:13.0Z
From: "fbm" <f@yahoo.com>
Newsgroups: Advantage.Linux
Subject: Advantage 9.0 Error open SQL
Date: Mon, 8 Sep 2008 15:26:13 -0400
Lines: 84
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
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: 67.93.4.100
Message-ID: <48c57ae2@solutions.advantagedatabase.com>
X-Trace: 8 Sep 2008 13:20:02 -0700, 67.93.4.100
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!67.93.4.100
Xref: solutions.advantagedatabase.com Advantage.Linux:1166
Article PK: 1130966

Hi

Configuration:
Linux: Ubuntu kernel 2.6
Server : 64 bit
Advantage 9.0
Architector 9.0

We created a sample table and then ran a SQL which returned an Error 6605
(poQuery: Error 6605: Client comm layer received more data from the
Advantage Database Server than it was expecting. axOpenTable).

The following is the SQL creating the table.

Create Table "st_cards_sync" (
CARD_ID Char( 7 ),
HOME Short,
PROG_ID Char( 7 ),
CURR_EXT Short,
STATUS Char( 10 ),
REFNUM Char( 7 ),
REG_DAY Date,
REG_REPS Char( 10 ),
LENGTH Integer,
START_DAY Date,
LAST_DAY Date,
DROP_DAY Date,
SCHD_ID Char( 7 ),
PARAMETRIC_SCHD Logical,
CL_HOME Short,
CL_NO Integer,
CLASS_ID Char( 14 ),
LAST_CLASS_ID Char( 14 ),
LAST_CHAPTER_ID Char( 3 ),
LAST_BOOK_ID Char( 10 ),
NEXT_START_DAY Date,
NEXT_CL_NO Integer,
NEXT_SCHD_ID Char( 7 ),
NEXT_CLASS_ID Char( 14 ),
NEXT_CHAPTER_ID Char( 3 ),
NEXT_BOOK_ID Char( 10 ),
NEXT_OLDCARD Char( 8 ),
SCHCHAND_ID Char( 7 ),
IN_PROG Logical,
ACTIVATED Logical,
DROPPED Logical,
HOUR_PER_WEEK Double,
DAYS Char( 7 ),
START_TIME Time,
END_TIME Time,
TUITION Double,
W_TUITION Double,
CAN_LATE Logical,
DOWNPAYMENT Double,
OLDCARD Char( 8 ),
COEFF Double,
TESTNEWCLASS Logical,
TEST_ID Char( 10 ),
NEXT_TEST_ID Char( 10 ),
PUT_ON_TEST TimeStamp,
TRANS_CL_HOME Short,
TRANS_CL_NO Integer,
TRANS_BY_DATE Date,
NBR Integer,
SYNC Char( 20 ),
RN Integer,
CUROPER Char( 10 ),
CURTIME TimeStamp);

The SQL that returned an error

SELECT * FROM "st_cards_sync"
Could you please explain this problem?

Thank you


Edgar Sherman Posted on 2008-09-09 15:17:48.0Z
Date: Tue, 09 Sep 2008 09:17:48 -0600
From: Edgar Sherman <no@email.com>
User-Agent: Thunderbird 2.0.0.16 (Windows/20080708)
MIME-Version: 1.0
Newsgroups: Advantage.Linux
Subject: Re: Advantage 9.0 Error open SQL
References: <48c57ae2@solutions.advantagedatabase.com>
In-Reply-To: <48c57ae2@solutions.advantagedatabase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 10.24.34.164
Message-ID: <48c69224@solutions.advantagedatabase.com>
X-Trace: 9 Sep 2008 09:11:32 -0700, 10.24.34.164
Lines: 104
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!10.24.34.164
Xref: solutions.advantagedatabase.com Advantage.Linux:1168
Article PK: 1130973

Not really sure based on the information.

Most likely something is happening to the packets as they are
transfered, possibly fragmenting them.

I would try to change from UDP to TCP as a first Test. In ARC, right
click on the connection and change "Communication Type" from default to
TCP/IP.

If this does not work, I would next try to decrease the packet size.
Open the ads.ini file (usually located in c:\windows) and add
PACKET_SIZE=512 below the [SETTINGS] section.

If either of these work, you may want to investigate the network and see
if there are any faulty hardware or setup that could be causing packet
corruption.

Edgar

fbm wrote:
> Hi
>
> Configuration:
> Linux: Ubuntu kernel 2.6
> Server : 64 bit
> Advantage 9.0
> Architector 9.0
>
> We created a sample table and then ran a SQL which returned an Error 6605
> (poQuery: Error 6605: Client comm layer received more data from the
> Advantage Database Server than it was expecting. axOpenTable).
>
> The following is the SQL creating the table.
>
> Create Table "st_cards_sync" (
> CARD_ID Char( 7 ),
> HOME Short,
> PROG_ID Char( 7 ),
> CURR_EXT Short,
> STATUS Char( 10 ),
> REFNUM Char( 7 ),
> REG_DAY Date,
> REG_REPS Char( 10 ),
> LENGTH Integer,
> START_DAY Date,
> LAST_DAY Date,
> DROP_DAY Date,
> SCHD_ID Char( 7 ),
> PARAMETRIC_SCHD Logical,
> CL_HOME Short,
> CL_NO Integer,
> CLASS_ID Char( 14 ),
> LAST_CLASS_ID Char( 14 ),
> LAST_CHAPTER_ID Char( 3 ),
> LAST_BOOK_ID Char( 10 ),
> NEXT_START_DAY Date,
> NEXT_CL_NO Integer,
> NEXT_SCHD_ID Char( 7 ),
> NEXT_CLASS_ID Char( 14 ),
> NEXT_CHAPTER_ID Char( 3 ),
> NEXT_BOOK_ID Char( 10 ),
> NEXT_OLDCARD Char( 8 ),
> SCHCHAND_ID Char( 7 ),
> IN_PROG Logical,
> ACTIVATED Logical,
> DROPPED Logical,
> HOUR_PER_WEEK Double,
> DAYS Char( 7 ),
> START_TIME Time,
> END_TIME Time,
> TUITION Double,
> W_TUITION Double,
> CAN_LATE Logical,
> DOWNPAYMENT Double,
> OLDCARD Char( 8 ),
> COEFF Double,
> TESTNEWCLASS Logical,
> TEST_ID Char( 10 ),
> NEXT_TEST_ID Char( 10 ),
> PUT_ON_TEST TimeStamp,
> TRANS_CL_HOME Short,
> TRANS_CL_NO Integer,
> TRANS_BY_DATE Date,
> NBR Integer,
> SYNC Char( 20 ),
> RN Integer,
> CUROPER Char( 10 ),
> CURTIME TimeStamp);
>
> The SQL that returned an error
>
> SELECT * FROM "st_cards_sync"
> Could you please explain this problem?
>
> Thank you
>
>
>
>
>
>
>
>
>


fbm Posted on 2008-09-11 21:39:15.0Z
From: "fbm" <f@yahoo.com>
Newsgroups: Advantage.Linux
References: <48c57ae2@solutions.advantagedatabase.com> <48c69224@solutions.advantagedatabase.com>
Subject: Re: Advantage 9.0 Error open SQL
Date: Thu, 11 Sep 2008 17:39:15 -0400
Lines: 128
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
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: 67.93.4.100
Message-ID: <48c98e93@solutions.advantagedatabase.com>
X-Trace: 11 Sep 2008 15:33:07 -0700, 67.93.4.100
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!67.93.4.100
Xref: solutions.advantagedatabase.com Advantage.Linux:1169
Article PK: 1130979

Hi Edgar.

Thanks a lot for help.

We switched to TCP/IP. It works.

We still have a problem with new server ( Advantage 9.0. Linux ).

It Looks like we can not design a tables with Architect 9.0.
We can't see any fields in the table designer. Actually we can change table
structure with SQL statements.
But we could do this in the previous version of architector (8.1) and
advantage 8.1.

May be it's related with SAMBA settings?

Could you please give us any suggestions?

Thanks
Boris Fayvinov.

"Edgar Sherman" <no@email.com> wrote in message
news:48c69224@solutions.advantagedatabase.com...
> Not really sure based on the information.
>
> Most likely something is happening to the packets as they are transfered,
> possibly fragmenting them.
>
> I would try to change from UDP to TCP as a first Test. In ARC, right
> click on the connection and change "Communication Type" from default to
> TCP/IP.
>
> If this does not work, I would next try to decrease the packet size. Open
> the ads.ini file (usually located in c:\windows) and add PACKET_SIZE=512
> below the [SETTINGS] section.
>
> If either of these work, you may want to investigate the network and see
> if there are any faulty hardware or setup that could be causing packet
> corruption.
>
> Edgar
>
> fbm wrote:
>> Hi
>>
>> Configuration:
>> Linux: Ubuntu kernel 2.6
>> Server : 64 bit
>> Advantage 9.0
>> Architector 9.0
>>
>> We created a sample table and then ran a SQL which returned an Error 6605
>> (poQuery: Error 6605: Client comm layer received more data from the
>> Advantage Database Server than it was expecting. axOpenTable).
>>
>> The following is the SQL creating the table.
>>
>> Create Table "st_cards_sync" (
>> CARD_ID Char( 7 ),
>> HOME Short,
>> PROG_ID Char( 7 ),
>> CURR_EXT Short,
>> STATUS Char( 10 ),
>> REFNUM Char( 7 ),
>> REG_DAY Date,
>> REG_REPS Char( 10 ),
>> LENGTH Integer,
>> START_DAY Date,
>> LAST_DAY Date,
>> DROP_DAY Date,
>> SCHD_ID Char( 7 ),
>> PARAMETRIC_SCHD Logical,
>> CL_HOME Short,
>> CL_NO Integer,
>> CLASS_ID Char( 14 ),
>> LAST_CLASS_ID Char( 14 ),
>> LAST_CHAPTER_ID Char( 3 ),
>> LAST_BOOK_ID Char( 10 ),
>> NEXT_START_DAY Date,
>> NEXT_CL_NO Integer,
>> NEXT_SCHD_ID Char( 7 ),
>> NEXT_CLASS_ID Char( 14 ),
>> NEXT_CHAPTER_ID Char( 3 ),
>> NEXT_BOOK_ID Char( 10 ),
>> NEXT_OLDCARD Char( 8 ),
>> SCHCHAND_ID Char( 7 ),
>> IN_PROG Logical,
>> ACTIVATED Logical,
>> DROPPED Logical,
>> HOUR_PER_WEEK Double,
>> DAYS Char( 7 ),
>> START_TIME Time,
>> END_TIME Time,
>> TUITION Double,
>> W_TUITION Double,
>> CAN_LATE Logical,
>> DOWNPAYMENT Double,
>> OLDCARD Char( 8 ),
>> COEFF Double,
>> TESTNEWCLASS Logical,
>> TEST_ID Char( 10 ),
>> NEXT_TEST_ID Char( 10 ),
>> PUT_ON_TEST TimeStamp,
>> TRANS_CL_HOME Short,
>> TRANS_CL_NO Integer,
>> TRANS_BY_DATE Date,
>> NBR Integer,
>> SYNC Char( 20 ),
>> RN Integer,
>> CUROPER Char( 10 ),
>> CURTIME TimeStamp);
>>
>> The SQL that returned an error
>>
>> SELECT * FROM "st_cards_sync"
>> Could you please explain this problem?
>>
>> Thank you
>>
>>
>>
>>
>>
>>
>>
>>