AAI Insight upgrade fails with "Failed to update superuser's password"

Products

Automation Analytics & Intelligence

Issue/Introduction

Error below seen when upgrading Insight to version 2.0

If you look further up in the installation log you will see the message below:

update-users:
[echo] Deleting extra user jasper admin and update superuser's default password
[java] Failed to delete user jasperadmin with DELETE http://localhost:8080/jasperserver-pro/rest_v2/organizations/organization_1/users/jasperadmin?j_username=superuser&j_password=superuser
[java] org.springframework.web.client.ResourceAccessException: I/O error on DELETE request for "http://localhost:8080/jasperserver-pro/rest_v2/organizations/organization_1/users/XXXX?j_username=XXXXX&j_password=XXXX": Connection reset; nested exception is java.net.SocketException: Connection reset
[java] at org.springframework.web.client.RestTemplate.doExecute(RestTemplate.java:534)
[java] at org.springframework.web.client.RestTemplate.execute(RestTemplate.java:482)
[java] at org.springframework.web.client.RestTemplate.exchange(RestTemplate.java:430)
[java] at com.termalabs.client.UsersUpdater.deleteUser(UsersUpdater.java:51)
[java] at com.termalabs.client.UsersUpdater.main(UsersUpdater.java:35)
[java] Caused by: java.net.SocketException: Connection reset
[java] at java.net.SocketInputStream.read(SocketInputStream.java:210)
[java] at java.net.SocketInputStream.read(SocketInputStream.java:141)
[java] at java.io.BufferedInputStream.fill(BufferedInputStream.java:246)
[java] at java.io.BufferedInputStream.read1(BufferedInputStream.java:286)
[java] at java.io.BufferedInputStream.read(BufferedInputStream.java:345)
[java] at sun.net.www.http.HttpClient.parseHTTPHeader(HttpClient.java:735)
[java] at sun.net.www.http.HttpClient.parseHTTP(HttpClient.java:678)
[java] at sun.net.www.http.HttpClient.parseHTTPHeader(HttpClient.java:848)
[java] at sun.net.www.http.HttpClient.parseHTTP(HttpClient.java:678)
[java] at sun.net.www.protocol.http.HttpURLConnection.getInputStream0(HttpURLConnection.java:1593)
[java] at sun.net.www.protocol.http.HttpURLConnection.getInputStream(HttpURLConnection.java:1498)
[java] at java.net.HttpURLConnection.getResponseCode(HttpURLConnection.java:480)
[java] at org.springframework.http.client.SimpleClientHttpResponse.getRawStatusCode(SimpleClientHttpResponse.java:47)
[java] at org.springframework.http.client.AbstractClientHttpResponse.getStatusCode(AbstractClientHttpResponse.java:32)
[java] at org.springframework.web.client.DefaultResponseErrorHandler.getHttpStatusCode(DefaultResponseErrorHandler.java:55)
[java] at org.springframework.web.client.DefaultResponseErrorHandler.hasError(DefaultResponseErrorHandler.java:49)
[java] at org.springframework.web.client.RestTemplate.doExecute(RestTemplate.java:520)
[java] ... 4 more
[java] Java Result: 6

BUILD FAILED
C:\Temp\terma-bi-installer-1.10\termaBiInstaller.xml:738: Last step failed, you can update superuser password in termaBiInstaller.xml and run: java -Djasper.root=c:\<Install Dir> -Djasper.port=8080 -cp lib -jar lib/ant-launcher-1.9.7.jar -f termaBiInstaller.xml update-users

Environment

Release : 6.4.5

Resolution

Error occurred because a system process was running on port 8005 which Insight is using for the Tomcat Shutdown Port.

After the error during the upgrade, open Windows Services and stop the Apache Tomcat service, it will likely be in a "Stopping" state, if you cannot stop it from the services, menu, find the process in task manager and kill the process.

Then start the Apache Tomcat Service.

Then run the command below from the \<Install dir>\terma-bi-installer-2.0.0 directory

java -Djasper.root=\<Install Dir> -Djasper.port=8080 -cp lib -jar lib/ant-launcher-1.9.7.jar -f termaBiInstaller.xml update-users

For a new installation the path to run this command from will vary slightly, below is an example of a new installation:

C:\<Install Dir>\installation>java -Djasper.root=C:\aibi -Djasper.port=8080 -cp lib -jar lib/ant-launcher-1.9.7.jar -f termaBiInstaller.xml update-users

On Linux you need to run this from the /opt/bi-server/installer directory: