Product: Stratusphere FIT/UX
Product Version: 6.6.1-1
Expires on: 365 days from publish date
Updated: October 4, 2022
Problem:
Unable to log in to 6.6.1-1 UI. Hub or Database disk is larger than 2.1 terabytes. Login page will only have Administration in the Product dropdown and Local Directory in the Domain dropdown (AD/LDAP domain is missing).
On the hub, /var/log/tnt-backend.log will have an error similar to the following:
[root@10 tnt]# grep 'sys_df()' tnt-backend.log|grep 'out of range'
Caused by: org.springframework.dao.DataIntegrityViolationException: PreparedStatementCallback; SQL [select percent_used from sys_df() where mountpoint = ? limit 1]; ERROR: value "2684336132" is out of range for type integer
PL/pgSQL function sys_df() line 5 at SQL statement; nested exception is org.postgresql.util.PSQLException: ERROR: value "2684336132" is out of range for type integer
Possible resolution:
- If offline appliance, download tnt-db-upgrade-1.5.0-79937.noarch.rpm linked below and use WinSCP or Windows 10 OpenSSH to upload it to your hub as friend/ec2-user/azureuser
- SSH into the hub as friend/ec2-user/azureuser and run the following commands (skip wget command if rpm file is already uploaded):
sudo bash
wget https://cdn.liquidware.com/stratusphere/hotfix//tnt-db-upgrade-1.5.0-79937.noarch.rpm
rpm -Uvh --nosignature tnt-db-upgrade-1.5.0-79937.noarch.rpm
systemctl restart lwl-backend
- REBOOT the Database appliance if applicable, then reboot hub.