memory leak with varchar(max) in sql

Stimulsoft Reports.NET discussion
Post Reply
siakefh
Posts: 13
Joined: Mon Nov 23, 2015 1:07 pm

memory leak with varchar(max) in sql

Post by siakefh »

Hello.
If in one report with varchar(max) column from sql server and that column has large len(longcol)=1586059 in my case the designer hughs in prievew and reports also and memory allocation comes to 100 % .
Regards
Efh
Alex K.
Posts: 6488
Joined: Thu Jul 29, 2010 2:37 am

Re: memory leak with varchar(max) in sql

Post by Alex K. »

Hello,

We couldn't reproduce this bug.
Can you please describe your issue in more details. Also, can you please send us a simple report with test data for analysis.

Thank you.
siakefh
Posts: 13
Joined: Mon Nov 23, 2015 1:07 pm

Re: memory leak with varchar(max) in sql

Post by siakefh »

test with actual data.
Backup is database db1 with 1 table t1 (id int identity , lcol Varchar(MAX)) and 1 row with actual data from client
Attachments
db1.7z
(200.81 KiB) Downloaded 220 times
Alex K.
Posts: 6488
Joined: Thu Jul 29, 2010 2:37 am

Re: memory leak with varchar(max) in sql

Post by Alex K. »

Hello,

Thank you for the test database. We need some time to investigate the issue.

We will let you know about the result.
Thank you.
Alex K.
Posts: 6488
Joined: Thu Jul 29, 2010 2:37 am

Re: memory leak with varchar(max) in sql

Post by Alex K. »

Hello,

Problems in GDI+. On such a large text just falls Draw method in GDI+, no drawing, no measure does not work.
Please try to limit your text. It is not possible to show the entire text.

Also, if you replace all tab characters on the space character, report should work.

Thank you.
siakefh
Posts: 13
Joined: Mon Nov 23, 2015 1:07 pm

Re: memory leak with varchar(max) in sql

Post by siakefh »

thank you . truncated and worked.
HighAley
Posts: 8430
Joined: Wed Jun 08, 2011 7:40 am
Location: Stimulsoft Office

Re: memory leak with varchar(max) in sql

Post by HighAley »

Hello.

We are always glad to help you.
Let us know if you need our help.

Thank you.
Post Reply