Support Article
CSV output not generated for BIX extract
SA-74132
Summary
CSV output file is not generated for Business Intelligence Exchange (BIX) Extract. However, when using XML instead, the CSV output file is generated.
Error Messages
[PegaRULES-Batch-36] [ ] [your_app:01.01.01] (internal.access.ExtractImpl) ERROR your_user - Unable to process com.pega.pegarules.data.internal.access.ExtractParameters@4411440e: Failed to download data: code: 0 SQLState: 22P02 Message: ERROR: invalid input syntax for type numeric: ""
Position: 192
DatabaseException caused by prior exception: org.postgresql.util.PSQLException: ERROR: invalid input syntax for type numeric: ""
Position: 192
| SQL Code: 0 | SQL State: 22P02
Steps to Reproduce
Unknown
Root Cause
High-throughput mode is used by default in certain circumstances.
In this case, however, the requirements were not met.
For more information, refer to: https://community.pega.com/sites/default/files/help_v74/procomhelpmain.htm#engine/bix/bix-high-throughput-ref.htm
Resolution
- Create the following Dynamic System Setting (DSS) to disable the high-throughput mode.
Ruleset: Pega-Engine
Purpose: prconfig/bix/useHighThroughputDownloadForCSV/default
Value: False
- Restart the application.
Published March 1, 2019 - Updated December 2, 2021
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.