- Community Home
- >
- Software
- >
- Agile Planning and Lifecycle
- >
- PPM
- >
- Project and Portfolio Management Practitioners
- >
- Re: Request copy problem
-
Communities
-
Blogs
-
Quick LinksProtect724English
Request copy problem
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
06-23-2010 01:00 AM
06-23-2010 01:00 AM
Request copy problem
Request copy problem
ksc_copy_request FROM_REQUEST_ID="[TEMP_REQFROM]" REQUEST_TYPE_ID="[TEMP_REQTYPE]" WORKFLOW_ID="[TEMP_WF]" COPY_FIELDS="N" COPY_NOTES="N" CREATE_REFERENCE="Y" REFERENCE_RELATIONSHIP="Child of this Request" SUBMIT="Y"
(all tokens are populated properly for sure – see below)
The following message appears in log:
Beginning command: KSC Copy Request
Running PL/SQL procedure KCRT_REQUEST_UTIL.COPY_REQUEST
Summary of parameters:
FROM_REQUEST_ID=30337
REQUEST_TYPE_ID=30431
WORKFLOW_ID=30573
COPY_FIELDS=N
COPY_NOTES=N
CREATE_REFERENCE=Y
REFERENCE_RELATIONSHIP=Child of this Request
STATUS_NAME=
SUBMIT=Y
PROCESS_RULE=N
Request copied successfully with new ID = 0
And the request is not being created.
FROM_REQ, REQ_TYPE and WORKFLOW exist for sure (partial results – not all columns shown):
select * from kcrt_requests r WHERE request_id = 30337
REQUEST_ID CREATION_DATE CREATED_BY LAST_UPDATE_DATE LAST_UPDATED_BY ENTITY_LAST_UPDATE_DATE REQUEST_NUMBER REQUEST_TYPE_ID
30337 05-11-2010 14:32:31 104329 05-11-2010 14:32:31 104329 05-11-2010 14:32:31 30337 30431
select * from kcrt_request_types t WHERE request_type_id = 30431
REQUEST_TYPE_ID CREATION_DATE CREATED_BY LAST_UPDATE_DATE LAST_UPDATED_BY
30431 05-11-2010 06:45:06 100304 05-12-2010 09:27:10 104329
select * from kwfl_workflows WHERE workflow_id = 30573
WORKFLOW_ID CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE ENTITY_LAST_UPDATE_DATE WORKFLOW_NAME
30573 100304 05-11-2010 06:47:40 100304 05-11-2010 06:47:40 05-11-2010 06:47:40 GEMB - Progress Report workflow
Thank you and best regards
Lukasz Czech
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
06-24-2010 01:17 AM
06-24-2010 01:17 AM
Re: Request copy problem
Re: Request copy problem
See another variant in attach.
May be it help you
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
06-24-2010 01:22 AM
06-24-2010 01:22 AM
Re: Request copy problem
Re: Request copy problem
thank you for your reply. I have seen your solution in previous posts. I am considering this as a workaround if everything else fails. I want to ensure why this solution is not working in one of our environments (in other works fine).
I have already submitted case in HP, but sometimes (often) Forum response is faster ;)
Best regards
Lukasz Czech
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
07-29-2010 10:27 AM
07-29-2010 10:27 AM
Re: Request copy problem
Re: Request copy problem
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
07-30-2010 12:21 AM
07-30-2010 12:21 AM
Re: Request copy problem
Re: Request copy problem
I do not use these group fields in the request we try to copy. I know that with project requests it is not possible.
Best regards
Lukasz Czech
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
07-30-2010 04:18 AM
07-30-2010 04:18 AM
Re: Request copy problem
Re: Request copy problem
I had a similar problem a couple of days ago.
Do you have installed a language Pack?
In this case you must change the REFERENCE_RELATIONSHIP to a localized value.
However additional to your command I set the STATUS_NAME.
Maybe this is the problem.
Regards
Volker
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
07-30-2010 04:53 AM
07-30-2010 04:53 AM
Re: Request copy problem
Re: Request copy problem
thank you for your reply - we do not have language pack. I will try you solution with STATUS_NAME.
Best regards
Lukasz Czech
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
08-02-2010 05:18 AM
08-02-2010 05:18 AM
Re: Request copy problem
Re: Request copy problem
i had a similiar problem with the ksc_move_request_workflow command.
Does the execution step has any security group listed? Because the ksc_move_request_workflow command requires the security group of the person, who will execute the step.
So maybe, you have to add the admin group to the execution step.
Hopefully, this works!
Regards
Sascha
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
08-06-2010 01:43 AM
08-06-2010 01:43 AM
Re: Request copy problem
Re: Request copy problem
thank you for your replies. I've tried to add Administrators security group to step where ksc_create_request command is used and additionally add STATUS_NAME (with value) to this command, however commands executed by workflow_timeout_service still do not properly execute and request is not being copied.
All other ideas are welcomed
Best regards
Lukasz Czech
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
08-06-2010 04:23 AM
08-06-2010 04:23 AM
Re: Request copy problem
Re: Request copy problem
Hope this will help.
Jyotir
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
08-06-2010 04:34 AM
08-06-2010 04:34 AM
Re: Request copy problem
Re: Request copy problem
we do not have any mandatory fields in copied request - it can be submitted without providing any values while manually creating.
I will try with kcvs_utilities.create_requests
Best regards
Lukasz Czech
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
12-16-2010 10:59 AM
12-16-2010 10:59 AM
Re: Request copy problem
Re: Request copy problem
Did you ever get a satisfactory answer from HP on the case that you sumbmitted on this issue?
I am hitting the same issue. I have a workflow that uses the ksc_Copy_Request command. The same step can be used to create different request types. Out of three (3) request types that the step can create, two of them are created without an issue, the third always fails.
All three request types use the same header which uses the Demand SLA and Demand Scheduling groups fields.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
12-16-2010 12:59 PM
12-16-2010 12:59 PM
Re: Request copy problem
Re: Request copy problem
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
12-16-2010 03:09 PM
12-16-2010 03:09 PM
Re: Request copy problem
Re: Request copy problem
Thanks for the heads up!
I turned off the Copy_Fields option and the offending request type now gets created. Now I have to go through 15-20 fields that use common tokens to find out which field(s) is causing the problem.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
12-16-2010 03:46 PM
12-16-2010 03:46 PM
Re: Request copy problem
Re: Request copy problem
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
12-30-2010 02:16 AM
12-30-2010 02:16 AM
Re: Request copy problem
Re: Request copy problem
sorry for the delay in response but I was out of office. Our problem was quite different - we use timeout to create requests on regular basis (e.g. once per week). In that case these new requests are being created by workflow_timeout_service user. Unfortunately this user does not have rights (licenses, access grants) to perform such operation. HP classified this as a bug. As a workaround you can add liceses and access grants for this user directly in DB, as it cannot be done in Workbench.
Best regards
Lukasz Czech
-
Francisco_M_PPM
on: Add and update Approved Budegt in Projects (financial summary)
-
hasankalim
on: Closed Project Workplan Keeps Reopening
-
Etienne_Canaud on: PPM 9.32 Filtering REST services
-
Tim_Gator
on: How to mark a field as "mandatory"/"required" field?
-
Etienne_Canaud on: uninstall operational reporting?
-
PeterM1977
on: Slowness of PPM sripts / node start - after applied WIndows server patches in March 2018
-
changl
on: PPM Performance issue - Project Summary page is loading very slow.
-
Chris18
on: Workplan Tasks to be Billable/Non-Billable
-
Neumator
on: Upgrades
-
Etienne_Canaud on: Scan QR Code error when exporting to Excel
- PPM
- popular discussion
- Project and Portfolio Management
- upgrade
- attachments
- SQL
- project
- License
- Java
- LDAP
- demand management
- Oracle
- tip
- popular_discussion
- Staffing Profile
- Search
- Expert Day
- PPM Support Tip
- Password
- portlet
- Request Type
- ssh
- XML
- 9.2
- operational reporting
- Project Management
- request
- Web services
- businessobjects