It's all about the answers!

Ask a question

CLM Upgrade 6.0.2 - Create index files for VVCMODEL.VERSION table in which databases?


Cláudio de Sá Rodrigues (28819) | asked Jul 02 '16, 4:05 p.m.

In the roadmap that I am following,

step 8: Create index files for VVCMODEL.VERSION

ALTER TABLE VVCMODEL.VERSION ALTER COLUMN CONCEPT NVARCHAR(450) NOT NULL
ALTER TABLE VVCMODEL.VERSION ALTER COLUMN STORAGE NVARCHAR(450) NULL

CREATE  INDEX VERSION_CONCEPT_DX ON VVCMODEL.VERSION (CONCEPT)
CREATE  INDEX VERSION_STORAGE_DX ON VVCMODEL.VERSION (STORAGE)

does not specify which database should I do it.

I noticed that the table exists in the database JTS, CCM, QM and RM.

This step should be applied at all then?

I'm upgrading from 5.0.2 to 6.0.2 CLM

One answer



permanent link
David Dulling (13731212) | answered Jul 02 '16, 4:26 p.m.
 Hi

I raised a PMR against this too. The response I received was "I discussed this further with Development and this step is to be
removed in our next release as it was only a temporary measure."

Hope this helps

Regards
David

Comments
Cláudio de Sá Rodrigues commented Jul 02 '16, 4:35 p.m.

Thank you David, 

in doubt I did in all databases, but left a script ready to reverse the action if necessary.

Your answer


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