Project and Portfolio Management Practitioners Forum
cancel

Automatically populating the sla violation date field

SOLVED
Go to solution
Highlighted
Jayant Gupta
Trusted Contributor.

Automatically populating the sla violation date field

hi i want to automatically populate the sla_violation_date when sla_level is selected.
for eg if sla lavel is 'high - 3business days', and day today is 21, APR, then violation date shud auto appear as: 24 Apr 2009.
for this i have created an advance rule in rules section and put the following query:
select to_char(sysdate +3, 'Mon dd, yyyy') from dual
the query rus fine when i run in the itg database but when i am using in the ppm nothing appears when i select priority and hence sla level
note: i am able to generate the auto sla level when i select the priority from the drop down.

let me know if i am unclear

Regards
Jayant
17 REPLIES
Mahen M
Acclaimed Contributor.

Re: Automatically populating the sla violation date field

I suppose for you rules there must be 2 parameters. one is ordinary Parameter and the other is visible_parameter.

Try
select to_char(sysdate +3, 'Mon dd, yyyy'),
to_char(sysdate +3, 'Mon dd, yyyy')
from dual



Sample Data

Select
next_day(to_date('[REQ.VP.START_DATE]','Month DD, YYYY')-7,'MONDAY'),
next_day(to_date('[REQ.VP.START_DATE]','Month DD, YYYY')-7,'MONDAY')
From dual


Regards,
Mahendran M
Jayant Gupta
Trusted Contributor.

Re: Automatically populating the sla violation date field

Hi mahendran
i tried putting two select statements as u mentioned but did not get success.
select unique to_char(sysdate +3, 'Mon dd, yyyy), to_char(sysdate +3, 'Mon dd, yyyy) from dual.

it still does nt comes up with anything.
wondering if 'dual' works with the itg sql window??
Mahen M
Acclaimed Contributor.

Re: Automatically populating the sla violation date field

Can you kindly send the snap?

Kindly introduce an error in the Rule Query, If there are any errors, you will get pop up errors in the request Page. Kindly send that errors too.

Regards,
Mahendran M
Mahen M
Acclaimed Contributor.

Re: Automatically populating the sla violation date field

Also I tried to execute your Query from my end, It contains errors.


Corrected Query :



select unique to_char(sysdate +3, 'Mon dd, yyyy'), to_char(sysdate +3, 'Mon dd, yyyy') from dual

Regards,
Mahendran M
Jayant Gupta
Trusted Contributor.

Re: Automatically populating the sla violation date field

hey the queries are same. and i took care of the commas when putting them in the rule :)
here is wat i try to create the request:
-------------------------------------------
Wrong number of values returned by SQL

in Rule 19 - 'Date - Priority High':

select unique to_char(sysdate +3, 'Mon dd, yyyy'), to_char(sysdate +3, 'Mon dd, yyyy') from dual (KNTA-10519)
---------------------------------------------

i am attaching the snapshot of the rule where i am putting the sql.
there are two dates which supposed to be populated(just for testing) one is custom (violation_date) which is of auto-complete validation(var-char instead of date).
but nothing gets populated.
Thanks much for ur help

Regards
Jayant
Mahen M
Acclaimed Contributor.

Re: Automatically populating the sla violation date field

Try this

select unique to_char(sysdate +3, 'Mon dd, yyyy'),
to_char(sysdate +3, 'Mon dd, yyyy'),
to_char(sysdate +3, 'Mon dd, yyyy'),
to_char(sysdate +3, 'Mon dd, yyyy')
from dual

Kindly let me know if this does not help.

Regards,
Mahendran M
Jayant Gupta
Trusted Contributor.

Re: Automatically populating the sla violation date field

i get this message now:


The date entered in SLA Violation Date: is invalid. Sample valid date entries are

April 21, 2009
Apr 21, 2009
4/21/09
April 21
21 April
21. April
21, April
Apr/21
21/Apr
Apr 21
21 Apr
4/21
2
Jayant Gupta
Trusted Contributor.

Re: Automatically populating the sla violation date field

but the violation_date field gets filled this time. i am able to see a date in the violation_date space automatically. but this wont help in dashboard.
Thanks a lot for ur support
Mahen M
Acclaimed Contributor.

Re: Automatically populating the sla violation date field

Simple, You are converting the date to Character, that should not be done

Try this:
Select (sysdate +3), (sysdate +3), (sysdate +3), (sysdate +3) from dual

Regards,
Mahendran M
Jayant Gupta
Trusted Contributor.

Re: Automatically populating the sla violation date field

hi mahendran
i am able to get the date on the sla violation space
i tried this query:

but now issue is that it will populate the space only during the creation.
when i change the field, it doesnt populate the sapce. though i have put similar query (with change date numbers) for other to-be changed fields.
Jayant Gupta
Trusted Contributor.

Re: Automatically populating the sla violation date field

select unique trunc(sysdate +3), trunc(sysdate +3), to_char(sysdate +3, 'Month dd, yyyy'),
to_char(sysdate +3, 'Month dd, yyyy')
from dual

this query i tried.
i ll try ur solution and update the thread.
thanks again
Mahen M
Acclaimed Contributor.

Re: Automatically populating the sla violation date field

Can you send snapshot of the whole Rule? I cannot understand.

Regards,
Mahendran M
Jayant Gupta
Trusted Contributor.

Re: Automatically populating the sla violation date field

hi
i am attaching the snapshot of the step by step sequence.
the rule(on creation) and the rule(on field change) and corresponding front ends.
i am getting the value only on the creation oof the request but when field changes, the date is not changed, i.e. the sql is not triggered.
Mahen M
Acclaimed Contributor.

Re: Automatically populating the sla violation date field

Kindly do not show the links in the IE to others.

For Low you have 15 days as SLA, for High you have 3 days. Initially on creation 'Low' being the default value a date 15 days from now is selected. If you change the values as 'High' the date is not getting updated.

I find everything is working correctly, Can you introduce some errors in the Field Change Rule? and see whether the error is coming in the front end?

I do not see a field called 'Violation Date' in your form.... Where are you using it.

Try clearing Cache by
'sh kRunCacheManager.sh A' once and see whether you have any impact.

Regards,
Mahendran M
Jayant Gupta
Trusted Contributor.

Re: Automatically populating the sla violation date field

hi mahendran
sorry for the late reply and thanks for the support
can u let me know where do i find this file kRunCacheManager.sh. i think this shud be th e problem(overflow of cache)

Thanks
Jayant
Mahen M
Acclaimed Contributor.
Solution

Re: Automatically populating the sla violation date field

Hi,
Please login into the Application Server, Open Command Prompt.

Go the 'Base path' in the command Prompt or Cygwin(You can find this in 'Server Configuration Report')

For my server it is

C:\Prod\ITG17\bin

When you are in this directory type the shell script as 'sh kRunCacheManager.sh A'
and click enter.

Regards,
Mahendran M
Jayant Gupta
Trusted Contributor.

Re: Automatically populating the sla violation date field

Thanks a lot mahendran
My issue is resolved.
i have used the following query:
select unique trunc(sysdate +3), trunc(sysdate +3) from dual.
thanks foir ur time.

Regards
Jayant