Announcement

Collapse
No announcement yet.

rates loaded only available after clear cache ?

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • rates loaded only available after clear cache ?

    Hi all,

    when i create rates via directsql (or upload them as csv), they will only be available for rating (RIQ, planning) in the UI after a "clear cache" on rateGeoCache or after opening them once in the UI (edit, finish, no changes). Does anyone know how to avoid clearing the cache so the rates are available immediatly ?

    Any hint is appretiated
    Thanks
    Oliver

  • #2
    Re: rates loaded only available after clear cache ?

    I faced the same issue several times. If we would have uploaded huge data then we have to restart the DB, so that cache will be cleared. Otherwise open the records from front end, so that OTM will consider those in planning. Oliver, pls let me know the solution if you get.

    Thanks & Regards,
    Lakshman
    Cheers,
    Murthy

    Comment


    • #3
      Re: rates loaded only available after clear cache ?

      Hi Laksham,

      did you try using the glog.webserver.cache.CacheDiagServlet to refresh only several parts instead of restarting the DB ? In my case its sufficient to refresh the "RateGeo" cache.

      Rgds
      Oliver

      Comment


      • #4
        Re: rates loaded only available after clear cache ?

        Originally posted by oliver View Post
        Hi Laksham,

        did you try using the glog.webserver.cache.CacheDiagServlet to refresh only several parts instead of restarting the DB ? In my case its sufficient to refresh the "RateGeo" cache.

        Rgds
        Oliver

        Hello All!
        We have the same issue, does anybody has a suggestion?

        Thank you!

        Comment


        • #5
          Re: rates loaded only available after clear cache ?

          Not sure but this might work. Try loading the rates with the AS.CSV format instead of CSV.

          Comment


          • #6
            Re: rates loaded only available after clear cache ?

            Hi,

            You can also clear the rate cache using the clearcache servlet:

            glog.webserver.processcontrol.ProcessServlet/?frame=TopicSpec&class=glog.server.workflow.adhoc. ClearCaches&topic=processControlLabel.Clear_Caches

            With your OTM's URL, append clearcache servlet and paste it in the browser and provide Username/Password.
            e.g.

            http://OTM62.com/GC3/glog.webserver....l.Clear_Caches

            Attached is the screensnap for more details

            Thank you


            -Prasad-
            Attached Files
            Let's connect on LinkedIn
            Mobile: +91 973 049 6886
            E-mail: [email protected]

            If my post was helpful, then click on the Like button

            Comment


            • #7
              Re: rates loaded only available after clear cache ?

              Hi, Daniel above is correct use AS.CSV's for them, AS.CSV updates the cache, CSV does not....

              Comment


              • #8
                Re: rates loaded only available after clear cache ?

                What are AS.CSV format, never used them. It will be really very helpful if anyone can please a sample file with this format.

                Comment


                • #9
                  Re: rates loaded only available after clear cache ?

                  Look for it at OTM Data Management Guide

                  Comment

                  Working...
                  X