Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 16 Oracle Analytics Lounge
- 216 Oracle Analytics News
- 43 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 79 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
OBIEE 12C Analytics page not opening after migration from 11G
Dear All,
OBIEE 12C Analytics page not opening after migration from 11G.
I have migrated from 11g to 12c using miration tool.
i am able to login to enterprise manager and console.
When trying to login to analytics with the same username(weblogic) i am getting an error message authentication failed.
kindly help me.
Regards,
Prasad.
Answers
-
As always: have you had any look at the log files? What do they say? Referencing another thread doesn't really help.
Have you done any analysis into what the source of the issue could be? Like for example using the approach outlined here:
Without proper root cause analysis you'll just stumble around trying out random things that people throw at you.
0 -
Dear Christian,
I am able to login to bi analytics before migration.
After migrating from 11g to 12c, i am unable to login to analytics. But i am able to login to em and console.
Weblogic has only bi-Administrator role assigned to it . Added bi-consumer and bu-author roles as well.
i have gone through this thread as well,
OBIEE 12C Analytics page not opening after migration from 11G
I can't see much help from the log files.
0 -
Have you even looked at the advisory webcast?! You're just repeating your original post.
0 -
Dear Christian,
Help me to find the exact location for the log file.
Please suggest me the work arounds , i will do that and will post a screenshot if required.
0 -
Dear Christian,
The log file errors are as follows
1.
[2016-06-18T19:51:35.823-07:00] [OBIS] [ERROR:1] [] [] [ecid: ] [sik: ssi] [tid: 16e4] [nQSError: 36001] Unable to load the dll ttclient1122.dll. [[
file: server\Query\Execution\DbGateway\DbGatewayTimesten35\..\DbGatewayTimesten\SQXDGTimestenLoader.cpp; line: 844
The specified module could not be found.
]]
[2016-06-18T19:52:35.353-07:00] [OBIS] [ERROR:1] [] [] [ecid: ] [sik: ssi] [tid: 16e4] [nQSError: 36001] Unable to load the dll ttclient1122.dll. [[
file: server\Query\Execution\DbGateway\DbGatewayTimesten\SQXDGTimestenLoader.cpp; line: 844
The specified module could not be found.
2.
[2016-06-18T23:26:55.953-07:00] [OBIS] [ERROR:1] [] [] [ecid: ] [sik: ssi] [tid: 448] [nQSError: 17014] Could not connect to Oracle database. [[
file: server\Query\Execution\DbGateway\Oci10g\..\Oci8\Src\SQXDGOci8.cpp; line: 401
Properties: description=SessionVar Exchange; producerID=0x62250008; requestID=0xfffe00f8; sessionID=0xfffe0000; userName=test;
[nQSError: 17001] Oracle Error code: 12154, message: ORA-12154: TNS:could not resolve the connect identifier specified
at OCI call OCIServerAttach.
********** Task: 1. Running for (mls): 18250 **********
Description: DB Connect
DSN: BIDEVDB; userName=BISAMPLE
********** Task: 2. Running for (mls): 18250 **********
Description: SessionVar GatewayDbGateway Prepare
DSN:InitBlock CP
User Name:BISAMPLE
SQL:SELECT '15-DEC-2010' FROM DUAL
********** Task: 3. Running for (mls): 18250 **********
Description: Producer Executing Query
Repository Name:ssi;Subject Area Name:;User Name:test
]]
3.
####<Jun 18, 2016 3:48:38 AM PDT> <Warning> <oracle.biee.search> <BITEST> <bi_server1> <Thread-70> <<anonymous>> <> <c78dcde0-f69c-410c-bfba-410fd650f6d1-0000000b> <1466246918831> <[severity-value: 16] [rid: 0:1813] [partition-id: 0] [partition-name: DOMAIN] > <BEA-000000> <Archival failed
java.io.IOException: Unable to delete file:
\Oracle\Middleware\Oracle_Home\user_projects\domains\bi\bidata\components\bisearch\webcat\ssi\en\1466073234193\wc_data\_1.cfsat org.apache.commons.io.FileUtils.forceDelete(FileUtils.java:2279)
at org.apache.commons.io.FileUtils.cleanDirectory(FileUtils.java:1653)
at org.apache.commons.io.FileUtils.deleteDirectory(FileUtils.java:1535)
at org.apache.commons.io.FileUtils.forceDelete(FileUtils.java:2270)
at org.apache.commons.io.FileUtils.cleanDirectory(FileUtils.java:1653)
at org.apache.commons.io.FileUtils.deleteDirectory(FileUtils.java:1535)
at oracle.biee.search.services.crawl.lucene.index.lifecycle.IndexFileUtil.delete(IndexFileUtil.java:41)
at oracle.biee.search.services.crawl.lucene.index.lifecycle.IndexLifecyclePolicy.moveLastIndexToArchive(IndexLifecyclePolicy.java:184)
at oracle.biee.search.services.crawl.lucene.index.lifecycle.IndexLifecyclePolicy.moveOldestIndexToArchive(IndexLifecyclePolicy.java:162)
at oracle.biee.search.services.crawl.lucene.index.lifecycle.IndexLifecyclePolicy.applyPolicy(IndexLifecyclePolicy.java:67)
at oracle.biee.search.services.crawl.lucene.BIWebCatalogLuceneIndexDirectory.applyPolicyWhenNoReferences(BIWebCatalogLuceneIndexDirectory.java:413)
at oracle.biee.search.services.crawl.lucene.BIWebCatalogLuceneIndexDirectory.access$400(BIWebCatalogLuceneIndexDirectory.java:31)
at oracle.biee.search.services.crawl.lucene.BIWebCatalogLuceneIndexDirectory$RefQueuePoller.run(BIWebCatalogLuceneIndexDirectory.java:469)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:308)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:180)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:294)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:745)
0 -
[2016-06-15T04:41:23.510-07:00] [AdminServer] [WARNING] [] [org.apache.myfaces.trinidad.component.UIXCollection] [tid: [ACTIVE].ExecuteThread: '39' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: weblogic] [ecid: cef18398-d13c-48ac-9322-c621145f6221-00000127,0] [APP: em] [partition-name: DOMAIN] [tenant-name: GLOBAL] [DSID: 0000LLJpTyS8Tss6wjYfMG1NOJmR000002] The row key or row index of a UIXCollection component is being changed outside of the components context. Changing the key or index of a collection when the collection is not currently being visited, invoked on, broadcasting an event or processing a lifecycle method, is not valid. Data corruption and errors may result from this call. Turn on fine level logging for a stack trace of this call. Component ID: {0}
[2016-06-15T04:41:23.510-07:00] [AdminServer] [WARNING] [] [org.apache.myfaces.trinidad.component.UIXCollection] [tid: [ACTIVE].ExecuteThread: '39' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: weblogic] [ecid: cef18398-d13c-48ac-9322-c621145f6221-00000127,0] [APP: em] [partition-name: DOMAIN] [tenant-name: GLOBAL] [DSID: 0000LLJpTyS8Tss6wjYfMG1NOJmR000002] The row key or row index of a UIXCollection component is being changed outside of the components context. Changing the key or index of a collection when the collection is not currently being visited, invoked on, broadcasting an event or processing a lifecycle method, is not valid. Data corruption and errors may result from this call. Turn on fine level logging for a stack trace of this call. Component ID: {0}
0