SYMPTOM:
When attempting to connect to a 9.x and 10.x Oracle metadata in 3-tier from a Linux machine, the following error may occur:
Sample Code/Error
2011-11-14 13:19:32.863+02:00 Failed to connect to data source. Error message: Connect failed. Unable to connect.
Error type: System call error. Error communicating with connection process. Child Process hung: Command ConnectionConnectWithNewParameters. The target data source hasn't responded to the Connect request after 300 seconds. It may be stressed. Connection String: DSN=TMPDSN_1321269243091;UID=MSTRMD;. SQL Statement: Connect.
The user is able to access the same metadata in 2-tier from the Linux server or from a Windows machine.
CAUSE:
This issue is caused by the password for the Intelligence Server user on the Oracle database entering the so-called 'grace period', instigated shortly prior to its expiry.
ACTION:
This issue may be addressed by requsting that the database administrator edit the profile of the Intelligence Server user on the Oracle database to modify the password.
Strategy will continue to investigate and post updates as soon as they are available.
An enhancement request has been logged for the error message thrown to be amended, so as to be more explicit with regard to the cause of this issue.
Third Party Software Installation:
WARNING:
The third-party product(s) discussed in this technical note is manufactured by vendors independent of Strategy. Strategy makes no warranty, express, implied or otherwise, regarding this product, including its performance or reliability.
