Categories
Error while migrating dashboard
Hi All,
I was moving some objects across instances, and got the following error:
Just trying to sort out what the issue is. Any input appreciated.
OBIEE 11.1.1.9.x
Regards,
Charles
Answers
-
Hi,
Would be easier seeing the environment to figure out "who is what"
The objects you are migrating between environments, are they shared (in shared folders) or private objects (in your own personal folder) ?
Just from the message looks like it was using a shortcut pointing somewhere else in the catalog (which already is not a clean start as you believe you have an object while it is somewhere else in real). And that shortcut points to something you didn't migrate in the new environment.
So a side effect of having shortcuts as you have the impression you migrated the objects, while you are migrating a shortcut pointing to a not existing destination.
0 -
+1 to Gianni objects containing cross-references between main folders - especially between /shared and /users - are a major pain. You won't easily be able to move them with their dependecies...unless you move /root and hence the whole catalog or both /shared and /users at the same time.
Dependency analysis is something that's key there. And also user training: make sure you don't keep things in your private folder which you want to distribute.
0 -
Thanks Gianni (and,@Christian Berg). Your explanation makes sense .... and seems to fit what is going on here. I don't really use shortcuts and am really not that familiar with them. Not sure I get the point of their use
But, I think I found this object in our Dev instance (or, what is left of it):
Regards,
Charles
0 -
Charles M wrote:I don't really use shortcuts and am really not that familiar with them. Not sure I get the point of their use
That's good, don't change it
Shortcuts are really what their name is: shortcuts! Instead of doing things properly you can "cheat" and use a dirty quick-win by setting up a shortcut. It's like symbolic links in a file system: you have something expecting to find bunch of files in a folder which isn't located and/or named as expected? You can either move the objects for real with all the possible consequences (breaking something else etc.) or you can setup a shortcut which virtually create a connection between 2 places in the catalog.
When you have to move all the objects linked by a dashboard you would have to relink them all or do a search/replace to replace paths in the dashboard page. Here again creating a shortcut will act like if objects have never been moved.
But as Christian said, a shortcut in a shared folder pointing to a private folder content is really bad practice: what happen if that user leave the company and his profile is deleted and his personal folder dropped? You are back in the office the day after and a whole dashboard is empty, all the content is gone because it was a shortcut to the personal folder of the user.
0 -
Shortcuts make sense (otherwise they shouldn't be there) but definitely should be handled with care.
"/user"-stored content may seem to be available when HE/SHE is doing or modifying a dashboard since he/she is the owner of the objects and has exclusive access. As soon as somebody else looks at the dashboard it will look empty as Gianni said because nobody else has access. Not even "weblogic".
0 -
Hi Gianni, Christian,
I'll circle back to the recent updates. In the meantime, I wanted to ask/clarify one thing.
I took a look at the Dashboard and I can see that the page (Activity - Summary) in not there/no longer there. Is that what the issue is here?. Like, what is broken in the shortcut ... it point to something that isn't there?
See, only 4 page, but "summary" is not one of them:
Regards,
Charles
0 -
It can be the shortcut point to something which doesn't exist or permissions as well : if you don't have the right permissions you can't "see" that object representing the page.
0 -
Is it really no longer there as in physically deleted or is it not there as in you don't have access?
BEst would be to check with an admin account and also go directly to the file system and check what's written in the XML definition of the dashboard.
0 -
Hi Christian,
Turns out this is an admin account . My guess someone from the implementation-side of things (who also functioned as developers, as I recall). But, I do see there there is no object on the file system/catalog corresponding to to it (Activity - Summary).
/$INSTANCE_HOME/bifoundation/OracleBIPresentationServicesComponent/coreapplication_obips1/catalog/OracleBIApps/root/shared/***+bi+folder/_portal/financial+dashboard
> ls -l
total 44
-rw-r----- 1 applmgr applmgr 423 Oct 3 2018 activity.atr
-rw-r----- 1 applmgr applmgr 1288 Jul 26 2018 activity+-+detailed
-rw-r----- 1 applmgr applmgr 351 Oct 3 2018 activity+-+detailed.atr
-rw-r----- 1 applmgr applmgr 1250 Jul 26 2018 ap+activity
-rw-r----- 1 applmgr applmgr 343 Oct 3 2018 ap+activity.atr
-rw-r----- 1 applmgr applmgr 1272 Jul 26 2018 balances
-rw-r----- 1 applmgr applmgr 340 Oct 3 2018 balances.atr
-rw-r----- 1 applmgr applmgr 1985 Jul 26 2018 balances+summary
-rw-r----- 1 applmgr applmgr 336 Oct 3 2018 balances+summary.atr
-rw-r----- 1 applmgr applmgr 620 Jul 26 2018 dashboard+layout
-rw-r----- 1 applmgr applmgr 332 Oct 3 2018 dashboard+layout.atr
Regards,
Charles
0 -
It's there the 5th page, it's the shortcut.
"activity.atr" represent your shortcut and, based on your very first posted picture, the "Activity" shortcut points to a thing called "Activity - Summary".
0
