6.7 B2C Setup Issue

[former_member630291]

Hi Experts,

I've just installed B2C with recipe with making an entry in the hosts file. The build is successful and the server is up and running. The initialization was successful. When I tried accessing the apparel-uk or apparel-de, it shows the web page only with the header but not the entire page. when I clicked on sign-in/register, the page redirected but again only the header. PFA.

Can you please help me with the problem?

[former_member620692]

It seems the initialization was not proper. Did you check the log? I think re-initialization should fix the problem. However, before you go for re-initialization, you should try accessing it in some other browser. It will be faster to analyze the problem if you can also mention the database you have used.

[former_member630291]

Hi Arvind,

Oracle 12CR2 is the database. I've re-initialized several times but the issue doesn't go away. There's nothing in the logs but the one thing I noticed is that the content catalog sync failed with some media duplication error, but this wouldn't cause the problem as it appears to me.

[former_member620692]

one thing I noticed is that the content catalog sync failed with some media duplication error

You have already found the root cause. This is why it is happening. Now, the question is how to fix the issue. I can see that database compatibility should not be an issue. You have faced the issue with Apparel sites; what about the electronics site?

Can you try updating your system and see if you get the same synchronization error?

Also, please make sure that you have the following configuration in your local.properties file:

 db.pool.maxActive=90
 db.pool.maxIdle=90

[former_member630291]

It's the same error. I tried opening electronics store but resulted in 500 server error.

INFO [000000OH::de.hybris.platform.catalog.jalo.synchronization.CatalogVersionSyncJob] (000000OH) [CatalogVersionSyncJob] Starting synchronization ... ERROR [SyncWorker<000000OH 11 of 24>] [AbstractItemCopyContext] could not copy data from 8796162654238 to 8796551315486 due to de.hybris.platform.persistence.hjmp.HybrisOptimisticLockingFailureException: item pk 8796551315486 was modified concurrently - expected database version 1 but got 2, expected blocked = false but got blocked = false, entity state = GenericItemEntityState(PK=8796551315486,txbound=true,sid=49488383,hjmpTS=2,hjmpTSBefore=1) ERROR [SyncWorker<000000OH 20 of 24>] [AbstractItemCopyContext] could not copy data from 8796162654238 to 8796551315486 due to de.hybris.platform.persistence.hjmp.HybrisOptimisticLockingFailureException: item pk 8796551315486 was modified concurrently - expected database version 3 but got 4, expected blocked = false but got blocked = false, entity state = GenericItemEntityState(PK=8796551315486,txbound=true,sid=1e5f7eef,hjmpTS=4,hjmpTSBefore=3)

[former_member630291]

Finally, I resolved the issue. The root cause was the content catalog and the product catalog were not synchronized. Reason: I used Hybris 6.7, Oracle 12CR2 with odjbc jar version 8. In Oracle 12CR2, the batch size support is removed and is limited to 1. I had to use ojdbc jar 7 and the issue is now resolved.