Skip to main content

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

3 respuestas
  1. 24 ene 2023, 1:51

    Hi Peter,

     

    This post has been resolved, solution are re-install master rmt server and agent rmt on each tableau server.

     

    Thank You

0/9000