The community will be in read-only from Tuesday 11:59pm (PST) to Wednesday 7:30am (PST)
The community will be in read-only from Tuesday 11:59pm (PST) to Wednesday 7:30am (PST)
Project and Portfolio Management Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

Multiple request details for request

SOLVED
Go to solution
Highlighted
Łukasz Czech
Collector

Multiple request details for request

Hi,

I have aq question regarding kcrt_request_details table and its relation to kcrt_requests - in Technical Reference Manual there is an information that there is one request detail per request (tied by kcrt_request_details.request_id), but for some of my requests I have two request details.
There is a difference in data in fields:
- creation_date
- created_by
- batch_number (value 1 or 2)
- parameteres1-50 values

What is more the valid one seems to be the older one with batch_number equal to 1 (parameters value matches these from PPM GUI).

Does anybody knows what is the purpose and triggers creation of additional details for the same request?
3 REPLIES
Darshan Bavisi
Occasional Visitor
Solution

Re: Multiple request details for request

Hi Å ukasz,

You would be finding such requests only for those having more than 50 parameters in the request types as the batch_number will increase by 1 with every new 50 parameters. Are you seeing any other requests having less than 50 parameters? Then that may be an issue.

Also, the creation_date may be the one when the request had over 50 parameters now and created_by may be the default or ootb user id (may 1 or something). Try increasing the parameters above 100 and you may find 3 kcrt_request)_details entries for one entry in kcrt_requests for that request.
Łukasz Czech
Collector

Re: Multiple request details for request

Yes, this is correct. Thank you.
Łukasz Czech
Collector

Re: Multiple request details for request

.
//Add this to "OnDomLoad" event