RIDW schema exists in DW.
I have been trying to get the RRDI20RC5 installed on a machine but have a few questions on the DW to be used in the 'Configure Data Warehouse' step in the Rational Reporting setup.
I have created an existing Datawarehouse, and am trying to point to that one but am getting:
"CRRRD4780E: The schema RIDW is not empty. No objects can exist under this schema. Drop all objects before continuing. Error Code: 4780'."
Any idea what may be causing this issue.
Much Thanks.
I have created an existing Datawarehouse, and am trying to point to that one but am getting:
"CRRRD4780E: The schema RIDW is not empty. No objects can exist under this schema. Drop all objects before continuing. Error Code: 4780'."
Any idea what may be causing this issue.
Much Thanks.
2 answers
Hi, Michael,
Which type of DBMS are you using?
Please checking your database is there RIDW schema existed in your database.
You said you have created an existing DW, when and how did you create it? Using any CLM build to create the DW or previous RRDI 2.0 build to create it? You saw this error when you were trying to point the data warehouse to your existing DW on RRDI20RC5, right?
As far as I known, RRDI does not support milestone to milestone DW schema migration, so you would have to drop the schemas and recreate them in RRDI again.
But I think you would get a more precise answer from RRDI developers when you add the tag to "rational-insight" or post the question at https://jazz.net/forum/tags/rational-insight/.
Which type of DBMS are you using?
Please checking your database is there RIDW schema existed in your database.
You said you have created an existing DW, when and how did you create it? Using any CLM build to create the DW or previous RRDI 2.0 build to create it? You saw this error when you were trying to point the data warehouse to your existing DW on RRDI20RC5, right?
As far as I known, RRDI does not support milestone to milestone DW schema migration, so you would have to drop the schemas and recreate them in RRDI again.
But I think you would get a more precise answer from RRDI developers when you add the tag to "rational-insight" or post the question at https://jazz.net/forum/tags/rational-insight/.