Today just a quick post about a problem with the taks execution of scheduled ICCSAP archiving tasks in Content Navigator.

IBM Content Navigator record each task execution in the TASK_EXREC table of you Content Navigator configuration database. In an ICCSAP archiving scenario where many scheduled task are running in the system this table can increase rapidly. In the specfiic case we had nearly 3.5 million entries in this table. Which cause the new scheduled task to crash. In the SystemOut.log of the ICN WebSphere server instance we could see this error.

Throwable occurred: org.apache.openjpa.util.MetaDataException: The type “class com.ibm.ecm.task.entities.ApplicationLock” has not been enhanced.
at org.apache.openjpa.meta.ClassMetaData.resolveMeta(ClassMetaData.java:1834)
at org.apache.openjpa.meta.ClassMetaData.resolve(ClassMetaData.java:1808)
at org.apache.openjpa.meta.MetaDataRepository.processBuffer(MetaDataRepository.java:828)
at org.apache.openjpa.meta.MetaDataRepository.resolveMeta(MetaDataRepository.java:725)
at org.apache.openjpa.meta.MetaDataRepository.resolve(MetaDataRepository.java:649)
at org.apache.openjpa.meta.MetaDataRepository.getMetaDataInternal(MetaDataRepository.java:417)
at org.apache.openjpa.meta.MetaDataRepository.getMetaData(MetaDataRepository.java:388)
at org.apache.openjpa.persistence.meta.MetamodelImpl.(MetamodelImpl.java:85)
at org.apache.openjpa.persistence.EntityManagerFactoryImpl.getMetamodel(EntityManagerFactoryImpl.java:350)
at org.apache.openjpa.persistence.EntityManagerFactoryImpl.getCriteriaBuilder(EntityManagerFactoryImpl.java:334)
at org.apache.openjpa.persistence.EntityManagerImpl.getCriteriaBuilder(EntityManagerImpl.java:1664)
at org.apache.openjpa.persistence.EntityManagerImpl.getCriteriaBuilder(EntityManagerImpl.java:102)
at com.ibm.ecm.task.entities.controller.EntitiesMediator.getAllActiveCalendarTasks(EntitiesMediator.java:1761)
at com.ibm.ecm.task.TimerChecker.timerExpired(TimerChecker.java:44)
at com.ibm.ws.asynchbeans.timer.TimerImpl.callListenerMethod(TimerImpl.java:361)
at com.ibm.ws.asynchbeans.timer.GenericTimer.run(GenericTimer.java:228)
at com.ibm.ws.asynchbeans.J2EEContext$RunProxy.run(J2EEContext.java:267)
at java.security.AccessController.doPrivileged(AccessController.java:424)
at javax.security.auth.Subject.doAs(Subject.java:495)
at com.ibm.websphere.security.auth.WSSubject.doAs(WSSubject.java:133)
at com.ibm.websphere.security.auth.WSSubject.doAs(WSSubject.java:91)
at com.ibm.ws.asynchbeans.J2EEContext$DoAsProxy.run(J2EEContext.java:338)
at java.security.AccessController.doPrivileged(AccessController.java:453)
at com.ibm.ws.asynchbeans.J2EEContext.run(J2EEContext.java:1174)
at com.ibm.ws.asynchbeans.timer.TimerImpl.runListenerAsCJWork(TimerImpl.java:490)
at com.ibm.ws.asynchbeans.am._Alarm.fireAlarm(_Alarm.java:340)
at com.ibm.ws.asynchbeans.am._Alarm.run(_Alarm.java:237)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1881)
[10/11/20 17:04:55:959 CEST] 0000006e SystemErr R Oct 11, 2020 5:04:55 PM TimerChecker timerExpired

So it seems that some kind of timeout occurs and the task is failing. The only solution was to clear the TASK_EXREC and TASKAUDIT table. After we reduced the amount of data in the table the taskmanager continues without problems running the schedules tasks.

So at this point we decided to create some maintenance tasks for our Content Navigator configuration database to prevent this in the future, as there is no out of the box housekeeping job provided by Content Navigator at the moment.

52 thoughts on “IBM Content Navigator – Execution of scheduled task fails due to large execution table

  1. It’s going to be finish of mine day, however before end I am reading this
    impressive article to increase my experience.

  2. Thanks for your marvelous posting! I genuinely enjoyed reading
    it, you happen to be a great author. I will be sure to bookmark
    your blog and definitely will come back at some point.
    I want to encourage you to ultimately continue
    your great writing, have a nice weekend!

  3. We absolutely love your blog and find nearly all of your post’s to be just what I’m looking
    for. Does one offer guest writers to write
    content available for you? I wouldn’t mind creating a post or elaborating on some of the subjects you write regarding here.
    Again, awesome website!

  4. Hmm is anyone else encountering problems with the pictures on this blog loading?

    I’m trying to find out if its a problem on my end or if
    it’s the blog. Any feed-back would be greatly appreciated.

  5. Hello! I could have sworn I’ve visited this site before
    but after looking at many of the articles I
    realized it’s new to me. Anyways, I’m definitely delighted I
    stumbled upon it and I’ll be bookmarking it and checking
    back frequently!

  6. Hello, i feel that i noticed you visited my weblog so i got here to return the prefer?.I am attempting to find things to improve my site!I assume
    its adequate to use a few of your ideas!!

  7. Hello my friend! I wish to say that this post is awesome, nice written and come with approximately all vital
    infos. I’d like to peer extra posts like this .

  8. Hello! Someone in my Myspace group shared this website with us so I came to check it out.
    I’m definitely enjoying the information. I’m book-marking and will be
    tweeting this to my followers! Terrific blog
    and fantastic design.

  9. I don’t even know how I ended up here, but I thought this
    post was great. I do not know who you are but definitely you are going to a famous blogger if you
    are not already 😉 Cheers!

  10. Howdy just wanted to give you a brief heads
    up and let you know a few of the pictures aren’t loading properly.
    I’m not sure why but I think its a linking issue. I’ve tried it in two different internet browsers and both show the same
    outcome.

  11. It is in reality a nice and helpful piece of information. I’m satisfied that you simply
    shared this helpful info with us. Please keep us informed like this.
    Thanks for sharing.

  12. Olá. Estive lendo seu web site por muito tempo
    e agora, finalmente, criei bravura para ir em frente e dar meu ponta pé inicial no meu negócio .
    Só queria dizer muito obrigado por ter escrito este material.

  13. Thanks for the good writeup. It actually used to be a leisure
    account it. Glance complex to more delivered agreeable from
    you! However, how can we be in contact?

  14. I don’t know whether it’s just me or if perhaps everybody else experiencing
    issues with your site. It appears as if some of the written text in your content are running off the screen. Can someone else please provide feedback and let me know if this is happening to them as well?

    This could be a problem with my browser because I’ve had this happen before.
    Kudos

  15. I think what you composed made a great deal of sense.
    But, what about this? suppose you typed a catchier title?
    I mean, I don’t wish to tell you how to run your blog, however suppose you added a title to
    possibly get people’s attention? I mean IBM Content Navigator – Execution of scheduled task fails due to large
    execution table – justECM is a little boring.
    You ought to glance at Yahoo’s home page and note how they create
    article headlines to grab people to click. You might add a related video or a related picture
    or two to grab readers excited about what you’ve got to say.
    Just my opinion, it would make your posts a little bit more interesting.

  16. Thank you, I’ve just been looking for info approximately this subject for a long time and yours is the greatest I have came upon till now.
    However, what concerning the conclusion? Are you positive
    concerning the source?

  17. Everything is very open with a really clear explanation of the
    issues. It was truly informative. Your website is extremely helpful.
    Many thanks for sharing!

  18. This is very interesting, You’re a very skilled blogger. I’ve joined your feed
    and look forward to seeking more of your fantastic post.
    Also, I’ve shared your web site in my social networks!

  19. My brother recommended I might like this website. He was
    totally right. This post truly made my day. You can not
    imagine just how much time I had spent for this info!

    Thanks!

  20. Have you ever thought about adding a little bit more than just your articles?

    I mean, what you say is important and everything.
    Nevertheless think about if you added some great graphics or videos to
    give your posts more, “pop”! Your content is excellent but with
    images and videos, this website could definitely be one of
    the most beneficial in its field. Excellent blog!

  21. Heya i am for the first time here. I came across this board and I find It truly useful & it helped me out a lot.
    I hope to give something back and help others like you aided me.

  22. Can I simply just say what a relief to find an individual who truly knows what they are talking about on the web.
    You definitely know how to bring a problem to light and make it important.
    More people have to look at this and understand this side of the story.
    I was surprised that you’re not more popular since you
    definitely possess the gift.

  23. Hello to every body, it’s my first pay a quick visit of this blog;
    this webpage contains amazing and in fact good data designed for readers.

  24. I was wondering if you ever considered changing the page layout of your website?
    Its very well written; I love what youve got
    to say. But maybe you could a little more in the way of content so people could connect with it better.
    Youve got an awful lot of text for only having 1 or 2 images.
    Maybe you could space it out better?

  25. Hey there! Do you use Twitter? I’d like to follow you if that would be okay.
    I’m absolutely enjoying your blog and look forward to new
    posts.

  26. I blog frequently and I really thank you for your information. This article has really peaked my interest.
    I am going to book mark your site and keep checking for new details about once per week.

    I subscribed to your RSS feed too.

  27. An outstanding share! I’ve just forwarded this onto a co-worker who has been doing a little homework on this.

    And he actually ordered me breakfast because I discovered it for him…
    lol. So let me reword this…. Thanks for the meal!! But yeah, thanx for spending some
    time to discuss this topic here on your web page.

  28. Hi! I could have sworn I’ve been to this website before but after checking through
    some of the post I realized it’s new to me. Anyhow, I’m definitely happy I found it and I’ll be book-marking and checking back often!

  29. We’re a group of volunteers and starting a new scheme in our community.
    Your website offered us with valuable information to work on. You’ve done an impressive job and our whole community will be
    grateful to you.

  30. No matter if some one searches for his required thing, thus he/she wishes to be available that in detail, so that thing is maintained over here.

  31. Spot on with this write-up, I actually think this web site needs far more attention. I’ll probably
    be returning to read more, thanks for the info!

  32. Great post. Articles that have meaningful and insightful comments are more enjoyable, at least to me. It’s interesting to read what other people thought and how it relates to them or their clients, as their perspective could possibly help you in the future.

Leave a Reply

Your email address will not be published.