8 Replies Latest reply: Nov 30, 2012 2:19 AM by user13114668 RSS

    work flow error in 11gR2

    user13114668
      hi experts
      following is error:
      Nov 29, 2012 7:39:15 PM PST> <Error> <org.quartz.impl.jdbcjobstore.JobStoreCMT> <BEA-000000> <MisfireHandler: Error handling misfires: Unexpected runtime exception: null
      org.quartz.JobPersistenceException: Unexpected runtime exception: null [See nested exception: java.lang.NullPointerException]
      at org.quartz.impl.jdbcjobstore.JobStoreSupport.doRecoverMisfires(JobStoreSupport.java:3042)
      at org.quartz.impl.jdbcjobstore.JobStoreSupport$MisfireHandler.manage(JobStoreSupport.java:3789)
      at org.quartz.impl.jdbcjobstore.JobStoreSupport$MisfireHandler.run(JobStoreSupport.java:3809)
      Caused By: java.lang.NullPointerException
      at org.quartz.SimpleTrigger.computeNumTimesFiredBetween(SimpleTrigger.java:800)
      at org.quartz.SimpleTrigger.updateAfterMisfire(SimpleTrigger.java:514)
      at org.quartz.impl.jdbcjobstore.JobStoreSupport.doUpdateOfMisfiredTrigger(JobStoreSupport.java:944)
      at org.quartz.impl.jdbcjobstore.JobStoreSupport.recoverMisfiredJobs(JobStoreSupport.java:898)
      at org.quartz.impl.jdbcjobstore.JobStoreSupport.doRecoverMisfires(JobStoreSupport.java:3029)
      at org.quartz.impl.jdbcjobstore.JobStoreSupport$MisfireHandler.manage(JobStoreSupport.java:3789)
      at org.quartz.impl.jdbcjobstore.JobStoreSupport$MisfireHandler.run(JobStoreSupport.java:3809)
        • 1. Re: work flow error in 11gR2
          Rajiv Dewan
          http://identityandaccessmanager.blogspot.com/2011/08/reconciliation-issue-misfirehandler.html
          • 2. Re: work flow error in 11gR2
            user13114668
            Hi Rajiv
            i have tried following:
            update QRTZ92_TRIGGERS set NEXT_FIRE_TIME=1 where NEXT_FIRE_TIME = -100000000;
            But it says table or view does not exist

            Thanks
            Harpreet
            • 3. Re: work flow error in 11gR2
              Nishith Nayan
              the table exist in R1 not sure if same table in R2. I would suggest login oimdb using developer or toad and diagnose the exact table name.
              • 4. Re: work flow error in 11gR2
                user13114668
                i am doing self registration and afte that request goes to manager.
                i open the manager identity slef service page
                go to pending request
                click on the request
                i get following in page thus pop up:

                his webpage is not available
                The webpage at https://identity.oracleads.com:14001/identity/faces/adf.task-flow?bpmWorklistTaskId=373350c4-85cf-4c30-8140-f2a211ec2177&bpmWorklistContext=682b3855-256c-43f2-a254-0f6acbf96180%3B%3BMfgO2%2Fn86OHSmIYCeEOoq0gc3m1FZpmwu43grTjQDYFvYzqsbOVO8SQZL6GygES3AcnxZPrL6CvTHCQoTMjSoVWH7BBR4lauiMQbeemdbUMJ4zAT1uWsmk9XXLOl7VRvCEVbLgYH3iRydnsclOD7sx8pd3TvK8uxK%2F6hDWn8JhJ7rcf07yCffareJSHrnDREFL71J1rBQroUoLqr7RxFi%2Fv9ZTTfngOQDLAV4VT9lGGC0A3W9z9LJCmWC7giQ0S3&bpmWorklistHttpURL=http%3A%2F%2Fidentity.oracleads.com%3A14000%2Fidentity%2Ffaces&bpmWorklistHome=home.jspx&bpmWorklistReassign=reassignTask.jspx&bpmWorklistRoute=routeTask.jspx&bpmWorklistRequestInfo=requestInfo.jspx&bpmWorklistSecurity=signTask.jspx&tz=US%2FPacific&lg=en&cy=US&vr=&dispNameLg=en&dispNameCy=US&dispNameVr=&df=medium&dt=both&tf=short&bpmWorklistSessionTimeoutInterval=2100&soaUrl=https%3A%2F%2Fidentity.oracleads.com%3A8002&bpmBrowserWindowStatus=taskFlowReturn&adf.tfDoc=%2FWEB-INF%2FApprovalTask_TaskFlow.xml&adf.tfId=ApprovalTask_TaskFlow&_task-flow-return=http%3A%2F%2Fidentity%2Ffaces%2Fadf.task-flow-return%3F_adf.ctrl-state%3Dheo99xoyb_145&_adf.winId=heo99xoyb_136&_afrLoop=5238709141528 might be temporarily down or it may have moved permanently to a new web address.
                • 5. Re: work flow error in 11gR2
                  user13114668
                  even after running Update QRTZ92_TRIGGERS set NEXT_FIRE_TIME=1 where NEXT_FIRE_TIME < 0;
                  i am getting same error
                  • 6. Re: work flow error in 11gR2
                    Nishith Nayan
                    have you restarted your machine after updating values in DB.

                    restart all the servers in this order Admin->OIM->SOA ( start soa only if OIM is up and running verify using weblogic admin console)
                    • 7. Re: work flow error in 11gR2
                      user13114668
                      getting same error even after re-starting the servers
                      • 8. Re: work flow error in 11gR2
                        user13114668
                        thanks a ton