How does ARC Temporary Tables get created?
When we execute multi parse KPIs, the temp tables automatically get created and dropped in real-time. Sometimes executing such multi parse KPIs may take longer time and business users might terminate in between because of the time taken. At such times, the temp tables might get created and not dropped automatically (since it was terminated in between). If the temp tables get accumulated in WH then, make use of the 'Delete Temp Tables' option that is available under 'Re-cache Changes' via Administrator module to drop the temp tables.
Related Articles
Temporary Tables have accumulated and is not dropping from the DB. Why?
Check for the Query id -'QUERY_FETCH_TEMP_TABLES' in 'warehouse xml' and modify as per the schema For example: If the Warehouse is DB2, modify the below query in 'admin_db2_warehouse.xml' as: QUERY_FETCH_TEMP_TABLES SELECT TABLE_NAME FROM ...
Why do I get "Measure not applicable" error while using newly created measure in the KPI?
There are various reasons for the newly created measure not to be applicable while publishing a KPI. Possible reasons are as follows: Measure is not created/defined properly. The character type is incorrect. If an expression measure is not applicable ...
Why do I get the error 'Measure not applicable', when I use the created expression measure in KPI?
The reasons could be any of the following: Measure ID is not prefixed with Table Name. Expression is not correct. This error can also occur in newly created measures due to the following reasons: Measure is not created/defined properly. The character ...
Which are the data getting migrated when ARC is upgraded?
The list of tables given below are migrated when ARC is upgraded: ADMIN_CHART_COMP, ADMIN_COLDETAILTABLE, ADMIN_DATASET, ADMIN_FILTER_COMBINATION, ADMIN_FILTER_DBCOLUMNSET, ADMIN_FILTER_DEFINITION, ADMIN_FILTER_GROUPS, ADMIN_GROUP_COLUMN, ...
Why is the ARC getting down in between?
The application session may time out with error "java.lang.IllegalStateException: Cannot create a session after the response has been committed" due to the following reasons: > If the KPI takes a very long time to fetch results which are large in ...