nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

java.lang.nullpointer exception

kvram25

Hi,
 
I am trying to build a Dashboard using Report Designer Pro.
<ol><li>Created a Shared Resources Data Objects called Cost_datadesign.datadesign</li>
<li>Generated Data Object by right clicking "Generate Data Object" menu on Data object design.</li>
<li>The generated Data object Cost_datadesign.data is also visible under Shared Resources Tab</li>
<li>Now then I created a New Dashboard which opened in a new browser window.</li>
<li>In the Dashboard browser menu I select "Manage Data" icon and select the newly created Data Object as mentioned in step-4</li>
<li>Now I get "java.lang.Nullpointer" exception error.</li>
<li>Not able to proceed further.</li>
</ol> 
Is there something wrong in my procedure? Please advise.
 
Ram

Find more posts tagged with

Comments

pricher

Hi,
 
Can you post the generated data object (.data file)?
 
Regards,
 
P.

serenahe

Hi Ram,
 
Could you please try to use the same data source and data set as you have in datadesign report to create a rptdesign report? First to check if you can run the report correctly, and then create a dashboard by using the report to see if you can run into the same error other than using data object?
 
Thanks,
Serena

kvram25

Hi Serena, 
 
If I create a report and use the same in my dashboard it shows OK. The problem comes if I use the Data object directly in the Dashboard. 
 
Mr P. 
I am getting "Error you aren't permitted to upload this kind of file" when I try to upload .data file or .datadesign file. Please advise. I have attache the source Excel file

pricher

Hi,
 
Try to zip the file before uploading it.

kvram25

Hi,
 
Please see the .data file zipped version.

pricher

Hi,
 
Have you tried running the dashboard from the datadesign file? I suspect the data file you have created is corrupted. Can you post the datadesign file too?
 
P.

kvram25

Hi Sending both .data and .datadesign files again
 
Regards,
Ram

pricher

Hi,
 
I found the problem. Your Excel source file has a column labeled "Cost/Eqvbus". This creates a column name called "Cost/Eqvbus" in your Data Set, but unfortunately, the slash ("/") in the column name creates the exception. Simplest workaround is to rename the column label in your Excel file and remove the slash. If you cannot rename in the Excel file, you can rename the column in the Data Set by editing the Data Set, going to Select Columns,and changing the name of the column with the slash.
 
I am resending you a modified version of your data design that works now with the original Excel file.
 
Hope this helps,
 
P.

kvram25

Thanks I will try and revert.
Meanwhile I would like to ask if a Data Design / Data Set can be shared accross multiple Dashboards and reports?
If so then how?
 
Thanks
Ram

kvram25

Hi,
 
Your solution worked after removing "/" from column name.
however I have landed in a new problem. If I add a data row in the source excel sheet this does not update in the Dashboard Bar chart.
I tried refreshing and reloading the page in browser but I only see a static bar chart of the rows that I added initially in Excel sheet.
 
please advise.
 
ram

pricher

Hi,
 
To refresh the data in the dashboard, you need to go to Data --> Manage Data, choose the data object from the list on the right side, and click the little icon in the upper right corner (the two arrows going in circle..) This will force an update of the data.
 
Hope this helps,
 
P.

kvram25

But then there is a menu under EDIT which has a set of radio buttons for Refresh Intervals? What is that for?
Am I to refresh manually?
Is auto refresh not an option?
 
Regards,
Ram

pricher

Hi,
 
I have answered your question in your latest post: you need to set the auto-refresh at the tab level, not the gadget level.
 
Regards,
 
P.

kvram25

Hello,
 
I have set up the Tab refresh option as told by you.
Please see the screenshot.
As you can see September Data does not show up.
 
Regards,
Ram

pricher

Hi,
 
I have tested it again here and it works fine. Make sure of a few things:
 
1. In your data source, make an absolute reference to your Excel file, i.e. point to the file located on the file system, not your project. This will ensure that changes made to your Excel file will be picked up automatically by iHub. Of course, the file location will have to be the same for BD Pro and iHub.
2. Make sure you are using the .datadesign when you create your dashboard, not the .data.
 
Hope this helps,
 
P.

kvram25

Thanks.
 
I had used .data instead of .datadesign as the source of the Chart, hence the problem.
Now it is working fine
 
Ram