You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Optimise Aggregation Job Erroring

Received Response
41
Views
8
Comments

Hi All

I run the job twice with 5 min separating

1) To enable query tracking

2) Execute Agg Process with parameters

  • Based on query data ? Y
  • Include Rollup Option ? Y
  • Enable alternate rollups ? N
  • Include Growth Size Option ? Y Stop when Size exceeds 1.01


First job runs fine but 2nd job fails with

'Failed to select any new views or all views that you requested to build exist already'

Should I increase the time before the second job runs, perhaps the query tracking is not completing ? Are the parameters correct for the 2nd job ?

tks R

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!