cancel
Showing results for 
Search instead for 
Did you mean: 

Role Expert Error Message - Invalid Workflow Type

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (6)

Answers (6)

Former Member
0 Kudos

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.

Former Member
0 Kudos

Solution:

In Access Enforcer go to "Configuration" and then activate the "Number Ranges"

Did it work?

Kind Regards,

Marcelo Cordero J.

Chile

koehntopp
Product and Topic Expert
Product and Topic Expert
0 Kudos

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.

Former Member
0 Kudos

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

Former Member
0 Kudos

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

Former Member
0 Kudos

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

Former Member
0 Kudos

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}

Former Member
0 Kudos

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

Former Member
0 Kudos

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