This is on version 11.1.1.3.500
Got the below error while performing the retrieval through SmartView.
"OLAP_error (1042017):Network error: The client or server timed out waiting to receive data using TCP/IP. Check network connections. Increase the NetRetryCount and/or NetDelay values in the essbase.cfg file. Update this file on both client and server. Restart the client and try again".
By seeing this error we have increased NetRetryCount and NetDelay values as below
NetRetryCount 1000
NetDelay 600
Restarted services and performed the retrieval but issue is still not resolved.
When we check logs found that it has generated exception file(log00001.xcp).
From the XCP file and the application log file found that sufficient server threads were not available for the users to connect to the database.
So added the below setting to Essbase.cfg file and restarted Essbase service for the changes to take effect.
SERVERTHREADS 50
After this performed the retrieval and got another error
OLAP_error (1023134): Request grid size is more than allowed limit [10000000]. Increase it using the config setting MAX_REQUEST_GRID_SIZE
Added the below setting to essbase.cfg file and restarted Essbase service for the changes to take effect
MAX_REQUEST_GRID_SIZE <ApplicationName> 100000000
Issue has been resolved after making these changes in Essbase.cfg file.
Got the below error while performing the retrieval through SmartView.
"OLAP_error (1042017):Network error: The client or server timed out waiting to receive data using TCP/IP. Check network connections. Increase the NetRetryCount and/or NetDelay values in the essbase.cfg file. Update this file on both client and server. Restart the client and try again".
By seeing this error we have increased NetRetryCount and NetDelay values as below
NetRetryCount 1000
NetDelay 600
Restarted services and performed the retrieval but issue is still not resolved.
When we check logs found that it has generated exception file(log00001.xcp).
From the XCP file and the application log file found that sufficient server threads were not available for the users to connect to the database.
So added the below setting to Essbase.cfg file and restarted Essbase service for the changes to take effect.
SERVERTHREADS 50
After this performed the retrieval and got another error
OLAP_error (1023134): Request grid size is more than allowed limit [10000000]. Increase it using the config setting MAX_REQUEST_GRID_SIZE
Added the below setting to essbase.cfg file and restarted Essbase service for the changes to take effect
MAX_REQUEST_GRID_SIZE <ApplicationName> 100000000
Issue has been resolved after making these changes in Essbase.cfg file.
No comments:
Post a Comment