1 2 Previous Next 24 Replies Latest reply on Jan 3, 2020 12:10 PM by r0j Go to original post
      • 15. Re: vRO 7.4 is not logging workflow runs and complaining of Lucene60
        JonSaund Novice

        Thank you,

        Same problem and fix upgrading from 7.3.0 to 7.4 

        • 16. Re: vRO 7.4 is not logging workflow runs and complaining of Lucene60
          jstander Novice
          vExpert

          Hi experience the exact same problem after upgrading from vRO7.2 to 7.4.

          I was not getting any proper logging as well as debug logs in vRO client was not showing when i run a workflow.

           

          Deleting the files scripting.log_lucene and scripting.log_lucene1 through 5 seems to have fix the problem for me as well.

           

          Now however i see the following errors in the server.log file.

           

           

          2018-05-25 21:00:14.107+0000 [https-jsse-nio-0.0.0.0-8281-exec-10] ERROR {} [VcoFactoryServiceFacadeProxy] ch.dunes.util.DunesServerException: could not execute query; SQL [select vmologeven0_.id as id1_19_, vmologeven0_.logtimestamp as logtimes2_19_, vmologeven0_.longdescription as longdesc3_19_, vmologeven0_.originatorid as originat4_19_, vmologeven0_.originatortype as originat5_19_, vmologeven0_.originatoruri as originat6_19_, vmologeven0_.originatorusername as originat7_19_, vmologeven0_.severity as severity8_19_, vmologeven0_.shortdescription as shortdes9_19_ from vmo_logevent vmologeven0_ where vmologeven0_.originatorid=? and vmologeven0_.originatoruri=? and (lower(vmologeven0_.shortdescription) like ? or lower(vmologeven0_.longdescription) like ?) order by vmologeven0_.logtimestamp desc]; nested exception is org.hibernate.exception.SQLGrammarException: could not execute query

           

          2018-05-25 21:00:14.102+0000 [https-jsse-nio-0.0.0.0-8281-exec-10] WARN  {} [SqlExceptionHelper] SQL Error: 0, SQLState: 07009

          2018-05-25 21:00:14.102+0000 [https-jsse-nio-0.0.0.0-8281-exec-10] ERROR {} [SqlExceptionHelper] Invalid parameter index 5.

          2018-05-25 21:00:14.103+0000 [https-jsse-nio-0.0.0.0-8281-exec-10] ERROR {} [VcoDelegatingWebFacade] Server Error...

          • 17. Re: vRO 7.4 is not logging workflow runs and complaining of Lucene60
            iiliev Champion
            VMware EmployeesCommunity Warriors

            Basically, this error means the code which tries to execute this SQL query passes more parameters than expected. What kind of database do you use?

            • 18. Re: vRO 7.4 is not logging workflow runs and complaining of Lucene60
              jstander Novice
              vExpert

              Sorry for the late reponse.

              I am using an external standalone SQL 2012 SP2  (11.0.5058.0).

               

              Any idea on what might be causing this issue and how I can go about resolving it?

              Thanks

              • 19. Re: vRO 7.4 is not logging workflow runs and complaining of Lucene60
                AndreasDiemer Novice
                VMware Employees

                Had the same problem with external 7.3 and your solution fixed it

                 

                thx a lot iiliev

                • 20. Re: vRO 7.4 is not logging workflow runs and complaining of Lucene60
                  XModem Enthusiast

                  Wow, this truely saved the day for me. Can we make a KB article out of this already? Hot patch the installer to remove the lucene indexes?

                  • 22. Re: vRO 7.4 is not logging workflow runs and complaining of Lucene60
                    concord0007 Lurker
                    VMware Employees

                    I believe there are more into this issue . The workaround helped bringing back the logging however the Events Tab still throws Error "Error while loading : Error while fetching : null .

                     

                    Server.log is flooded with the following : 

                    2018-07-11 19:56:43.907+0000 [RollingLogFile-Thread] WARN {} [StubbornRetrier] Retry 1/3 failed because of: Lock held by this virtual machine: /storage/log/vmware/vco/app-server/scripting.log_lucene/write.lock

                     

                    Waiting update if rebooting the vRO appliance Fix the issue. 

                     

                    • 23. Re: vRO 7.4 is not logging workflow runs and complaining of Lucene60
                      Chakresh_HCSC Lurker

                      I had similar issue but error in logs is different that what is mentioned here. I have tried the same workaround which did not fix the issue.

                       

                      Error in catalina.out :

                       

                      log4j:WARN Unable to get write.lock:

                      org.apache.lucene.store.LockObtainFailedException: Lock held by another program: /storage/log/vmware/vco/app-server/scripting.log_lucene/write.lock

                              at org.apache.lucene.store.NativeFSLockFactory.obtainFSLock(NativeFSLockFactory.java:118)

                              at org.apache.lucene.store.FSLockFactory.obtainLock(FSLockFactory.java:41)

                              at org.apache.lucene.store.BaseDirectory.obtainLock(BaseDirectory.java:45)

                              at org.apache.lucene.index.IndexWriter.<init>(IndexWriter.java:776)

                              at com.vmware.o11n.service.logging.RollingLogFileAppender.initTry(RollingLogFileAppender.java:246)

                              at com.vmware.o11n.service.logging.RollingLogFileAppender.access$400(RollingLogFileAppender.java:42)

                              at com.vmware.o11n.service.logging.RollingLogFileAppender$2.call(RollingLogFileAppender.java:230)

                              at com.vmware.o11n.service.logging.RollingLogFileAppender$2.call(RollingLogFileAppender.java:227)

                              at ch.dunes.util.StubbornRetrier.retryAtAllCosts(StubbornRetrier.java:27)

                              at com.vmware.o11n.service.logging.RollingLogFileAppender.init(RollingLogFileAppender.java:227)

                              at com.vmware.o11n.service.logging.RollingLogFileAppender.access$300(RollingLogFileAppender.java:42)

                              at com.vmware.o11n.service.logging.RollingLogFileAppender$RollingLogRunnable.run(RollingLogFileAppender.java:162)

                              at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)

                              at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:308)

                       

                       

                      I could able to resolve this issue by rebooting faulty VRA/VRO appliance node.

                      • 24. Re: vRO 7.4 is not logging workflow runs and complaining of Lucene60
                        r0j Enthusiast

                        The above works for us as well... We have had this issue with every upgrade after 7.3, we are at 7.6.

                        1 2 Previous Next