If DPA cannot create or modify the index, the following error can be found in the error.log file:ĮRROR (T01:58:54,059-0700) PeriodicLogger:190 - Error when getting index writer or index directory for text index and database ID 64.Ĭheck the amount of available space in the location where the Find SQL index files are stored. Resolution: Restart DPA and wait for data summarization to run. The Find SQL index files were moved, but DPA was not restarted afterward. DPA was not restarted after the Find SQL index files were moved For a database instance with historical data, the process runs in 10 minute intervals.
For a newly registered database instance, data summarization runs after at least one hour of data is collected. Resolution: Wait for data summarization to run. Data summarization indexes the SQL statements to make them available for searching. The Find SQL functionality was recently enabled, and data summarization has not run yet. The search criteria violates the Find SQL search rulesĭata summarization has not had time to run.
DPA was not restarted after the Find SQL index files were moved.Data summarization has not had time to run.If no results are returned when you search for a SQL statement, it could be for one of the following reasons: Searches on the Find SQL tab do not return any data
0 kommentar(er)
