0039133: Test VerifyPaymentBasedOnStoreConversionRate is not stable. Marked as unstable

Description
Assigned to gorka because he was editing it after commit the project related to verified returns dialog

Link to error:

https://ci.openbravo.com/job/ret-qa-test-oracle-suite7/1759/testReport/org.openbravo.test.mobile.retail.pack.selenium.tests.storecurrencyexchangerate/VerifyPaymentBasedOnStoreConversionRate/testCreationStoreConversionRateOutOfDate/ [^]

Attached error details
Steps To Reproduce
N/A
Tags
No tags attached.
Attached Files
test_error_ggi.txt [^] (32,440 bytes) 2018-08-14 11:35 [Show Content] [Hide Content]
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.<init>(OBWait.java:66)
  at org.openbravo.test.mobile.core.utils.OBWait.<init>(OBWait.java:35)
  at org.openbravo.test.mobile.retail.mobilecore.database.DatabaseHelperSelect$1.<init>(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: <last-results/ret-qa-test-oracle-suite7/screenshots/03:10:09 FAILED: VerifyPaymentBasedOnStoreConversionRate.testCreationStoreConversionRateOutOfDate.png>
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
Relationships [ Relation Graph ] [ Dependency Graph ]
Notes
(0106494) gorka_gil (administrator) 2018-08-27 12:42	The test that was failing: testCreationStoreConversionRateOutOfDate (VerifyPaymentBasedOnStoreConversionRate.java) Don't have any change of verified returns, so probably not caused by this commit. Maybe is this commit the cause: - https://code.openbravo.com/tools/automation/pi-mobile/rev/da9b55d9942e [^] - https://code.openbravo.com/tools/automation/pi-mobile/diff/da9b55d9942e/src-test/org/openbravo/test/mobile/retail/pack/selenium/tests/storecurrencyexchangerate/VerifyPaymentBasedOnStoreConversionRate.java [^]
Issue History
Date Modified	Username	Field	Change
2018-08-14 11:35	guilleaer	New Issue
2018-08-14 11:35	guilleaer	Assigned To	=> gorka_gil
2018-08-14 11:35	guilleaer	File Added: test_error_ggi.txt
2018-08-14 11:35	guilleaer	Triggers an Emergency Pack	=> No
2018-08-27 12:40	gorka_gil	Assigned To	gorka_gil => rqueralta
2018-08-27 12:42	gorka_gil	Note Added: 0106494