Apex Code Development You need to sign in to do that
Don't have an account?
bdPeter Can SmartStore soup accept large base64 string as a field in record?
In my hybrid app I am creating Attachment records in SmartStore (which later at the user's convenience can be uploaded to Salesforce). This is all working fine with the MockSmartStore. However, with the actual SmartStore on a device I am getting an NPObject exception (see 'Body' field in trace below).
Can the SmartStore handle a large string containing a base64 string?
Thanks
Peter
D/CordovaLog( 2137): file:///android_asset/app/scripts/vendor/cordova.force.js: Line 479 : SmartStore.registerSoup: 'smA
ttachments_a00i0000005SH72AAG' indexSpecs: [{"path":"ParentId","type":"string"},{"path":"TimeStamp","type":"integer"}]
D/CordovaLog( 2137): file:///android_asset/app/scripts/controllers/controllers.js: Line 747 : onAcceptAttachments: attac
hments soup registered, issuing write for attachments record
D/CordovaLog( 2137): file:///android_asset/app/scripts/controllers/controllers.js: Line 748 : onAcceptAttachments: {"Tim
eStamp":1377020402902,"Name":"1377020392246.jpg","Description":"","IsPrivate":false,"ParentId":"003i000000CsLkpAAF","Con
tentType":"image/jpeg","Body":"/9j/4AAQSkZJRgABAQAAAQABAAD/2wBDAAIBAQEBAQIBAQECAgICAgQDAgICAgUEBAMEBgUGBgYF\nBgYGBwkIBgc
JBwYGCAsICQoKCgoKBggLDAsKDAkKCgr/2wBDAQICAgICAgUDAwUKBwYHCgoKCgoK\nCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKC
goKCgr/wAARCAHgAoADASIA\nAhEBAxEB/8QAHwAAAQUBAQEBAQEAAAAAAAAAAAECAwQFBgcICQoL/8QAtRAAAgEDAwIEAwUFBAQA\nAAF9AQIDAAQRBRIhM
UEGE1FhByJxFDKBkaEII0KxwRVS0fAkM2JyggkKFhcYGRolJicoKSo0NTY3\nODk6Q0RFRkdISUpTVFVWV1hZWmNkZWZnaGlqc3R1dnd4eXqDhIWGh4iJipK
TlJWWl5iZmqKjpKWm\np6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW19jZ2uHi4+Tl5ufo6erx8vP09fb3+Pn6/8QAHwEA\nAwEBAQEBAQEBAQAAAAAAAAE
CAwQFBgcICQoL/8QAtREAAgECBAQDBAcFBAQAAQJ3AAECAxEEBSEx\nBhJBUQdhcRMiMoEIFEKRobHBCSMzUvAVYnLRChYkNOEl8RcYGRomJygpKjU2Nzg5O
kNERUZHSElK\nU1RVVldYWVpjZGVmZ2hpanN0dXZ3eHl6goOEhYaHiImKkpOUlZaXmJmaoqOkpaanqKmqsrO0tba3\nuLm6wsPExcbHyMnK0tPU1dbX2Nna4
uPk5ebn6Onq8vP09fb3+Pn6/9oADAMBAAIRAxEAPwDyoAqS\ngbOO9NzhgN36U7yHV23AnBwcdqaV+beGxx6V+bqp0sfdpP5jCcMQ3T3qFgd+A2MHtU6xPI2
1iTn0\nphi8oMGGc9K1nzuO2g+ez5RklzmFgOGIxweK5DWPKGsKQ5BByMetdRdR7IsnBOOtcpf26S6yPLYk\nDnHvmoU5vRMpRjfU3dFiRpEkeQHkewHNdCi
hwQwx71zmgRtJc7UPpyRwK6REfy/v7sDg+lKnUcpa\nIc9rIayMSQWBx1x2qpLY3UTCeAA89DVoSAgo3brx1oKse/Aq1GNdt2HQrVKErxepNpWuC2uFgkYj\
n1ArstC8WmLBjvAMY4J7VwjQLImdn0NOhuZbM7myRkdPxrGeElO/IfQ4DN6Tly1tz23wz4jiv3DSS\nkgHJI7/5/rXf+F9Xton+1LIC3b2FfOnhnxXHanZJL
t5713/h/wAcwwjy5LgEqOMmudKpT9yx9DB4\naouZH0FomtrcRAB0BDDr6VtXt6DCPKcAkfMF715B4Q8Zi5fzIrlflxn5v8a7JPGCs6xREHI456Vt\nGrG3v
GVTDxlK6NbU7Z7iBpIEIfHp1rJtRdRSGQthQe4wau22t+ZEczqcH6Vn6rrFrGDI8oRV65ro\nXK1e5y8rTasbXh/WEiv3hkk6jJI7Vd8U/FPw14L0uTVvEGp
xwQRKWLOcV4d8Sf2iPD/w7t2aGXzb\ngD92iEZP19BXzD8UPjb4t+KOpSXWtalJ5IJ8m3U4ROvQV6OFoykr2PDzLMKeGvGO56l+0R+234i8\nazXPhrwOfst
gwKNcbf3jrz+Qr54u57idzPJJubOSWNMJlZtwcEGmMqhmbBYoOle1SUKdPTc+Lr4q\nriKnvMhWaR7jcqZx69KtLJcbNw4DYyAaqxRSGRzI+3I4xU0ccixhE
l/3iRk1gptN8zJjLTQW6nmz\n5nmcKAMGqE7yXCOVU5zngdK1EgwhmbOAeDjPNOWFFjyExzzVQbTvF3I5XJNtHDa5omtaj/x7QYDH\nH1rk9R8A66khml0sy
KRgtjrXrM93bwtjYCwPQHpWVceJbaElZ5YiS3UmqlFqXN1MvZwSep5Ja2Pi\nTwhqvnf2ZJGhPzZTgiuy0/Uzf2XnbCr9wR0rR1fxnoduS9zdRlM8dDXLax8
RtNj3GwhZ8/w4xmua\nvh1V0d2zWhiY0OptPBcK29Jty9cKO9W7SGW5AVwA38WK4C28R/ELUpc6NZShScAFMqQc+orf8O3X\njy0d5das4ogOozzXN9SlD4D
vp4+E3qjtbZrPyfsczbc/x1V8l0u2t0lDKpG0+tcL4z8c6hY6fI9s\noU/xYHPWtj4Waxf6roUd/qcm4uf3bfQ966KNCSl7zMsRioz91I6/bvHlu3PqBxVWR
wVdGXBB+/61\nMZpvKLKm5s4+lVbrLKVRsvnkCumMby1OZN2sJG0c1yjswBX8ia3dOiEr4kII7ZrH0613puuV5HQg\nVu6OiRqSEAAHB71T+LshpKS3Lxt4r
aHcXwO9ZuoRBuSflz19a2JmVlGUz8ozmsi+n8wPGgAAPbvV\n8sXBtBzNbMrTBiQoxgUqQgfMxxtPA702NLlW28FQOpqWRQAWMgxjnPas4KU4jTguoxtzZKo
cD2qM\nxoYyODn36VOSFQhG6qPxqvbDMrRueR0pyk17u4XbXkSRRmQgJ0FCxzR/KjA45J9adIxt02nPPamF\n2yAFxxxWjlHlt1HG1guGZ5drEH0H50yQBFz
JnB6HHFShDISXUdOCKhH+kofMdgFbAAFRKSSvuQkn\ndhGFZty8HPU1PGSpKyc474qCFWYbC3TpgUkCtg+cec0KSEnbYlD71Ygj5TilDbbUrkHPUYqN5Bnb\
njnOBTSj5KqccdDRLlvYabauPth+7ZOmVwc1GIBHOMybgOntSQM0RMM8g9qY0ju4IB4Pap9xQsJc1\ntSeRJdv3+/U9qiuYlEXlIAT2INOJdty8jIHSokfCG
NcZP8VNSTV7MpOy0GRRKTmUZIGODSOqAFlc\njg4IocgRlVbHPLVHAzSAhQCAeuaXPDa2olFvUVJ/Kj8t8sT0wPrViK5YRmM4BI71GgeCIlnyemB+\nNNRWu
W3oTlOM1Sk4u1yElYsKJFjdlUEd+etQlZfKZj2HIFWo42WP58k/WopQ+87XPPfFXOLa0CMl\nFaFYRKQG3YxwQBT33uhicHA+7mpVtyq+WZRn6VFM8auLYSZ
I7gVmm4/EU0n1uQxiOG5xsJ445+tS\nSTmEeZkckZxRIYjJ5aDJHXjpTUXzSRLwvbA5qkrbE+7bUUK0ibopunPIpFlmCnpk9CopEKqhiWYE\njgHH1qFJHhJ
aJ8NUStHYfS6Lgeefm4j5x1H41LbMEJCvn2xVb7XLGNjuGJAxipbWSMggkhh271qn\nFRumSpuWktiVsmTYueOtNZZd5chcAcAmlhcFGfeCx7mg7iuJhgd8G
lPkcdSlJrSxXvYPNtt5PIPf\n1rGmtCjM7PgDqRXRXAgkg2q46cgng1h32Njxk8HqRUxUIxtuZvmb7GWyhmIjQknvU1r5slwIw2FU\ngkHpUUa8MVY4HSnxy
+VKJcYz/FSje2uxLaLHj23+3+CpCTzC6soX0Fef2jypE4Xj5eD+dej3kQ1D\nwpfRhgw8gnHTpXmtvISdpfIXuKzqJRNY7F7TZCYSkseWzkE+laNth4tjYx7
VjrIGnAE+0HqCvStW\nAJHGW80DjnA61CTa8iXa59u3lmrtJ5QAww+73qjJZMhMrDj6fWtREMe55AQB97A61A772OU4brXz\nn1h83M9z6BU1ujKuIcru7dM
evWqsayLIVVyRjgmtqSzUKRyfRSPrVU2cqEsqDaR260nUk5XmOMEl\noYuqbhEwJ5x2rkYgH1yZmJxjaOO1drqdkDE6kkEc5HeuTtdOaW/luFbkcMD9amUeZ
tpFx
D/CordovaLog( 2137): file:///android_asset/app/components-min/angular/angular.js: Line 5754 : Error: Error calling metho
d on NPObject.
D/CordovaLog( 2137): at androidExec (file:///android_asset/app/scripts/vendor/cordova.js:863:48)
D/CordovaLog( 2137): at file:///android_asset/app/scripts/vendor/cordova.force.js:196:16
D/CordovaLog( 2137): at file:///android_asset/app/scripts/vendor/cordova.force.js:538:9
D/CordovaLog( 2137): at Object.upsertSoupEntries (file:///android_asset/app/scripts/vendor/cordova.force.js:531:9)
D/CordovaLog( 2137): at Object.writeRecords (file:///android_asset/app/scripts/services/services.js:1874:22)
D/CordovaLog( 2137): at file:///android_asset/app/scripts/controllers/controllers.js:751:31
D/CordovaLog( 2137): at file:///android_asset/app/components-min/angular/angular.js:6846:59
D/CordovaLog( 2137): at file:///android_asset/app/components-min/angular/angular.js:6846:59
D/CordovaLog( 2137): at file:///android_asset/app/components-min/angular/angular.js:6883:26
D/CordovaLog( 2137): at Object.$eval (file:///android_asset/app/components-min/angular/angular.js:8057:28)
D/CordovaLog( 2137): file:///android_asset/app/scripts/services/services.js: Line 364 : AttachHub.reportError: {}
Hi Gaurav, thanks for your suggestion. As a result I went back and had another detailed look this morning. As it turns out I should have investigated better before I posted. The base64 string is accepted just fine. The NP Object exception was caused by the integer timestamp in the record exceeding maximum integer value. I was fooled by it working just fine in the MockSmartstore.
I don't t regret posting though because I learned from akhilesh about the 1MB maximum blob size in SmartStore. I like the idea of storing potential sensitive documents temporary in SmartStore (before they are uploaded to SF) due to its encryption and logout destruction. Ideally though the attachments can have the same maximum size as in Salesforce. I am looking forward to the file storage solutions that akhilesh mentioned.
Peter
All Answers
We are currently working on some file storage solutions to handle such situations.
The file size is nowhere near 1MB, just 93110 bytes (see trace below). Thanks for pointing out this 1MB limitation though. In this case, however, the limit does not play a role.
Peter
I/Web Console( 1827): RequestDoc LaunchCameraApp result.statuscode=1 at file:///android_asset/app/scripts/controllers/co
ntrollers.js:666
D/CordovaLog( 1827): file:///android_asset/app/scripts/controllers/controllers.js: Line 692 : ---------------Body base64
size=93110
I/Web Console( 1827): ---------------Body base64 size=93110 at file:///android_asset/app/scripts/controllers/controllers
.js:692
V/PhoneStatusBar( 1276): setLightsOn(true)
D/LockChecker:run( 1827): isLocked:true elapsedSinceLastActivity:20 timeout:0
D/LockChecker:run( 1827): isLocked:true elapsedSinceLastActivity:40 timeout:0
I/SmartStorePlugin.execute( 1827): action: pgRegisterSoup, jsVersion: 2.0.0
W/SmartStorePlugin.execute( 1827): is being called by js from older sdk, jsVersion: 2.0.0, nativeVersion: 2.0.1
I/SmartStorePlugin.execute( 1827): action: pgQuerySoup, jsVersion: 2.0.0
W/SmartStorePlugin.execute( 1827): is being called by js from older sdk, jsVersion: 2.0.0, nativeVersion: 2.0.1
I/SmartSqlHelper.convertSmartSql( 1827): smart sql = SELECT {smUpdates_a00i0000005SH72AAG:_soup} FROM {smUpdates_a00i00
00005SH72AAG} WHERE {smUpdates_a00i0000005SH72AAG:_recordId} = ? ORDER BY {smUpdates_a00i0000005SH72AAG:_recordId} ASC
I/SmartSqlHelper.convertSmartSql( 1827): sql = SELECT TABLE_2.soup FROM TABLE_2 WHERE TABLE_2_0 = ? ORDER BY TABLE_2_0
ASC
I/SmartSqlHelper.convertSmartSql( 1827): smart sql = SELECT {smUpdates_a00i0000005SH72AAG:_soup} FROM {smUpdates_a00i00
00005SH72AAG} WHERE {smUpdates_a00i0000005SH72AAG:_recordId} = ? ORDER BY {smUpdates_a00i0000005SH72AAG:_recordId} ASC
I/SmartSqlHelper.convertSmartSql( 1827): sql = SELECT TABLE_2.soup FROM TABLE_2 WHERE TABLE_2_0 = ? ORDER BY TABLE_2_0
ASC
I/SmartStorePlugin.execute( 1827): action: pgCloseCursor, jsVersion: 2.0.0
W/SmartStorePlugin.execute( 1827): is being called by js from older sdk, jsVersion: 2.0.0, nativeVersion: 2.0.1
I/SmartStorePlugin.execute( 1827): action: pgUpsertSoupEntries, jsVersion: 2.0.0
W/SmartStorePlugin.execute( 1827): is being called by js from older sdk, jsVersion: 2.0.0, nativeVersion: 2.0.1
I/SmartStorePlugin.execute( 1827): action: pgRegisterSoup, jsVersion: 2.0.0
W/SmartStorePlugin.execute( 1827): is being called by js from older sdk, jsVersion: 2.0.0, nativeVersion: 2.0.1
D/CordovaLog( 1827): file:///android_asset/app/scripts/vendor/cordova.force.js: Line 479 : SmartStore.registerSoup: 'smU
pdates_a00i0000005SH72AAG' indexSpecs: [{"path":"_recordId","type":"string"},{"path":"_numAtt","type":"integer"},{"path"
:"_numUpdt","type":"integer"}]
I/Web Console( 1827): SmartStore.registerSoup: 'smUpdates_a00i0000005SH72AAG' indexSpecs: [{"path":"_recordId","type":"s
tring"},{"path":"_numAtt","type":"integer"},{"path":"_numUpdt","type":"integer"}] at file:///android_asset/app/scripts/v
endor/cordova.force.js:479
D/CordovaLog( 1827): file:///android_asset/app/scripts/vendor/cordova.force.js: Line 504 : SmartStore.querySoup: 'smUpda
tes_a00i0000005SH72AAG' indexPath: _recordId
I/Web Console( 1827): SmartStore.querySoup: 'smUpdates_a00i0000005SH72AAG' indexPath: _recordId at file:///android_asset
/app/scripts/vendor/cordova.force.js:504
D/CordovaLog( 1827): file:///android_asset/app/scripts/vendor/cordova.force.js: Line 582 : closeCursor: 8
I/Web Console( 1827): closeCursor: 8 at file:///android_asset/app/scripts/vendor/cordova.force.js:582
D/CordovaLog( 1827): file:///android_asset/app/scripts/vendor/cordova.force.js: Line 479 : SmartStore.registerSoup: 'smA
ttachments_a00i0000005SH72AAG' indexSpecs: [{"path":"ParentId","type":"string"},{"path":"TimeStamp","type":"integer"}]
I/Web Console( 1827): SmartStore.registerSoup: 'smAttachments_a00i0000005SH72AAG' indexSpecs: [{"path":"ParentId","type"
:"string"},{"path":"TimeStamp","type":"integer"}] at file:///android_asset/app/scripts/vendor/cordova.force.js:479
I/SmartStorePlugin.execute( 1827): action: pgUpsertSoupEntries, jsVersion: 2.0.0
W/SmartStorePlugin.execute( 1827): is being called by js from older sdk, jsVersion: 2.0.0, nativeVersion: 2.0.1
D/CordovaLog( 1827): file:///android_asset/app/components-min/angular/angular.js: Line 5754 : Error: Error calling metho
d on NPObject.
D/CordovaLog( 1827): at androidExec (file:///android_asset/app/scripts/vendor/cordova.js:863:48)
D/CordovaLog( 1827): at file:///android_asset/app/scripts/vendor/cordova.force.js:196:16
D/CordovaLog( 1827): at file:///android_asset/app/scripts/vendor/cordova.force.js:538:9
D/CordovaLog( 1827): at Object.upsertSoupEntries (file:///android_asset/app/scripts/vendor/cordova.force.js:531:9)
D/CordovaLog( 1827): at Object.writeRecords (file:///android_asset/app/scripts/services/services.js:1879:22)
D/CordovaLog( 1827): at file:///android_asset/app/scripts/controllers/controllers.js:744:31
D/CordovaLog( 1827): at file:///android_asset/app/components-min/angular/angular.js:6846:59
D/CordovaLog( 1827): at file:///android_asset/app/components-min/angular/angular.js:6846:59
D/CordovaLog( 1827): at file:///android_asset/app/components-min/angular/angular.js:6883:26
D/CordovaLog( 1827): at Object.$eval (file:///android_asset/app/components-min/angular/angular.js:8057:28)
E/Web Console( 1827): Error: Error calling method on NPObject.
E/Web Console( 1827): at androidExec (file:///android_asset/app/scripts/vendor/cordova.js:863:48)
E/Web Console( 1827): at file:///android_asset/app/scripts/vendor/cordova.force.js:196:16
E/Web Console( 1827): at file:///android_asset/app/scripts/vendor/cordova.force.js:538:9
E/Web Console( 1827): at Object.upsertSoupEntries (file:///android_asset/app/scripts/vendor/cordova.force.js:531:9)
E/Web Console( 1827): at Object.writeRecords (file:///android_asset/app/scripts/services/services.js:1879:22)
E/Web Console( 1827): at file:///android_asset/app/scripts/controllers/controllers.js:744:31
E/Web Console( 1827): at file:///android_asset/app/components-min/angular/angular.js:6846:59
E/Web Console( 1827): at file:///android_asset/app/components-min/angular/angular.js:6846:59
E/Web Console( 1827): at file:///android_asset/app/components-min/angular/angular.js:6883:26
E/Web Console( 1827): at Object.$eval (file:///android_asset/app/components-min/angular/angular.js:8057:28) at file:
///android_asset/app/components-min/angular/angular.js:5754
D/CordovaLog( 1827): file:///android_asset/app/scripts/services/services.js: Line 364 : AttachHub.reportError: {}
I/Web Console( 1827): AttachHub.reportError: {} at file:///android_asset/app/scripts/services/services.js:364
E/SurfaceFlinger( 794): ro.sf.lcd_density must be defined as a build property
Someone had reported a similar isuse on this thread and was able to get it working - http://boards.developerforce.com/t5/Mobile/Encountering-issues-when-I-run-Salesforce-Hybrid-sample-app-quot/m-p/665592
You might want to try this out.
Regards,
Gaurav
Hi Gaurav, thanks for your suggestion. As a result I went back and had another detailed look this morning. As it turns out I should have investigated better before I posted. The base64 string is accepted just fine. The NP Object exception was caused by the integer timestamp in the record exceeding maximum integer value. I was fooled by it working just fine in the MockSmartstore.
I don't t regret posting though because I learned from akhilesh about the 1MB maximum blob size in SmartStore. I like the idea of storing potential sensitive documents temporary in SmartStore (before they are uploaded to SF) due to its encryption and logout destruction. Ideally though the attachments can have the same maximum size as in Salesforce. I am looking forward to the file storage solutions that akhilesh mentioned.
Peter