No Data Tree in PAW 2.0.49 with error 500 javax.crypto.BadPaddingException
-
- 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
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?
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.
-
- 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
Hi,
is it a fresh installation on this machine?
Try to clear your cookies and browser cache.
BR
is it a fresh installation on this machine?
Try to clear your cookies and browser cache.
BR
-
- 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
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.
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.
-
- 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
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?
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?
-
- 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
here is the message that I am getting.
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 .
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 .
-
- 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
I would narrow down the focus to security and Certificates. I wish I could be more specific!
Maren
Maren
-
- 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
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.
-
- 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
did you add a firewall exception for configured HTTPPortNumber, if you have a fw active?
-
- 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
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.
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.
-
- 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
Now I've tried to reinstall TM1 and Workspace with the same message
Does anyone know how to check the certificates?
Does anyone know how to check the certificates?
-
- 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
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
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
-
- 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
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.
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.
-
- 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
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
cookie_secret.key
credential_store.key
pa-workspace.pem
In the ProgramData\docker\config folder there are only the files:
daemon.json
key.json
-
- 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
OK and the credential_store.key is actually a file of non-zero size and not a directory?
-
- 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
yes, the file has 512 Bytes
-
- 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
You'd best contact support. I don't work at IBM any more so my ability to help is now limited!
-
- 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
Now I have made a new Installation on a new Windows with the same settings and it worked fine.