Skip to main content

This content has been archived and is no longer being updated. Links may not function; however, this content may be relevant to outdated versions of the product.

Support Article

Function referring a column in report definition is failing

SA-43975

Summary



When creating report definitions, if the column source is filled with a function that refers to a property in Sybase, exceptions are thrown.


Error Messages



java.lang.NullPointerException. Second Java step in activity pzGetFiltersFromContent in ruleset Pega-Reporting:07-10-23 is failing


Steps to Reproduce

  1. Create a Report definition.
  2. Specify one of the Out-of-the-box (OOTB) functions as a column value.
  3. For the parameter value in the function, specify a property in an external Sybase database.



Root Cause


An issue in the custom application code or rules: The use of functions with properties in unsupported databases ( Sybase) for report definitions is not supported.

The OOTB function aliases have been implemented against the APIs of the supported databases (example:Oracle) and will not necessarily work with any other arbitrary database.



Resolution



Refer to PDN article "How to create custom SQL functions for reporting", to create a custom function alias that will work specifically with Sybase.

Suggest Edit

Published September 21, 2017 - Updated October 8, 2020

Did you find this content helpful? Yes No

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.

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

Pega Community 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
Contact us