0040600: DocumentNoLIst table is not initialized in local database

Description

Randomly, when functionality to prevent document number repeated is added to one environment, the documentNoLIst table could not be created in local database

In this cases, this error is returned:
OB.Dal.find: table 'documentNoList'; SQLError code: 5, message: could not prepare statement (1 no such table: DocumentNoList)

Steps To Reproduce

in environment without functionality to prevent document number repeated:
. do login in POS
. install functionality
. do login in POS

Error is returned in console:
OB.Dal.find: table 'documentNoList'; SQLError code: 5, message: could not prepare statement (1 no such table: DocumentNoList)

Proposed Solution

attached a possible fix

Tags

No tags attached.

Attached Files

initCacheDocumentNoListPosTerminal.diff [^] (2,264 bytes) 2019-04-11 16:15 [Show Content] [Hide Content]

diff --git a/modules/org.openbravo.retail.posterminal/web/org.openbravo.retail.posterminal/js/model/order.js b/modules/org.openbravo.retail.posterminal/web/org.openbravo.retail.posterminal/js/model/order.js
--- a/modules/org.openbravo.retail.posterminal/web/org.openbravo.retail.posterminal/js/model/order.js
+++ b/modules/org.openbravo.retail.posterminal/web/org.openbravo.retail.posterminal/js/model/order.js
@@ -5890,23 +5890,25 @@
           callback();
         }
       } else {
-        var documentNoInfo = new OB.Model.DocumentNoList();
-        OB.info('Try to save documentNo ' + this.get('documentNo') + ' in documentnolist table');
-        documentNoInfo.set('documentNo', this.get('documentNo'));
-        documentNoInfo.set('date', new Date().getTime());
-        OB.Dal.save(documentNoInfo, function () {
-          OB.info('DocumentNo ' + documentNoInfo.get('documentNo') + ' saved successfully in documentnolist table');
-          if (callback instanceof Function) {
-            callback();
-          }
-        }, function () {
-          OB.error('DocumentNo ' + documentNoInfo.get('documentNo') + ' failed to save in documentnolist table');
-          if (callback instanceof Function) {
-            callback();
-          }
-        });
-      }
-
+    	var me=this;
+        OB.Dal.initCache(OB.Model.DocumentNoList, [], function () {    	  
+		  var documentNoInfo = new OB.Model.DocumentNoList();
+		  OB.info('Try to save documentNo ' + me.get('documentNo') + ' in documentnolist table');
+		  documentNoInfo.set('documentNo', me.get('documentNo'));
+		  documentNoInfo.set('date', new Date().getTime());
+		  OB.Dal.save(documentNoInfo, function () {
+		    OB.info('DocumentNo ' + documentNoInfo.get('documentNo') + ' saved successfully in documentnolist table');
+		    if (callback instanceof Function) {
+		      callback();
+		    }
+		  }, function () {
+		    OB.error('DocumentNo ' + documentNoInfo.get('documentNo') + ' failed to save in documentnolist table');
+		    if (callback instanceof Function) {
+		      callback();
+		    }
+		  });
+        }, null);  
+      }      
     },
     checkForDocumentNoDuplicated: function (documentNumber, successCallback, errorCallback) {
       var documentNo = documentNumber,

Relationships [ Relation Graph ] [ Dependency Graph ]

Notes
There are no notes attached to this issue.

Issue History
Date Modified	Username	Field	Change
2019-04-11 16:15	malsasua	New Issue
2019-04-11 16:15	malsasua	Assigned To	=> Retail
2019-04-11 16:15	malsasua	Resolution time	=> 1554242400
2019-04-11 16:15	malsasua	Triggers an Emergency Pack	=> No
2019-04-11 16:15	malsasua	File Added: initCacheDocumentNoListPosTerminal.diff
2019-04-11 16:16	malsasua	Proposed Solution updated
2019-04-17 14:35	gorka_gil	Resolution time	1554242400 => 1556834400
2019-04-22 21:44	rqueralta	Assigned To	Retail => rqueralta
2019-04-22 21:44	rqueralta	Status	new => scheduled
2019-05-08 13:23	marvintm	Resolution time	1556834400 =>