Skip Ribbon Commands
Skip to main content
Navigate Up
Sign In

Quick Launch

Average Rating:

facebook Twitter
Email
Print Bookmark Alert me when this article is updated

Feedback

ERROR:"Found non-empty schema 'PIM_SUPPLIER' without metadata table! Use init() first to initialize the metadata table" while starting PIM Supplier portal
Problem Description
The Product Information Management (PIM) Supplier portal fails to start with the following error messages:

Caused by: com.googlecode.flyway.core.api.FlywayException: Found non-empty schema 'PIM_SUPPLIER' without metadata table! Use init() first to initialize the metadata table.
at com.googlecode.flyway.core.Flyway$1.execute(Flyway.java:842) ~[flyway-core-2.0.3.jar:na]
at com.googlecode.flyway.core.Flyway$1.execute(Flyway.java:820) ~[flyway-core-2.0.3.jar:na]
at com.googlecode.flyway.core.Flyway.execute(Flyway.java:1259) ~[flyway-core-2.0.3.jar:na]
at com.googlecode.flyway.core.Flyway.migrate(Flyway.java:820) ~[flyway-core-2.0.3.jar:na]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_201]
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:1.8.0_201]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_201]
at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_201]
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeCustomInitMethod(AbstractAutowireCapableBeanFactory.java:1758) ~[spring-beans-4.3.10.RELEASE.jar:4.3.10.RELEASE]
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1695) ~[spring-beans-4.3.10.RELEASE.jar:4.3.10.RELEASE]
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1624) ~[spring-beans-4.3.10.RELEASE.jar:4.3.10.RELEASE]
... 87 common frames omitted
04/02 15:45:36.960 [localhost-startStop-1] [] INFO c.h.h.s.f.ApplicationLoadedContextListener - PIM Supplier Portal started.
04/02 15:45:36.965 [localhost-startStop-1] [] INFO c.h.h.s.f.ApplicationLoadedContextListener - PIM Supplier Portal shut down.
Cause
This issue occurs when the correct schema is not used. Supplier portal comes with its own schema which needs to be created at the time of installation of the supplier portal. In case you link the schema created as a part of PIM core, you face metadata issues. Both the schemas serve different purposes. 
Solution
As per the guidelines, the schema needs to be created using the script provided with the supplier portal installer. Provide the same schema name in the configuration.properties of supplier portal.

Create a new schema using that script to resolve this issue.
More Information
Applies To
Product: Product 360(Media Manager)
Problem Type: Configuration
User Type: Administrator
Project Phase: Configure
Product Version:
Database:
Operating System:
Other Software:

Reference
Attachments
Last Modified Date:5/17/2019 4:27 AMID:575329
People who viewed this also viewed

Feedback

Did this KB document help you?



What can we do to improve this information (2000 or fewer characters)