BO Error - Connection or SQL sentence error (DA0005)

[Former Member]

Hi All,

I am facing an issue while connecting to BO -

Connection or SQL sentence error (DA0005)

Exception: DBD, ORA-12170: TNS:Connect timeout occuredState: N/A

Funny thing is, this error occurs on some machines, whereas on some it does not. There, BO works pretty smooth. We tried exchanging the TNS files between machines, tried matching the firewall rules, but nothing works.

Any ideas on why this is happening? Thanks a lot in advance!

Cheers,

Akshay

[Former Member]

Our issue seems very similar to yours. The errors we have are:

Connection or SQL sentence error (DA0005). Unable to create connection.

or

A connection required to refresh this document is unavailable (DA0004)

or

Cannot open file due to unknown error (FRM0007)

I've tried lots of posts on google but couldn't find proper solution.

Desperately looking for help as the users are just not able to work with this kind of errors

and there's still time for us to commence the upgrade.

Wondering what's your environment. Ours as below:

BOXI R2 sp6

Database: Oracle 11g