Absent Member.. Absent Member..
Absent Member..
438 views

How to change a field value in the DB?

Jump to solution

Hi,

 

I need to change the Planned Start Period and Planned Finish Period of projects in DB.

Because, I need a mass update.

PPM 8.04.

 

Any help is appreciated.

 

Regards

TM

0 Likes
1 Solution

Accepted Solutions
Absent Member.. Absent Member..
Absent Member..
Hi,

the information you're looking for is in the KCRT_FG_PFM_PROJECT.

You should also update LAST_UPDATE_DATE in this table as well as in KCRT_REQUESTS.

Let us know if it works.

Cheers
Alex

--remember to kudos people who helped solve your problem

View solution in original post

5 Replies
Absent Member.. Absent Member..
Absent Member..

Hi, TurboMan,

 

do you need to change the field in the Project Request form, or the start / end  date of the Project workplan?

 

for the first one, you can use the PPM built-in functionality called Mass Update 😉

 

cheers

alex


--remember to kudos people who helped solve your problem
0 Likes
Absent Member.. Absent Member..
Absent Member..

Thanks,

 

I need to change in the Project Request Form.

Becasue, I cannot save.

So, I need to try to resolve this problem  by updating DB fields first and see on the Project Request Form.

 

Regards

TM

 

0 Likes
Absent Member.. Absent Member..
Absent Member..
Hi,

the information you're looking for is in the KCRT_FG_PFM_PROJECT.

You should also update LAST_UPDATE_DATE in this table as well as in KCRT_REQUESTS.

Let us know if it works.

Cheers
Alex

--remember to kudos people who helped solve your problem

View solution in original post

Absent Member.. Absent Member..
Absent Member..

Alex,

 

You are a legend, thanks very much.

Just a quick update,

After I updated, I have to run cache manager to flush all caches as follows 

./kRunCacheManager.sh A

or rebounce the PPM . 

 

Regards

TM

0 Likes
Absent Member.. Absent Member..
Absent Member..
Hi,

If you also update the KCRT_REQUESTS.ENTITY_LAST_UPDATE_DATE, then you don't need to refresh the cache or bounce the server.

Remember to provide kudos to people who helped solve your problem.

Cheers
Alex

--remember to kudos people who helped solve your problem
0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.