Support Tip: Search for a location fails with error: "The call to the stored procedure 'constructManyLocations' failed..."

0 Likes

Search for a location fails with error: "The call to the stored procedure 'constructManyLocations' failed inside 'ExecuteStoredProcedure'".

Environment

Content Manager 9.4
Content Manager 10.0
 

Situation

When a user conducts a location search, the location search will fail with an error such as:  

"The call to the stored procedure 'constructManyLocations' failed inside 'ExecuteStoredProcedure'.  The detailed error was 'Content Manager workgroup server on <WorkgroupServerName>' reported an error. You haven't requested all the rows for this disconnected row set, it has more than 100000 rows.'" 
 

Cause

The root cause of the issue in this example the location to be returned includes at least one location which is associated with too many member locations. This makes the disconnected row set larger than the maximum allowed (in this example 100000).

Find resolution and complete support article here


Caroline Oest

Micro Focus Customer Experience Marketing

If you find this post useful, give it a ‘Like’ or use ‘Verify Answer’

Labels:

Knowledge Docs
Comment List
Anonymous
Related Discussions
Recommended