Project and Portfolio Management Practitioners Forum
cancel

Invalid data objects post upgrade

SOLVED
Go to solution
Highlighted
Harika Appa
Trusted Contributor.

Invalid data objects post upgrade

Hello,

I have successfully completed upgrade to 8.00 version and am able to access with out any issues.

But during the end of upgrade I have recivedan message which says as below:


The following database objects are invalid. This is likely the result of data
model changes made during the upgrade. Please reconcile these items before you
start the PPM Server, particularly if they are core PPM Center objects.



- UPGRADE_RENAME_TABLE
- ASML_PROPOSALS_AND_PROJECTS_V
- ASML_PROPOSALS_AND_PROJECTS_B4
- ASML_PROPOSALS_AND_PROJECTS_B1
- ASML_PROPOSALS_AND_PROJECTS_B2
- ASML_ANALYTICAL_REPORT_DS_V
- ASML_RFF_BASE_V
- EMP
- KTMG_STATUS_TRANSACTIONS_TH
- ASML_TIME_SHEET_LINE_APPROVE
- ASML_AUTOSTAFF
- ASML_STAFFING_UTILS
- ASML_ANALYTICAL_REPORT_DS_B
- ASML_RFF_PROJ_TOTAL_FINANC_V
- ASML_PRJ_BUDGET_LINES_DS_V
- ASML_RFF_BASE_B
- ASML_LIVE_PROJ_TOTAL_FINANC_V
- ASML_RFF_PROJECTS_FINANC_DS_V
- ASML_PRJ_SPRG_PERCENTAGES_V

Press ENTER to read the text [Type q to quit]

- ASML_RFF_BUDGET_LINES_EAC_V
- ASML_PRJ_BUDGET_SPONSOR_DS_V
- ASML_CAPEX_OPEX_CLUSTER_DS_V
- ASML_RFF_MATCHING_REQUESTS_V
- ASML_CAPEX_OPEX_FUNDING_DS_V
- ASML_ROADMAP_REPORT_V
- ASML_BUDGET_ETC_ACTUALS_V
- ASML_BUDG_PLAN_ACT_VAL_TYPE_V
- ASML_RFF_PROJ_DEF_FINANC_DS_V
- ASML_LIVE_PROJECTS_FINANC_DS_V
- ASML_LIVE_PROJ_DEF_FINANC_DS_V
- ASML_RES_COMMITMENT_TMEMB_V
- ASML_PRJ_SPRG_RTS_TOTALS_V
- ASML_RFF_SCENARIO_CONTENTS_V
- ASML_SVP_SPONSORS_V
- ASML_GENERIC_PROJECT_LIST_DS_V
- ASML_REQ_BUDGET_LINES_EAC_V
- ASML_PROJECT_STAKEHOLDERS_DS_V
- ASML_PROJ_REALIZATION_START_V
- ASML_CAPEX_OPEX_PORTLET_V

Press ENTER to read the text [Type q to quit]

- ASML_BUDG_PLAN_ACTUALS_V
- ASML_RFF_BUDGET_PERIOD_V
- ASML_PROJECTS_AND_PROPOSALS_V
- ASML_PROJECT_LIST_DS_V
- ASML_PRJ_REAL_SPRG_RATIOS_V
- ASML_RESOURCE_REQUESTS_DS_V
- ASML_SCEN_COMP_CONTENTS_V
- ASML_REQUEST_BUDGET_LINES_V
- ASML_BUDGET_VALUES_PER_LINE_V
- ASML_SCEN_BUDGETS_V
- ASML_SCEN_BUDGET_LINE_CELLS_V
- ASML_SCEN_BENEFITS_V
- ASML_SCEN_BENEFIT_PERIOD_SUM_V
- ASML_SCEN_BENEFIT_LINE_CELLS_V
- ASML_SCEN_BUDGET_PERIOD_SUM_V
- ASML_PROJECT_PROPOSALS_V
- ASML_PROJECTS_V
- ASML_BUDGET_LINES_V
- ASML_BENEFIT_LINES_V
- ASLM_PROPOSALS_AND_PROJECTS_V

Press ENTER to read the text [Type q to quit]

- ASML_PROPOSALS_AND_PROJECTS_B
- ASML_RFF_SCEN_COMP_ENTITIES_V
- ASML_SCENARIO_CONTENTS_V
- ASML_PROPOSALS_V
- SYS_PLSQL_28280_75_2
- SYS_PLSQL_28280_65_2
- SYS_PLSQL_10715_75_1
- SYS_PLSQL_10715_65_1




But all the above mentioned views are used behind important portlets, and now those portlets in 8.0 version are showing errors as attached file.


So Could any one please advice me what exactly I need to do in order to make all those views as valid.

Best Regards,
Harika.
3 REPLIES
Jason Nichols K
Acclaimed Contributor.
Solution

Re: Invalid data objects post upgrade

Harika,

It seems that most of these views are pulling data from Benefits and Budgets. The whole table structure for these changed in 8.0, so the code behind the views need to be updated to reference the Financial Summaries instead of the individual Budget and Benefit. The Data Model Guide document will give you the layout of the new tables that you will need to use.

Jason
Harika Appa
Trusted Contributor.

Re: Invalid data objects post upgrade

Hi Jason,

Thankyou soo much for your advice.

I have now changed all the views according to new datamodel and it have resolved the issue.

Best Regards,
Harika.
Harika Appa
Trusted Contributor.

Re: Invalid data objects post upgrade

I have now changed all the views according to new datamodel and it have resolved the issue.