problems with action links, presentation variables, subject area aliases v 12.2.1.3

Question

Applied OBI BUNDLE PATCH 12.2.1.3.171218

Straight basic installation

Looking for the best way to diagnose where my problems might be:

1) Action links stop working with path not found even though nothing has changed

2) Subject Area aliases are not working; after renaming a subject area; editing report shows subject area not available

3) presentation variables not persistent across multiple reports on a tab; using same where clauses; first report shows correct filter value; subsequent reports reference default session value instead of presentation value

Thanks for any insights!

Bill S3 · Answer

Thanks for the feedback.  I had done a catalog integrity check and everything looked good there.  I've also been monitoring the saw log.  I've been seeing some  errors and been tracking them down 1 by 1...

1) sawlog errors

a) an error occurred during execution of "send". Broken pipe ETI2U8FA

b) An error occurred during execution of "send". Connection reset by peer

c) Client no longer there

d) Assertion failure: !rServiceContext.isEmpty() at line 286 of project/webcatalog/coprivilegemap.cpp

e) Files are being created in the past. The NFS mounted File System server system time and the OBIPS server system time are off by more than 1 seconds.  This can lead to undefined behaviour in OBIPS.  Please see your system administrator to ensure the clocks are synchronized.  (There is a note about this on Oracle support that says it's a non issue)

f) Worker thread job errored out. /u01/app/obi/config/user_projects/domains/bi/bidata/service_instances/ssi/metadata/content/catalog/root/system/checkforclockskew.844a71e91e47ecff could not be accessed.

Error Codes: OTTZ6R57

g) Assertion failure: nTargetColumn < vCompiledColumns.size() at line 1274 of project/webreport/filterexprsqlvisitor.cpp; RSP: o:viewpreview~r:report ;HttpCommand: AnswersGetView

2) Yea, the rpd had the alias and everything looked fine

3) Thanks; I'll check that out!

Joel Acha · Answer

Regarding your 1st issue, do the presentation services log files indicate anything? Any errors in there?

Your 2nd issue, do you see the alias in the Admin Tool? Again, do the presentation services log files indicate anything? Any errors in there?

Regarding your 3rd issue, I think it might be related to this:  which I believe you can find the fix here - Oracle Support Document 2338889.1 (OBIEE 12.2.1.X Reports and Dashboards Using Dynamic Repository Variables Not Refreshing and Showing Incorrect Data )