Hi Friends,
One error which i recently faced and its solutions is below ..
OBIEE 11g Error: NQS 46028 Unable to get the DLL path for the CLI 10g/11g from the NQSConfig.ini file
Where:- when connecting to datasources from Rpd(importing meta data) or trying to view data from rpd.
what Happens:- BI system will not allow you to logged in into the system.
Solutiuons:-
1) Copied the ‘tnsnames.ora’ from Oracle DB path “E:\OraDeba11gR2\product\11.2.0\dbhome_1\NETWORK\ADMIN” to “E:\OraFMW11g\Oracle_BI1\network\admin” doesn’t resolves the issue fully .
2) Create a Environment System variable in windows advanced option of system properties called as ORACLE_INSTANCE and set the value as ‘E:\OraFMW11g\instances\instance1′ (without quote) .
3) Use absolute connection pool information to RPD or if the VALUEOF has been used just need to make sure that it will match exactly with the tnsnames.ora configuration . (having same value for SID or SERVICE_NAME will be fine in some cases)
ORADEBA =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = Oradeba)
)
)
4) Restart the BI Server .
One error which i recently faced and its solutions is below ..
OBIEE 11g Error: NQS 46028 Unable to get the DLL path for the CLI 10g/11g from the NQSConfig.ini file
Where:- when connecting to datasources from Rpd(importing meta data) or trying to view data from rpd.
what Happens:- BI system will not allow you to logged in into the system.
Solutiuons:-
1) Copied the ‘tnsnames.ora’ from Oracle DB path “E:\OraDeba11gR2\product\11.2.0\dbhome_1\NETWORK\ADMIN” to “E:\OraFMW11g\Oracle_BI1\network\admin” doesn’t resolves the issue fully .
2) Create a Environment System variable in windows advanced option of system properties called as ORACLE_INSTANCE and set the value as ‘E:\OraFMW11g\instances\instance1′ (without quote) .
3) Use absolute connection pool information to RPD or if the VALUEOF has been used just need to make sure that it will match exactly with the tnsnames.ora configuration . (having same value for SID or SERVICE_NAME will be fine in some cases)
ORADEBA =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = Oradeba)
)
)
4) Restart the BI Server .
No comments:
Post a Comment