szymic1 Posted August 18, 2009 Share Posted August 18, 2009 Hi,When I try to see my analysis raport I've gotAn error occurred while getting property "result" from an instance of class com.tonbeller.jpivot.tags.OlapModelProxyIWe are using Postgres 8.3 and I've creaed datasource for my view and it works (it works without problem with Reports)in my database I have two tables public.crm_document (it is fact table) and public.fee_codeand I've define my schema as follow:<Schema name="UproszczonaKosta"> <Cube name="UproszczonaKostkaNaliczenia" caption="Kostka" cache="true" enabled="true"> <Table name="crm_document" schema="public"> </Table> <Dimension type="StandardDimension" foreignKey="id_fee_code" name="RodzajUslugi"> <Hierarchy name="WszystkieUslugi" hasAll="true" allMemberName="WszystkeUslugi" primaryKey="fee_code_id"> <Table name="fee_code" schema="public"> </Table> <Level name="fee_code" column="description" nameColumn="description" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never"> </Level> </Hierarchy> </Dimension> <Measure name="Kwota" column="amount" datatype="Numeric" aggregator="sum" visible="true"> </Measure> </Cube></Schema> In Schema Workbech following MDX query:SELECT[Measures].AllMembers ON COLUMNS,Hierarchize([RodzajUslugi.WszystkieUslugi].[WszystkeUslugi].Children) ON ROWSFROM [uproszczonaKostkaNaliczenia]it works without problem eg:| | Kwota |+-------------------------------------------------+-----------+| Obciążenie manualne konta | 1,000.94 |.......................... but when I try to view created 'Analysis View' I always get An error occurred while getting property "result" from an instance of class com.tonbeller.jpivot.tags.OlapModelProxy P.S We replace old Postgre JDBC driver in Jasper directories (to be honest I've replaced in several places because I do not know where is proper location of JDBC driver) Michal Szymanskihttp://blog.szymanskich.net Link to comment Share on other sites More sharing options...
swood Posted August 19, 2009 Share Posted August 19, 2009 What version of JasperServer are you running? Could you try restarting the server and then the analysis view? ShermanJaspersoft Link to comment Share on other sites More sharing options...
szymic1 Posted August 19, 2009 Author Share Posted August 19, 2009 >What version of JasperServer are you running? 3.5, after when I've described problem here I've discovered that someone else describde problem here http://jasperforge.org/plugins/espforum/view.php?group_id=112&forumid=102&topicid=61358 As I've written it works in 3.1 :( > Could you try restarting the server and then the analysis view? Yes I've restarted server several times. Today I will report issue to Jaspersoft Mantis with log files and detail description of problem. Regards Michal Szymanski http://blog.szymanskich.net Link to comment Share on other sites More sharing options...
szymic1 Posted August 19, 2009 Author Share Posted August 19, 2009 swoodWrote: What version of JasperServer are you running? Could you try restarting the server and then the analysis view? Sherman Jaspersoft Today I've submited error to tracker http://jasperforge.org/projects/jasperserver/tracker/view.php?id=4247 and asigned to youMichal Szymanskihttp://blog.szymanskich.net Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now