Categories
- All Categories
- Oracle Analytics Learning Hub
- 25 Oracle Analytics Sharing Center
- 17 Oracle Analytics Lounge
- 233 Oracle Analytics News
- 45 Oracle Analytics Videos
- 15.9K Oracle Analytics Forums
- 6.2K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 87 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Platform migration win -> Linux
Used this procedure for platform migration OBIEE 12.2.1.0 Win -> OL7 12.2.1.4
All steps below completed ok with no errors.
But when running user reports we get errors, i.e
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred
Not a lot of experience on OBIEE,
pls advise if below steps are correct ?
Thx,
reg peter
1.
Base install of Java / MW / BI
http://www.techanswersweb.com/installing-obiee-12c-version-12-2-1-4-0/
2.
New META db created
3.
rcu + config
http://www.techanswersweb.com/configuring-obiee-12c-version-12-2-1-4-0-rcu-component-configuration/
4.
Export import BAR file
importServiceInstance('/u01/app/oracle/product/12/middlewarehome/obiee/user_projects/domains/bi','ssi','/u01/app/oracle/product/12/middlewarehome/obiee/custom_exports/ssi.bar',true,true,true,'password')
5.
WLS export import users / security realm
Answers
-
Go into the logs and find the real reasons for the very generic error you see on screen.
Logs tells you everything...
0 -
What do the log files say? (Edit: didn't see Gianni's post)
0 -
Can't "find the table" !?
[nQSError: 27047] Tabell som inte finns: "Apoteksförsäljning".
Steps 4,5 above , maybe barfile import should be last step ?
If so, can barfile import command be re-run ?
reg peter
***************************
obis1/logs/obis1-diagnostic.log:
[2022-05-26T23:22:20.699+02:00] [OBIS] [ERROR:1] [] [] [ecid: bcd74f4d-9e49-4e15-92c6-0ee812c780aa-00016feb,0:1:54] [sik: ssi] [tid: 745ca700] [nQSError: 27047] Tabell som inte finns: "Apoteksförsäljning". [[
file: server/NQSNative/NQSServEntry/Source/NQSQueryDataType.cpp; line: 156
********** Task: 1. Running for (mls): 1 **********
Description: Execute Query
Repository Name: ssi
Catalog:
Tenant:
Tenant ID: ssi
Service Name:
User: TestApotek
Session ID: 0x71f80000
Request ID: 0x71f8000b
ProcedureID: 49
Logical SQL:
]]
0 -
I would first setup the authenticators and the whole security realm before to import the BAR, because if you import the security model of the BAR it will map groups to approles, and if your groups do not exist it will maybe not like it much.
Also another thing to do anyway, because it's jump between 4 versions from your .0 to .4 (and .0 was the first release with all the issues it could have), you have to go through the various checks: consistency check of the RPD etc.
0 -
Hi
ok, so best would be to migrate to a target with the same version ?
Another reflection, why not use the same metadata schema from old env in the new target (instead of creating new schemas with rcu) ?
reg peter
0 -
Are you asking us about your migration process? Because you are the one who decided on the process and the steps for the job, not us.
You can't use the the existing RCU schemas because you have mismatching versions.
0 -
Keeping it short: you can migrate content across versions and a change of OS, it does work.
Just don't expect anything to work directly with 2 clicks and no manual intervention: that is the idealistic case and only work with sample content (= no content more or less). In a real situation there is always something requiring some manual interventions to "help" the migration process.
0
