Dashboard and Analytics Setup

[Former Member]

I need help in how to resetup the repository. When I created the repository the first time I got errors. I now all I see is errors.

Can you delete the Repository and redo the setup.

[Former Member · Accepted solution]

This what I need to know how to do. When I select the datasource for the repository, I do not get the button to create any longer. I just get the Red icon with the upgrade message.

[arvin_chiu · Accepted solution]

It has to be done on the database side.

[Former Member · Accepted solution]

Can you tell me what needs to be done? Do all the table/indexes/views that were created need to be deleted? Or which table hold the information regarding the repository?

Thanks

[arvin_chiu · Accepted solution]

Anything with the prefix ci, ipm or set would have to be deleted. If the database was blank prior to you setting up the system tables, I'd recommend just asking your DB admin to clear it completely.

[Former Member · Accepted solution]

Thanks you very much.

[Former Member]

I get the upgrade message but I did not a previous versions.

Something happen when I created the first repsoitory. The script failed and some of the table did not get created. But now I can not rerun the scripts to create the repository on the database.

Thanks

[arvin_chiu]

I see. Well, if the script didn't run properly the tables are probably created in error. I'd say just wipe it anyway and re-run the system table creation.

[Former Member]

I do not have any setup yet. I just need to delete it and reset it up.

The error is asking to upgrade. But this is 3.0

[arvin_chiu]

When you first specify a database as your PM repo, you will need to create system tables. What you should be seeing at that point is a blue exclamation point icon with a message that says "create system tables"

If you are connecting a PM repo that was in use for an R2 installation, you will get a similar message that asks for you to migrate the repository. This is normal and should be done.

[arvin_chiu]

What kind of errors are you seeing? If you delete the repository, you will lose any metrics, goals, rules that you have created in it.