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

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

Platform migration win -> Linux

user5806200

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

Base install of Java / MW / BI

http://www.techanswersweb.com/installing-obiee-12c-version-12-2-1-4-0/

New META db created

rcu + config

http://www.techanswersweb.com/configuring-obiee-12c-version-12-2-1-4-0-rcu-component-configuration/

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')

WLS export import users / security realm

Find more posts tagged with

Accepted answers

All comments

Gianni Ceresa

Go into the logs and find the real reasons for the very generic error you see on screen.

Logs tells you everything...

[Deleted User]

What do the log files say? (Edit: didn't see Gianni's post)

user5806200

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:

]]

Gianni Ceresa

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.

user5806200

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

Gianni Ceresa

https://community.oracle.com/tech/apps-infra/discussion/comment/16837236#Comment_16837236

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.

Gianni Ceresa

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.