|
|
Member
|
lancetek
-
11/8/2011 4:39:17 PM
Can't export sites that have too many users - v5.5.4248 R2
How can I export a site that has lots of users. This site in particular has about 60,000...
[DataConnection.ExecuteQuery]: Query: SELECT UserName FROM CMS_User WHERE (((((((UserID IN (53, 65, 6479, 6480, 6483, 6484, 6485, 6487, 6489, 6491, 6492, 6493, 6494, 6497, 6500, 6969, 6970, 6971, 6972, 6973, 6974, 6975, 6976, 6977, 6978, 6979, 6980, 6981, 6982, 6983, 6...
the statement is HUGE and lists each user by ID.
..., 62866, 35211, 62884, 62852, 62896, 62881, 62899, 62887, 62856, 62831, 62848, 62885, 62863, 62834, 62861, 30437, 62879, 62833, 62903, 62862, 62930, 62748, 62691, 6555, 62643))) OR (UserID IN (53, 6501))) OR (UserID = 53) : caused exception: Internal error: An expression services limit has been reached. Please look for potentially complex expressions in your query, and try to simplify them.
I'd think that we are hitting some Sql Server limit for the size of a query. Perhaps Kentico could look at simplifying the export statement so it's not so long. Maybe even doing a table join so that you don't have to list out EVERY SINGLE USER in the query? Lance
|
|
|
|
Kentico Support
|
kentico_jurajo
-
11/8/2011 11:44:57 PM
RE:Can't export sites that have too many users - v5.5.4248 R2
Hi,
We are aware of this SQL server limitation and in v6 are the queries split into several smaller queries to avoid this problem. We are sorry for this inconvenience.
Best regards,
Juraj Ondrus
|
|