I was thinking that maybe the "IBM Cognos TM1" service is running, and taking the 9514 port while the intent is probably for the "Planning Analytics Spreadsheet Services" service to have 9514. The "IBM Cognos TM1" service is often hanging around since 2.0.9.2 when TM1Web became PASS and was separated from the rest of the "other" Web Tier Components in the "IBM Cognos TM1" service. Sometimes, "IBM Cognos TM1" gets started if it hasn't been removed, even after the PASS install sets it to only manually start. The "IBM Cognos TM1" service should have been called "IBM Cognos TM1 Web Tier" so it would be less confusing than sounding like it is the all-inclusive, main TM1 service, but I digress.
Original Message:
Sent: Wed November 16, 2022 11:09 AM
From: Ted Phillips
Subject: PAfE extremely slow after upgrades
feel free to make a support case, we should be able to get it straightened out pretty quick.
what I meant was, the PASS install includes webservices running under http://<mypass:9510>/tm1web and http://<mypass:9510>/evalservice
if the traffic going to PASS from PA for Excel is timing out (which it seems it could be from your screenshot of the PAW setup screen), it's imaginable it could be the source of your delays. This could be due to PASS setup issues or specific network details (ex: firewall) if you've installed bare metal; I would not expect such issues if you've bought any of IBM's PA managed services.
for posterity I'll mention that PA for Excel consumes Workspace, Spreadsheet Services, and TM1; we'll continue to onboard functions that leverage Spreadsheet Services across time.
------------------------------
Ted Phillips
IBM
Original Message:
Sent: Tue November 15, 2022 08:13 AM
From: Herman Teeuwen
Subject: PAfE extremely slow after upgrades
Hi Ted,
We're upgrading to:
PA: 2.0.9.14
PAW: 2.0.80
PASS: 2.0.79
PAFE: 2.0.80
Re. deployment method and eval service. I can't really follow along.
If I set PAfE log level to all and check the log file, I see issues re. the eval service, but to be honest, I can't really translate all of this to a root cause.
Maybe it's better to create a ticket at IBM Support.
Thanks
------------------------------
Herman Teeuwen
Original Message:
Sent: Mon November 14, 2022 05:12 PM
From: Ted Phillips
Subject: PAfE extremely slow after upgrades
say more about your entire version mix, please.
other thing i would suggest is if you can capture an 'all' level PA for Excel log, delay in activity should be apparent there under analysis.
what is your deployment method? if the eval service as part of PA Spreadsheet Services isn't exposed, but simultaneously isn't blocked, it's possible for that to induce a delay (if it is black hole-ing the requests)
------------------------------
Ted Phillips
IBM
Original Message:
Sent: Mon November 14, 2022 07:07 AM
From: Herman Teeuwen
Subject: PAfE extremely slow after upgrades
We're in the process of upgrading our PA components on our DEV, Quality, and Productive environments.
PAfE is upgraded from 2.0.70.4 >> 2.0.80.2.
PAfE on DEV works just fine after upgrades.
On Quality we see that after upgrade opening a report in PAfE that previously took 5-6 seconds, now takes 5 minutes.
When we check with PAW Administration Tool, we're seeing a timeout error that would normally show "Not Found" (can be ignored, see https://community.ibm.com/community/user/businessanalytics/communities/community-home/digestviewer/viewthread?GroupId=3067&MessageKey=f9614fa8-d0f4-47d5-ba14-cea814791191&CommunityKey=8fde0600-e22b-4178-acf5-bf4eda43146b&tab=digestviewer).
In PAfE logs we see errors like:
Any clues?
Best, Herman
------------------------------
Herman Teeuwen
------------------------------
#PlanningAnalyticswithWatson