jasperserver: Error while creating SQL dialect

[amalizia]

When I click on view menu->analysis view, I've this error:

 

Error Message:

com.jaspersoft.jasperserver.api.JSException: mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while creating SQL dialect

Error Trace:

com.jaspersoft.jasperserver.api.JSException: mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while creating SQL dialect

com.jaspersoft.jasperserver.api.JSException: mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while creating SQL dialect

at com.jaspersoft.jasperserver.war.control.OlapModelController.getOlapSession(OlapModelController.java:248)

at com.jaspersoft.jasperserver.war.control.OlapModelController.viewOlap(OlapModelController.java:142)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

at java.lang.reflect.Method.invoke(Method.java:585)

.....

Caused by: com.mysql.jdbc.exceptions.MySQLNonTransientConnectionException: Server connection failure during transaction. Due to underlying exception: 'java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: YES)...

I understand that I should set a passwor but I don't know where do it.

Can you help me???

[swood]

Have you seen the User Guide? http://jasperforge.org/sf/docman/do/listDocuments/projects.jasperintelligence/docman.root

It walks you through creating via screens:

 

Database Connection

Schema

Mondrian Connection

Analysis View

 

The error below indicates that your schema was probably not OK. There is a Mondrian Technical Guide which talks about the schema.

 

 

 

Sherman

JasperSoft