Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

Error on dashboard: schema 'RIODS' does not exist

Questions
Tags
Users
Badges
N. VD
(84●27●34) edited
Aug 30 '13, 5:40 a.m.
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 Parameters+ Cannot 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?

0 votes

2 answers
6,065 views
0 votes

Accepted answer

Permanent link
Krzysztof Kaźmierczyk
(7.5k●4●80●103) 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

1 vote

One other answer

Permanent link
N. VD
(84●27●34) Aug 30 '13, 8:30 a.m.
Thanks Krzysztof Kaźmierczyk, for you answer!
Running repotools-ccm -createWarehouse solved the problem.

0 votes

Your answer

Register or log in 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.

Ask a question
Guidelines
FAQ
Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details
× 267

Question asked: Aug 30 '13, 4:56 a.m.

Question was seen: 6,065 times

Last updated: Aug 30 '13, 8:30 a.m.

Confirmation Cancel Confirm