Executing the ODI OdiPurgeLog Tool Results In NullPointerException (Doc ID 2056355.1)

Last updated on FEBRUARY 22, 2017

Applies to:

Oracle Data Integrator - Version 11.1.1.9.0 and later
Information in this document applies to any platform.

Symptoms

The execution of the Oracle Data Integrator (ODI) OdiPurgeLog command with any set of parameters:

OdiPurgeLog "-PURGE_TYPE=ALL" "-TODATE=...9" "-PURGE_REPORTS=YES" ...

... returns the following error message:

oracle.odi.core.exception.OdiRuntimeException: java.lang.NullPointerException
 The issue is reproducible on both ODI 11g and ODI 12c

In ODI 12.1.3.0.0, the error is:

oracle.odi.core.exception.OdiRuntimeException: java.lang.NullPointerException
  at ...
Caused by: java.lang.NullPointerException
  at com.sunopsis.security.DwgApplicationSecurityHelper.isMethodExist(DwgApplicationSecurityHelper.java:248)
  at com.sunopsis.security.DwgApplicationSecurityHelper.isMethodExist(DwgApplicationSecurityHelper.java:229)
  at com.sunopsis.security.DwgApplicationSecurityHelper.isAuthorized(DwgApplicationSecurityHelper.java:65)
  at com.sunopsis.dwg.dbobj.SnpSession.isPurgeAuthorized(SnpSession.java:467)
  at com.sunopsis.dwg.dbobj.SnpSession.checkPurgeScenReportAuthorized(SnpSession.java:552)
  at com.sunopsis.dwg.dbobj.SnpSession.purgeScenReport(SnpSession.java:1143)
  at com.sunopsis.dwg.dbobj.SnpSession.purgeLog(SnpSession.java:829)
  at com.sunopsis.dwg.dbobj.SnpSession$1.doAction(SnpSession.java:608)
  ... 31 more

In ODI 11.1.1.9.0, the error is:

Caused By: oracle.odi.core.exception.OdiRuntimeException: java.lang.NullPointerException
  at ...
Caused by: java.lang.NullPointerException
  at com.sunopsis.security.DwgApplicationSecurityHelper.isMethodExist(DwgApplicationSecurityHelper.java:235)
  at com.sunopsis.security.DwgApplicationSecurityHelper.isAuthorized(DwgApplicationSecurityHelper.java:65)
  at com.sunopsis.dwg.dbobj.SnpSession.isPurgeAuthorized(SnpSession.java:536)
  at com.sunopsis.dwg.dbobj.SnpSession.checkPurgeScenReportAuthorized(SnpSession.java:572)
  at com.sunopsis.dwg.dbobj.SnpSession.purgeScenReport(SnpSession.java:1018)
  at com.sunopsis.dwg.dbobj.SnpSession.purgeSessionsAttachedToLoadPlan(SnpSession.java:881)
  at com.sunopsis.dwg.dbobj.SnpLoadPlan.purgeAttachedSessions(SnpLoadPlan.java:1174)
  at com.sunopsis.dwg.dbobj.SnpLoadPlan.deleteLPRLogs(SnpLoadPlan.java:1022)
  at com.sunopsis.dwg.dbobj.SnpLoadPlan.purgeLoadPlanLogs(SnpLoadPlan.java:859)
  at com.sunopsis.dwg.dbobj.SnpLoadPlan.access$0(SnpLoadPlan.java:676)
  at com.sunopsis.dwg.dbobj.SnpLoadPlan$2.doAction(SnpLoadPlan.java:637)
  ... 24 more

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms