Symptoms
Online store synchronization or installation of new proxy store Install Proxy Store fails with error:
Error message: Operation failed with error code : 28; connect() timed out!
Same error can be seen in ~bm/log/STORES.log on PBA application server:
[15-02-07 01:24:20.789 Worker1.3 TH28915 NTE] Entering method STORES_Container::Worker1.3.StoreSyncConfSynchronize_API(user = -1, transaction = 4902, SID = 0, lang = en, HP)
[15-02-07 01:24:20.789 Worker1.3 TH28915 NTE] 1 input arguments :
int32_t: 10
[15-02-07 01:24:20.789 Worker1.3 TH28915 TRC] +++[0] ErrorMessage* STORES::StoreSyncConfSynchronize_API(Int)(10)
[15-02-07 01:24:20.789 STORES TH28915 NTE] Exclusively locking a row (StoreID=10) in table StoreSyncConf
[15-02-07 01:24:20.791 Worker1.3 TH28915 TRC] Sync store by URL https://203.0.113.2 :443/index.php?act=sync&StoreID=10
[15-02-07 01:24:30.802 Worker1.3 TH28915 TRC] ...[0] *** INTERRUPTED BY EXCEPTION *** ErrorMessage* STORES::StoreSyncConfSynchronize_API(Int)
[15-02-07 01:24:30.802 Worker1.3 TH28915 NTE] Finished method STORES_Container::Worker1.3.StoreSyncConfSynchronize_API(user = -1, transaction = 4902, SID = 0, lang = en, HP)
[15-02-07 01:24:30.802 Worker1.3 TH28915 NTE] ErrorManager::Complete: Rollback 2 - exception handled.
[15-02-07 01:24:30.802 Worker1.3 TH28915 NTE] ROLLBACK of transaction = 4902
[15-02-07 01:24:30.806 Worker1.3 TH28915 NTE] ExceptionResult: Operation failed with error code : 28; connect() timed out!
You can see an IP address which PBA is trying to connect to - 203.0.113.2.
Cause
PBA-E unable to establish a ftp connection to the webspace with proxy store.
[root@pba ~]# ftp 203.0.113.2
ftp: connect: Connection timed out
Resolution
Ensure that ftp connection could be established from billing server to the webspace with proxy store.