Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

OBIEE 12c: Unable to write cache object with GUID path not found Error - While doing a count on a Se

Received Response
1
Views
1
Comments
min_kusak
min_kusak Rank 1 - Community Starter
edited Aug 13, 2024 5:57PM in Oracle Analytics Cloud and Server

Hi,

We have recently installed OBIEE 12.2.1.2.0 and have migrated artifacts from our BI 11g (11.1.1.7.0) install using "migration-tool.cmd" command.

In this migrated environment, when we try try to do a Count on the Segment Tree, it gives us below error:

Unable to write cache object with GUID "39e66fb0-0da8-1000-8029-ac1d05e40000" to web catalog.

Path not found (/system/mktgcache/SRVRNAME/39e66fb0-0da8-1000-8029-ac1d05e40000)

(SRVRNAME is our current server's name).

When we locate this path "/system/mktgcache/", we notice that a folder with name "SRVRNAME" does not even exist there.

When we migrate artifacts from 11g, shouldn't the migration process create this new "SRVRNAME" folder under path  "/system/mktgcache/" (if it needed it later)

At this path, we see other folders named as our old 11g machine.

BTW, we have already ran both "runcat.cmd -cmd validate c:/.../.../catalog" command, and "Scan and Update Catalog Objects That Require Updates" process to ensure that catalog is error free.

Any help on this is greatly appreciated.

Answers

  • min_kusak
    min_kusak Rank 1 - Community Starter

    Solution:

    1. Take a back up of full catalog using 7-Zip.

    2. Open Catalog Manager and connect to your server catalog online.

    3. Navigate to Catalog Root -> System Folders -> mktgcache

    4. Delete everything under "mktgcache" folder.

    5. While in "mktgcache" folder, right click in the Table pane, and create a new folder. Name the new folder exact same as the "SERVERNAME" folder was given in the original error.

    6. Close the Catalog Manager.

    Log back into OBIEE 12c, and you should be able to create and run a count on "Segment Tree".