Microsoft KB Archive/818883

= PRB: You may receive error 7619 when you run a full-text query that contains many OR operators in the search string =

Article ID: 818883

Article Last Modified on 1/12/2004

-

APPLIES TO


 * Microsoft SQL Server 2000 Service Pack 3

-



BUG#: 469483 (SQL Server 8.0)



SYMPTOMS
When you run a full-text query on a computer that is running Microsoft SQL Server 2000 Service Pack 3 (SP3), the query may not be successful if all the following conditions are true:
 * The full-text query contains full-text predicates (such as CONTAINS) or full-text rowset-valued functions (such as CONTAINSTABLE).
 * The search string in the full-text query contains many logical OR operators.

You may receive one of the following error messages:

Server: Msg 7619, Level 16, State 1, Line 1

Execution of a full-text operation failed. The query was too complex to be executed.

Server: Msg 7619, Level 16, State 1, Line 1

Execution of a full-text operation failed. Not enough storage is available to complete this operation.

Server: Msg 7619, Level 16, State 1, Line 4

Execution of a full-text operation failed. The pipe has been ended.



CAUSE
This problem occurs because the availability of stack resources is limited when you use the full-text search engine (Microsoft Search) in SQL Server 2000 SP3.



WORKAROUND
To work around this problem, modify the full-text query to reduce the number of logical OR operators in the search string of the query.



MORE INFORMATION
To help prevent the stack overflow, the stack resources are limited when you use the full-text search engine. This change was first made in SQL Server 2000 SP3.

Each OR operator requires the stack resources and other factors that are involved in the full-text query. Generally, the limit is approximately 325 logical OR operators with any full-text query. However, the limit for a query may be less than 325 logical OR operators because other stack resources are needed to run full-text queries. The following example is a query that may not be successful: SELECT * FROM CONTAINSTABLE (       fts1,         fts2,        'FORMSOF         ( INFLECTIONAL, &quot;SomeText&quot; )       AND         FORMSOF         ( INFLECTIONAL, &quot;OtherText&quot; )        AND         ( &quot;#pcId=158#&quot; OR &quot;#pcId=159#&quot; OR &quot;#pcId=166#&quot; OR &quot;#pcId=183#&quot; OR &quot;#pcId=184#&quot; OR &quot;#pcId=191#&quot; OR &quot;#pcId=205#&quot; OR &quot;#pcId=614#&quot; OR &quot;#pcId=634#&quot; OR &quot;#pcId=647#&quot; OR &quot;#pcId=660#&quot; OR &quot;#pcId=673#&quot; OR &quot;#pcId=677#&quot; OR &quot;#pcId=682#&quot; OR &quot;#pcId=717#&quot; OR &quot;#pcId=723#&quot; OR &quot;#pcId=790#&quot; OR &quot;#pcId=791#&quot; OR &quot;#pcId=811#&quot; OR &quot;#pcId=838#&quot; OR &quot;#pcId=860#&quot; OR &quot;#pcId=892#&quot; OR &quot;#pcId=893#&quot; OR &quot;#pcId=894#&quot; OR &quot;#pcId=895#&quot; OR &quot;#pcId=1054#&quot; OR &quot;#pcId=1055#&quot; OR &quot;#pcId=1068#&quot; OR &quot;#pcId=1103#&quot; OR &quot;#pcId=1118#&quot; OR &quot;#pcId=1122#&quot; OR &quot;#pcId=1123#&quot; OR &quot;#pcId=1124#&quot; OR &quot;#pcId=1125#&quot; OR &quot;#pcId=1126#&quot; OR &quot;#pcId=1127#&quot; OR &quot;#pcId=1128#&quot; OR &quot;#pcId=1129#&quot; OR &quot;#pcId=1130#&quot; OR &quot;#pcId=1159#&quot; OR &quot;#pcId=1160#&quot; OR &quot;#pcId=1172#&quot; OR &quot;#pcId=1173#&quot; OR &quot;#pcId=1188#&quot; OR &quot;#pcId=1202#&quot; OR &quot;#pcId=1204#&quot; OR &quot;#pcId=1206#&quot; OR &quot;#pcId=1207#&quot; OR &quot;#pcId=1208#&quot; OR &quot;#pcId=1209#&quot; OR &quot;#pcId=1210#&quot; OR &quot;#pcId=1211#&quot; OR &quot;#pcId=1212#&quot; OR &quot;#pcId=1213#&quot; OR &quot;#pcId=1214#&quot; OR &quot;#pcId=1215#&quot; OR &quot;#pcId=1216#&quot; OR &quot;#pcId=1217#&quot; OR &quot;#pcId=1274#&quot; OR &quot;#pcId=1275#&quot; OR &quot;#pcId=1276#&quot; OR &quot;#pcId=1277#&quot; OR &quot;#pcId=1367#&quot; OR &quot;#pcId=1368#&quot; OR &quot;#pcId=1369#&quot; OR &quot;#pcId=1371#&quot; OR &quot;#pcId=1372#&quot; OR &quot;#pcId=1373#&quot; OR &quot;#pcId=1374#&quot; OR &quot;#pcId=1375#&quot; OR &quot;#pcId=1376#&quot; OR &quot;#pcId=1443#&quot; OR &quot;#pcId=1505#&quot; OR &quot;#pcId=1899#&quot; OR &quot;#pcId=1900#&quot; OR &quot;#pcId=1932#&quot; OR &quot;#pcId=1998#&quot; OR &quot;#pcId=1999#&quot; OR &quot;#pcId=2011#&quot; OR &quot;#pcId=2012#&quot; OR &quot;#pcId=2013#&quot; OR &quot;#pcId=2014#&quot; OR &quot;#pcId=2098#&quot; OR &quot;#pcId=2099#&quot; OR &quot;#pcId=2101#&quot; OR &quot;#pcId=2102#&quot; OR &quot;#pcId=2103#&quot; OR &quot;#pcId=2104#&quot; OR &quot;#pcId=2105#&quot; OR &quot;#pcId=2106#&quot; OR &quot;#pcId=2107#&quot; OR &quot;#pcId=2108#&quot; OR &quot;#pcId=2220#&quot; OR &quot;#pcId=2221#&quot; OR &quot;#pcId=2231#&quot; OR &quot;#pcId=2237#&quot; OR &quot;#pcId=2238#&quot; OR &quot;#pcId=2241#&quot; OR &quot;#pcId=2243#&quot; OR &quot;#pcId=2244#&quot; OR &quot;#pcId=2245#&quot; OR &quot;#pcId=2247#&quot; OR &quot;#pcId=2248#&quot; OR &quot;#pcId=2249#&quot; OR &quot;#pcId=2250#&quot; OR &quot;#pcId=2251#&quot; OR &quot;#pcId=2252#&quot; OR &quot;#pcId=2253#&quot; OR &quot;#pcId=2254#&quot; OR &quot;#pcId=2255#&quot; OR &quot;#pcId=2260#&quot; OR &quot;#pcId=2261#&quot; OR &quot;#pcId=2263#&quot; OR &quot;#pcId=2264#&quot; OR &quot;#pcId=2265#&quot; OR &quot;#pcId=2266#&quot; OR &quot;#pcId=2267#&quot; OR &quot;#pcId=2268#&quot; OR &quot;#pcId=2270#&quot; OR &quot;#pcId=2271#&quot; OR &quot;#pcId=2272#&quot; OR &quot;#pcId=2273#&quot; OR &quot;#pcId=2274#&quot; OR &quot;#pcId=2275#&quot; OR &quot;#pcId=2276#&quot; OR &quot;#pcId=2277#&quot; OR &quot;#pcId=2278#&quot; OR &quot;#pcId=2279#&quot; OR &quot;#pcId=2280#&quot; OR &quot;#pcId=2281#&quot; OR &quot;#pcId=2282#&quot; OR &quot;#pcId=2283#&quot; OR &quot;#pcId=2558#&quot; OR &quot;#pcId=2560#&quot; OR &quot;#pcId=2561#&quot; OR &quot;#pcId=2571#&quot; OR &quot;#pcId=2577#&quot; OR &quot;#pcId=2578#&quot; OR &quot;#pcId=2579#&quot; OR &quot;#pcId=2580#&quot; OR &quot;#pcId=2582#&quot; OR &quot;#pcId=2585#&quot; OR &quot;#pcId=2587#&quot; OR &quot;#pcId=2588#&quot; OR &quot;#pcId=2590#&quot; OR &quot;#pcId=2591#&quot; OR &quot;#pcId=2592#&quot; OR &quot;#pcId=2593#&quot; OR &quot;#pcId=2594#&quot; OR &quot;#pcId=2595#&quot; OR &quot;#pcId=2596#&quot; OR &quot;#pcId=2597#&quot; OR &quot;#pcId=2598#&quot; OR &quot;#pcId=2599#&quot; OR &quot;#pcId=2603#&quot; OR &quot;#pcId=2604#&quot; OR &quot;#pcId=2605#&quot; OR &quot;#pcId=2607#&quot; OR &quot;#pcId=2608#&quot; OR &quot;#pcId=2609#&quot; OR &quot;#pcId=2610#&quot; OR &quot;#pcId=2612#&quot; OR &quot;#pcId=2614#&quot; OR &quot;#pcId=2616#&quot; OR &quot;#pcId=2618#&quot; OR &quot;#pcId=2619#&quot; OR &quot;#pcId=2620#&quot; OR &quot;#pcId=2621#&quot; OR &quot;#pcId=2623#&quot; OR &quot;#pcId=2624#&quot; OR &quot;#pcId=2626#&quot; OR &quot;#pcId=2628#&quot; OR &quot;#pcId=2629#&quot; OR &quot;#pcId=2630#&quot; OR &quot;#pcId=2631#&quot; OR &quot;#pcId=2737#&quot; OR &quot;#pcId=2741#&quot; OR &quot;#pcId=2827#&quot; OR &quot;#pcId=2856#&quot; OR &quot;#pcId=2858#&quot; OR &quot;#pcId=2861#&quot; OR &quot;#pcId=2862#&quot; OR &quot;#pcId=2863#&quot; OR &quot;#pcId=2864#&quot; OR &quot;#pcId=2865#&quot; OR &quot;#pcId=2964#&quot; OR &quot;#pcId=2965#&quot; OR &quot;#pcId=2966#&quot; OR &quot;#pcId=2967#&quot; OR &quot;#pcId=3296#&quot; OR &quot;#pcId=3297#&quot; OR &quot;#pcId=3298#&quot; OR &quot;#pcId=3299#&quot; OR &quot;#pcId=3300#&quot; OR &quot;#pcId=3301#&quot; OR &quot;#pcId=3302#&quot; OR &quot;#pcId=3303#&quot; OR &quot;#pcId=3304#&quot; OR &quot;#pcId=3305#&quot; OR &quot;#pcId=3306#&quot; OR &quot;#pcId=3307#&quot; OR &quot;#pcId=3308#&quot; OR &quot;#pcId=3309#&quot; OR &quot;#pcId=3311#&quot; OR &quot;#pcId=3312#&quot; OR &quot;#pcId=3313#&quot; OR &quot;#pcId=3314#&quot; OR &quot;#pcId=3315#&quot; OR &quot;#pcId=3316#&quot; OR &quot;#pcId=3317#&quot; OR &quot;#pcId=3318#&quot; OR &quot;#pcId=3319#&quot; OR &quot;#pcId=3320#&quot; OR &quot;#pcId=3321#&quot; OR &quot;#pcId=3322#&quot; OR &quot;#pcId=3323#&quot; OR &quot;#pcId=3324#&quot; OR &quot;#pcId=3325#&quot; OR &quot;#pcId=3326#&quot; OR &quot;#pcId=3327#&quot; OR &quot;#pcId=3328#&quot; OR &quot;#pcId=3329#&quot; OR &quot;#pcId=3330#&quot; OR &quot;#pcId=3331#&quot; OR &quot;#pcId=3332#&quot; OR &quot;#pcId=3333#&quot; OR &quot;#pcId=3334#&quot; OR &quot;#pcId=3335#&quot; OR &quot;#pcId=3336#&quot; OR &quot;#pcId=3337#&quot; OR &quot;#pcId=3338#&quot; OR &quot;#pcId=3339#&quot; OR &quot;#pcId=3340#&quot; OR &quot;#pcId=3341#&quot; OR &quot;#pcId=3345#&quot; OR &quot;#pcId=3346#&quot; OR &quot;#pcId=3347#&quot; OR &quot;#pcId=3348#&quot; OR &quot;#pcId=3349#&quot; OR &quot;#pcId=3350#&quot; OR &quot;#pcId=3351#&quot; OR &quot;#pcId=3352#&quot; OR &quot;#pcId=3353#&quot; OR &quot;#pcId=3354#&quot; OR &quot;#pcId=3355#&quot; OR &quot;#pcId=3356#&quot; OR &quot;#pcId=3357#&quot; OR &quot;#pcId=3358#&quot; OR &quot;#pcId=3359#&quot; OR &quot;#pcId=3360#&quot; OR &quot;#pcId=3472#&quot; OR &quot;#pcId=3473#&quot; OR &quot;#pcId=3474#&quot; OR &quot;#pcId=3475#&quot; OR &quot;#pcId=3557#&quot; OR &quot;#pcId=3558#&quot; OR &quot;#pcId=3559#&quot; OR &quot;#pcId=3560#&quot; OR &quot;#pcId=3561#&quot; OR &quot;#pcId=3562#&quot; OR &quot;#pcId=3565#&quot; OR &quot;#pcId=3566#&quot; OR &quot;#pcId=3567#&quot; OR &quot;#pcId=3568#&quot; OR &quot;#pcId=3586#&quot; OR &quot;#pcId=3591#&quot; OR &quot;#pcId=3597#&quot; OR &quot;#pcId=3638#&quot; OR &quot;#pcId=3639#&quot; OR &quot;#pcId=3640#&quot; OR &quot;#pcId=3641#&quot; OR &quot;#pcId=3715#&quot; OR &quot;#pcId=3734#&quot; OR &quot;#pcId=3735#&quot; OR &quot;#pcId=3884#&quot; OR &quot;#pcId=3891#&quot; OR &quot;#pcId=3960#&quot; OR &quot;#pcId=3961#&quot; OR &quot;#pcId=3962#&quot; OR &quot;#pcId=3963#&quot; OR &quot;#pcId=4001#&quot; OR &quot;#pcId=4002#&quot; OR &quot;#pcId=4003#&quot; OR &quot;#pcId=4004#&quot; OR &quot;#pcId=4058#&quot; OR &quot;#pcId=4059#&quot; OR &quot;#pcId=4112#&quot; OR &quot;#pcId=4113#&quot; OR &quot;#pcId=4114#&quot; OR &quot;#pcId=4115#&quot; OR &quot;#pcId=4117#&quot; OR &quot;#pcId=4118#&quot; OR &quot;#pcId=4119#&quot; OR &quot;#pcId=4120#&quot; OR &quot;#pcId=5023#&quot; )',        1000    ) fts

