Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 Chunzhi Hong (Chunzhi_Hong)
PEGA
Principal System Architect
Pegasystems Inc.
JP
Chunzhi_Hong Member since 2013 143 posts
PEGA
Posted: Feb 10, 2016
Last activity: Feb 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)

Show More

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?


Show Less
To see attachments, please log in.
Data Integration
Reporting

Posted: 8 years ago
Posted: 10 Feb 2016 3:33 EST
Chunzhi Hong (Chunzhi_Hong)
PEGA
Principal System Architect
Pegasystems Inc.
JP

I run a report on History-Data-Admin-DB-Table class and got two records as below.

2/9/2016 11:00 PM <---- I recovered the record this morning. The time stamp is in GMT.

hongcz

Initial Creation

DATA-ADMIN-DB-TABLE INDEX-DATA-ADMIN-OPERATOR-ID

1/14/2016 1:39 AM

hongcz

Saved this record

DATA-ADMIN-DB-TABLE INDEX-DATA-ADMIN-OPERATOR-ID

I also checked schema change history, and below schema change history shows that the index- class and corresponding data-admin-db-table record must have

been created on the same time when I run the optimizer to expose the column.

PegaDATA

PEGADATA

07.10 coreCode_719_108

Table

pr_index_data_admin_operator_i

CREATE TABLE

NEW CLASS RULE

hongcz

1/6/16 9:03 PM

To see attachments, please log in.

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice