Send your questions to appsdbauniverse@gmail.com

Wednesday, November 30, 2016

adstrtal.sh failing with Exception in thread "main" java.lang.NullPointerException


You are running adstrtal.sh version 120.24.12020000.11
Enter the WebLogic Server password:
The logfile for this session is located at /u01/applmgr/fs1/inst/apps/vis1_server1/logs/appl/admin/log/adstrtal.log
Exception in thread "main" java.lang.NullPointerException
        at oracle.apps.ad.autoconfig.ServiceControl$ServiceGroup.administerServiceGroup(ServiceControl.java:2616)
        at oracle.apps.ad.autoconfig.ServiceControl$ServiceGroup.access$000(ServiceControl.java:2264)
        at oracle.apps.ad.autoconfig.ServiceControl.<init>(ServiceControl.java:686)
        at oracle.apps.ad.autoconfig.ServiceControl.main(ServiceControl.java:2161)
adstrtal.sh: Exiting with status 1


** Fixing s_oaeaname, s_oaea_managed_servers with value oaea_server1 and run autoconfig fixes the issue


Before change:
            <oa_service_name oa_var="s_oaeaname" type="managed_server"/>
            <oa_service_status oa_var="s_oaeastatus">enabled</oa_service_status>
            <oa_managed_server_name oa_var="s_oaea_managed_servers"/>


After change:
            <oa_service_name oa_var="s_oaeaname" type="managed_server">oaea_server1</oa_service_name>
            <oa_service_status oa_var="s_oaeastatus">enabled</oa_service_status>
            <oa_managed_server_name oa_var="s_oaea_managed_servers">oaea_server1</oa_managed_server_name>

Workflow Notification mailer failing with Unable to make a connection with the user and responsibility

Status Information
This automatic Service Component has been restarted the maximum of 10 times after stopping with error. Thus, it has been system deactivated -> oracle.apps.fnd.cp.gsc.SvcComponentContainerException: Could not start component; performing rollback -> oracle.apps.fnd.cp.gsc.SvcComponentException: Validation failed for the following parameters -> {FRAMEWORK_USER=Unable to make a connection with the user and responsibility}.


SQL> select user_id,user_name from apps.fnd_user where user_name='SYSADMIN';
USER_ID USER_NAME
---------- -------------
  12345678 SYSADMIN


Someone have updated user_id of SYSADMIN to different value instead of 0. This is not allowed.


SQL> update apps.fnd_user set user_id=0 where user_name='SYSADMIN' and user_id='12345678';


1 row updated.


SQL> commit;


Commit complete.


SQL> select user_id,user_name from fnd_user_bkp where user_id=0;
USER_ID USER_NAME
---------- -------------
         0 SYSADMIN


Restart Workflow Notification mailer.