[ECOMMERCE-464] Investigate - Salesforce seems to lose connection from time to time Created: 07/Sep/21  Updated: 22/Oct/21  Resolved: 19/Oct/21

Status: Closed
Project: E-commerce
Component/s: None
Affects Version/s: 1.2.6, 1.3.1
Fix Version/s: 1.3.2, 1.2.7

Type: Bug Priority: Major
Reporter: Bartosz Staryga Assignee: Thuy To
Resolution: Fixed Votes: 1
Labels: VN-Maintenance, cm-team-support, maintenance
Remaining Estimate: Not Specified
Time Spent: 4.5d
Original Estimate: Not Specified

Attachments: PNG File Screenshot 2021-08-30 at 12.47.55.png     PNG File Screenshot 2021-10-13 at 11.13.30.png     Text File magnolia-error.log     Text File salesforceError.txt    
Issue Links:
Cloners
clones ECOMMERCE-461 Can not use product picker with dial... Closed
relation
is related to ECOMMERCE-484 Investigate-Throwing the SocketExcept... Closed
Template:
Acceptance criteria:
Empty
Task DoD:
[X]* Doc/release notes changes? Comment present?
[X]* Downstream builds green?
[X]* Solution information and context easily available?
[X]* Tests
[X]* FixVersion filled and not yet released
[ ]  Architecture Decision Record (ADR)
Bug DoR:
[ ]* Steps to reproduce, expected, and actual results filled
[ ]* Affected version filled
Date of First Response:
Epic Link: cm-team-support
Sprint: Content Mngmt 15
Story Points: 5

 Description   

 

2. Salesforce seems to lose connection from time to time
When I run the connection test I get the connection successful, but in browser view, and then in dialogues, I can not choose the connection.

It happens very randomly.



 Comments   
Comment by Bartosz Staryga [ 13/Oct/21 ]

The connection instability also affects the rest endpoints delivered by the pack to fetch the data e.g.
http://ecommerce-headless-author.magnolia-cms-demo.com/.rest/ecommerce/v1/products/apparel-m-catalog~TG720M?definitionName=salesforce-commerce&connectionName=connection
Sometimes I got JSON with the product, sometimes I got 404 from the server (not even Magnolia)

I attached another error stack trace magnolia-error.log in which we can see something that looks like it:

ERROR info.magnolia.ecommerce.salesforce.products.ById 13.10.2021 08:52:45 -- Can not load product [salesforce-commerce/connection/TG720M] from Salesforce
ERROR info.magnolia.ecommerce.salesforce.products.ById 13.10.2021 09:02:11 -- Can not load product [salesforce-commerce/connection/apparel-m-catalog~TG720M] from Salesforce
javax.net.ssl.SSLException: Connection reset
...
...
Comment by Bartosz Staryga [ 13/Oct/21 ]

Error I see when connection is out in browser for fetching the product data:

Comment by Thuy To [ 19/Oct/21 ]

Notes:
ERROR info.magnolia.ecommerce.salesforce.products.ById 13.10.2021 08:52:45 – Can not load product [salesforce-commerce/connection/TG720M] from Salesforce
ERROR info.magnolia.ecommerce.salesforce.products.ById 13.10.2021 09:02:11 – Can not load product [salesforce-commerce/connection/apparel-m-catalog~TG720M] from Salesforce
javax.net.ssl.SSLException: Connection reset
==> This issue is related to java version and fixed after increased the version to Oracle Corporation 11.0.12 (build 11.0.12+7).

Generated at Mon Feb 12 01:44:20 CET 2024 using Jira 9.4.2#940002-sha1:46d1a51de284217efdcb32434eab47a99af2938b.