Failed org.openbravo.test.mobile.retail.pack.selenium.tests.storecurrencyexchangerate.VerifyPaymentBasedOnStoreConversionRate.testCreationStoreConversionRateOutOfDate (from org.openbravo.test.mobile.retail.pack.selenium.suites.concurrent.job017.StoreCurrencyExchangeRateSuite) Failing for the past 39 builds (Since #1721 ) Took 38 sec. Error Message The database didn't return the expected data Query has timed out (15 * 1000 = 15000) Query: "select cr.* from c_conversion_rate_document cr inner join (select fpdv.fin_payment_id as fin_payment_id from fin_payment_detail_v fpdv where fpdv.orderno = 'VBS1001CR/0000011' and fpdv.finacc_currency_id = '100' and round(fpdv.finacc_txn_convert_rate,2) = round(1.31,2)) fp on cr.fin_payment_id = fp.fin_payment_id where round(cr.foreign_amount,2) = round(197.79,2) order by cr.fin_payment_id" Stacktrace java.lang.RuntimeException: The database didn't return the expected data Query has timed out (15 * 1000 = 15000) Query: "select cr.* from c_conversion_rate_document cr inner join (select fpdv.fin_payment_id as fin_payment_id from fin_payment_detail_v fpdv where fpdv.orderno = 'VBS1001CR/0000011' and fpdv.finacc_currency_id = '100' and round(fpdv.finacc_txn_convert_rate,2) = round(1.31,2)) fp on cr.fin_payment_id = fp.fin_payment_id where round(cr.foreign_amount,2) = round(197.79,2) order by cr.fin_payment_id" at org.openbravo.test.mobile.retail.mobilecore.database.DatabaseHelperSelect$1.timeout(DatabaseHelperSelect.java:189) at org.openbravo.test.mobile.core.utils.OBWait.(OBWait.java:66) at org.openbravo.test.mobile.core.utils.OBWait.(OBWait.java:35) at org.openbravo.test.mobile.retail.mobilecore.database.DatabaseHelperSelect$1.(DatabaseHelperSelect.java:115) at org.openbravo.test.mobile.retail.mobilecore.database.DatabaseHelperSelect.execute(DatabaseHelperSelect.java:115) at org.openbravo.test.mobile.retail.mobilecore.database.DatabaseHelperSelect.execute(DatabaseHelperSelect.java:78) at org.openbravo.test.mobile.retail.mobilecore.database.DatabaseHelperSelect.execute(DatabaseHelperSelect.java:69) at org.openbravo.test.mobile.retail.mobilecore.database.DatabaseHelperSelect.execute(DatabaseHelperSelect.java:61) at org.openbravo.test.mobile.retail.pack.selenium.tests.storecurrencyexchangerate.VerifyPaymentBasedOnStoreConversionRate.verifyPaymentConversionRates(VerifyPaymentBasedOnStoreConversionRate.java:438) at org.openbravo.test.mobile.retail.pack.selenium.tests.storecurrencyexchangerate.VerifyPaymentBasedOnStoreConversionRate.testDefaultBehaviorUSACash(VerifyPaymentBasedOnStoreConversionRate.java:125) at org.openbravo.test.mobile.retail.pack.selenium.tests.storecurrencyexchangerate.VerifyPaymentBasedOnStoreConversionRate.testCreationStoreConversionRateOutOfDate(VerifyPaymentBasedOnStoreConversionRate.java:137) Standard Output 2018-08-14 03:09:29,526 [main] INFO VBS1001.HighVolumeUtils.deactivateHighVolumeMode - Deactivating High Volume mode 2018-08-14 03:09:29,721 [main] INFO VBS1001.ConnectionHelper.buildConnection - SINGLESERVER (0 connections) oracle.jdbc.driver.OracleDriver connecting to jdbc:oracle:thin:@10.0.3.12:1521:oborcl, user: ret_qa_test_oracle_suite7, password: ret_qa_test_oracle_suite7 2018-08-14 03:09:29,816 [main] INFO VBS1001.MultiserverUtils.deactivateSynchronizedMode - Deactivating Syncronized mode 2018-08-14 03:09:29,835 [main] INFO VBS1001.ServiceWorkerUtils.disableServiceWorkerPreference - Disabling Service Worker mode 2018-08-14 03:09:29,859 [main] INFO VBS1001.OBWildcardPatternSuite.getSuiteClasses - Tests to be run: 1. Suite: AllStoreCurrencyExchangeRateTests 2018-08-14 03:09:29,898 [main] INFO VBS1001.RetryRunner.run - *** test class start *** 2018-08-14 03:09:29,901 [main] INFO VBS1001.SequentialTestInfoJUnit.getTestInfoFromTheGoogleSheet - Test quality status for 'org.openbravo.test.mobile.retail.pack.selenium.tests.storecurrencyexchangerate.VerifyPaymentBasedOnStoreConversionRate' being checked in ret-qa-test-oracle-suite7 2018-08-14 03:09:29,995 [main] INFO VBS1001.GoogleSheetsHelper.getTestsInfo - Getting tests information from Google Spreadsheet. Reading A2:D range 2018-08-14 03:09:30,085 [main] INFO VBS1001.GoogleSheetsHelper.authorize - Credentials saved to /srv/ci/workspace/ret-qa-test-oracle-suite7/SANDBOX/automation/pi-mobile/config 2018-08-14 03:09:30,724 [main] INFO VBS1001.SequentialTestInfoJUnit.getTestInfoFromTheGoogleSheet - Test is in status: quarantine 2018-08-14 03:09:30,724 [main] INFO VBS1001.SequentialTestInfoJUnit.getTestInfoFromTheGoogleSheet - Checking if org.openbravo.test.mobile.retail.pack.selenium.tests.storecurrencyexchangerate.VerifyPaymentBasedOnStoreConversionRate md5 has changed 2018-08-14 03:09:30,745 [main] INFO VBS1001.VerifyPaymentBasedOnStoreConversionRate.testCreationStoreConversionRateOutOfDate - ** test start ** 2018-08-14 03:09:32,867 [Thread-1] INFO VBS1001.VerifyPaymentBasedOnStoreConversionRate.testCreationStoreConversionRateOutOfDate - The query to activate all terminals affected 258 records 2018-08-14 03:09:32,925 [Thread-1] INFO VBS1001.VerifyPaymentBasedOnStoreConversionRate.testCreationStoreConversionRateOutOfDate - [sound-ci-disable] Preference that disables throttle was already added 2018-08-14 03:09:32,925 [Thread-1] INFO VBS1001.VerifyPaymentBasedOnStoreConversionRate.testCreationStoreConversionRateOutOfDate - [throttle-ci-disable] Preference that disables throttle was already added 2018-08-14 03:09:32,939 [Thread-1] INFO VBS1001.VerifyPaymentBasedOnStoreConversionRate.testCreationStoreConversionRateOutOfDate - [service-worker-ci-disable] Preference that disables service worker was already added 2018-08-14 03:09:33,498 [Thread-1] INFO VBS1001.VerifyPaymentBasedOnStoreConversionRate.testCreationStoreConversionRateOutOfDate - #### Selenium driver is ready. server ip: 127.0.1.1, selenium server: http://localhost:4444/wd/hub #### 2018-08-14 03:09:33,890 [Thread-1] INFO VBS1001.VerifyPaymentBasedOnStoreConversionRate.testCreationStoreConversionRateOutOfDate - Logging in VBS1001CR 2018-08-14 03:09:33,891 [Thread-1] INFO VBS1001.VerifyPaymentBasedOnStoreConversionRate.testCreationStoreConversionRateOutOfDate - Wait waitServiceWorkerToLoadSources iteration: 1 of 90 2018-08-14 03:09:34,015 [Thread-1] INFO VBS1001.VerifyPaymentBasedOnStoreConversionRate.testCreationStoreConversionRateOutOfDate - Verifying that 'login_appName' = 'Openbravo Mobile' 2018-08-14 03:09:34,116 [Thread-1] INFO VBS1001.VerifyPaymentBasedOnStoreConversionRate.testCreationStoreConversionRateOutOfDate - Writing 'vallblanca' into 'login_username' 2018-08-14 03:09:34,188 [Thread-1] INFO VBS1001.VerifyPaymentBasedOnStoreConversionRate.testCreationStoreConversionRateOutOfDate - Writing 'openbravo' into 'login_password' 2018-08-14 03:09:34,461 [Thread-1] INFO VBS1001.VerifyPaymentBasedOnStoreConversionRate.testCreationStoreConversionRateOutOfDate - Tap on 'login_loginButton' 2018-08-14 03:09:34,629 [Thread-1] INFO VBS1001.VerifyPaymentBasedOnStoreConversionRate.testCreationStoreConversionRateOutOfDate - Wait verifyThatTheLoginProcessHasStarted iteration: 1 of 90 2018-08-14 03:09:34,669 [Thread-1] INFO VBS1001.VerifyPaymentBasedOnStoreConversionRate.testCreationStoreConversionRateOutOfDate - The 'POINTOFSALE' window is rendered 2018-08-14 03:09:34,669 [Thread-1] INFO VBS1001.VerifyPaymentBasedOnStoreConversionRate.testCreationStoreConversionRateOutOfDate - Wait verifyThatTheLoginProcessHasEnded iteration: 1 of 90 2018-08-14 03:09:35,682 [Thread-1] INFO VBS1001.VerifyPaymentBasedOnStoreConversionRate.testCreationStoreConversionRateOutOfDate - Wait verifyThatTheLoginProcessHasEnded iteration: 2 of 90 2018-08-14 03:09:36,703 [Thread-1] INFO VBS1001.VerifyPaymentBasedOnStoreConversionRate.testCreationStoreConversionRateOutOfDate - Wait verifyThatTheLoginProcessHasEnded iteration: 3 of 90 2018-08-14 03:09:36,754 [Thread-1] INFO VBS1001.VerifyPaymentBasedOnStoreConversionRate.testCreationStoreConversionRateOutOfDate - WAIT_DEFAULT_RETRIES adjusted from 90 to 15 2018-08-14 03:09:36,754 [Thread-1] INFO VBS1001.VerifyPaymentBasedOnStoreConversionRate.testCreationStoreConversionRateOutOfDate - changed WAIT_DEFAULT_RETRIES to : 3 2018-08-14 03:09:36,991 [Thread-1] INFO VBS1001.VerifyPaymentBasedOnStoreConversionRate.testCreationStoreConversionRateOutOfDate - Ignoring activateRemoteModels 2018-08-14 03:09:36,991 [Thread-1] INFO VBS1001.VerifyPaymentBasedOnStoreConversionRate.testCreationStoreConversionRateOutOfDate - Reloading to apply database changes 2018-08-14 03:09:36,991 [Thread-1] INFO VBS1001.VerifyPaymentBasedOnStoreConversionRate.testCreationStoreConversionRateOutOfDate - Reloading 2018-08-14 03:09:37,039 [Thread-1] INFO VBS1001.VerifyPaymentBasedOnStoreConversionRate.testCreationStoreConversionRateOutOfDate - Synchronizing terminal and server 2018-08-14 03:09:37,063 [Thread-1] INFO VBS1001.VerifyPaymentBasedOnStoreConversionRate.testCreationStoreConversionRateOutOfDate - Waiting for the terminal synchronization process to flush the data to the 'message' table 2018-08-14 03:09:37,538 [Thread-1] INFO VBS1001.VerifyPaymentBasedOnStoreConversionRate.testCreationStoreConversionRateOutOfDate - There are no pending POST or GET requests to the server 2018-08-14 03:09:37,561 [Thread-1] INFO VBS1001.VerifyPaymentBasedOnStoreConversionRate.testCreationStoreConversionRateOutOfDate - Navigating to 'http://127.0.0.1/ret-qa-test-oracle-suite7/web/org.openbravo.retail.posterminal/?terminal=VBS1001CR#retail.pointofsale' 2018-08-14 03:09:39,802 [Thread-1] INFO VBS1001.VerifyPaymentBasedOnStoreConversionRate.testCreationStoreConversionRateOutOfDate - The 'POINTOFSALE' window is rendered 2018-08-14 03:09:39,802 [Thread-1] INFO VBS1001.VerifyPaymentBasedOnStoreConversionRate.testCreationStoreConversionRateOutOfDate - Wait verifyThatTheLoginProcessHasEnded iteration: 1 of 15 2018-08-14 03:09:39,821 [Thread-1] INFO VBS1001.VerifyPaymentBasedOnStoreConversionRate.testCreationStoreConversionRateOutOfDate - New webpage at window 'POINTOFSALE' loaded 2018-08-14 03:09:39,900 [Thread-1] INFO VBS1001.VerifyPaymentBasedOnStoreConversionRate.testCreationStoreConversionRateOutOfDate - Reloading 2018-08-14 03:09:39,950 [Thread-1] INFO VBS1001.VerifyPaymentBasedOnStoreConversionRate.testCreationStoreConversionRateOutOfDate - Synchronizing terminal and server 2018-08-14 03:09:39,984 [Thread-1] INFO VBS1001.VerifyPaymentBasedOnStoreConversionRate.testCreationStoreConversionRateOutOfDate - Waiting for the terminal synchronization process to flush the data to the 'message' table 2018-08-14 03:09:40,458 [Thread-1] INFO VBS1001.VerifyPaymentBasedOnStoreConversionRate.testCreationStoreConversionRateOutOfDate - There are no pending POST or GET requests to the server 2018-08-14 03:09:40,495 [Thread-1] INFO VBS1001.VerifyPaymentBasedOnStoreConversionRate.testCreationStoreConversionRateOutOfDate - Navigating to 'http://127.0.0.1/ret-qa-test-oracle-suite7/web/org.openbravo.retail.posterminal/?terminal=VBS1001CR#retail.pointofsale' 2018-08-14 03:09:42,907 [Thread-1] INFO VBS1001.VerifyPaymentBasedOnStoreConversionRate.testCreationStoreConversionRateOutOfDate - The 'POINTOFSALE' window is rendered 2018-08-14 03:09:42,907 [Thread-1] INFO VBS1001.VerifyPaymentBasedOnStoreConversionRate.testCreationStoreConversionRateOutOfDate - Wait verifyThatTheLoginProcessHasEnded iteration: 1 of 15 2018-08-14 03:09:42,920 [Thread-1] INFO VBS1001.VerifyPaymentBasedOnStoreConversionRate.testCreationStoreConversionRateOutOfDate - New webpage at window 'POINTOFSALE' loaded 2018-08-14 03:09:42,944 [Thread-1] INFO VBS1001.VerifyPaymentBasedOnStoreConversionRate.testCreationStoreConversionRateOutOfDate - Tap on 'theButton_toolbarBtnCatalog' 2018-08-14 03:09:43,135 [Thread-1] INFO VBS1001.VerifyPaymentBasedOnStoreConversionRate.testCreationStoreConversionRateOutOfDate - Verifying that 'categoryTable_title' = 'Categories' 2018-08-14 03:09:43,252 [Thread-1] INFO VBS1001.VerifyPaymentBasedOnStoreConversionRate.testCreationStoreConversionRateOutOfDate - Verifying that 'categoryTable_title' = 'Categories' 2018-08-14 03:09:43,374 [Thread-1] INFO VBS1001.VerifyPaymentBasedOnStoreConversionRate.testCreationStoreConversionRateOutOfDate - Tap on 'table_categoryTable' 2018-08-14 03:09:43,724 [Thread-1] INFO VBS1001.VerifyPaymentBasedOnStoreConversionRate.testCreationStoreConversionRateOutOfDate - Verifying that 'productTable_title' = 'Mountaineering' 2018-08-14 03:09:43,808 [Thread-1] INFO VBS1001.VerifyPaymentBasedOnStoreConversionRate.testCreationStoreConversionRateOutOfDate - Tap on 'table_productTable' 2018-08-14 03:09:44,092 [Thread-1] INFO VBS1001.VerifyPaymentBasedOnStoreConversionRate.testCreationStoreConversionRateOutOfDate - Verifying that 'theButton_btnTotalToPay' = '150.50' 2018-08-14 03:09:44,180 [Thread-1] INFO VBS1001.VerifyPaymentBasedOnStoreConversionRate.testCreationStoreConversionRateOutOfDate - Tap on 'theButton_btnTotalToPay' 2018-08-14 03:09:44,729 [Thread-1] WARN VBS1001.VerifyPaymentBasedOnStoreConversionRate.testCreationStoreConversionRateOutOfDate - 'toolbarpane_payment' is missing the 'getDisabled()' method. Add 'published: {disabled: false}' to the 'payment' enyo object 2018-08-14 03:09:44,763 [Thread-1] INFO VBS1001.VerifyPaymentBasedOnStoreConversionRate.testCreationStoreConversionRateOutOfDate - Tap on 'OBPOS.payment.usacash_button' 2018-08-14 03:09:44,934 [Thread-1] INFO VBS1001.VerifyPaymentBasedOnStoreConversionRate.testCreationStoreConversionRateOutOfDate - Verifying that 'paymentTabContent_totalpending' = '$197.79' 2018-08-14 03:09:45,034 [Thread-1] INFO VBS1001.VerifyPaymentBasedOnStoreConversionRate.testCreationStoreConversionRateOutOfDate - Tap on 'paymentTabContent_exactbutton' 2018-08-14 03:09:45,280 [Thread-1] INFO VBS1001.VerifyPaymentBasedOnStoreConversionRate.testCreationStoreConversionRateOutOfDate - Verifying that the button 'paymentTabContent_donebutton' is visible 2018-08-14 03:09:45,461 [Thread-1] INFO VBS1001.VerifyPaymentBasedOnStoreConversionRate.testCreationStoreConversionRateOutOfDate - Tap on 'paymentTabContent_donebutton' 2018-08-14 03:09:45,598 [Thread-1] INFO VBS1001.VerifyPaymentBasedOnStoreConversionRate.testCreationStoreConversionRateOutOfDate - Verifying that 'theButton_btnTotalToPay' = '0.00' 2018-08-14 03:09:45,735 [Thread-1] INFO VBS1001.VerifyPaymentBasedOnStoreConversionRate.testCreationStoreConversionRateOutOfDate - Synchronizing terminal and server 2018-08-14 03:09:45,756 [Thread-1] INFO VBS1001.VerifyPaymentBasedOnStoreConversionRate.testCreationStoreConversionRateOutOfDate - Waiting for the terminal synchronization process to flush the data to the 'message' table 2018-08-14 03:09:46,198 [Thread-1] INFO VBS1001.VerifyPaymentBasedOnStoreConversionRate.testCreationStoreConversionRateOutOfDate - There are no pending POST or GET requests to the server 2018-08-14 03:09:46,306 [Thread-1] INFO VBS1001.VerifyPaymentBasedOnStoreConversionRate.testCreationStoreConversionRateOutOfDate - Retrieving data from the database. 1 expected, 0 records found 2018-08-14 03:09:47,367 [Thread-1] INFO VBS1001.VerifyPaymentBasedOnStoreConversionRate.testCreationStoreConversionRateOutOfDate - Retrieving data from the database. 1 expected, 0 records found 2018-08-14 03:09:48,407 [Thread-1] INFO VBS1001.VerifyPaymentBasedOnStoreConversionRate.testCreationStoreConversionRateOutOfDate - Retrieving data from the database. 1 expected, 0 records found 2018-08-14 03:09:49,448 [Thread-1] INFO VBS1001.VerifyPaymentBasedOnStoreConversionRate.testCreationStoreConversionRateOutOfDate - Retrieving data from the database. 1 expected, 0 records found 2018-08-14 03:09:50,489 [Thread-1] INFO VBS1001.VerifyPaymentBasedOnStoreConversionRate.testCreationStoreConversionRateOutOfDate - Retrieving data from the database. 1 expected, 0 records found 2018-08-14 03:09:51,511 [Thread-1] INFO VBS1001.VerifyPaymentBasedOnStoreConversionRate.testCreationStoreConversionRateOutOfDate - Retrieving data from the database. 1 expected, 0 records found 2018-08-14 03:09:52,549 [Thread-1] INFO VBS1001.VerifyPaymentBasedOnStoreConversionRate.testCreationStoreConversionRateOutOfDate - Retrieving data from the database. 1 expected, 0 records found 2018-08-14 03:09:53,571 [Thread-1] INFO VBS1001.VerifyPaymentBasedOnStoreConversionRate.testCreationStoreConversionRateOutOfDate - Retrieving data from the database. 1 expected, 0 records found 2018-08-14 03:09:54,609 [Thread-1] INFO VBS1001.VerifyPaymentBasedOnStoreConversionRate.testCreationStoreConversionRateOutOfDate - Retrieving data from the database. 1 expected, 0 records found 2018-08-14 03:09:55,649 [Thread-1] INFO VBS1001.VerifyPaymentBasedOnStoreConversionRate.testCreationStoreConversionRateOutOfDate - Retrieving data from the database. 1 expected, 0 records found 2018-08-14 03:09:56,688 [Thread-1] INFO VBS1001.VerifyPaymentBasedOnStoreConversionRate.testCreationStoreConversionRateOutOfDate - Retrieving data from the database. 1 expected, 0 records found 2018-08-14 03:09:57,726 [Thread-1] INFO VBS1001.VerifyPaymentBasedOnStoreConversionRate.testCreationStoreConversionRateOutOfDate - Retrieving data from the database. 1 expected, 0 records found 2018-08-14 03:09:58,766 [Thread-1] INFO VBS1001.VerifyPaymentBasedOnStoreConversionRate.testCreationStoreConversionRateOutOfDate - Retrieving data from the database. 1 expected, 0 records found 2018-08-14 03:09:59,806 [Thread-1] INFO VBS1001.VerifyPaymentBasedOnStoreConversionRate.testCreationStoreConversionRateOutOfDate - Retrieving data from the database. 1 expected, 0 records found 2018-08-14 03:10:00,847 [Thread-1] INFO VBS1001.VerifyPaymentBasedOnStoreConversionRate.testCreationStoreConversionRateOutOfDate - Retrieving data from the database. 1 expected, 0 records found 2018-08-14 03:10:01,848 [Thread-1] ERROR VBS1001.VerifyPaymentBasedOnStoreConversionRate.testCreationStoreConversionRateOutOfDate - The database didn't return the expected data Query has timed out (15 * 1000 = 15000) Query: "select cr.* from c_conversion_rate_document cr inner join (select fpdv.fin_payment_id as fin_payment_id from fin_payment_detail_v fpdv where fpdv.orderno = 'VBS1001CR/0000011' and fpdv.finacc_currency_id = '100' and round(fpdv.finacc_txn_convert_rate,2) = round(1.31,2)) fp on cr.fin_payment_id = fp.fin_payment_id where round(cr.foreign_amount,2) = round(197.79,2) order by cr.fin_payment_id" 2018-08-14 03:10:02,035 [Thread-1] INFO VBS1001.VerifyPaymentBasedOnStoreConversionRate.testCreationStoreConversionRateOutOfDate - Ignoring activateRemoteModels 2018-08-14 03:10:02,035 [Thread-1] INFO VBS1001.VerifyPaymentBasedOnStoreConversionRate.testCreationStoreConversionRateOutOfDate - Reloading to restore database changes 2018-08-14 03:10:02,035 [Thread-1] INFO VBS1001.VerifyPaymentBasedOnStoreConversionRate.testCreationStoreConversionRateOutOfDate - Reloading 2018-08-14 03:10:02,087 [Thread-1] INFO VBS1001.VerifyPaymentBasedOnStoreConversionRate.testCreationStoreConversionRateOutOfDate - Synchronizing terminal and server 2018-08-14 03:10:02,116 [Thread-1] INFO VBS1001.VerifyPaymentBasedOnStoreConversionRate.testCreationStoreConversionRateOutOfDate - Waiting for the terminal synchronization process to flush the data to the 'message' table 2018-08-14 03:10:02,596 [Thread-1] INFO VBS1001.VerifyPaymentBasedOnStoreConversionRate.testCreationStoreConversionRateOutOfDate - There are no pending POST or GET requests to the server 2018-08-14 03:10:02,616 [Thread-1] INFO VBS1001.VerifyPaymentBasedOnStoreConversionRate.testCreationStoreConversionRateOutOfDate - Navigating to 'http://127.0.0.1/ret-qa-test-oracle-suite7/web/org.openbravo.retail.posterminal/?terminal=VBS1001CR#retail.pointofsale' 2018-08-14 03:10:04,847 [Thread-1] INFO VBS1001.VerifyPaymentBasedOnStoreConversionRate.testCreationStoreConversionRateOutOfDate - The 'POINTOFSALE' window is rendered 2018-08-14 03:10:04,847 [Thread-1] INFO VBS1001.VerifyPaymentBasedOnStoreConversionRate.testCreationStoreConversionRateOutOfDate - Wait verifyThatTheLoginProcessHasEnded iteration: 1 of 15 2018-08-14 03:10:04,868 [Thread-1] INFO VBS1001.VerifyPaymentBasedOnStoreConversionRate.testCreationStoreConversionRateOutOfDate - New webpage at window 'POINTOFSALE' loaded 2018-08-14 03:10:04,869 [Thread-1] INFO VBS1001.VerifyPaymentBasedOnStoreConversionRate.testCreationStoreConversionRateOutOfDate - ======================== 2018-08-14 03:10:04,869 [Thread-1] INFO VBS1001.VerifyPaymentBasedOnStoreConversionRate.testCreationStoreConversionRateOutOfDate - After test verifications 2018-08-14 03:10:04,869 [Thread-1] INFO VBS1001.VerifyPaymentBasedOnStoreConversionRate.testCreationStoreConversionRateOutOfDate - Forcing Log Client synchronization 2018-08-14 03:10:08,009 [Thread-1] INFO VBS1001.VerifyPaymentBasedOnStoreConversionRate.testCreationStoreConversionRateOutOfDate - Synchronizing terminal and server 2018-08-14 03:10:08,047 [Thread-1] INFO VBS1001.VerifyPaymentBasedOnStoreConversionRate.testCreationStoreConversionRateOutOfDate - Waiting for the terminal synchronization process to flush the data to the 'message' table 2018-08-14 03:10:08,517 [Thread-1] INFO VBS1001.VerifyPaymentBasedOnStoreConversionRate.testCreationStoreConversionRateOutOfDate - There are no pending POST or GET requests to the server 2018-08-14 03:10:08,971 [main] INFO VBS1001.VerifyPaymentBasedOnStoreConversionRate.testCreationStoreConversionRateOutOfDate - Test failed 2018-08-14 03:10:09,422 [main] INFO VBS1001.VerifyPaymentBasedOnStoreConversionRate.testCreationStoreConversionRateOutOfDate - Screenshot taken: 2018-08-14 03:10:09,422 [main] INFO VBS1001.VerifyPaymentBasedOnStoreConversionRate.testCreationStoreConversionRateOutOfDate - *** Errors found: *** java.lang.RuntimeException: The database didn't return the expected data Query has timed out (15 * 1000 = 15000) Query: "select cr.* from c_conversion_rate_document cr inner join (select fpdv.fin_payment_id as fin_payment_id from fin_payment_detail_v fpdv where fpdv.orderno = 'VBS1001CR/0000011' and fpdv.finacc_currency_id = '100' and round(fpdv.finacc_txn_convert_rate,2) = round(1.31,2)) fp on cr.fin_payment_id = fp.fin_payment_id where round(cr.foreign_amount,2) = round(197.79,2) order by cr.fin_payment_id" *** Extra info: *** - Test: testCreationStoreConversionRateOutOfDate(org.openbravo.test.mobile.retail.pack.selenium.tests.storecurrencyexchangerate.VerifyPaymentBasedOnStoreConversionRate) - Connection info: total number of connections: 56, this connection string: oracle.jdbc.driver.OracleDriver connecting to jdbc:oracle:thin:@10.0.3.12:1521:oborcl, user: ret_qa_test_oracle_suite7, password: ret_qa_test_oracle_suite7 - Memory info: total used free shared buffers cached Mem: 32772128 25036932 7735196 1968876 918208 16869524 -/+ buffers/cache: 7249200 25522928 Swap: 16760828 1825368 14935460 - Java processes: 3424 /srv/ci/workspace/ret-qa-test-oracle-suite7/SANDBOX/automation/pi-mobile/lib/test/selenium-server-default.jar 3313 org.apache.tools.ant.launch.Launcher 3395 com.openbravo.poshw.Main 10163 org.apache.tools.ant.taskdefs.optional.junit.JUnitTestRunner 10340 sun.tools.jps.Jps 23560 slave.jar 3146 org.apache.catalina.startup.Bootstrap *** end *** 2018-08-14 03:10:09,422 [main] INFO VBS1001.VerifyPaymentBasedOnStoreConversionRate.testCreationStoreConversionRateOutOfDate - ** test end ** 2018-08-14 03:10:09,425 [main] INFO VBS1001.VerifyPaymentBasedOnStoreConversionRate.testCreationStoreConversionRateOutOfDate - *** test class end *** 2018-08-14 03:10:09,425 [main] INFO VBS1001.AutomationHostHelper.logTestResult - Logging test result at /srv/ci/workspace/ret-qa-test-oracle-suite7/SANDBOX/automation/pi-mobile/last-results/ret-qa-test-oracle-suite7/logs/suiteLikeTestList.log 2018-08-14 03:10:09,426 [main] INFO VBS1001.AutomationHostHelper.logTestResult - Logging test result at /srv/ci/workspace/ret-qa-test-oracle-suite7/SANDBOX/automation/pi-mobile/quarantine/history/retail.pack.selenium.tests.storecurrencyexchangerate.VerifyPaymentBasedOnStoreConversionRate.log 2018-08-14 03:10:09,427 [main] INFO VBS1001.RetryRunner.run - *** test class start *** 2018-08-14 03:10:09,427 [main] INFO VBS1001.SequentialTestInfoJUnit.getTestInfoFromTheGoogleSheet - Test quality status for 'org.openbravo.test.mobile.retail.pack.selenium.tests.loginout.LogoutAndCloseBrowser' being checked in ret-qa-test-oracle-suite7 2018-08-14 03:10:09,427 [main] INFO VBS1001.SequentialTestInfoJUnit.getTestInfoFromTheGoogleSheet - Test is in status: stable 2018-08-14 03:10:09,428 [main] INFO VBS1001.SequentialTestInfoJUnit.getTestInfoFromTheGoogleSheet - Checking if org.openbravo.test.mobile.retail.pack.selenium.tests.loginout.LogoutAndCloseBrowser md5 has changed 2018-08-14 03:10:09,431 [main] INFO VBS1001.LogoutAndCloseBrowser - ** test start ** 2018-08-14 03:10:11,526 [Thread-2] INFO VBS1001.LogoutAndCloseBrowser - Verifying the browser log before closing the selenium session 2018-08-14 03:10:11,628 [Thread-2] INFO VBS1001.LogoutAndCloseBrowser - #### Selenium driver terminated #### 2018-08-14 03:10:11,689 [Thread-2] INFO VBS1001.LogoutAndCloseBrowser - The query to activate all terminals affected 258 records 2018-08-14 03:10:11,706 [Thread-2] INFO VBS1001.LogoutAndCloseBrowser - [sound-ci-disable] Preference that disables throttle was already added 2018-08-14 03:10:11,706 [Thread-2] INFO VBS1001.LogoutAndCloseBrowser - [throttle-ci-disable] Preference that disables throttle was already added 2018-08-14 03:10:11,706 [Thread-2] INFO VBS1001.LogoutAndCloseBrowser - [service-worker-ci-disable] Preference that disables service worker was already added 2018-08-14 03:10:12,080 [Thread-2] INFO VBS1001.LogoutAndCloseBrowser - #### Selenium driver is ready. server ip: 127.0.1.1, selenium server: http://localhost:4444/wd/hub #### 2018-08-14 03:10:12,446 [Thread-2] INFO VBS1001.LogoutAndCloseBrowser - Logging in VBS1001 2018-08-14 03:10:12,446 [Thread-2] INFO VBS1001.LogoutAndCloseBrowser - Wait waitServiceWorkerToLoadSources iteration: 1 of 15 2018-08-14 03:10:12,499 [Thread-2] INFO VBS1001.LogoutAndCloseBrowser - Verifying that 'login_appName' = 'Openbravo Mobile' 2018-08-14 03:10:12,638 [Thread-2] INFO VBS1001.LogoutAndCloseBrowser - Writing 'vallblanca' into 'login_username' 2018-08-14 03:10:12,749 [Thread-2] INFO VBS1001.LogoutAndCloseBrowser - Writing 'openbravo' into 'login_password' 2018-08-14 03:10:13,051 [Thread-2] INFO VBS1001.LogoutAndCloseBrowser - Tap on 'login_loginButton' 2018-08-14 03:10:13,152 [Thread-2] INFO VBS1001.LogoutAndCloseBrowser - Wait verifyThatTheLoginProcessHasStarted iteration: 1 of 15 2018-08-14 03:10:13,177 [Thread-2] INFO VBS1001.LogoutAndCloseBrowser - The 'POINTOFSALE' window is rendered 2018-08-14 03:10:13,177 [Thread-2] INFO VBS1001.LogoutAndCloseBrowser - Wait verifyThatTheLoginProcessHasEnded iteration: 1 of 15 2018-08-14 03:10:14,190 [Thread-2] INFO VBS1001.LogoutAndCloseBrowser - Wait verifyThatTheLoginProcessHasEnded iteration: 2 of 15 2018-08-14 03:10:15,209 [Thread-2] INFO VBS1001.LogoutAndCloseBrowser - Wait verifyThatTheLoginProcessHasEnded iteration: 3 of 15 2018-08-14 03:10:15,249 [Thread-2] INFO VBS1001.LogoutAndCloseBrowser - changed WAIT_DEFAULT_RETRIES to : 3 2018-08-14 03:10:15,249 [Thread-2] INFO VBS1001.LogoutAndCloseBrowser - Ignoring activateRemoteModels 2018-08-14 03:10:15,249 [Thread-2] INFO VBS1001.LogoutAndCloseBrowser - Ignoring activateRemoteModels 2018-08-14 03:10:15,249 [Thread-2] INFO VBS1001.LogoutAndCloseBrowser - ======================== 2018-08-14 03:10:15,249 [Thread-2] INFO VBS1001.LogoutAndCloseBrowser - After test verifications 2018-08-14 03:10:15,249 [Thread-2] INFO VBS1001.LogoutAndCloseBrowser - Forcing Log Client synchronization 2018-08-14 03:10:17,354 [Thread-2] INFO VBS1001.LogoutAndCloseBrowser - Synchronizing terminal and server 2018-08-14 03:10:17,387 [Thread-2] INFO VBS1001.LogoutAndCloseBrowser - Waiting for the terminal synchronization process to flush the data to the 'message' table 2018-08-14 03:10:17,876 [Thread-2] INFO VBS1001.LogoutAndCloseBrowser - There are no pending POST or GET requests to the server 2018-08-14 03:10:18,301 [Thread-2] INFO VBS1001.LogoutAndCloseBrowser - Logging out 2018-08-14 03:10:18,316 [Thread-2] INFO VBS1001.LogoutAndCloseBrowser - Synchronizing terminal and server 2018-08-14 03:10:18,346 [Thread-2] INFO VBS1001.LogoutAndCloseBrowser - Waiting for the terminal synchronization process to flush the data to the 'message' table 2018-08-14 03:10:18,799 [Thread-2] INFO VBS1001.LogoutAndCloseBrowser - There are no pending POST or GET requests to the server 2018-08-14 03:10:21,052 [Thread-2] INFO VBS1001.LogoutAndCloseBrowser - First found 'menuHolder_mainMenuButton' 2018-08-14 03:10:21,052 [Thread-2] INFO VBS1001.LogoutAndCloseBrowser - Tap on 'menuHolder_mainMenuButton' 2018-08-14 03:10:21,194 [Thread-2] INFO VBS1001.LogoutAndCloseBrowser - Tap on 'menuScroller_connStatusButton' 2018-08-14 03:10:21,318 [Thread-2] INFO VBS1001.LogoutAndCloseBrowser - Tap on 'profileSessionInfo_endSessionButton' 2018-08-14 03:10:21,412 [Thread-2] INFO VBS1001.LogoutAndCloseBrowser - Tap on 'bodyButtons_logoutDialogLogout' 2018-08-14 03:10:21,504 [Thread-2] WARN VBS1001.LogoutAndCloseBrowser - BUTTON_LOGOUT specific tap 2018-08-14 03:10:21,519 [Thread-2] INFO VBS1001.LogoutAndCloseBrowser - Synchronizing terminal and server 2018-08-14 03:10:21,549 [Thread-2] INFO VBS1001.LogoutAndCloseBrowser - Waiting for the terminal synchronization process to flush the data to the 'message' table 2018-08-14 03:10:22,042 [Thread-2] INFO VBS1001.LogoutAndCloseBrowser - There are no pending POST or GET requests to the server 2018-08-14 03:10:23,124 [Thread-2] INFO VBS1001.LogoutAndCloseBrowser - First found 'login_appName' 2018-08-14 03:10:23,146 [Thread-2] INFO VBS1001.LogoutAndCloseBrowser - Verifying that 'login_appName' = 'Openbravo Mobile' 2018-08-14 03:10:23,223 [Thread-2] INFO VBS1001.LogoutAndCloseBrowser - Verifying the browser log before closing the selenium session 2018-08-14 03:10:23,313 [Thread-2] INFO VBS1001.LogoutAndCloseBrowser - #### Selenium driver terminated #### 2018-08-14 03:10:23,313 [main] INFO VBS1001.LogoutAndCloseBrowser - Final test verifications 2018-08-14 03:10:23,314 [main] INFO VBS1001.LogoutAndCloseBrowser - Test succeeded 2018-08-14 03:10:23,314 [main] INFO VBS1001.LogoutAndCloseBrowser - finished in 00:13 2018-08-14 03:10:23,314 [main] INFO VBS1001.LogoutAndCloseBrowser - ** test end ** 2018-08-14 03:10:23,314 [main] INFO VBS1001.LogoutAndCloseBrowser - *** test class end *** 2018-08-14 03:10:23,315 [main] INFO VBS1001.AutomationHostHelper.logTestResult - Logging test result at /srv/ci/workspace/ret-qa-test-oracle-suite7/SANDBOX/automation/pi-mobile/last-results/ret-qa-test-oracle-suite7/logs/suiteLikeTestList.log 2018-08-14 03:10:23,316 [main] INFO VBS1001.AutomationHostHelper.logTestResult - Logging test result at /srv/ci/workspace/ret-qa-test-oracle-suite7/SANDBOX/automation/pi-mobile/quarantine/history/retail.pack.selenium.tests.loginout.LogoutAndCloseBrowser.log 2018-08-14 03:10:23,316 [main] INFO SuiteHelper - Suite: StoreCurrencyExchangeRateSuite - Time elapsed: 53 seconds 2018-08-14 03:10:23,317 [main] INFO VBS1001.AutomationHostHelper.saveTestResult - *** Test Result *** 2018-08-14 03:10:23,317 [main] INFO VBS1001.AutomationHostHelper.saveTestResult - *** Test: org.openbravo.test.mobile.retail.pack.selenium.tests.storecurrencyexchangerate.VerifyPaymentBasedOnStoreConversionRate has finished in status: false*** 2018-08-14 03:10:23,318 [main] INFO VBS1001.AutomationHostHelper.saveTestResult - *** Test: org.openbravo.test.mobile.retail.pack.selenium.tests.loginout.LogoutAndCloseBrowser has finished in status: true*** 2018-08-14 03:10:23,318 [main] INFO VBS1001.AutomationHostHelper.saveTestResult - *** Test Result End *** 2018-08-14 03:10:23,320 [main] INFO VBS1001.GoogleSheetsHelper.executeScript - Executing function saveTestResult into Google Spreadsheet 2018-08-14 03:10:34,920 [main] INFO VBS1001.GoogleSheetsHelper.executeScript - Script saveTestResult has been executed successfully