OBIEE Killing the firewall on linux

I was trying to connect to the new SampleApp rpd on a remote machine and got this  error nqserror 12008 unable to connect to port 9703. The error says it all, port 9703 is blocked. First I killed the firewall on the linux VM (yep, the  security guy will beat me up tonight )

Open a terminal, make yourself root  > SU

next kill the firewall:

1. Stop the ipchains service. > # service ipchains stop
2. Stop the iptables service. > # service iptables stop
3. Stop the ipchains service from starting when you restart the server. > # chkconfig ipchains off
4. Stop the iptables service from starting when you restart the server. > # chkconfig iptables off

See: http://download.oracle.com/docs/cd/E19140-01/821-0908/p52.html

On all router in between I checked that port 9703 was open.

Now I could make a ODBC for my windows 7 machine to the sample app.

Till Next Time

OBIEE11g nQSError: 61007

I got this error after a power crash of the whole BI-system:

[nQSError: 61007] File error: path=//Nll-5614418/obiee_cache\NQS_CLUSTER_CACHE_SPACE.DES.LCK, code=80: Access is denied

The BI-server refused to start up. Reason it couldn’t create a new lock file for the shared cache. Solution: just drop the old file and start the BI-server.

Till Next Time

OBIEE Excel count distinct error

I have a simple Excel sheet imported into OBIEE:

If I do a count it works fine:

But if I do a count distinct I get an error:

Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 16001] ODBC error state: 37000 code: -3100 message: [Microsoft][ODBC Excel Driver] Syntax error (missing operator) in query expression 'count(distinct T2207.[F_LETTER])'.. [nQSError: 16014] SQL statement preparation failed. (HY000)

This is causes by the fact that Microsoft Excel doesn't know the "COUNT DISTINCT" command.

You can fix this by deselecting the count distinct feature in the database properties:

Now it works perfect:

Till next time

OBIEE nQSError

Sometime you get these strange error codes. For OBIEE there isn't a "real" error messages guide. But there is still one for the "old" Siebel:

http://download.oracle.com/otndocs/products/bi/bi-ee/docs/784/AnyMsg.pdf

Get your own copy while it's still there.

Till Next Time