It's all about the answers!

Ask a question

Error on dashboard: schema 'RIODS' does not exist


N. VD (842734) | asked Aug 30 '13, 4:56 a.m.
edited Aug 30 '13, 5:40 a.m. by Krzysztof Kaźmierczyk (7.5k480103)
Since we have upgraded from 4.0.2 to 4.0.3 we're getting this error on all user's dashboards:
We are working with a derby database.

 Show ParametersCannot execute the statement.
    org.eclipse.datatools.connectivity.oda.OdaException: Schema 'RIODS' does not exist

ReportDesign (id = 1):
There are errors evaluating script "totalTeamAreas = row["TOTAL_COLUMN_0"];
"Hidden label bound to Team Areas data set " + totalTeamAreas;":
ReferenceError: "row" is not defined. (<inline>#2)
There are errors evaluating script "totalDefaultCategories = row["TOTAL_COLUMN_1"];
"Hidden label bound to DefaultCategories data set " + totalDefaultCategories;":
ReferenceError: "row" is not defined. (<inline>#2)
There are errors evaluating script "totalCategories = row["TOTAL_COLUMN_2"];
var categories = params["Category"].
...

Any ideas?
																
																
																

Accepted answer


permanent link
Krzysztof Kaźmierczyk (7.5k480103) | answered Aug 30 '13, 5:39 a.m.
Hi N,
Schema RIODS comes from data warehouse.
Have you modified your data warehouse settings already?

What do you see in data warehouse connection jobs status: https://your-server:9443/ccm/admin#action=com.ibm.team.reportsManagement.etlStatus

Try running following command to check if it fixes the issue:
repotools-ccm -createWarehouse
N. VD selected this answer as the correct answer

One other answer



permanent link
N. VD (842734) | answered Aug 30 '13, 8:30 a.m.
Thanks Krzysztof Kaźmierczyk, for you answer!
Running repotools-ccm -createWarehouse solved the problem.

Your answer


Register or to post your answer.


Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.