Hi Aparajita, I’m posting an ObjectTools question here because this forum is active. Please let me know if there is a better place for this question.
We are running ObjectTools 3.0r5 on 4D v12.3 Hotfix 4 and on 4D v13.0 Hotfix 1. In both versions of 4D, many, if not all, of our data files and our customers’ data files become spontaneously corrupted all the time. Sometimes it is difficult or impossible to repair them with MSC. Often the corrupted data files suffer spontaneous crashes during regular operations. MSC reports that there are ‘orphan BLOBS’ in many tables, even in tables that don’t contain any BLOBs. We’re having a very hard time solving this problem. We recently found that 4D stores BLOBs by default ‘in data file’, but that v13 has added an option to store BLOBs ‘in record’. 4D Tech Support says that this new option was not added because of a known problem with storing BLOBs ‘in data file’, but was just a feature request. Do you have any knowledge of problems with storing BLOBs in 4D? Most of our BLOBs store ObjectTools information. Typical code to create a BLOB is: $tempBlob:=x_OTNew (Current method name) x_OTputArray ($tempBlob;"alLongText1";->alLongText1) x_OTputArray ($tempBlob;"alLongText2";->alLongText2) x_OTputArray ($tempBlob;"alLongText3";->alLongText3) x_OTputArray ($tempBlob;"alLongText4";->alLongText4) x_OTputArray ($tempBlob;"alLongText5";->alLongText5) x_OTputArray ($tempBlob;"aLongInt1";->aLongInt1) x_OTputLong ($tempBlob;"r_userTopics";r_userTopics) x_OTputLong ($tempBlob;"r_systemTopics";r_systemTopics) READ WRITE([Resources]) QUERY([Resources];[Resources]ID=shUser_getStaffID ) SET BLOB SIZE([Resources]Palette_Preferences;0) // line of code added this week in case voodoo is affecting us [Resources]Palette_Preferences:=OT ObjectToNewBLOB ($tempBlob) All of the arrays and variables are valid. Is there anything obvious we are doing wrong in ObjectTools? Thanks for your help, Victor _______________________________________________ Active4D-dev mailing list [email protected] http://list.aparajitaworld.com/listinfo/active4d-dev Archives: http://vasudev.aparajitaworld.com/archive/active4d-dev/
