Troubleshooting
Problem
How do I resolve the error "Generated code is too large, please set the value of system.maxBcastMsgKB to 4096 in system.cfg"
Symptom
When adding more columns to a query, I receive the following error message:
- Error: ERROR: 0 : Generated code is too large, please set the value of system.maxBcastMsgKB to 4096 in system.cfg. (State:HY000, Native Code: 2D)
Resolving The Problem
To set the value of system.maxBcastMsgKB to 4096, you need to edit the system.cfg file and restart NPS. The steps are as follows:
1. Open the system configuration file using the vi editor:
- vi /nz/data/config/system.cfg
2. Add the following line to the end of the file:
- system.maxBcastMsgKB = 4096
3. Save the file and exit the vi editor.
4. Stop the NPS system using the following command:
- nzstop
5. Restart the NPS system using the following command:
- nzstart
To confirm that the setting is in effect, you can run the following command:
- nzsystem showRegistry | grep BcastMsg
The following output should appear:
- system.maxBcastMsgKB = 4096
[{"Product":{"code":"SSULQD","label":"IBM PureData System"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":null,"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"1.0.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Historical Number
NZ783573
Was this topic helpful?
Document Information
Modified date:
17 October 2019
UID
swg21571076