size limit for blob/dyn_blob in raima?

[kilianvp]

is there any limitation on size stored in blob/dyn_blob?

i tried 429 mb

Code: Select all

WCCILdata    (0), 2017.10.26 22:00:41.336, SYS,  SEVERE,     69, Database error, DataManTask, dbError, RAIMA Database Error *** Code:-909 (SYSTEM/OS error: -909
file record limit exceeded
C errno = -1: Unknown error
FILE: D:\\workspaces\\3.15\\workspace\\ExternLibs\\rdm45\\runtime\\Dio.c(2096)), errno:-1 (Unknown error)
WCCILdata    (0), 2017.10.26 22:00:41.336, SYS,  SEVERE,     69, Database error, StVLastVariableUtils, updateVariable-909
WCCILdata    (0), 2017.10.26 22:00:41.337, SYS,  SEVERE,     69, Database error, StVLastVariableUtils, updateVariable-909

[leoknipp]

The log message describes that the limit for storing the last values have been reached, at least on record type has reached the limit.
For every record type (e.g. bit variable, float variable, ...) in the RAIMA database there is a limit of 16.777.216 records.
How many records of which type are needed to store the information depends on the datatype and the amount of data.

There is no fixed limit defined in the database. Which amount of data can be saved additionaly depends on how much data is already saved.
Storing a given amount of data will probably work in one project and not in another one if there are more records already used.

Why do you want to store a blob of 429MB?
Is it necessary to store it in the database or do you just need the information during runtime?

If there is no need to store it persistently in the database you can deactivate the last value storage for this dp element.

Best Regards
Leopold Knipp
Senior Support Specialist

[kilianvp]

I encode files to base64 and store them in the Database. On the Server side a script decodes the string back to files.

Deactivate the last value storage is good hint.

//Edit

I can't find the option

[Gertjan van Schijndel]

With a blob there is no need to encode it. You could read a file directly in a blob with 'blobRead'.
With the base64 encoding you could also store it in a (dyn_)string.