Hello All - I'm using evaluation copy and trying to install HDP server using postgress/oracle database in both cases the installation completed with below error. Please help how to fix this issue.
Error in createSchema at Line 268
Can you please provide the logs directory from installed location and details on inputs provided.
[View:/cfs-file/__key/communityserver-discussions-components-files/261/5635.Progress_5F00_DataDirect_5F00_Hybrid_5F00_Data_5F00_Pipeline_5F00_Server_5F00_Install_5F00_04_5F00_01_5F00_2020_5F00_18_5F00_22_5F00_58.log:0:0][View:/cfs-file/__key/communityserver-discussions-components-files/261/3187.Progress_5F00_DataDirect_5F00_Hybrid_5F00_Data_5F00_Pipeline_5F00_Server_5F00_Install_5F00_04_5F00_02_5F00_2020_5F00_08_5F00_43_5F00_35.log:0:0]
Here attached install logs
Hi Shiva - Here attached installation log. Inputs are listed below:
InstallAnywhere is now ready to install Progress DataDirect Hybrid Data
Pipeline Server onto your system at the following location:
/opt/hdp/Progress/DataDirect/Hybrid_Data_Pipeline/Hybrid_Server
Other user input values:
Hostname: xxxxxxxxxxxxxxxxxx.com
Certificate File:
MySQL Datasource: No
MySQL driver jar location:
/opt/hdp/Progress/DataDirect/Hybrid_Data_Pipeline/Hybrid_Server/drivers/
Load Balancing : No
Load Balancing Hostname :
Key Location : /opt/hdp/Progress/DataDirect/Hybrid_Data_Pipeline/Hybrid_Server/ddcloud/keystore
Java home directory :
/opt/hdp/Progress/DataDirect/Hybrid_Data_Pipeline/Hybrid_Server/jre
FIPS Enabled: 0
OPC Enable : No
Database Type: External
Database Vendor: PostgreSQL
Database Host: pgxxxxxxxxx
Database Port: 5432
Database Name: hdp
Schema Name :
Database Admin Username: hdpadmin
Database User Username: hdpuser
Oracle DB SID:
Oracle DB Service Name:
Database Advanced Options:
API Port: 8080
API SSL Port: 8443
OPC Access Port: 0
Notification Port: 0
Notification SSL Port: 0
Message Queue Port: 0
Internal API Port: 8190
Internal API SSL Port: 8090
Shutdown Port: 8005
[View:/cfs-file/__key/communityserver-discussions-components-files/261/7026.Progress_5F00_DataDirect_5F00_Hybrid_5F00_Data_5F00_Pipeline_5F00_Server_5F00_Install_5F00_04_5F00_01_5F00_2020_5F00_18_5F00_22_5F00_58.log:320:240]
Cab you also provide the following log files from the failed HDP install:
<install_dir>/ddcloud/deploy.log
<install_dir>/ddcloud/error.log
Very strange, next try of installation it went through now, however the issue now is I'm unable to get to UI. The admin user credentials are not working.
Any idea how to reset admin user password may be from DB side?
d2cadmin
d2cuser
Here errors in the logs when try to login.. Looks like database connection seems issue
System logs:
02-Apr-2020 12:47:22.023 SEVERE [main] [system].[initialize environment] exception [token=Error][errorCode=222206095][sqlState=HY000][origin=INTERNAL][message=Error getting database info: com.ddtek.cloudservice.servlets.ddh: Account DB JDBC Connection - error getting prepared statement for statement id 6: java.sql.SQLSyntaxErrorException: [DD Cloud OP][PostgreSQL JDBC Driver][PostgreSQL]relation "systemlimits" does not exist. ]
02-Apr-2020 12:47:22.023 CONFIG [main] [system].[initialize environment] exception [token=Error][errorCode=222206019][sqlState=HY000][origin=SERVICE][message=Error getting data source. System not available, try again later.]
Tomcat Logs:
02-04-2020 13:00:22,850 INFO OnPremiseLoginModule:? AppName in OnPremiseLoginModule: hdpui
02-04-2020 13:00:22,853 INFO OnPremiseLoginModule:? Started validating user credentials for: d2cadmin
02-04-2020 13:00:22,855 WARN hdpb:? [msg=Thread local request context is null.]
02-04-2020 13:00:22,862 ERROR hdpa:? [errorMsg=Failed to extract error message from raw response.] [resp=<!doctype html><html lang="en"><head><title>HTTP Status 404 – Not Found
02-04-2020 13:00:23,119 INFO IPWhiteListFilterServlet:? Checking for WebUI resource access: IP: 10.0.0.11
02-04-2020 13:00:23,122 WARN hdpb:? [msg=Thread local request context is null.]
02-04-2020 13:00:23,124 ERROR hdpa:? [errorMsg=Failed to extract error message from raw response.] [resp=<!doctype html><html lang="en"><head><title>HTTP Status 404 – Not Found
02-04-2020 13:00:23,125 ERROR hdpa:? [url=http://localhost:8080/api/public/webOperations] [statusCode=404] [errorMsg=<!doctype html><html lang="en"><head><title>HTTP Status 404 – Not Found
02-04-2020 13:00:23,127 ERROR IPWhiteListServiceImpl:? [msg=D2SServiceException occurred while checking WebUI Access, Reason: <!doctype html><html lang="en"><head><title>HTTP Status 404 – Not Found
02-04-2020 13:00:23,127 ERROR IPWhiteListFilterServlet:? Failed to check the webUI resource access with DAS
com.progress.d2cui.exception.hdpa: HTTP Status 404
Can you try accessing REST APIs and let us know if they are working.
Rest API Reference
Pradeep - No APIs throwing error 404.
https://xxxx:xxx/api/mgmt/datastores
Here attached all logs show there seems connection issue however at the installation it all went well few hour ago. Please help.
[View:/cfs-file/__key/communityserver-discussions-components-files/261/All_5F00_Logs.zip:320:240]
When the first install failed, it did not clean up the changes it made to the database. The reinstall reported success, but the database was already in a bad state. The errors are being caused by trying to access tables which were improperly created by the initial install. This doesn't prevent client connections, but it does prevent authorization and login. You will need to recreate the empty account database, and reinstall. If this fails, we will need the deploy.log and error.log generated by the install process to troubleshoot the issue.
When the first install failed, it did not clean up the changes it made to the database. The reinstall reported success, but the database was already in a bad state. The errors are being caused by trying to access tables which were improperly created by the initial install. This doesn't prevent client connections, but it does prevent authorization and login. You will need to recreate the empty account database, and reinstall. If this fails, we will need the deploy.log and error.log generated by the install process to troubleshoot the issue.
I did cleaned up the database schema and tried reinstall, I never faced the create schema issue, that was wired.
Later was able to install this successfully using option install onprem connector.
I did cleaned up the database schema and tried reinstall, I never faced the create schema issue, that was wired.
Later was able to install this successfully using option install onprem connector.