SAP commerce (hybris) & DB (MSSQL)out of sync

[former_member759683]

Greetings, everyone!

I found out a strange issue, where while I search in backoffice I do not find any entries. I tried to import one entry via impex, and hybris throw me an error that such entry already exist. I checked it in the DB (MSSQL) and it was really there.

When I deleted in from DB and reimported it through impex, only then it appeared in backoffice. Do you have any idea what this might be. I cleared the cache in hybirs & refreshed the local cache of the DB. Both lead me to no luck.

Due to that reason I'm getting such errors while trying to save model instance in the backoffice:

Caused by: de.hybris.platform.jalo.JaloSystemException: Couldn't instantiate item for given PK 8796370370651
        at de.hybris.platform.jalo.Item.setAttribute(Item.java:2403) ~[coreserver.jar:?]
        at de.hybris.platform.jalo.Item.setAllAttributesInternal(Item.java:2224) ~[coreserver.jar:?]
        at de.hybris.platform.jalo.Item$18.execute(Item.java:2145) ~[coreserver.jar:?]
        at de.hybris.platform.tx.Transaction.execute(Transaction.java:1181) ~[coreserver.jar:?]
        at de.hybris.platform.tx.Transaction.execute(Transaction.java:1149) ~[coreserver.jar:?]
        at de.hybris.platform.jalo.Item.setAllAttributes(Item.java:2140) ~[coreserver.jar:?]
        at de.hybris.platform.jalo.Item.setAllAttributes(Item.java:2120) ~[coreserver.jar:?]
        at de.hybris.platform.servicelayer.internal.converter.impl.ItemModelConverter.storeAttribut

Any help will be appreciated.

[devdixit]

@Dian, did you get the solution of this problem?