Siebel Issue in Product export: 

Error: Too many records that could be returned (SBL-DAT-00500)

While exporting products from Dev environment, you might get below error in a newly setup environment.

Error details:

The' NextRecord' method of Business Component' Object Rule Nodes ImpExp BC' (Integration Component' Object Rule Nodes ImpExp BC') returned the following error:
"Too many records that could be returned . Refine your query so that fewer rows are retrieved.(SBL-DAT-00500)

Root cause:

The DSMaxFetchArraySize and MaxCursorSize are not sufficient for the number of records to be exported

Solution:

• Navigate to : Site map -> Administration - Server configuration -> Enterprise -> Profile configuration
• In Enterprise Profiles Search for ServerDataSrc in the Alias column.
• In the lower applet (Profile Parameters) click on the "Advanced" tab and search for DSMaxFetchArraySize in the Alias column.
• Change the value to -1 from 0
• Then restart the server.

Hope this helps...⏩