Hi Anyone,
I have a case related tableau rmt failed start after restart, this is first time to restarting tableau rmt since last year installed.
- All services Tableau RMT restart completed
C:\Program Files\Tableau\Tableau Resource Monitoring Tool\master>rmtadmin restart
TableauResourceMonitoringTool is currently running
Stopping service: TableauResourceMonitoringTool
Waiting for the TableauResourceMonitoringTool service to stop.
TableauResourceMonitoringTool service successfully stopped
TableauResourceMonitoringToolPostgreSQL is currently running
Stopping service: TableauResourceMonitoringToolPostgreSQL
Waiting for the TableauResourceMonitoringToolPostgreSQL service to stop.
TableauResourceMonitoringToolPostgreSQL service successfully stopped
TableauResourceMonitoringToolRabbitMQ is currently running
Stopping service: TableauResourceMonitoringToolRabbitMQ
Waiting for the TableauResourceMonitoringToolRabbitMQ service to stop.
TableauResourceMonitoringToolRabbitMQ service successfully stopped
TableauResourceMonitoringToolRabbitMQ is currently stopped
Starting service: TableauResourceMonitoringToolRabbitMQ
Waiting for the TableauResourceMonitoringToolRabbitMQ service to start.
TableauResourceMonitoringToolRabbitMQ service successfully started
TableauResourceMonitoringToolPostgreSQL is currently stopped
Starting service: TableauResourceMonitoringToolPostgreSQL
Waiting for the TableauResourceMonitoringToolPostgreSQL service to start.
TableauResourceMonitoringToolPostgreSQL service successfully started
TableauResourceMonitoringTool is currently stopped
Starting service: TableauResourceMonitoringTool
Waiting for the TableauResourceMonitoringTool service to start.
TableauResourceMonitoringTool service successfully started
but after this tableau rmt can't access
- when i checking rmtadmin status
C:\Program Files\Tableau\Tableau Resource Monitoring Tool\master>rmtadmin status
TableauResourceMonitoringTool service status: Running
TableauResourceMonitoringTool executable path: "C:\Program Files\Tableau\Tableau Resource Monitoring Tool\master\tabrmt-master.exe" -displayname "Tableau Resource Monitoring Tool Master" -servicename "TableauResourceMonitoringTool"
[ERR] Failed to connect to the message queue: localhost:5672
Connected to the database: localhost:5555
MQ Logs :
2022-12-01 11:06:45.816 [info] <0.943.0> closing AMQP connection <0.943.0> (192.168.1.216:61102 -> 192.168.1.35:5672 - tabrmt-agent-background (6356), vhost: 'none', user: 'user925d20e01c2248138e5fe1dfae5d31fe')
2022-12-01 11:06:45.816 [info] <0.948.0> Closing all channels from connection '192.168.1.216:61102 -> 192.168.1.35:5672' because it has been closed
2022-12-01 11:06:46.269 [info] <0.951.0> accepting AMQP connection <0.951.0> ([::1]:51643 -> [::1]:5672)
2022-12-01 11:06:46.316 [info] <0.951.0> Connection <0.951.0> ([::1]:51643 -> [::1]:5672) has a client-provided name: tabrmt-master-web (5708)
2022-12-01 11:06:46.316 [error] <0.951.0> Error on AMQP connection <0.951.0> ([::1]:51643 -> [::1]:5672 - tabrmt-master-web (5708), vhost: 'none', user: 'tabrmtmq', state: opening), channel 0:
{handshake_error,opening,
{amqp_error,internal_error,
"access to vhost 'tabrmt' refused for user 'tabrmtmq': vhost 'tabrmt' is down",
'connection.open'}}
2022-12-01 11:06:46.316 [info] <0.951.0> closing AMQP connection <0.951.0> ([::1]:51643 -> [::1]:5672 - tabrmt-master-web (5708), vhost: 'none', user: 'tabrmtmq')
2022-12-01 11:06:46.316 [info] <0.956.0> Closing all channels from connection '[::1]:51643 -> [::1]:5672' because it has been closed
2022-12-01 11:06:47.269 [info] <0.959.0> accepting AMQP connection <0.959.0> (192.168.1.216:61103 -> 192.168.1.35:5672)
2022-12-01 11:06:47.269 [info] <0.959.0> Connection <0.959.0> (192.168.1.216:61103 -> 192.168.1.35:5672) has a client-provided name: tabrmt-agent-web (6384)
2022-12-01 11:06:47.285 [error] <0.959.0> Error on AMQP connection <0.959.0> (192.168.1.216:61103 -> 192.168.1.35:5672 - tabrmt-agent-web (6384), vhost: 'none', user: 'user925d20e01c2248138e5fe1dfae5d31fe', state: opening), channel 0:
{handshake_error,opening,
{amqp_error,internal_error,
"access to vhost 'tabrmt' refused for user 'user925d20e01c2248138e5fe1dfae5d31fe': vhost 'tabrmt' is down",
'connection.open'}}
2022-12-01 11:06:47.285 [info] <0.959.0> closing AMQP connection <0.959.0> (192.168.1.216:61103 -> 192.168.1.35:5672 - tabrmt-agent-web (6384), vhost: 'none', user: 'user925d20e01c2248138e5fe1dfae5d31fe')
2022-12-01 11:06:47.285 [info] <0.964.0> Closing all channels from connection '192.168.1.216:61103 -> 192.168.1.35:5672' because it has been closed
2022-12-01 11:06:49.153 [info] <0.967.0> accepting AMQP connection <0.967.0> (192.168.1.216:61113 -> 192.168.1.35:5672)
2022-12-01 11:06:49.153 [info] <0.967.0> Connection <0.967.0> (192.168.1.216:61113 -> 192.168.1.35:5672) has a client-provided name: tabrmt-agent-background (6356)
2022-12-01 11:06:49.153 [error] <0.967.0> Error on AMQP connection <0.967.0> (192.168.1.216:61113 -> 192.168.1.35:5672 - tabrmt-agent-background (6356), vhost: 'none', user: 'user925d20e01c2248138e5fe1dfae5d31fe', state: opening), channel 0:
{handshake_error,opening,
{amqp_error,internal_error,
"access to vhost 'tabrmt' refused for user 'user925d20e01c2248138e5fe1dfae5d31fe': vhost 'tabrmt' is down",
'connection.open'}}
2022-12-01 11:06:49.153 [info] <0.967.0> closing AMQP connection <0.967.0> (192.168.1.216:61113 -> 192.168.1.35:5672 - tabrmt-agent-background (6356), vhost: 'none', user: 'user925d20e01c2248138e5fe1dfae5d31fe')
2022-12-01 11:06:49.153 [info] <0.972.0> Closing all channels from connection '192.168.1.216:61113 -> 192.168.1.35:5672' because it has been closed
i get error message from rabbitmq service, however tableau rmt rabbitmq service succesfully started.
has anyone faced this error ? and what the solution to fixing this.
Thank You
Hi Peter,
This post has been resolved, solution are re-install master rmt server and agent rmt on each tableau server.
Thank You