datahub-webapp-18.08.1-RC2 is not working

[VinayKumarS]

datahub-webapp-18.08.1-RC2 is not working.

I downloaded the 1808 datahub from support.sap.com. Then, I downloaded and installed Apache Tomcat 9, and I copied datahub-webapp-18.08.1-RC2.war file in webapps of Apache.

After server start, URL is not accessible: http://localhost:8080/datahub-webapp/v1/status

Also, I see exception below:

 2018-10-28 05:31:17,124 [INFO] [o.s.j.s.SQLErrorCodesFactory] Found custom sql-error-codes.xml file at the root of the classpath
 2018-10-28 05:31:17,171 [INFO] [o.s.j.s.SQLErrorCodesFactory] SQLErrorCodes loaded: [DB2, Derby, H2, HDB, HSQL, Informix, MS-SQL, MySQL, Oracle, PostgreSQL, Sybase]
 2018-10-28 05:31:17,187 [DEBUG] [c.h.d.p.j.u.i.DefaultJpaSchemaGenerationStrategy] Version table does not exist.
 org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [SELECT "version" FROM "DataHubVersion"]; nested exception is java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: DataHubVersion in statement [SELECT "version" FROM "DataHubVersion"]
         at org.springframework.jdbc.support.SQLExceptionSubclassTranslator.doTranslate(SQLExceptionSubclassTranslator.java:91)
         at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:73)
         at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:82)
         at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:655)
         at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:690)
         at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:722)
         at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:732)
         at org.springframework.jdbc.core.JdbcTemplate.queryForObject(JdbcTemplate.java:800)
         at org.springframework.jdbc.core.JdbcTemplate.queryForObject(JdbcTemplate.java:819)
         at com.hybris.datahub.persistence.jpa.util.impl.DefaultJpaSchemaGenerationStrategy.verifyDatabaseVersion(DefaultJpaSchemaGenerationStrategy.java:68)
         at com.hybris.datahub.persistence.jpa.util.impl.DefaultJpaSchemaGenerationStrategy.getDatabaseActionFromJavaxDatabaseActionProperty(DefaultJpaSchemaGenerationStrategy.java:90)
         at com.hybris.datahub.persistence.jpa.util.impl.DefaultJpaS

[regina_moore]

Hi there, we have been able to recreate this issue using hsql and have created a JIRA ticket to address. In the meantime, a workaround is to startup using datahub.autoInitMode=create-drop. If hsql is NOT the database you were using, please let us know so we can do more research. Thank you!

[VinayKumarS]

HSQL it is always giving the version error. when i use create-drop. Then i switched to mysql

[VinayKumarS · Accepted solution]

Too much with Hybris Datahub 1808. I just maintained below properties in local.properties of datahub. It worked fine.

 datahub.autoInitMode=create-drop
 datahub.security.basic.admin.user=admin
 datahub.security.basic.admin.password=nimda
 datahub.security.https.enabled=false
 

But if you add below entries in local.properties, datahub doesn't work. So, here we need to understand one thing. When we add the security https enabled and when we add other user authorization entries as given below.

 datahub.security.basic.developer.user=admin
 datahub.security.basic.developer.password=nimda
 datahub.security.basic.read_only.user=rouser
 datahub.security.basic.read_only.password=ropass
 datahub.security.https.enabled=true

This works for me. May be SAP Hybris folks has to relook what they have done. If it is same. Please vote for this answer.

Thank you Avinash, Elan and Murali

[VinayKumarS · Accepted solution]

This is the same behavior for previous verion aswell.

[regina_moore · Accepted solution]

Hi there, the https enabled issue that you are seeing seems like a separate issue than that of the original post. Can you please post this as a separate question so it can be looked at independently of this? Or if you think they are related, please let us know. Thank you!

[VinayKumarS · Accepted solution]

Hi Regina,

There were multiple issues. 1) with HSQL. always the server logs are throwing errors. saying DataHubVersion table not exist. 2) when i added security enabled. I cannot even see the index.html page which i added in datahub-webapp folder. When i disabled i am able to see. 3)when i added below entries and use mysql with create-drop i am getting memory leak warnings in the logs.

datahub.security.basic.developer.user=admin datahub.security.basic.developer.password=nimda datahub.security.basic.read_only.user=rouser datahub.security.basic.read_only.password=ropass

[VinayKumarS · Accepted solution]

The web application [datahub-webapp] appears to have started a thread named [Abandoned connection cleanup thread] but has failed to stop it. This is very likely to create a memory leak. Stack trace of thread:

[former_member333910 · Accepted solution]

, this forum works most efficiently when we can have a single issue per question. I understand you have experienced a few different issues and we want to help you. Please post new questions for different topics. Thanks!