SAP Commerce 2011 - B2B Accelerator storefront 404 can't be found

[Alexander_0001]

I can't access the B2B Storefront of SAP Commerce 2011

Situation:
I have installed SAP Commerce 2011 on a local machine for demo purposes.
I used the receipt cx.
Receipt based installation was successful:
- I can access the B2C Accelerator electronics storefront without any issues.
- Backoffice, Administration and SmartEdit works.

Problem:

I can't access the B2B Accelerator powertools storefront => I got a 404 - Page does not exist

And I don't know how to fix it.

Here are more details:

In the administration hub the extension overview shows me the following:

SmartEdit and the Backoffice lists the website:

I have found the following thread but i can't find a guidance in it to solve this problem.
https://answers.sap.com/questions/12750311/powertools-site-404-page-does-not-exist.html

[christoph_probst]

Can you also provide the console.log sometimes this occurs because an exception was thrown during startup. Furthermore, the log should be gathered after the call to the storefront.

[christoph_probst · Accepted solution]

Can you try this URL no redirect should happen here

https://localhost:9002/yb2bacceleratorstorefront/powertools/en/USD/login?site=powertools

If this is working then the only thing I can think of is that powertools.local is not in your hosts file please add the line

127.0.0.1 powertools.local

according to

https://help.sap.com/viewer/4c33bf189ab9409e84e589295c36d96e/LATEST/en-US/8ab6a84e86691014b935a582ca...

When using the browser in vm it is sufficient to add it in the VM only. see also https://docs.rackspace.com/support/how-to/modify-your-hosts-file/

Another option is to change the URLs for powertools storefront in the properties file to point to localhost.

[Alexander_0001 · Accepted solution]

Hi Christoph,
Your first link guided me successfully to the login page of the b2b shop.

https://localhost:9002/yb2bacceleratorstorefront/powertools/en/USD/login?site=powertools

After I have picked a given b2b customer from the backend (1. giving him a password 2. enabling the login for the account),
I have used his account for Login. Reusult: SUCCESS! Hurray! I have entered the b2b-powertools-shop.

I think you are on the right path with your assumptions and I would love it to fix my problem with your approach.
Unfortunetally the link to the detailed explaination: https://help.sap.com/viewer/4c33bf189ab9409e84e589295c36d96e/2011/en-US/8ab6a84e86691014b935a582ca5e.... doesn't work. could you please correct your shared link.

Thank you very much for your awesome guidance!

[christoph_probst · Accepted solution]

Right link would be

https://help.sap.com/viewer/4c33bf189ab9409e84e589295c36d96e/LATEST/en-US/8ab6a84e86691014b935a582ca...

[christoph_probst]

The startup looks fine. The only thing I can see is following message

Cannot find CMSSite associated with current URL (https://localhost:9002/yb2bacceleratorstorefront/powertools/en)

This is message occurs when none of the basestore URL patterns is matching the URL. In your first screenshot you called the commerce instance with domain powertools.localhost this should match the powertools base store.

I recommend to try following URL

https://localhost:9002/yb2bacceleratorstorefront/powertools/en?site=powertools

[Alexander_0001]

Hi Christoph,
using the URL you have shared, I got redirect to the following url:
"https://powertools.local:9002/yb2bacceleratorstorefront/powertools/en/USD/login"

I got the error that the website can't be reached with the following console message:

screenshot-2021-06-07-133746.png

The link in the console message directed me to the following source information: vm105.txt

The apparel and the electronics shops work fine.

vm105.txt

[Alexander_0001]

Hi christoph.probst,
thank you for your fast reply and your patience. The console shows de following entries:

I have started the server with "hybrisserver.bat debug" from hybris/bin/platform via my Visual Studio Code:
This is the Output from Terminal (from Starting Orbeon Forms until the Server Startup): hybrisserverbat-debug.txt (Don't know if it is helpful to find a solution)

The Visual Studio Code didn't show any entries within the Problems, Output or Debug Console tab.

Please don't hesitate to let me know what I can do in addition to find the reason of the problem or if you have an idea what I could try to fix the issue.

Kind regards
Alexander

hybrisserverbat-debug.txt

[christoph_probst]

Hi first of all you have an exception in the log

error connecting to DataSource having url jdbc:hsqldb:file:C:\Users\axmae\Desktop\SAPCommerce\SAPCommerce2011\CxCom\hybris\data/hsqldb/mydb;shutdown=true;hsqldb.tx=MVCC;hsqldb.log_size=256: Database lock acquisition failure: lockFile: org.hsqldb.persist.LockFile@2d6b978d[file =C:\Users\axmae\Desktop\SAPCommerce\SAPCommerce2011\CxCom\hybris\data\hsqldb\mydb.lck, exists=true, locked=false, valid=false, ] method: checkHeartbeat read: 2021-05-19 08:01:46 heartbeat - read: -9813 ms.
java.sql.SQLException: Database lock acquisition failure: lockFile: org.hsqldb.persist.LockFile@2d6b978d[file =C:\Users\axmae\Desktop\SAPCommerce\SAPCommerce2011\CxCom\hybris\data\hsqldb\mydb.lck, exists=true, locked=false, valid=false, ] method: checkHeartbeat read: 2021-05-19 08:01:46 heartbeat - read: -9813 ms.

This most likely happens when 2 commerce instances where startet from same folder or the clean up was not done after shutdown. Try do remove

C:\Users\axmae\Desktop\SAPCommerce\SAPCommerce2011\CxCom\hybris\data\hsqldb\mydb.lck

and then start the commerce suite again

After you fixed this exception please provide again the log. it could be found

C:\Users\axmae\Desktop\SAPCommerce\SAPCommerce2011\CxCom\hybris\log\tomcat\console*.log

[Alexander_0001]

Hi,
christoph.probst thank you very much for your advice. before I followed it, I deleted the old commerce directory and installed it once again and did a update via the administrator cockpit for the b2b and frontend modules. It was not successful.

Then I have followed your instruction: After I have deleted the mydb.lck and started the commerce suite again, I tried to access the b2b frontend and got the same server error.
But attached to this comment I have the requested log for you: console-20210602.txt

If you want anything else please let me know. You are at the moment my biggest hope. 🙂

To give you some more context: I try to run the SAP Commerce demo within a VMware (which shouldn't be the problem)
I try to install the 2011 version for training and demo purposes for my colleagues, for me and in future our costumer's.

The final objective is to GET a running SAP 2011 Commerce system with Spartacus based B2B frontend. Because of the fact that the 2011 installation with Spartacus fails what ever I try, I decided at least to have a accelerator solution. I have already successfully installed SAP Commerce 2005 with Spartacus in another directory within the same Environment but there I have the same problem with the B2B frontend. But for the Spartacus installation I will open another question.

Look forward to your feedback.
Kind regards

console-20210602.txt