Jump to content
We've recently updated our Privacy Statement, available here ×

An error occurred while getting property "result"


szymic1

Recommended Posts

Hi,

When I try to see my  analysis raport I've got

An error occurred while getting property "result" from an instance of class com.tonbeller.jpivot.tags.OlapModelProxy

IWe 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_code

and 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 ROWS
FROM [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 Szymanski

http://blog.szymanskich.net

Link to comment
Share on other sites

  • Replies 3
  • Created
  • Last Reply

Top Posters In This Topic

Top Posters In This Topic

>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

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 account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...