on 06-25-2007 1:35 PM
Hello,
currently we trying to set up Role Expert (SAP GRC 5.2) with a simple workflow:
Definition > Define Authorization > Approval > Role Generation > Testing
But the workflow does not work respectively the step "Approval" does not work. Each time when I approve a role I get the error message "Error in creating request". The System Log shows the following entries:
2007-06-25 15:27:19,546 [SAPEngine_Application_Thread[impl:3]_20] DEBUG Current Module: |RE| Conversation: |cnvRole| Screen: |scrRoleEdit|
2007-06-25 15:27:19,546 [SAPEngine_Application_Thread[impl:3]_20] DEBUG Module#RE#Conversation#cnvRole#Screen#scrRoleEdit#Action#approvalWorkflow#
2007-06-25 15:27:19,546 [SAPEngine_Application_Thread[impl:3]_20] DEBUG Handler found:class com.virsa.re.workflow.actions.WorkflowRequestAction
2007-06-25 15:27:19,546 [SAPEngine_Application_Thread[impl:3]_20] DEBUG Instantiating Workflow Request Client
2007-06-25 15:27:19,546 [SAPEngine_Application_Thread[impl:3]_20] DEBUG Calling client.exec
2007-06-25 15:27:19,625 [SAPEngine_Application_Thread[impl:3]_20] DEBUG Response is either null or not successful
2007-06-25 15:27:19,625 [SAPEngine_Application_Thread[impl:3]_20] ERROR 2010 : com.virsa.ae.core.ObjectNotFoundException: Invalid Workflow type : RE
To solve the problem I checked the configuration of the workflow (role attributes, condition group, methodology) and found it to be configured correctly.
When I remove the step "Approval" from my workflow then it is possible to complete the workflow. Unfortunately this is not a valid solution for the problem and the error messages are not helpful either.
So I am completely stuck at this problem and can't resolve it. Can anybody provide an advice?
Thanks and regards,
Oliver
We encountered the same issue here. Please look at OSS Note 1099261 for more information. We reinstalled the initial system files and were able to resolve the issue.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Solution:
In Access Enforcer go to "Configuration" and then activate the "Number Ranges"
Did it work?
Kind Regards,
Marcelo Cordero J.
Chile
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Please go to the workflow settings and check that your workflow is of type "RE" rather than "AE" or "CUP".
If it isn't, then you caught a bad XML file in one of the support packs (happened to me before). Look into the XML files in the latest SP and check that the RE Approval workflow has type "RE", then re-upload those initial XML files (don't worry - "clean and insert" won't break any of your configurations). You need to do that with every SP.
Let us know if it worked.
Frank.
Hi,
We are having the same problem- "Unable to Create request Error while creating request" when clicking the "Approval" button from AE.
We have number range configured, the RE request type is active, the workflow with RE Inititator, Stage (CAD-with Web services) path, exit URL are all set.
Pls let me know if there is anything else that needs to be looked at or if there are other tricks.
Thanks
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
try using link ending with rpc rather than document
In AE, go to the - Configuration tab / Miscellaneous
Check to make sure Workflow type RE / Role Expert has a tick in the Active box. and that it has a return Exit URL
http://<Host system name>:50200/AEWFExitServiceWS_5_2/Config1?style= rpc
worked for me, dont ask why
regards
naveed
Hi All.
Not sure if you have had the answer to this issue yet as it is now the end of January.
We have just installed GRC - 5.2
We have successful got Role Expert and Access Enforce to talk to each other and therefore the Approval step now works.
The issue we had was that the Access Enforcer workflow was not activated.
In AE, go to the - Configuration tab / Miscellaneous
Check to make sure Workflow type RE / Role Expert has a tick in the Active box. and that it has a return Exit URL http://<Host system name>:50200/AEWFExitServiceWS_5_2/Config1?style=document
You can get this short cut from SAP Netweaver default page go to < http://<Host system name>:50200> Web Services Navigator Scroll down and open the "AEWFEXITSERVICEWS_5_2" then copy the link from the document.
Then Create your
AE "Request type" for "RE Role Expert Approval"
AE "Initiator" for "Role Expert Approval Workflow"
AE "Stage" for "RE Role Approver Stage"
AE " PATH" for "Role Expert role approval path " with your required Stage for role approval.
Now In RE you should be able to select your Role Approvers.
When you do an approval it should generate an AE - Approval request, and the approver has to approve it in AE not RE.
Terry Carter
SAP Security Specialist
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi ,
Even I m getting the same error.
Do we have any solution to it?
Here is the system log in AE which i got when i have inserted the AE_init_append_data_RE file in AE:-
2007-12-01 14:06:57,842 [SAPEngine_Application_Thread[impl:3]_127] ERROR SQL Exception in insert : DB2 SQL error: SQLCODE: -803, SQLSTATE: 23505, SQLERRMC: 1;SAPND2DB.VIRSA_AE_WF_STGFLD ==> VIRSA_AE_WF_STGFLD : {FLD_NAME=Email Group, WFTYPE=RE, FLD_DESCRIPTION=Email Group}
2007-12-01 14:06:57,844 [SAPEngine_Application_Thread[impl:3]_127] ERROR SQL Exception in insert : DB2 SQL error: SQLCODE: -803, SQLSTATE: 23505, SQLERRMC: 1;SAPND2DB.VIRSA_AE_WF_STGFLD ==> VIRSA_AE_WF_STGFLD : {FLD_NAME=Approve by Email, WFTYPE=RE, FLD_DESCRIPTION=Approve by Email}
2007-12-01 14:06:57,848 [SAPEngine_Application_Thread[impl:3]_127] ERROR SQL Exception in insert : DB2 SQL error: SQLCODE: -803, SQLSTATE: 23505, SQLERRMC: 1;SAPND2DB.VIRSA_AE_WF_STGFLD ==> VIRSA_AE_WF_STGFLD : {FLD_NAME=Comments Mandatory, WFTYPE=RE, FLD_DESCRIPTION=Comments Mandatory}
2007-12-01 14:06:57,850 [SAPEngine_Application_Thread[impl:3]_127] ERROR SQL Exception in insert : DB2 SQL error: SQLCODE: -803, SQLSTATE: 23505, SQLERRMC: 1;SAPND2DB.VIRSA_AE_WF_STGFLD ==> VIRSA_AE_WF_STGFLD : {FLD_NAME=Request Rejection, WFTYPE=RE, FLD_DESCRIPTION=Request Rejection}
2007-12-01 14:06:57,851 [SAPEngine_Application_Thread[impl:3]_127] ERROR SQL Exception in insert : DB2 SQL error: SQLCODE: -803, SQLSTATE: 23505, SQLERRMC: 1;SAPND2DB.VIRSA_AE_WF_STGFLD ==> VIRSA_AE_WF_STGFLD : {FLD_NAME=Re-Route, WFTYPE=RE, FLD_DESCRIPTION=Re-Route}
2007-12-01 14:06:57,853 [SAPEngine_Application_Thread[impl:3]_127] ERROR SQL Exception in insert : DB2 SQL error: SQLCODE: -803, SQLSTATE: 23505, SQLERRMC: 1;SAPND2DB.VIRSA_AE_WF_STGFLD ==> VIRSA_AE_WF_STGFLD : {FLD_NAME=Reject by Email, WFTYPE=RE, FLD_DESCRIPTION=Reject by Email}
2007-12-01 14:06:57,855 [SAPEngine_Application_Thread[impl:3]_127] ERROR SQL Exception in insert : DB2 SQL error: SQLCODE: -803, SQLSTATE: 23505, SQLERRMC: 1;SAPND2DB.VIRSA_AE_WF_STGFLD ==> VIRSA_AE_WF_STGFLD : {FLD_NAME=Forward Allowed, WFTYPE=RE, FLD_DESCRIPTION=Forward Allowed}
2007-12-01 14:06:57,856 [SAPEngine_Application_Thread[impl:3]_127] ERROR SQL Exception in insert : DB2 SQL error: SQLCODE: -803, SQLSTATE: 23505, SQLERRMC: 1;SAPND2DB.VIRSA_AE_WF_STGFLD ==> VIRSA_AE_WF_STGFLD : {FLD_NAME=Forward Type, WFTYPE=RE, FLD_DESCRIPTION=Forward Type}
2007-12-01 14:06:57,858 [SAPEngine_Application_Thread[impl:3]_127] ERROR SQL Exception in insert : DB2 SQL error: SQLCODE: -803, SQLSTATE: 23505, SQLERRMC: 1;SAPND2DB.VIRSA_AE_WF_STGFLD ==> VIRSA_AE_WF_STGFLD : {FLD_NAME=Approval Type, WFTYPE=RE, FLD_DESCRIPTION=Approval Type}
2007-12-01 14:06:57,860 [SAPEngine_Application_Thread[impl:3]_127] ERROR SQL Exception in insert : DB2 SQL error: SQLCODE: -803, SQLSTATE: 23505, SQLERRMC: 1;SAPND2DB.VIRSA_AE_WF_STGFLD ==> VIRSA_AE_WF_STGFLD : {FLD_NAME=confirmApproval, FLD_DESCRIPTION=confirmApproval, WFTYPE=RE}
2007-12-01 14:06:57,862 [SAPEngine_Application_Thread[impl:3]_127] ERROR SQL Exception in insert : DB2 SQL error: SQLCODE: -803, SQLSTATE: 23505, SQLERRMC: 1;SAPND2DB.VIRSA_AE_WF_STGFLD ==> VIRSA_AE_WF_STGFLD : {FLD_NAME=confirmReject, FLD_DESCRIPTION=confirmReject, WFTYPE=RE}
2007-12-01 14:06:57,865 [SAPEngine_Application_Thread[impl:3]_127] ERROR SQL Exception in insert : DB2 SQL error: SQLCODE: -803, SQLSTATE: 23505, SQLERRMC: 1;SAPND2DB.VIRSA_AE_RQ_PRTY ==> VIRSA_AE_RQ_PRTY : {REQPRIORITYDESC=RE High, ISDELETABLE=0, WFTYPE=RE, REQPRIORITY=RE_HIGH}
2007-12-01 14:06:57,869 [SAPEngine_Application_Thread[impl:3]_127] ERROR SQL Exception in insert : DB2 SQL error: SQLCODE: -803, SQLSTATE: 23505, SQLERRMC: 1;SAPND2DB.VIRSA_AE_INTR_ATTR ==> VIRSA_AE_INTR_ATTR : {FIELDTYPE=DropDown, ATTRIBUTE=Priority, WHERE_CONDITION=WHERE WFTYPE='RE', ENABLED=1, FIELD=ReqPriority, TABLENAME=VIRSA_AE_RQ_PRTY, WFTYPE=RE}
2007-12-01 14:06:57,870 [SAPEngine_Application_Thread[impl:3]_127] ERROR SQL Exception in insert : DB2 SQL error: SQLCODE: -803, SQLSTATE: 23505, SQLERRMC: 1;SAPND2DB.VIRSA_AE_INTR_ATTR ==> VIRSA_AE_INTR_ATTR : {FIELDTYPE=DropDown, ATTRIBUTE=Request Type, WHERE_CONDITION=WHERE WFTYPE='RE', ENABLED=1, FIELD=REQTYPE, TABLENAME=VIRSA_AE_RQ_TYP, WFTYPE=RE}
2007-12-01 14:06:57,874 [SAPEngine_Application_Thread[impl:3]_127] ERROR SQL Exception in insert : DB2 SQL error: SQLCODE: -803, SQLSTATE: 23505, SQLERRMC: 1;SAPND2DB.VIRSA_AE_WFTYPE ==> VIRSA_AE_WFTYPE : {NAME=RE, DESCRIPTION=Role Expert, ACTIVE=0}
2007-12-01 14:06:57,876 [SAPEngine_Application_Thread[impl:3]_127] ERROR SQL Exception in insert : DB2 SQL error: SQLCODE: -803, SQLSTATE: 23505, SQLERRMC: 1;SAPND2DB.VIRSA_AE_RQ_TYP ==> VIRSA_AE_RQ_TYP : {REQTYPEDESC=RE Role Approval, ISDELETABLE=0, WFTYPE=RE, REQTYPE=RE_ROLE_APPROVAL}
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Oliver,
I've got the same problem. Did you already find a solution yet?
Does the error possibly occur due to incorrect roles of the roleapprover?
Rgds,
Martin
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Guys, not sure how far you have got, but esentially the config to setup the roloe approval bit is:
Access enforcer config:
- Ensure you have installed initial data file AE_init_append_data_RE.xml in AE
- Set the RE exit service http://host:port/AEWFExitServiceWS_5_2/Config1?wsdl&style=rpc
-activate request type RE
- create initiator , (workflow type = Role expert)
- create a CAD for role expert . use service http://host:port/AEWFCADApproversServiceWS_5_2/Config1?wsdl&style=rpc
- create stage and path
role expert config:
- Configuration -> miscellaneous use webservice
http://host:port/AEWFRequestSubmissionService_5_2/Config1?wsdl&style=document
this is for 5.2 so services may difer for 5.1
role approvers should have the ASApprover role
Naveed
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.