Question

2
Replies
184
Views
Chunzhi Hong (Chunzhi_Hong)
PEGA
Consulting Manager
Pegasystems Inc.
JP
Chunzhi_Hong Member since 2013 141 posts
PEGA
Posted: February 10, 2016
Last activity: February 10, 2016
Posted: 10 Feb 2016 0:17 EST
Last activity: 10 Feb 2016 3:33 EST
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)

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, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.