Error Code 101 Segment buffer length shorter than expected

[cesar_picazo]

hi

Iam using Zeos Lib 6.5, and when i connect to Firebird 1.5 and the table have a Field blod or memo this work. But if field have 600 lines of text the component send this message:
SQL error Segment buffer length shorter than expected: Error Code 101. segment buffer length shorter than expected.

I see any other message with the same error on the version Zeos Lib 6.1.

Some body knows if this bug be fix and the version?

Please send me a mail if this be fix.
cesar_picazo@hotmail.com
or
cesar_picazo@mp-erp.com.mx

[cesar_picazo]

Hi

I post this message the last week, the bug 101 can be Fix?

If anybody have any answer please post a message.

I use Firebird 1.5 with Delphi 6 and if use a blod field with 500 lines and send the message error 101.

[fduenas]

did you get latest version for CVS?
have you posted this as a bug?

[cesar_picazo]

Hi

No i don't know were post this bug.

hola desconosco en donde se tienen que publicar los bugs que se encuentren en el componente pero si me dices donde lo pongo.

Gracias.


Regards.

[fduenas]

http://sourceforge.net/tracker/?group_i ... tid=415824

It is prefered to register to source forge, log in and the post your bug with a sample project.

are you using latest CVS version?

[sandeep_c24]

I could not post this bug on SourceForge. So I thought I might post it here.

Here is code to create table

CREATE TABLE "GLRP"
(
"GLRP_CO" VARCHAR(30),
"GLRP_DE" BLOB SUB_TYPE TEXT SEGMENT SIZE 80
);

CREATE UNIQUE INDEX "GLRP_KEY1" ON "GLRP"("GLRP_CO");

Add following record

INSERT INTO "GLRP" ("GLRP_CO") VALUES ('Profit And Loss');

Assign GLRP_DE following:

<PAGE
Period Style=Fixed
Page Orientation=Portrait
Top Margin=1.00
Bottom Margin=1.00
Left Margin=1.00
Right Margin=1.00
>
<BAND
BandLetter=A
Name=Page Header 1
Band Style=Page Header
Print=Yes
Blank Lines Before=0
Blank Lines After=0
Height (CM)=0.60
>
<OBJ
ObjectType=otText
Name=AT1
Value={Date, dd mmmm yyyy}
Print=Yes
Truncate=No
Position (CM)=0.00
Width (CM)=1.40
Font=Ms Sans Serif, 8, Black
Alignment=Left Justify
>
<OBJ
ObjectType=otText
Name=AT2
Value={Company Name}
Print=Yes
Truncate=No
Position (CM)=7.95
Width (CM)=3.20
Font=Ms Sans Serif, 8, Black
Alignment=Centre
>
<OBJ
ObjectType=otText
Name=AT3
Value=Page {Page}
Print=Yes
Truncate=No
Position (CM)=17.62
Width (CM)=1.40
Font=Ms Sans Serif, 8, Black
Alignment=Right Justify
>
</BAND>
<BAND
BandLetter=B
Name=Page Header 2
Band Style=Page Header
Print=Yes
Blank Lines Before=0
Blank Lines After=1
Height (CM)=0.60
>
<OBJ
ObjectType=otText
Name=BT1
Value=BALANCE SHEET AS AT {Period, 0, -1, dd/mm/yyyy}
Print=Yes
Truncate=No
Position (CM)=6.05
Width (CM)=7.00
Font=Ms Sans Serif, 8, Black
Alignment=Centre
>
</BAND>
<BAND
BandLetter=F
Name=Column Header
Band Style=Page Header
Print=Yes
Blank Lines Before=0
Blank Lines After=0
Height (CM)=0.60
>
<OBJ
ObjectType=otText
Name=FT1
Value={Period, 0, -1, mmmm yyyy}
Print=Yes
Truncate=No
Position (CM)=7.98
Width (CM)=1.40
Font=Ms Sans Serif, 8, Black
Alignment=Right Justify
>
<OBJ
ObjectType=otText
Name=FT2
Value={Period, -1, -1, mmmm yyyy}
Print=Yes
Truncate=No
Position (CM)=13.05
Width (CM)=1.40
Font=Ms Sans Serif, 8, Black
Alignment=Right Justify
>
</BAND>
<BAND
BandLetter=C
Name=Capital & Reserves Header
Band Style=Header
Header Of=Capital & Reserves Data
Print=Yes
Start New Page=No
Blank Lines Before=0
Blank Lines After=0
Height (CM)=0.60
>
<OBJ
ObjectType=otText
Name=CT1
Value=CAPITAL & RESERVES
Print=Yes
Truncate=No
Position (CM)=0.00
Width (CM)=3.24
Font=Ms Sans Serif, 8, Black
Alignment=Left Justify
>
</BAND>
<BAND
BandLetter=D
Name=Capital & Reserves Data
Band Style=Data
Account From=9100
Account To=9130
Data Source=Actual
Normal Sign=Credit
Print=Yes
Start New Page=No
Blank Lines Before=0
Blank Lines After=0
Height (CM)=0.60
>
<OBJ
ObjectType=otNumber
Name=DN1
Value=0, 0, -1, Yes
Print=Yes
Data Source=Actual
Decimals=2
Percentage Of=
Position (CM)=7.98
Width (CM)=1.40
Font=Ms Sans Serif, 8, Black
Alignment=Right Justify
>
<OBJ
ObjectType=otText
Name=DT1
Value={Account Description}
Print=Yes
Truncate=No
Position (CM)=0.49
Width (CM)=2.00
Font=Ms Sans Serif, 8, Black
Alignment=Left Justify
>
<OBJ
ObjectType=otNumber
Name=DN2
Value=-1, 0, -1, Yes
Print=Yes
Data Source=Actual
Decimals=2
Percentage Of=
Position (CM)=13.05
Width (CM)=1.40
Font=Ms Sans Serif, 8, Black
Alignment=Right Justify
>
</BAND>
<BAND
BandLetter=E
Name=Capital & Reserves Total
Band Style=Total
Data Source=Actual
Normal Sign=Credit
Print=Yes
Start New Page=No
Blank Lines Before=1
Blank Lines After=0
Height (CM)=0.60
>
<OBJ
ObjectType=otNumber
Name=EN1
Value=DN1
Print=Yes
Data Source=Actual
Decimals=2
Percentage Of=
Position (CM)=7.98
Width (CM)=1.40
Font=MS Sans Serif, 8, Black, Underline
Alignment=Right Justify
>
<OBJ
ObjectType=otNumber
Name=EN2
Value=DN2
Print=Yes
Data Source=Actual
Decimals=2
Percentage Of=
Position (CM)=13.05
Width (CM)=1.40
Font=MS Sans Serif, 8, Black, Underline
Alignment=Right Justify
>
<OBJ
ObjectType=otText
Name=ET1
Value=TOTAL CAPITAL & RESERVES
Print=Yes
Truncate=No
Position (CM)=0.49
Width (CM)=2.00
Font=Ms Sans Serif, 8, Black
Alignment=Left Justify
>
</BAND>
<BAND
BandLetter=G
Name=Represented By Header
Band Style=Text
Print=Yes
Start New Page=No
Blank Lines Before=1
Blank Lines After=1
Height (CM)=0.60
>
<OBJ
ObjectType=otText
Name=GT1
Value=REPRESENTED BY:
Print=Yes
Truncate=No
Position (CM)=0.00
Width (CM)=3.62
Font=Ms Sans Serif, 8, Black
Alignment=Left Justify
>
</BAND>
<BAND
BandLetter=H
Name=Current Assets Header
Band Style=Header
Header Of=Current Assets Data
Print=Yes
Start New Page=No
Blank Lines Before=0
Blank Lines After=0
Height (CM)=0.60
>
<OBJ
ObjectType=otText
Name=HT1
Value=CURRENT ASSETS
Print=Yes
Truncate=No
Position (CM)=0.00
Width (CM)=2.00
Font=Ms Sans Serif, 8, Black
Alignment=Left Justify
>
</BAND>
<BAND
BandLetter=I
Name=Current Assets Data
Band Style=Data
Account From=9200
Account To=9599
Data Source=Actual
Normal Sign=Debit
Print=Yes
Start New Page=No
Blank Lines Before=0
Blank Lines After=0
Height (CM)=0.60
>
<OBJ
ObjectType=otNumber
Name=IN1
Value=0, 0, -1, Yes
Print=Yes
Data Source=Actual
Decimals=2
Percentage Of=
Position (CM)=7.98
Width (CM)=1.40
Font=Ms Sans Serif, 8, Black
Alignment=Right Justify
>
<OBJ
ObjectType=otNumber
Name=IN2
Value=-1, 0, -1, Yes
Print=Yes
Data Source=Actual
Decimals=2
Percentage Of=
Position (CM)=13.05
Width (CM)=1.40
Font=Ms Sans Serif, 8, Black
Alignment=Right Justify
>
<OBJ
ObjectType=otText
Name=IT1
Value={Account Description}
Print=Yes
Truncate=No
Position (CM)=0.49
Width (CM)=2.00
Font=Ms Sans Serif, 8, Black
Alignment=Left Justify
>
</BAND>
<BAND
BandLetter=J
Name=Current Assets Total
Band Style=Total
Data Source=Actual
Normal Sign=Debit
Print=Yes
Start New Page=No
Blank Lines Before=1
Blank Lines After=0
Height (CM)=0.60
>
<OBJ
ObjectType=otNumber
Name=JN1
Value=IN1
Print=Yes
Data Source=Actual
Decimals=2
Percentage Of=
Position (CM)=7.98
Width (CM)=1.40
Font=MS Sans Serif, 8, Black, Underline
Alignment=Right Justify
>
<OBJ
ObjectType=otNumber
Name=JN2
Value=IN2
Print=Yes
Data Source=Actual
Decimals=2
Percentage Of=
Position (CM)=13.05
Width (CM)=1.40
Font=MS Sans Serif, 8, Black, Underline
Alignment=Right Justify
>
<OBJ
ObjectType=otText
Name=JT1
Value=TOTAL CURRENT ASSETS
Print=Yes
Truncate=No
Position (CM)=0.00
Width (CM)=2.00
Font=Ms Sans Serif, 8, Black
Alignment=Left Justify
>
</BAND>
<BAND
BandLetter=K
Name=Current Liabilities Header
Band Style=Header
Header Of=Current Liabilities Data
Print=Yes
Start New Page=No
Blank Lines Before=1
Blank Lines After=0
Height (CM)=0.60
>
<OBJ
ObjectType=otText
Name=KT1
Value=CURRENT LIABILITIES
Print=Yes
Truncate=No
Position (CM)=0.00
Width (CM)=2.00
Font=Ms Sans Serif, 8, Black
Alignment=Left Justify
>
</BAND>
<BAND
BandLetter=L
Name=Current Liabilities Data
Band Style=Data
Account From=9600
Account To=9790
Data Source=Actual
Normal Sign=Credit
Print=Yes
Start New Page=No
Blank Lines Before=0
Blank Lines After=0
Height (CM)=0.60
>
<OBJ
ObjectType=otNumber
Name=LN1
Value=0, 0, -1, Yes
Print=Yes
Data Source=Actual
Decimals=2
Percentage Of=
Position (CM)=7.98
Width (CM)=1.40
Font=Ms Sans Serif, 8, Black
Alignment=Right Justify
>
<OBJ
ObjectType=otNumber
Name=LN2
Value=-1, 0, -1, Yes
Print=Yes
Data Source=Actual
Decimals=2
Percentage Of=
Position (CM)=13.05
Width (CM)=1.40
Font=Ms Sans Serif, 8, Black
Alignment=Right Justify
>
<OBJ
ObjectType=otText
Name=LT1
Value={Account Description}
Print=Yes
Truncate=No
Position (CM)=0.49
Width (CM)=2.00
Font=Ms Sans Serif, 8, Black
Alignment=Left Justify
>
</BAND>
<BAND
BandLetter=M
Name=Current Liabilities Total
Band Style=Total
Data Source=Actual
Normal Sign=Credit
Print=Yes
Start New Page=No
Blank Lines Before=1
Blank Lines After=0
Height (CM)=0.60
>
<OBJ
ObjectType=otNumber
Name=MN1
Value=LN1
Print=Yes
Data Source=Actual
Decimals=2
Percentage Of=
Position (CM)=7.98
Width (CM)=1.40
Font=MS Sans Serif, 8, Black, Underline
Alignment=Right Justify
>
<OBJ
ObjectType=otNumber
Name=MN2
Value=LN2
Print=Yes
Data Source=Actual
Decimals=2
Percentage Of=
Position (CM)=13.05
Width (CM)=1.40
Font=MS Sans Serif, 8, Black, Underline
Alignment=Right Justify
>
<OBJ
ObjectType=otText
Name=MT1
Value=TOTAL CURRENT LIABILITIES
Print=Yes
Truncate=No
Position (CM)=0.00
Width (CM)=2.00
Font=Ms Sans Serif, 8, Black
Alignment=Left Justify
>
</BAND>
<BAND
BandLetter=N
Name=Working Capital Total
Band Style=Total
Data Source=Actual
Normal Sign=Debit
Print=Yes
Start New Page=No
Blank Lines Before=1
Blank Lines After=0
Height (CM)=0.60
>
<OBJ
ObjectType=otText
Name=NT1
Value=WORKING CAPITAL
Print=Yes
Truncate=No
Position (CM)=0.00
Width (CM)=2.00
Font=Ms Sans Serif, 8, Black
Alignment=Left Justify
>
<OBJ
ObjectType=otNumber
Name=NN1
Value=JN1, LN1
Print=Yes
Data Source=Actual
Decimals=2
Percentage Of=
Position (CM)=7.98
Width (CM)=1.40
Font=MS Sans Serif, 8, Black, Underline
Alignment=Right Justify
>
<OBJ
ObjectType=otNumber
Name=NN2
Value=JN2, LN2
Print=Yes
Data Source=Actual
Decimals=2
Percentage Of=
Position (CM)=13.05
Width (CM)=1.40
Font=MS Sans Serif, 8, Black, Underline
Alignment=Right Justify
>
</BAND>
<BAND
BandLetter=U
Name=Fixed Assets Header
Band Style=Header
Header Of=Fixed Assets Data
Print=Yes
Start New Page=No
Blank Lines Before=1
Blank Lines After=0
Height (CM)=0.60
>
<OBJ
ObjectType=otText
Name=UT1
Value=FIXED ASSETS
Print=Yes
Truncate=No
Position (CM)=0.00
Width (CM)=2.00
Font=Ms Sans Serif, 8, Black
Alignment=Left Justify
>
</BAND>
<BAND
BandLetter=V
Name=Fixed Assets Data
Band Style=Data
Account From=9801
Account To=9899
Data Source=Actual
Normal Sign=Debit
Print=Yes
Start New Page=No
Blank Lines Before=0
Blank Lines After=0
Height (CM)=0.60
>
<OBJ
ObjectType=otNumber
Name=VN1
Value=0, 0, -1, Yes
Print=Yes
Data Source=Actual
Decimals=2
Percentage Of=
Position (CM)=7.98
Width (CM)=1.40
Font=Ms Sans Serif, 8, Black
Alignment=Right Justify
>
<OBJ
ObjectType=otNumber
Name=VN2
Value=-1, 0, -1, Yes
Print=Yes
Data Source=Actual
Decimals=2
Percentage Of=
Position (CM)=13.05
Width (CM)=1.40
Font=Ms Sans Serif, 8, Black
Alignment=Right Justify
>
<OBJ
ObjectType=otText
Name=VT1
Value={Account Description}
Print=Yes
Truncate=No
Position (CM)=0.49
Width (CM)=2.00
Font=Ms Sans Serif, 8, Black
Alignment=Left Justify
>
</BAND>
<BAND
BandLetter=W
Name=Fixed Assets Total
Band Style=Total
Data Source=Actual
Normal Sign=Debit
Print=Yes
Start New Page=No
Blank Lines Before=1
Blank Lines After=0
Height (CM)=0.60
>
<OBJ
ObjectType=otNumber
Name=WN1
Value=VN1
Print=Yes
Data Source=Actual
Decimals=2
Percentage Of=
Position (CM)=7.98
Width (CM)=1.40
Font=MS Sans Serif, 8, Black, Underline
Alignment=Right Justify
>
<OBJ
ObjectType=otNumber
Name=WN2
Value=VN2
Print=Yes
Data Source=Actual
Decimals=2
Percentage Of=
Position (CM)=13.05
Width (CM)=1.40
Font=MS Sans Serif, 8, Black, Underline
Alignment=Right Justify
>
<OBJ
ObjectType=otText
Name=WT1
Value=TOTAL FIXED ASSETS
Print=Yes
Truncate=No
Position (CM)=0.49
Width (CM)=2.00
Font=Ms Sans Serif, 8, Black
Alignment=Left Justify
>
</BAND>
<BAND
BandLetter=X
Name=Net Assets Total
Band Style=Total
Data Source=Actual
Normal Sign=Debit
Print=Yes
Start New Page=No
Blank Lines Before=1
Blank Lines After=0
Height (CM)=0.60
>
<OBJ
ObjectType=otNumber
Name=XN1
Value=NN1, WN1
Print=Yes
Data Source=Actual
Decimals=2
Percentage Of=
Position (CM)=7.98
Width (CM)=1.40
Font=MS Sans Serif, 8, Black, Underline
Alignment=Right Justify
>
<OBJ
ObjectType=otNumber
Name=XN2
Value=NN2, WN2
Print=Yes
Data Source=Actual
Decimals=2
Percentage Of=
Position (CM)=13.05
Width (CM)=1.40
Font=MS Sans Serif, 8, Black, Underline
Alignment=Right Justify
>
<OBJ
ObjectType=otText
Name=XT1
Value=NET ASSETS
Print=Yes
Truncate=No
Position (CM)=0.49
Width (CM)=2.00
Font=Ms Sans Serif, 8, Black
Alignment=Left Justify
>
</BAND>
</PAGE>




Copy upto last line.

Try opening the table now using protocol firebird-1.5 and you get the error

SQL error Segment buffer length shorter than expected: Error Code 101. segment buffer length shorter than expected.

Regards

Sandeep

[sandeep_c24]

I haven't had a reply for this for a long time so I thought I might check to see if anyone is around. I know there are quite a few people working on this, but it would be great if a list of developers, along with their responsibilities can be published.

Regards

Sandeep