https://community.cloudera.com/t5/Archives-of-Support-Questions/Sqoop2-metastore-configuration-error/m-p/56601#M62812 This problem was caused because the Sqoop tables hadn't been created in PostgreSQL. To solve this problem, please go to CM &gt; Sqoop 2 service, click on Actions button and then choose "Create Sqoop Database". After that, please try to start Sqoop2 service again. Tue, 27 Jun 2017 21:32:29 GMT yshi 2017-06-27T21:32:29Z https://community.cloudera.com/t5/Archives-of-Support-Questions/Sqoop2-metastore-configuration-error/m-p/55819#M62809 <P>Hi ,</P><P>I am trying to configure postgres metastore from sqoop2 but getting error whiel starting the sqoop2</P><PRE>Sqoop server failed to start java.lang.RuntimeException: Failure in server initialization at org.apache.sqoop.core.SqoopServer.initialize(SqoopServer.java:63) at org.apache.sqoop.server.ServerInitializer.contextInitialized(ServerInitializer.java:41) at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4210) at org.apache.catalina.core.StandardContext.start(StandardContext.java:4709) at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:802) at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:779) at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:583) at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:944) at org.apache.catalina.startup.HostConfig.deployWARs(HostConfig.java:779) at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:505) at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1322) at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:325) at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:142) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1068) at org.apache.catalina.core.StandardHost.start(StandardHost.java:822) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1060) at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:463) at org.apache.catalina.core.StandardService.start(StandardService.java:525) at org.apache.catalina.core.StandardServer.start(StandardServer.java:759) at org.apache.catalina.startup.Catalina.start(Catalina.java:595) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289) at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414) Caused by: org.apache.sqoop.common.SqoopException: REPO_0002:Repository structures are not in suitable state, might require upgrade at org.apache.sqoop.repository.RepositoryManager.initialize(RepositoryManager.java:130) at org.apache.sqoop.repository.RepositoryManager.initialize(RepositoryManager.java:78) at org.apache.sqoop.core.SqoopServer.initialize(SqoopServer.java:56) ... 25 more <BR /><BR /><BR /></PRE><P>I have created the sqoop db in postgres&nbsp;</P><P>followed doc&nbsp;</P><P><A href="https://www.cloudera.com/documentation/enterprise/5-5-x/topics/install_sqoop_ext_db.html" target="_blank">https://www.cloudera.com/documentation/enterprise/5-5-x/topics/install_sqoop_ext_db.html</A></P><P>&nbsp;</P><P>&nbsp;</P><P>List of databases<BR />Name | Owner | Encoding | Collate | Ctype | Access privileges<BR />-----------+----------+----------+-------------+-------------+-----------------------<BR />postgres | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 |<BR />sqoop | sqoop | UTF8 | en_US.UTF8 | en_US.UTF8 |<BR />template0 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/postgres +<BR />| | | | | postgres=CTc/postgres<BR />template1 | postgres | UTF8 | en_US.UTF8 | en_US.UTF8 |<BR />(4 rows)</P><P>&nbsp;</P> Fri, 16 Sep 2022 11:44:56 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/Sqoop2-metastore-configuration-error/m-p/55819#M62809 MSharma 2022-09-16T11:44:56Z https://community.cloudera.com/t5/Archives-of-Support-Questions/Sqoop2-metastore-configuration-error/m-p/55828#M62810 <P>Could you let me know the CDH version you are using .&nbsp;</P><P>because it is forcing you to upgrade sqoop 2 version . ?&nbsp;</P> Wed, 14 Jun 2017 01:44:23 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/Sqoop2-metastore-configuration-error/m-p/55828#M62810 csguna 2017-06-14T01:44:23Z https://community.cloudera.com/t5/Archives-of-Support-Questions/Sqoop2-metastore-configuration-error/m-p/55830#M62811 CDH 5.7.5 Wed, 14 Jun 2017 03:26:18 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/Sqoop2-metastore-configuration-error/m-p/55830#M62811 MSharma 2017-06-14T03:26:18Z https://community.cloudera.com/t5/Archives-of-Support-Questions/Sqoop2-metastore-configuration-error/m-p/56601#M62812 This problem was caused because the Sqoop tables hadn't been created in PostgreSQL. To solve this problem, please go to CM &gt; Sqoop 2 service, click on Actions button and then choose "Create Sqoop Database". After that, please try to start Sqoop2 service again. Tue, 27 Jun 2017 21:32:29 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/Sqoop2-metastore-configuration-error/m-p/56601#M62812 yshi 2017-06-27T21:32:29Z