No Data Tree in PAW 2.0.49 with error 500 javax.crypto.BadPaddingException

Post Reply
mawitti
Posts: 11
Joined: Mon Apr 06, 2020 2:08 pm
OLAP Product: TM1 / Planning Analytics
Version: 11.2
Excel Version: Office 365 -V16
Location: Germany

No Data Tree in PAW 2.0.49 with error 500 javax.crypto.BadPaddingException

Post by mawitti »

Hi together,

on a Windows Server 2016 I had installed a PA 2.0.49 and the workspace.
After several Problems during the installation I got the workspace started.

But when I try to open the Tree in the Databases I am getting an error message:

"Abrufen der Funktionen für den Server ... nicht möglich.
Die Sitzung kann für den Server ... nicht aufgebaut werden.
500 (Internal Server Error) javax.crypto.BadPaddingException: Given final block not properly padded"

On previous Installations on other servers I know Error 500 but always in an other context. I've tried to change the IPAddresV4 config field without changes on the message.

Do you have experience with this Message?
Last edited by mawitti on Thu Apr 23, 2020 9:55 am, edited 1 time in total.
HighKeys
Posts: 117
Joined: Fri Aug 09, 2019 10:11 am
OLAP Product: TM1 / TM1 Web / Perspectives
Version: Planning Analytics V2.0.9
Excel Version: Office 365

Re: No Data Tree in PAW 2.0.49 with error 500 javax.crypto.BadPaddingException

Post by HighKeys »

Hi,

is it a fresh installation on this machine?

Try to clear your cookies and browser cache.

BR
mawitti
Posts: 11
Joined: Mon Apr 06, 2020 2:08 pm
OLAP Product: TM1 / Planning Analytics
Version: 11.2
Excel Version: Office 365 -V16
Location: Germany

Re: No Data Tree in PAW 2.0.49 with error 500 javax.crypto.BadPaddingException

Post by mawitti »

Hi,

yes it is a fresh installation on a new Server.

Now I tried to delete the cache and the cookies in the browser.

same result - same error.
HighKeys
Posts: 117
Joined: Fri Aug 09, 2019 10:11 am
OLAP Product: TM1 / TM1 Web / Perspectives
Version: Planning Analytics V2.0.9
Excel Version: Office 365

Re: No Data Tree in PAW 2.0.49 with error 500 javax.crypto.BadPaddingException

Post by HighKeys »

Do you got some infos in the browser console?

Which browser are you using?

Whats happen if you try it in the browser at the server directly?

If everything working just the Database Tree not?
mawitti
Posts: 11
Joined: Mon Apr 06, 2020 2:08 pm
OLAP Product: TM1 / Planning Analytics
Version: 11.2
Excel Version: Office 365 -V16
Location: Germany

Re: No Data Tree in PAW 2.0.49 with error 500 javax.crypto.BadPaddingException

Post by mawitti »

here is the message that I am getting.
2020-04-23 12_31_01-Window.png
2020-04-23 12_31_01-Window.png (18.12 KiB) Viewed 7034 times

Only the UI of paw is working. But nothing regarding the data. After I click on the message I only can see the servers.

I am using Firefox. What do you mean with trying in the browser at the server directly? The browser is running on the Windows 2016 Server where I have installed PA. On this Server I also installed PAW.

In the Browser Console I found nothing special
2020-04-23 14_08_55-Window.png
2020-04-23 14_08_55-Window.png (103 KiB) Viewed 7034 times
.
MarenC
Regular Participant
Posts: 346
Joined: Sat Jun 08, 2019 9:55 am
OLAP Product: Planning Analytics
Version: Planning Analytics 2.0
Excel Version: Excel 2016

Re: No Data Tree in PAW 2.0.49 with error 500 javax.crypto.BadPaddingException

Post by MarenC »

I would narrow down the focus to security and Certificates. I wish I could be more specific!

Maren
dr.nybble
MVP
Posts: 160
Joined: Wed Aug 17, 2011 3:51 pm
OLAP Product: TM1
Version: 10.2.2
Excel Version: Excel 2007

Re: No Data Tree in PAW 2.0.49 with error 500 javax.crypto.BadPaddingException

Post by dr.nybble »

Try to restart redis. Something wrong with the encryption of TM1 credentials that are stored in redis. May also be that the encryption key generation didn't work right due to your installation problems.
Martin Erlmoser
Community Contributor
Posts: 125
Joined: Wed May 28, 2008 1:22 pm
OLAP Product: TM1, Cognos Express,..
Version: 9.1.4 FP1
Excel Version: 2010
Location: Vienna
Contact:

Re: No Data Tree in PAW 2.0.49 with error 500 javax.crypto.BadPaddingException

Post by Martin Erlmoser »

did you add a firewall exception for configured HTTPPortNumber, if you have a fw active?
mawitti
Posts: 11
Joined: Mon Apr 06, 2020 2:08 pm
OLAP Product: TM1 / Planning Analytics
Version: 11.2
Excel Version: Office 365 -V16
Location: Germany

Re: No Data Tree in PAW 2.0.49 with error 500 javax.crypto.BadPaddingException

Post by mawitti »

Hi together,

the firewall is disabled at the moment (for testing).
I've tried to restart redis and also I restarted paw, even the windows server - no success.

My next step will be a new installation of TM1 and PAW.
mawitti
Posts: 11
Joined: Mon Apr 06, 2020 2:08 pm
OLAP Product: TM1 / Planning Analytics
Version: 11.2
Excel Version: Office 365 -V16
Location: Germany

Re: No Data Tree in PAW 2.0.49 with error 500 javax.crypto.BadPaddingException

Post by mawitti »

Now I've tried to reinstall TM1 and Workspace with the same message

Does anyone know how to check the certificates?
a1m80t
Posts: 13
Joined: Mon Mar 09, 2015 11:54 pm
OLAP Product: TM1
Version: 9.1 to 10.2.2
Excel Version: Office 2010

Re: No Data Tree in PAW 2.0.49 with error 500 javax.crypto.BadPaddingException

Post by a1m80t »

If PAW/PA are installed on the same server, then you need to specify the IP4 or IP6 in TM1s.cfg



IPAddressV4="10.109.241.121"
https://www.ibm.com/support/knowledgece ... m1cfg.html

IPAddressV6="0ff1:aa00:4125:2:a05:f7b1:61c2:a341"
https://www.ibm.com/support/knowledgece ... m1cfg.html
dr.nybble
MVP
Posts: 160
Joined: Wed Aug 17, 2011 3:51 pm
OLAP Product: TM1
Version: 10.2.2
Excel Version: Excel 2007

Re: No Data Tree in PAW 2.0.49 with error 500 javax.crypto.BadPaddingException

Post by dr.nybble »

Look in the config/ssl directory. You should see some small key files in there. Make sure they are not empty directories instead (which can happen if Docker has some problems).

Those key files get mounted into wa-proxy and other services who need it. wa-proxy encrypts credentials and stores them in redis, other services fetch and decrypt the credentials to log into TM1 Servers.
mawitti
Posts: 11
Joined: Mon Apr 06, 2020 2:08 pm
OLAP Product: TM1 / Planning Analytics
Version: 11.2
Excel Version: Office 365 -V16
Location: Germany

Re: No Data Tree in PAW 2.0.49 with error 500 javax.crypto.BadPaddingException

Post by mawitti »

In the paw base-folder there are the following files:
cookie_secret.key
credential_store.key
pa-workspace.pem

In the ProgramData\docker\config folder there are only the files:
daemon.json
key.json
dr.nybble
MVP
Posts: 160
Joined: Wed Aug 17, 2011 3:51 pm
OLAP Product: TM1
Version: 10.2.2
Excel Version: Excel 2007

Re: No Data Tree in PAW 2.0.49 with error 500 javax.crypto.BadPaddingException

Post by dr.nybble »

OK and the credential_store.key is actually a file of non-zero size and not a directory?
mawitti
Posts: 11
Joined: Mon Apr 06, 2020 2:08 pm
OLAP Product: TM1 / Planning Analytics
Version: 11.2
Excel Version: Office 365 -V16
Location: Germany

Re: No Data Tree in PAW 2.0.49 with error 500 javax.crypto.BadPaddingException

Post by mawitti »

yes, the file has 512 Bytes
dr.nybble
MVP
Posts: 160
Joined: Wed Aug 17, 2011 3:51 pm
OLAP Product: TM1
Version: 10.2.2
Excel Version: Excel 2007

Re: No Data Tree in PAW 2.0.49 with error 500 javax.crypto.BadPaddingException

Post by dr.nybble »

You'd best contact support. I don't work at IBM any more so my ability to help is now limited!
mawitti
Posts: 11
Joined: Mon Apr 06, 2020 2:08 pm
OLAP Product: TM1 / Planning Analytics
Version: 11.2
Excel Version: Office 365 -V16
Location: Germany

Re: No Data Tree in PAW 2.0.49 with error 500 javax.crypto.BadPaddingException

Post by mawitti »

Now I have made a new Installation on a new Windows with the same settings and it worked fine.
Post Reply