Page 1 of 1

PAW unable to connect to TM1 Database

Posted: Mon May 27, 2019 10:55 am
by slique-cya
Hi, 

 I am using the Planning Sample TM1 database to test the installation process of Planning Analytics Workspace. I can connect to the Welcome Page of PAW.  The issue is when I try to create a New Book, instead of seeing  the TM1 database, I get the following error: 

"Path not exist" 

I also navigated to the "Administer" page where I could pick up the Planning Sample TM1 database. I can see the TM1 server that is running but it also shows an error message: 

"Cannot display resource information. Unable to connect to server."

This is my first time installing Planning Analytics Workspace so please forgive me if I have missed out any information that might help in this instance. PAW is installed on the below environment: 

- Hyper-V Virtual Machine
- Windows Server 2016 Standard Edition OS
- Docker EE version 18.09.6
- Docker-Compose version 1.24.0
- PAW version 2.0.41
- TM1 version PA 2.0.6

I even turned off Firewalls (Both Windows and ESET) and I still get the same error on both the server and on a separate client machine.

Re: PAW unable to connect to TM1 Database

Posted: Mon May 27, 2019 1:58 pm
by dr.nybble
In order for the "Administer" page to display resource information, the "IBM Planning Analytics Administration Agent" service must be configured and running. The TM1 Server also needs to be reporting the correct address to the admin host.

You may need to specify the IPAddressV4 setting in tm1s.cfg so TM1 reports the correct IP address to the admin host.

If you capture a Fiddler trace or network trace in the browser, what request is failing?

Re: PAW unable to connect to TM1 Database

Posted: Tue May 28, 2019 1:25 pm
by slique-cya
Hi dr.nybble

So I have confirmed that the "IBM Planning Analytics Administration Agent" service is running - I was running all along apparently.

I added the IPAddressV4 parameter onto the .cfg file (the AdminHost and IPAddressV4 parameters are the same)

But after restarting the TM1 Service, TM1 Admin Server, as well as the PAW Admin Tool, I go the following error.

"pa-gateway’s server IP address could not be found"

This is after successfully validating the configuration on PAW Admin tool
PAW Admin Validation.png
PAW Admin Validation.png (11.3 KiB) Viewed 11865 times
Below is a screenshot of the PAW script
PAW Scripts.png
PAW Scripts.png (46.83 KiB) Viewed 11865 times

Re: PAW unable to connect to TM1 Database

Posted: Wed Jun 05, 2019 9:24 am
by slique-cya
An update:

After re-installing PAW AND adding the TM1 PortNumber onto the Inbound Firewall Rules, I can now access the TM1 Server via PAW. The following changes were made:

1. updated the tm1s.cfg file.
- IPAddress=T
- IPVersion=ipv4

2. Added TM1 PortNumber, AdminServer Ports, and HTTPPortNumber onto the Inbound Firewall Rules.

The above seemed to take care of the "Path Not Exist" error. I am still unable to see the TM1 Server resource info on the administration tab, but that is a secondary issue at this point. If I crack that as well, I'll be sure to update this thread.

Re: PAW unable to connect to TM1 Database

Posted: Tue Nov 26, 2019 2:57 pm
by TiagoUmr
slique-cya wrote: Wed Jun 05, 2019 9:24 am An update:

After re-installing PAW AND adding the TM1 PortNumber onto the Inbound Firewall Rules, I can now access the TM1 Server via PAW. The following changes were made:

1. updated the tm1s.cfg file.
- IPAddress=T
- IPVersion=ipv4

2. Added TM1 PortNumber, AdminServer Ports, and HTTPPortNumber onto the Inbound Firewall Rules.

The above seemed to take care of the "Path Not Exist" error. I am still unable to see the TM1 Server resource info on the administration tab, but that is a secondary issue at this point. If I crack that as well, I'll be sure to update this thread.
Hi there,

Not sure if I understood the topic here (english is not my native language), and also I'm newbie at PA, but
have you looked at documentation from IBM? It's about the free ports required for PAW.

https://www.ibm.com/support/knowledgece ... ports.html

The following ports are required for Planning Analytics Workspace Local.

80
8888
9012
443

So, if you add those into the Inbound Firewall Rules, maybe it could enable the Database Tab on Administer painel.
I'm note sure if it necessary in your case, but here we installed PAW on a linux server while Tm1 is on windows