Problem Note 64322: You encounter a null pointer exception when migrating from SAS® Infrastructure for Risk Management 3.4 to 3.6
 |  |  |  |  |
When migrating from SAS Infrastructure for Risk Management 3.4 to 3.6, you can encounter migration errors for overridden task inputs that are similar to the following:
ERROR (localhost-startStop-2)
[org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/SASIRMServer]] Servlet [ComputationServer] in web application [/SASIRMServer] threw load() exception java.lang.NullPointerException
at
com.sas.solutions.risk.irm.server.migration.MigrationService.migrateDataOverrideVersions(MigrationService.java:604)
at
com.sas.solutions.risk.irm.server.migration.MigrationService.start(MigrationService.java:90)
at
com.sas.solutions.risk.irm.server.engine.ComputationServerEngine.start(ComputationServerEngine.java:212)
[org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/SASIRMServer]] Servlet [ComputationServer] in web application [/SASIRMServer] threw load() exception java.lang.NullPointerException
at
com.sas.solutions.risk.irm.server.migration.MigrationService.migrateDataOverrideVersions(MigrationService.java:604)
at
com.sas.solutions.risk.irm.server.migration.MigrationService.start(MigrationService.java:90)
at
com.sas.solutions.risk.irm.server.engine.ComputationServerEngine.start(ComputationServerEngine.java:212)
When this issue occurs, the failure in the migration service causes subsequent services to not start. In this scenario, FA Import, Live ETL, and the Scripting Client do not work.
As a workaround, use the following code to update the IRM Postgres database:
update data_obj_ovrd
set data_obj_ovrd_ver = 1
where data_obj_ovrd_ver = 0
set data_obj_ovrd_ver = 1
where data_obj_ovrd_ver = 0
After you run this code, restart SASServer8.
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Infrastructure for Risk Management | Microsoft® Windows® for x64 | 3.6 | 9.4 TS1M6 | ||
| Linux for x64 | 3.6 | 9.4 TS1M6 | ||||
A fix for this issue for SAS Infrastructure for Risk Management 3.6 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/G2T.html#64322
When you upgrade from SAS Infrastructure for Risk Management 3.4 to 3.6, migration errors for overridden task inputs occur.
| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2019-12-12 15:05:36 |
| Date Created: | 2019-06-12 16:19:18 |