TFDParam.Size to a greater value

Hello Folks!

I do have a problem with a DataSnap server using FireDAC against MS SQL. We have created memo fields of type VarChar(max) in MS SQL, which should support up to 2 GB. When our users post a big memo content (e.g. more than 8002 bytes) the app server runs into an exception:
[FireDAC][Phys][ODBC]-345. Data too large for variable [#1]. Max len = [8002], actual len = [224088] Hint: set the TFDParam.Size to a greater value

If I do the same update without a ClientDataSet and a DataSetProvider - only using a FDQuery - all is fine. Though when using the DataSetProvider and a TSQLResolver the ftMemo field is truned into a ftString parameter inside TParam.AssignFieldValue.

Here is the call stack at the time the error is raised by the FireDAC ODBC driver:
{code}
:766db727 KERNELBASE.RaiseException + 0x58
FireDAC.Stan.Error.FDException(???,???,???)
FireDAC.Stan.Error.FDException($2F3F180,???,345,???)
FireDAC.Phys.ODBCWrapper.ErrorDataTooLarge(8002,8407)
FireDAC.Phys.ODBCWrapper.TODBCVariable.SetData(???,$2EDAECC,8407)
FireDAC.Phys.ODBCBase.ProcessArrayItem($3002630,$2F77C88,0,???)
FireDAC.Phys.ODBCBase.TFDPhysODBCCommand.SetParamValues(1,0,-1)
FireDAC.Phys.ODBCBase.TFDPhysODBCCommand.InternalExecute(1,0,0)
FireDAC.Phys.Process_HandleSystemFailure(1,0,0,False)
FireDAC.Phys.Process_SingleRow
FireDAC.Phys.TFDPhysCommand.ExecuteBase(1,0)
FireDAC.Phys.TFDPhysCommandAsyncExecute.Execute
FireDAC.Stan.Async.TFDStanAsyncExecutor.ExecuteOperation(False)
FireDAC.Stan.Async.TFDStanAsyncExecutor.Run
FireDAC.Phys.TFDPhysCommand.ExecuteTask(TFDPhysCommandAsyncExecute($2FCBEC0) as IFDStanAsyncOperation,TFDCommand($2F0FD20) as IFDStanAsyncHandler,False)
FireDAC.Phys.TFDPhysCommand.Execute(???,???,False)
FireDAC.Comp.Client.TFDCustomCommand.InternalExecute(0,0,False)
FireDAC.Comp.Client.TFDCustomCommand.Execute(0,0,False)
FireDAC.Comp.Client.TFDAdaptedDataSet.DoExecuteSource(0,0)
FireDAC.Comp.DataSet.TFDDataSet.Execute(0,0)
FireDAC.Comp.Client.TFDCustomQuery.ExecSQL
FireDAC.Comp.Client.TFDAdaptedDataSet.InternalPSExecuteStatement('update "TestMemo"  set'#$D#$A' "VarCharMemo" = ?'#$D#$A'where'#$D#$A' "ID" = ?'#$D#$A,$2FCB870,0,$2F26370)
FireDAC.Comp.Client.TFDAdaptedDataSet.PSExecuteStatement(???,???)
Datasnap.Provider.TSQLResolver.DoExecSQL($622F38,$2FCB870)
Datasnap.Provider.TSQLResolver.InternalDoUpdate(???,ukModify)
Datasnap.Provider.TSQLResolver.DoUpdate(???)
Datasnap.Provider.TCustomResolver.InternalUpdateRecord($2FD0560)
Datasnap.Provider.TUpdateTree.DoUpdates
Datasnap.Provider.TCustomResolver.ApplyUpdates(Variant array of Byte,0,0)
Datasnap.Provider.TBaseProvider.InternalApplyUpdates(Variant array of Byte,0,0)
Datasnap.Provider.TDataSetProvider.InternalApplyUpdates(Variant array of Byte,0,0)
Datasnap.Provider.TCustomProvider.DoApplyUpdates(Unknown type: 20688,0,0,Unassigned)
Datasnap.Provider.TCustomProvider.ApplyUpdates(Variant array of Byte,0,0,Unassigned)
Datasnap.Provider.TLocalAppServer.AS_ApplyUpdates('DataSetProvider1',Variant array of Byte,0,0,Unassigned)
Datasnap.DBClient.TCustomClientDataSet.DoApplyUpdates(Variant array of Byte,0,0)
Datasnap.DBClient.TCustomClientDataSet.ApplyUpdates(0)
Unit1.TForm2.ClientDataSet1AfterPost($2F25920)
Data.DB.TDataSet.DoAfterPost
Data.DB.TDataSet.Post
Datasnap.DBClient.TCustomClientDataSet.Post
Vcl.DBCtrls.TDBNavigator.BtnClick(nbPost)
Vcl.DBCtrls.TDBNavigator.ClickHandler(???)
Vcl.Controls.TControl.Click
Vcl.Buttons.TSpeedButton.Click
Vcl.Buttons.TSpeedButton.MouseUp(mbLeft,[],???,???)
Vcl.DBCtrls.TNavButton.MouseUp(???,[],9,19)
Vcl.Controls.TControl.DoMouseUp((514, (), 0, (), 9, 19, (), (9, 19), (), 0),(out of bound) 40)
Vcl.Controls.TControl.WMLButtonUp((514, (), 0, (), 9, 19, (), (9, 19), (), 0))
Vcl.Controls.TControl.WndProc((514, 0, 1245193, 0, 0, 0, (), 9, 19, (), 0, 0, ()))
Vcl.Controls.TControl.Perform(???,???,1245193)
Vcl.Controls.TWinControl.IsControlMouseMsg((514, (), 0, (), 177, 19, (), (177, 19), (), 0))
Vcl.Controls.TWinControl.WndProc((514, 0, 1245361, 0, 0, 0, (), 177, 19, (), 0, 0, ()))
Vcl.Controls.TWinControl.MainWndProc(???)
System.Classes.StdWndProc(5048084,514,0,1245361)
:751e62fa ; C:\Windows\syswow64\USER32.dll
:751e6d3a USER32.GetThreadDesktop + 0xd7
:751e77c4 ; C:\Windows\syswow64\USER32.dll
:751e788a USER32.DispatchMessageW + 0xf
Vcl.Forms.TApplication.ProcessMessage(???)
:005fe680 TApplication.ProcessMessage + $F8
:45c6f445
{code}

I have build a small sample application that illustrates the problem. Part of the sample project is the option to switch between FDQuery (works fine) & ClientDataSet (crashes). To get to the problem the user of the sample app has to enter more than 8002 bytes of memo text. Here is the download URL:
http://www.maranatha-consulting.com/Delphi/TFDParam.Size.zip

I am looking forward to your suggestions.

Salut,
  +Mathias+
-1
Mathias
7/1/2015 7:57:56 AM
embarcadero.datasnap 643 articles. 1 followers. Follow

0 Replies
2047 Views

Similar Articles

[PageSpeed] 32
Get it on Google Play
Get it on Apple App Store

Reply:

Similar Artilces:

TFDParam.Size to a greater value [Edit]
Hello Folks! I do have a problem with a DataSnap server using FireDAC against MS SQL Server 2012. We have created memo fields of type VarChar(max) in MS SQL, which should support up to 2 GB. When our users post a big memo content (e.g. more than 8002 bytes) the app server runs into an exception: [FireDAC][Phys][ODBC]-345. Data too large for variable [#1]. Max len = [8002], actual len = [224088] Hint: set the TFDParam.Size to a greater value If I do the same update without a ClientDataSet and a DataSetProvider - only using a FDQuery - all is fine. Though when using the DataSetProvider an...

MobiLink Replication of Image data type
Replicating data between ASE15 and ASA9 databases. A particular table existing in both database is of type image can hold pictures and windows movie content etc. We are succesfully loading content up to about 4Mb in size but when replicated from ASE to ASA the content is cut off a 1Mb. Is there a switch/setting we can set to have the entire column successfully replicate? Found the ansa in a different reply from Sybase (in part): The blob was larger than the DefaultLongDataBuffLen (Default Buffer Size for Long Columns) setting in my ODBC DSN (or in the MobiLink connect st...

[Thunderbird] values of macAccountManager.size and prefWindow.size
Hi all, while packaging the Mac builds I noticed that some locales either kept the en-US values in macAccountManager.size or entered some other strange values. As the Account Manager _cannot_ be resized by the user on Mac, it is important that we use usable values here. So here is my idea: as most locales need bigger windows that en-US, please a) either test on a Mac b) if you cannot do so and think you need a bigger window than en-US, use "73em" as width. This does not break 800x600 resolution and fits most of the locales (except ca-AD so far) for some locales, as...

Is Greater Greater?
Hi, In util.c (2 places) there is: (PERL_ABS(rev) > VERSION_MAX ) VERSION_MAX is defined 0x7FFFFFFF (highest + in a signed int) and 'rev' defined as I32 (also signed), so how can 'rev' ever be greater than VERSION_MAX?? By dropping VERSION_MAX to 0x7FFFFFFE confirm my compiler no longer sees this comparison a permanent (logic) 0. Given the numeric size of an int, wonder if versions could really get that large? Norm On 08/03/2011 05:23 AM, NormW wrote: > Hi, > In util.c (2 places) there is: > > (PERL_ABS(rev) > VERSION_MAX ) >...

If Not value or value then....
Hi all,I want to write a simple IF Not then statement in ASP.net 2.0 and I would like some help please.  If Not ntuser = "DOMAIN\ntuser" Or ntuser = "DOMAIN\ntuser2" Then Panel1.Visible = False End If Doesnt work, can you tell me where i'm going wrong please?many thanks.  The first place you're going wrong is in telling us it "doesn't work" without providing any details. JeffPlease: Don't forget to click "Mark as Answer" on the post that helped you. That way future readers will know which post solved your issue. Use Not as stated below. It ...

superreview granted: [Bug 425849] Consider changing mail.imap.fetch_by_chunks pref value : [Attachment 328688] this persists the calculated chunk size, and starts with a bigger chunk size, and grows i
neil@parkwaycc.co.uk <neil@httl.net> has granted David Bienvenu <bienvenu@nventure.com>'s request for superreview: Bug 425849: Consider changing mail.imap.fetch_by_chunks pref value https://bugzilla.mozilla.org/show_bug.cgi?id=425849 Attachment 328688: this persists the calculated chunk size, and starts with a bigger chunk size, and grows it faster https://bugzilla.mozilla.org/attachment.cgi?id=328688&action=edit ------- Additional Comments from neil@parkwaycc.co.uk <neil@httl.net> >+static PRBool gNeedChunkSizeWritten = PR_FALSE; Looks good, but I'...

superreview requested: [Bug 425849] Consider changing mail.imap.fetch_by_chunks pref value : [Attachment 328688] this persists the calculated chunk size, and starts with a bigger chunk size, and grows
David Bienvenu <bienvenu@nventure.com> has asked neil@parkwaycc.co.uk <neil@httl.net> for superreview: Bug 425849: Consider changing mail.imap.fetch_by_chunks pref value https://bugzilla.mozilla.org/show_bug.cgi?id=425849 Attachment 328688: this persists the calculated chunk size, and starts with a bigger chunk size, and grows it faster https://bugzilla.mozilla.org/attachment.cgi?id=328688&action=edit ------- Additional Comments from David Bienvenu <bienvenu@nventure.com> something else to try... ...

superreview granted: [Bug 181712] Menu item for "default font size" (also indicate current text/font zoom value/size?) : [Attachment 237374] r=smorgan patch
Mike Pinkerton <mikepinkerton@mac.com> has granted froodian <stridey@gmail.com>'s request for superreview: Bug 181712: Menu item for "default font size" (also indicate current text/font zoom value/size?) https://bugzilla.mozilla.org/show_bug.cgi?id=181712 Attachment 237374: r=smorgan patch https://bugzilla.mozilla.org/attachment.cgi?id=237374&action=edit ------- Additional Comments from Mike Pinkerton <mikepinkerton@mac.com> sr=pink. are we sure those getter_addrefs -> dont_addrefs are correct? ...

superreview requested: [Bug 181712] Menu item for "default font size" (also indicate current text/font zoom value/size?) : [Attachment 237374] r=smorgan patch
froodian <stridey@gmail.com> has asked Mike Pinkerton <mikepinkerton@mac.com> for superreview: Bug 181712: Menu item for "default font size" (also indicate current text/font zoom value/size?) https://bugzilla.mozilla.org/show_bug.cgi?id=181712 Attachment 237374: r=smorgan patch https://bugzilla.mozilla.org/attachment.cgi?id=237374&action=edit ------- Additional Comments from froodian <stridey@gmail.com> Pink, this blocks all the menu cleanup work for 1.1, so a speedy sr would be most helpful for me. :) ...

Purgable size has a negative value.
Folks, On a volume of one of my servers I have a negative value for Purgable size (-512 Kb) Now what sense do I make of this ! TIA Hi, Kapil wrote: > > Folks, > > On a volume of one of my servers I have a negative value for Purgable size > (-512 Kb) > Now what sense do I make of this ! As we neither know your OS version or patch, nor any other details, I'm afraid nobody can tell you. :-) CU, -- Massimo Rosen Novell Support Connection Sysop No emails please! http://www.cfc-it.de NW6/SP3 And the volume is NSS Thanks...

Checking The value is Greater Than Zero
Hi,           I have a text box inm my form. I need to check the value in the textBox is Greater than zero in Server Side. So  i tried to do like Dim txt as Double=TryCast(TxtBox.Text,Double) if Not(txt isNothing) then method() endif    But im Getting error on the Dim txt as Double=TryCast(TxtBox.Text,Double) error is trycast operand must be reference type,but double is a value type.  pla help meThanks, TryCast only works for reference types (i.e. objects). Since double is a value type, you cannot use ...

image size greater than 64k
Hi.. I am using ASA 703 #2046... Is there any way for ultralite to hold images which has its size greater than 64k byte?? I believe long varchar & long binary have size limit < 64k... and Is this true? Thank you The 64k limit for the LONG VARCHAR and LONG BINARY datatypes is documented. UltraLite User's Guide APPENDIX A. UltraLite Features and Limitations UltraLite data types So if you wanted to store an image greater than 64k, you would have to break it up in to 64k chunks and store it in multiple columns. -- ------------------------...

About the Default value of zoom size
Name: nvin Email: nvinatvipdot163dotcom Product: Firefox Summary: About the Default value of zoom size Comments: Can firefox provide the option to defining the default value of Zoom size at the right bottom of firefox? This must be a very useful function. Now I can only change the zoom size value of every single page, there is no option to define the zoom size value for all pages. You can't image how bore to define the zoom size value for every html page, but I think many users need this function because their lcd is 1920x1200 or 1680x1050, we need bigger fonts for defa...

Matching each value out of multiple values to single column value
 Hi,  @whoposted in stored procedure holds value "agent  builder owner"  ( please note the space in between) My column  POSTED_BY  always holds one and only one value out of above 3.Example:       POSTED_BY  owneragent          etc... If  All / any of the value hold by  @whoposted matches with value of POSTED_BY column, i want to show that row in gridview.( Also, please note, str may hold different values depending on user selection. For example, it may ...

size of the value linked to param?
Hi, I use HTML and PERL. The TEXTAREA value linked to param doesn't accept more than 2k. method is GET, I tried PUT. doesn't work. Any solution? Thanks Pierre _________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. <on 28.05.01, P lerenard wrote> > Hi, > I use HTML and PERL. > The TEXTAREA value linked to param doesn't accept more than 2k. > > method is GET, I tried PUT. doesn't work. Hiya, Do you mean POST? It would be useful to know...

Column Value Greater Than 255
Hi, 1) Is there a way to create a column with data type char or varchar having size more than 255? 2) Is there a way to retrive the values from more than one column having a combined size of greater than 255?? (Say for ex. col1 150, col2 150)?? TIA, Hi, Wait until ASE 12.5 SId. Sishya wrote: > Hi, > > 1) Is there a way to create a column with data type char or varchar having > size more than 255? Not yet, ASE 12.5 will have that capability. > 2) Is there a way to retrive the values from more than one column having a > combined size...

Setting Cache Size greater than 1gB
As part of a third party application, Sysbase Anyware came bundled. There seems to be a difference of opinion regarding max cache size. Each time we try to set the cache size greater than 1024m, the Sybase service (for new created dB's) are unable to start up. Is this a Sybase restriction or does it have to do with the application / machine class / settings / etc.. What OS? What version of SQL Anywhere? The 1024m is not the expected limit for cache size on most platforms. You should be able to get to between 1.3 and 1.6GB cache on most Windows platforms (and 2GB for most oth...

Maximum Size of To:, Cc:, and Bc: values
I have a user that has reported that the Windows GW 6.5.2 client does not allow more that 88 internet address in the Bc: field. My guess that this is about 2048 characters, or close to it. Is there a limitation of the number of characters for any of these values? Does the RFC state a maximum value? Thanks for your help. Brian No maximum in the RFC. However I'm not aware of a limit in the client -- Michael J. Bell Novell Support Connection Volunteer Sysop Author of Guinevere (http://www.openhandhome.com) PLEASE: Do not e-mail me privately unless specifically ask...

Device size greater then 2 GB
Does anyone know which version of ASE and Sun Solaris supports Sybase device more then 2 GB Please reply ASAP See http://www.sybase.com/detail/1,3693,800,00.html -bret Pankaj R Patel wrote: > Does anyone know which version of ASE and Sun Solaris supports Sybase > device more then 2 GB > > Please reply ASAP Is this information correct? I see that ASE 11.9.2 on HP-UX supports raw and file devices of up to 32GB. I thought that file devices where still limited to 2GB. I'm a bit confused because I asked this question to Sybase Tech Support a ...

Good Cache Size value to set
I am trying to find a good tradeoff for setting a cache size for Mozilla. It's currently set for 20 megs on ramdisk. (I noticed that bigger ramdisk cause memory fragmentation faster) Will there be a significant slowdown if I went to 10 megs ? andrewkennedy1@ev1.net wrote: > I am trying to find a good tradeoff for setting a cache size for Mozilla. > > It's currently set for 20 megs on ramdisk. (I noticed that bigger ramdisk > cause memory > fragmentation faster) > > Will there be a significant slowdown if I went to 10 megs ? On dialup you mig...

Gridviewhelper And Greater Than Zero Values Avg
Hi everybody,I've tried Agrinei Gridviewhelper and it works like a charm. I only got a problem with Summary when choosen operation is AVG.As a matter of fact, Avg is calculated upon all of the elements of the gridview, while I'd like to obtain a more significant average, based only upon elements that are greater than zero. I've tried looking around in configuration files, but I don't seem to succeed in discard these annoying elements. Can anyone please point me to the right direction?TIA     Hi,I've succeeded in find a solution. But now I'm stuck...

datalist size + value of textbox after postbackurl
Hello everybody, asp.net is pretty new to me so i have a few simple questions. I am working on a page to send emails. First, i have a table with in one row a datalist, that is a presentation of email attachments. Now I loop through all these elements and i want to show them all after each other horizontal, but the problem is that if i don' t specify the number of columns the size of my page ( and table )  will increase if the list of items becomes to great, and if i specify for example 4 columns, everything looks ok if i have for example 4 attachments, but when i have only 2 atta...

Increasing the Connection Pool Size to be Greater than 100
We support a site of 600 users and the following message displays sometimes when many people are hitting the site. People are getting this because there are 100 connections to the database. Does anyone know how to increase the pool size??? Message: Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached Hi, Try to add "max pool size" to your connection string : connstring ="Provider=SQLOLEDB;Data Source=YourSQLServer;Integrated Secu...

procedure cache size exceeds configured value
ASE 15.0.2 ESD#2 Why active procedure cache size from sp_monitorconfig keep increasing and exceeds configured value? sp_configure "procedure cache size" Parameter Name Default Memory Used Config Value Run Value Unit Type procedure cache size 7000 348762 160000 160000 memory pages(2k) dynamic sp_monitorconfig "all" Name Num_free Num_active Pct_act Max_Used Reuse_cnt max memory 465456 2606544 84.85 2606544 0 procedure cache size 0 542172 100.00 572244 ...

Web resources about - TFDParam.Size to a greater value - embarcadero.datasnap

Resources last updated: 3/13/2016 10:18:56 PM