Question

2
Replies
182
Views
Close popover
Chunzhi Hong (Chunzhi_Hong)
PEGA
Consulting Manager, Pega Consulting
Pegasystems Inc.
JP
Chunzhi_Hong Member since 2013 138 posts
PEGA
Posted: February 10, 2016
Last activity: February 10, 2016
Closed

7.1.9 the database table record for Index- class gone

I got null pointer exception below as I run pyMyCasesReport this morning, however the report used to work fine.

An error occured during resolving the report definition - null

java.lang.NullPointerException

  at com.pega.pegarules.data.external.rd.constants.ColumnType.enumOf(ColumnType.java:88)

  at com.pega.pegarules.data.internal.rd.reference.GenericPropertyReferenceResolver.resolve(GenericPropertyReferenceResolver.java:197)

  at com.pega.pegarules.data.internal.rd.resolve.AbstractFieldResolver.resolveField(AbstractFieldResolver.java:79)

  at com.pega.pegarules.data.internal.rd.resolve.AbstractFieldResolver.resolveFields(AbstractFieldResolver.java:60)

  at com.pega.pegarules.data.internal.rd.resolve.AbstractFieldResolver.resolveFields(AbstractFieldResolver.java:53)

  at com.pega.pegarules.data.internal.rd.resolve.ListResolver.resolve(ListResolver.java:54)

  at com.pega.pegarules.data.internal.rd.resolve.SqlReportResolver.resolve(SqlReportResolver.java:82)

  at com.pega.pegarules.data.internal.rd.resolve.SqlReportResolver.resolve(SqlReportResolver.java:36)

  at com.pega.pegarules.data.internal.rd.SqlReportExecutor.resolve(SqlReportExecutor.java:208)

  at com.pega.pegarules.data.internal.rd.SqlReportExecutor.executeMainReport(SqlReportExecutor.java:111)

  at com.pega.pegarules.data.internal.rd.SqlReportExecutor.execute(SqlReportExecutor.java:90)

  at com.pega.pegarules.data.internal.rd.SqlReportExecutor.execute(SqlReportExecutor.java:57)

  at com.pega.pegarules.data.internal.PRDataProviderImpl.executeReport(PRDataProviderImpl.java:1229)

  at com.pega.pegarules.session.internal.mgmt.Executable.executeReport(Executable.java:10829)

  at com.pegarules.generated.definition.ra_action_pymycasesreport_cc6e50b7e2e3310c8dea9ae0b0f57fa5.perform(ra_action_pymycasesreport_cc6e50b7e2e3310c8dea9ae0b0f57fa5.java:50)

  at com.pega.pegarules.session.internal.mgmt.Executable.doAction(Executable.java:3310)

For investigation purpose,I private checked out the report definition and clicked "Save" without any modification, then I got below error messages.

It seems one of the exposed column called "UserIDForExpose" has lost its column mapping.

pyMyCasesReport-Runtime-Error-Message.JPG

So, I checked the table mapping of the declare index class being used in the report definition, and found the database table record for the Index- class has gone!

I am sure there is no one consciously deleted this database table record then,

What operation might delete database table record accidently?

Data Integration Reporting
Moderation Team has archived post