We are proceeding by step and the first one concerns migration from 9.12 to 9.20. We copied production instance with a license of fixed number of users. Then we asked HP a new license for development purpose for the new machine (OS and IP address changed).
We encountered problems with the new license provided by support because PPM doesn’t start regularly because of licensing problems.
This is the error that appears:
ERROR server:main:com.kintana.core.server:2015/05/20-16:51:56.963 CEST: License usage exceeded. Your maximum of 0 license(s) for Portfolio Management have already been allocated. There are 4 users in your system with this license. (KNTA-10043)
Then we asked HP a new license containing also this 4 portfolio users but they told us that we’re not entitled which in my opinion doesn’t make sense because we bought 4 portfolio users license.
Is this the correct way to proceed to perform the upgrade or is there a workaround to avoid license problem when performing upgrade in a test/dev environment?
We’ve already tried to set server mode on RESTRICTED (./setServerMode.sh RESTRICTED) without any success.
Hello, I run the query suggested by Utkarsh_Mishra, but I didn't run it on all users except admin, I just run it on a small number of users, enough to be compliant with the number of users contained into licence file.
When I started PPM I got the same licence error I got before running the query, as if the disabled users were stil enabled and consuming licences.
When I was doing some testing upgrading from 9.14 to 9.31 I ran into the same issue but in my case is was with Time Management Licenses, I did something simmilar to what was suggested but I removed the users from the Product table instead.. here are the queries I used for that.
I left the notes I had in there for reference
/* Disabling Users that have Time Management License (5) First Query gets the License ID Second Query gets the Users with (in this case) TM Licenses Third Query Deletes the user from knta_user_products effectively removing the licenses from their profile My DB is set to NOT autocommit so if yours is set the same way make sure to commit after this is done */
select Product_key as product_id, Product_name from KNTA_PRODUCTS_NLS;
select ku.user_id, ku.full_name, ku.username from knta_user_products kup, knta_users ku where 1 = 1 and kup.Product_id = 5 --CHANGE AS NEEDED and kup.user_id = ku.user_id and ku.end_date is null;
delete from knta_user_products where user_id IN('30213', --4 users with Time Management Licenses '30214', '30216', '101788') And product_id = 5;