Planning Analytics

Planning Analytics

Get AI-infused integrated business planning

 View Only
Back to discussions
Expand all | Collapse all

Unable to open connection to Database

  • 1.  Unable to open connection to Database

    Posted 03/11/24 02:40 PM

    Hi,

    I have been running a TI process with ODBC connection for a while but suddenly it has an issue with Database Connection.

    All looks good when the Host Server (Window 2019) try to connect to the Oracle Database (System DSN show successful connection)

    But when i try to connect database through the TI process, it shows the database connection issue. UserID and password for the database has no issue.

    When checked with my Database Administrator and Network team, there is no issue with Host server and Database server communication.

    Is there anything i need to check in TM1? or if anything i can ask my DB admin/Security team to look at? As i said the Driver setup show successful connection in Host server.

    We are using the TM1 Local version PAL-2.0.9.18

    Thanks

    Sudeep



    ------------------------------
    Sudeep Rimal
    ------------------------------


  • 2.  RE: Unable to open connection to Database

    Posted 03/11/24 03:30 PM

    Hi Sudeep,

    1- Perhaps re-input user and password in the DataSoiurce Tab of your TI Process ? (sometine password corrupted ....

    2- does the windows account under run TM1 service as changed ?

         this account can access to to ODBC DSN ?

    Regards,

    Philippe



    ------------------------------
    Philippe CHAMPLEBOUX
    ------------------------------



  • 3.  RE: Unable to open connection to Database

    Posted 03/11/24 05:04 PM

    Hi Philippe,

    Thanks for your quick response and suggestion,

    I tried reentering user and password. It is not helping out

    Also, the window account has not been changed for the TM1 service, it always Log in as 'Local System account.' 



    ------------------------------
    Sudeep Rimal
    ------------------------------

    Original Message


  • 4.  RE: Unable to open connection to Database

    Posted 03/12/24 03:48 AM

    Hi Sudeep, have you checked the Message Log for errors? Kind regards, Luc



    ------------------------------
    Luc Cusiel
    ------------------------------



  • 5.  RE: Unable to open connection to Database

    Posted 03/12/24 12:27 PM

    Hi Luc,

    Yes, i did, it just say 'Unable to open the data source'

    Error: Prolog procedure line (0): Unable to open data source "XXX".

    Sudeep



    ------------------------------
    Sudeep Rimal
    ------------------------------

    Original Message


  • 6.  RE: Unable to open connection to Database

    Posted 03/12/24 01:35 PM

    Here is more detail of the Log i got

    TM1.SQLAPI   E16) Cannot connect to ODBC data source "XXX"  SQLState: 08004 SQLMsg: [Oracle][ODBC][Ora]ORA-12154: TNS:could not resolve the connect identifier specified

    The DBA admin recently changed the TNS location as the ODBC manager in the host server. The ODBC manager then connected to the DB but the TM1 could not connect

    Could there be anything that i can look into TM1 



    ------------------------------
    Sudeep Rimal
    ------------------------------

    Original Message


  • 7.  RE: Unable to open connection to Database

    Posted 03/12/24 02:07 PM

    Several solution ...

    Can solve by tour dba 

    1- Create a "system" environement variable TNS_ADMIN wich contain the full directoryPath where file tnsnames.ora is.

      After restart your tm1 windows service

    2- Ask to your DBA to make something in your Server (where is TM1)  for averyone can connect using ODBC 

    Look at Configuring access to Oracle databases - IBM Documentation to have idea (In my opinion, just TNS_ADMIN is enough)

    Regards,

    Philippe



    ------------------------------
    Philippe CHAMPLEBOUX
    ------------------------------

    Original Message


  • 8.  RE: Unable to open connection to Database

    Posted 03/15/24 02:11 PM

    Tried all these options, No success!!



    ------------------------------
    Sudeep Rimal
    ------------------------------

    Original Message


  • 9.  RE: Unable to open connection to Database

    Posted 03/15/24 02:18 PM

    Run tnsping from command line, if that doesn't work, TM1 won't either. 
    tnsping <service_name or SID>

    If tnsping works, try sqlplus as well to make sure the username/password are correct. 
    sqlplus username/password@service_name



    ------------------------------
    JILL MACLAURIN
    ------------------------------

    Original Message


  • 10.  RE: Unable to open connection to Database

    Posted 03/15/24 03:57 PM

    The most likely cause for this is that the server is running as Local System whereas you're testing manually as a logged-in user (probably a local admin?).  Based on the error message it sounds like the Local System account can't even see the tnsnames.ora file.  Can you try setting up the TM1 server to run as a service account instead of Local System?  This is best practice anyway.



    ------------------------------
    Brian Simpson
    ------------------------------

    Original Message


  • 11.  RE: Unable to open connection to Database

    Posted 04/01/24 05:58 PM

    Thank you, Brian,

    Sorry, I was out vacation so could not reply on time. 

    you were right that providing the service account to the TM1 services worked. There was a change in the TNS location by the Network team recently. But before the location change the TM1 server was connecting to the database even without the Service account. Seems there has been a security update too.

    Thank you again,

    Sudeep  



    ------------------------------
    Sudeep Rimal
    ------------------------------

    Original Message


Related Content