Consultor Eletrônico



Kbase P84535: Dyn: Error when generating Client Cache for a large number of entities
Autor   Progress Software Corporation - Progress
Acesso   Público
Publicação   6/16/2004
Status: Unverified

FACT(s) (Environment):

Dynamics 2.1A

SYMPTOM(s):

Generating Client Cache for a large number of entities

** More than <value> characters in a single statement--use -inp parm. (135)

Progress session crashes

** More than <value> items in a single statement. Use the -tok parameter. (136)
Could not tokenize PREPARE string FOR EACH ttEntity WHERE ttEntity.EntityName = "<SelectedTable1>" OR ttEntity.EntityName = "<SelectedTable2>" OR ttEntity.EntityName = "<SelectedTable3>" OR ttEntity.EntityName = "<SelectedTable4>" ... OR ttEntity.EntityName = "<SelectedTable[n]>"

4GL stack trace:
USER-INTERFACE-TRIGGER ry/obj/ryclcrunv.w (d:\dyn21a\gui\icf\ry\obj\ryclcrunv.r) at line 3343
generateCache ry/obj/ryclcrunv.w (d:\dyn21a\gui\icf\ry\obj\ryclcrunv.r) at line 3559
--> saveEntitiesToClientCache d:\dyn21a\gui\icf\ry\app\ryrepsrvrp.r (d:\dyn21a\gui\icf\ry\app\ryrepsrvrp.r) at line 25114

Dynamics 2.1A02

CAUSE:

Known issue when Generating Client Cache for a large number of entities (between 100 and 600). Development aware.
You get one of the above error or crash depending on the values you have for startup parameters -tok and -inp. (crash with High values)

FIX:

Generate the client cache in batches of about 100 entities rather than all at once.