Product: Aqua Data Studio
Version: 17.0.3-26
Build #: 49297
Build Date: 2016-Apr-08 03:25:32 PM
Operating Environment: Windows 8.1 (6.3, amd64) / Cp1252 / en / IN / Oracle Corporation 1.8.0_73-b02
Memory: Max=704,643,072; Total=503,840,768; Free=266,090,312; CPUs=8
//Create a table "USER_COUNT"
CREATE TABLE "USER_COUNT" (
"NUMBER_OF_USERS" NUMBER(4) NULL,
"TIME_OF_DAY" TIMESTAMP(6) NULL
)
TABLESPACE "USERS" NOCOMPRESS PCTFREE 10 INITRANS 1 MAXTRANS 255
STORAGE( BUFFER_POOL DEFAULT )
NOPARALLEL
LOGGING
NOCACHE
MONITORING
NOROWDEPENDENCIES
DISABLE ROW MOVEMENT
GO
//Create a procedure "INSERT_USER_COUNT"
CREATE PROCEDURE "INSERT_USER_COUNT" AS
v_user_count NUMBER(4);
BEGIN
SELECT count(*)
INTO v_user_count
FROM v$session
WHERE username IS NOT NULL;
INSERT INTO user_count
VALUES (v_user_count, systimestamp);
commit;
END insert_user_count;
GO
//Create below Job "INSERT_USER_COUNT"
BEGIN
sys.dbms_scheduler.create_job
(
job_name => '"C##DB_LEFT"."MY_USER_COUNT_JOB"',
program_name => 'C##DB_LEFT.PROG_INSERT_USER_COUNT',
schedule_name => 'C##DB_LEFT.MY_WEEKEND_5MIN_SCHEDULE',
job_class => 'DEFAULT_JOB_CLASS',
auto_drop => TRUE,
enabled => FALSE
);
sys.dbms_scheduler.set_attribute(name=> '"C##DB_LEFT"."MY_USER_COUNT_JOB"', attribute => 'job_priority', value =>3);
sys.dbms_scheduler.set_attribute(name=> '"C##DB_LEFT"."MY_USER_COUNT_JOB"', attribute => 'max_runs', value =>0);
sys.dbms_scheduler.set_attribute(name=> '"C##DB_LEFT"."MY_USER_COUNT_JOB"', attribute => 'max_failures', value =>0);
sys.dbms_scheduler.set_attribute(name=> '"C##DB_LEFT"."MY_USER_COUNT_JOB"', attribute => 'logging_level', value =>DBMS_SCHEDULER.LOGGING_OFF);
sys.dbms_scheduler.set_attribute(name=> '"C##DB_LEFT"."MY_USER_COUNT_JOB"', attribute => 'job_weight', value =>1);
sys.dbms_scheduler.set_attribute(name=> '"C##DB_LEFT"."MY_USER_COUNT_JOB"', attribute => 'instance_stickiness', value =>TRUE);
sys.dbms_scheduler.set_attribute(name=> '"C##DB_LEFT"."MY_USER_COUNT_JOB"', attribute => 'restartable', value =>FALSE);
sys.dbms_scheduler.set_attribute(name=> '"C##DB_LEFT"."MY_USER_COUNT_JOB"', attribute => 'stop_on_window_close', value =>FALSE);
END;
GO
---------------------------------------------------------------------------------------------------------------------------------------------
Now,
-
Connect go to DBA Tools--->Instance Manager-->Jobs-->"MY_USER_COUNT_JOB".
-
Right click on "MY_USER_COUNT_JOB" ,select Alter Job or Job Properties.
Observation:
NPE is observed when we right click and select "Alter Job"
Exception:
java.lang.NullPointerException
at \\.\\.\\??ñçêC???????\\.B????void.cH(Unknown Source)
at \\.\\.\\??ñçêC???????\\.k????.cH(Unknown Source)
at \\.\\.\\??ñçêC???????\\.k????.initComponents(Unknown Source)
at \\.\\.\\??ñçêC???????\\.k????.c(Unknown Source)
at \\.\\.\\??ñçêC???????\\.k????.b(Unknown Source)
at \\.\\.\\??ñçêC???????\\.Z????implements.bK(Unknown Source)
at \\.\\.\\??ñçêC???????\\.v????.success(Unknown Source)
at com.common.ui.util.BackgroundThread$1.run(Unknown Source)
at java.awt.event.InvocationEvent.dispatch(Unknown Source)
at java.awt.EventQueue.dispatchEventImpl(Unknown Source)
at java.awt.EventQueue.access$500(Unknown Source)
at java.awt.EventQueue$3.run(Unknown Source)
at java.awt.EventQueue$3.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(Unknown Source)
at java.awt.EventQueue.dispatchEvent(Unknown Source)
at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.run(Unknown Source)
When no schedule type was getting set for the job and then the user tries to alter the job a NPE was been thrown on the type check. This will no longer occur... Issue has exists since 2007
Revision: 14379