Sasusaku Fanfic High School

Forcing flush the cache server olap with jasper

I need to have the Analysis Server by Jasper View the latest possible because the data in the cube is updated and increased every night.
Given that the "flush olap cache" does not quite work properly, then even in that forum to forge jasper suggest to login and logout, the best workaround I found is the following:
prepend the page " login_welcome.jsp "located in

JASPER_HOME / apache-tomcat / webapps / JasperServer / WEB-INF / jsp

a line of code that forces flushing before each access

\u0026lt;%

(new com.jaspersoft.jasperserver.api.metadata.olap.service.impl.OlapManagementServiceImpl ()). FlushOlapCache ();

%>

In this way there is no longer the need the login / logout explicitly and every time I access my data cubes are slightly out of date.

High Definition Pokemon Images

Temporarily disable the foreign keys in MySQL

If we are working with a pattern of InnoDB tables, we may need to update some tables in a targeted way.
Because referential integrity introduced by the foreign keys, even a simple "delete table" is not feasible. In this case you can resolve the problem by removing temporarily the use of references to foreign keys:

USE `` ilMioDb;

September FOREIGN_KEY_CHECKS = 0;

TRUNCATE `` table_1;

table_2 `DELETE`;

OTHER OPERATIONS ...

September FOREIGN_KEY_CHECKS = 1;