My Oracle Support Banner

Manage Mobile User>Creation Error "ResourceException: Java heap space" (Doc ID 1323705.1)

Last updated on JULY 14, 2020

Applies to:

Oracle Mobile Field Service - Version 12.1.2 and later
Information in this document applies to any platform.

Symptoms

When attempting to delete a user running Manage Mobile User, the following error occurs.

ERROR
-----------------------
Program will delete invalid mobile users
deleteInvalidUsers: SQL Command: SELECT user_name FROM ASG.asg_user WHERE user_name not in ( SELECT CLIENTID FROM MOBILEADMIN.c$all_clients) ORDER BY user_name
deleteInvalidUsers: SQL Command: select user_name,language from ASG.asg_user where enabled = 'N' order by user_name
delete Obselete user SQL command: select distinct user_name , resource_id from ASG.asg_user a where EXISTS ( select 1 from fnd_user b where b.user_name = a.user_name and trunc(b.end_date) < trunc(sysdate) ) or EXISTS ( select 1 from jtf_rs_resource_extns c where c.user_name = a.user_name and trunc(c.END_DATE_ACTIVE) < trunc(sysdate)) or EXISTS ( select 1 from jtf_rs_resource_extns rs, jtf_rs_group_members gm, jtf_rs_groups_b gb, jtf_rs_group_usages gusg where rs.user_name = a.user_name and a.group_id is not null and gm.resource_id=rs.resource_id and gm.group_id=gb.group_id and gm.delete_flag = 'N' and gb.group_id = gusg.group_id and gusg.usage = 'CSM_MOBILE_USAGE' and trunc(gb.END_DATE_ACTIVE) < trunc(sysdate) ) or EXISTS ( select 1 from jtf_rs_resource_extns rs, jtf_rs_roles_b rb, jtf_rs_role_relations rr where rs.user_name = a.user_name and rr.role_resource_id=rs.resource_id and rr.role_resource_type='RS_INDIVIDUAL' and rr.delete_flag='N' and rb.role_id = rr.role_id and rb.role_type_code like 'CSM_MOBILE' and trunc(rr.END_DATE_ACTIVE) < trunc(sysdate) ) order by a.user_name
Invalid Users List: [<USERNAME>][<USERNAME>]
Deleting Invalid User: <USERNAME>
Checking for Unprocessed Data: SQL Command: select count(*) from MOBILEADMIN.c$inq where clid$$cs = :1
Deleting Invalid User: <USERNAME>
Checking for Unprocessed Data: SQL Command: select count(*) from MOBILEADMIN.c$inq where clid$$cs = :1
Error: Read returned -1
Exception in opening connection
User Deletion Error: <USERNAME> oracle.lite.web.resource.ResourceException: Java heap space
Obselete Users List: []
Done deleting invalid Users



The issue can be reproduced at will with the following steps:
1. Ran Manage Mobile User (MMU)  for nn users, 1 user failed,
2. Tried to end date and submit MMU to delete the user
3. Error occurs.

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.