Question
WellCare
US
Last activity: 28 Dec 2015 16:07 EST
How do we query the PRPC DB for hotfixes not installed by the Hotfix Manager?
I am trying to find out if there are any hotfixes that were installed in the system which were not installed by the Hotfix Manager.
Accepted Solution
Pegasystems Inc.
GB
Hi,
I would suggest examining instances of the Log-PegaRULESMove class in the system.
as per the Help documentation, "Log-PegaRULESMove concrete class contains one instance for each execution of the Import Archive and Export Archive tools. Properties in each instance identify the date and time the execution started, which user ran the tool, a record count, and the name of the ZIP file used. "
From this you should be able to identify any archive that has been imported to the system (including hot fixes not added via Update Manager) using the Import (or Export) facility.
Gareth
Pegasystems Inc.
US
Not sure this is possible, why are you doing this? To identify framework related hotfixes (normally installed by import directly)? Eventually we are going to make all hotfixes unified, including frameworks, but we are not there yet.
Pegasystems Inc.
IN
Hi,
Irrespective of whether it is a DL item or HFIX jar containing rule changes , it should ideally be stored in the ServiceExport directory on the server.
So that should be one quick way to check whether you have uploaded the framework HFIX es into system.
Also, you can try importing the HFIX again by checking " Enable advanced mode to provide more granular control over the import process" so that at runtime you can see the name of the rules which system wants to import to system.
At this point, if you see a message which says " Instances already loaded " then you can assume that the particular HFIX is already loaded.
WellCare
US
Hi Santanu,
The temp directory had been cleaned already so I could not find the jars there; that is why I was asking if there is a way to query the DB for certain tables that might contain such info.
JPMC
IN
The other way would be to use export wizrd, there you you see the list of hotfixes not installed by Hotfix manager
See the list of products for the select export mode as product, say for example:
JPMC
IN
Hi Fabian,
Its interesting that it did not work for you.
May i know the hotfix number which you just installed through import and it is not shwoing in the product list in export wizard.
Usually all PRPC hotfixes will be installed through the hotfix manager and the frameworks hotfix will be imported directly which are usually just products, so should appear in this list.
Regards,
Ashish
Pegasystems Inc.
IN
Hi Diaz, Good Morning!
could you please try querying 'pr_data_products' for Hfix-es & 'pr_engineclasses' for external jar imports.
Please share your observations/comments, Thank you!
psahukaru
WellCare
US
Hi Phani,
I tried querying prd_data_products for hotfixes and it only shows the ones that where done thru the hotfix manager and for the pr_engineclasses yes I am able to see which external jars were imported.
Thank you,
Accepted Solution
Pegasystems Inc.
GB
Hi,
I would suggest examining instances of the Log-PegaRULESMove class in the system.
as per the Help documentation, "Log-PegaRULESMove concrete class contains one instance for each execution of the Import Archive and Export Archive tools. Properties in each instance identify the date and time the execution started, which user ran the tool, a record count, and the name of the ZIP file used. "
From this you should be able to identify any archive that has been imported to the system (including hot fixes not added via Update Manager) using the Import (or Export) facility.
Gareth