Question

2
Replies
179
Views
Chunzhi_Hong Member since 2013 137 posts
PEGA
Posted: 4 years ago
Last activity: 4 years 8 months ago
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
Share this page LinkedIn