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


The information in this article applies to:

  • Microsoft SQL Server 2000 (all editions) SP3
BUG#: 469483 (SQL Server 8.0)
SQL Server 8.0:469483

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

REFERENCES

For additional information, click the following article number to view the article in the Microsoft Knowledge Base:

317486 FIX: A query that uses a large search string in the CONTAINS clause may fail with error message 7607

Modification Type:MajorLast Reviewed:1/12/2004
Keywords:kberrmsg kbTSQL kbprb KB818883 kbAudDeveloper
©2004 Microsoft Corporation. All rights reserved.