I was in the
process of upgrading the EPM System from Version 11.1.2.1 to 11.1.2.3 through maintenance
release, and after the installation and configuration completed successfully, I
noticed that I was not able to log in to Shared Services (or should we say pull
up Shared Services – as we can now see Shared Services residing in the Workspace
window in a different tab - as opposed to a different Window that we could see
in Version 11.1.2.1).
Every time I
tried to get in to Shared Services, I would get the following error -
“Required application
module cas.containers.tadpole is not configured.”
Upon checking the FoundationServices error logs @ user_projects\domains\EPMSystem\servers\FoundationServices0\logs,
I could see
“DSF initialization error ORA-00904: "PROCESSNAME": invalid
identifier” which would suggest that it had to do with Oracle table or schema.
The logs would suggest that It was pointing to "PROCESSNAME"
column in the Shared Services oracle table.
Upon further
research, I found out that, during maintenance release, some of the Shared Services tables were not updated during the maintenance release upgrade.
For example,
the table “CES_PROCESS_DEF” has 4 columns
in Version 11.1.2.1. However, in Version 11.1.2.3, it is supposed to have 9 columns. In fact, “PROCESSNAME”
is one of the columns that would have to be added to the “CES_PROCESS_DEF” table during the EPM maintenance release
process (during upgrade process). However, the tables were not being modified.
In order to
resolve the issue, I would have to add the missing columns, but, there
could have been other columns missing as well. Upon doing some research and digging through the folders, I could find a bunch of SQL scripts in the “Middleware\EPMSystem11R1\products\Foundation\server\conf”
folder which would be used to resolve the issue.
One such script in this
case – since I have Oracle as my database – is
”create_oracle_workflow_upgrade.sql”
which basically adds tables/columns that might not have been added during the
upgrade process.
From this I could figure out that it might have been a known issue where the tables would not be me modified during the maintenance release so these could be the scripts that Oracle might have created in order to resolve such issues. But that is just my guess.
Feel free to open the script
and run only the ones that are required to resolve the issue. In my case, I had
to run only two of the lines in the script.
After
stopping the services, I ran the script
“ALTER TABLE
ces_process_def ADD (applicationname Varchar(100), processname Varchar(100),
revision Varchar(100), authorname Varchar(100),description Varchar(100))” from
within the main script which added the columns that were missing.
I verified
the addition of the columns, started the services, and I was able to get into Shared Services.
Check you Shared Services table in case you experience the same issue during upgrades.
2 comments:
2017 ford fusion energi titanium - TitaniumArts.com
2018 FUTUR-TOUR joico titanium YEARS RAGE FOR titanium connecting rod DIVINE. The head titanium ti s6 Ultimate 2021-22 Experience titanium knee replacement will have a bang in our time of operation. apr casino
rd557 stockxdanmark.com,tevasandalen,crocs türkiye,crocsbasutes,vivobarefoot nederland,crocs online,havaianas zürich,dsquared2jeans,dsquared2 jeans wz938
Post a Comment