Page 1 of 1
memory leak with varchar(max) in sql
Posted: Wed Jul 20, 2016 8:43 am
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
Re: memory leak with varchar(max) in sql
Posted: Wed Jul 20, 2016 5:23 pm
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.
Re: memory leak with varchar(max) in sql
Posted: Thu Jul 21, 2016 6:48 am
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
Re: memory leak with varchar(max) in sql
Posted: Fri Jul 22, 2016 8:31 am
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.
Re: memory leak with varchar(max) in sql
Posted: Fri Jul 22, 2016 12:22 pm
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.
Re: memory leak with varchar(max) in sql
Posted: Sun Jul 24, 2016 3:47 pm
by siakefh
thank you . truncated and worked.
Re: memory leak with varchar(max) in sql
Posted: Mon Jul 25, 2016 5:33 am
by HighAley
Hello.
We are always glad to help you.
Let us know if you need our help.
Thank you.