Forum Discussion

MadeshK's avatar
MadeshK
New Contributor
2 days ago

SQL Table Editor on External Connection

We are trying to update a table in External DB using SQL table editor. But we are getting below error.

 

5 Replies

  • JJones's avatar
    JJones
    Icon for OneStream Employee rankOneStream Employee

    What version of OneStream are you using?  

  • DanielWillis's avatar
    DanielWillis
    Valued Contributor

    This is all you get in the OS interface which can be painful, but on the SIC server itself there is a log file that should contain more detail to solve the issue such as SQL error detail. You should check that.

    • MadeshK's avatar
      MadeshK
      New Contributor

      Hi Daniel,
      Where can we check the log file? any specific location?

       

  • JJones's avatar
    JJones
    Icon for OneStream Employee rankOneStream Employee

    The default location for the log files are the following path on the Gateway Server:

    %programdata%\OneStream Software\OneStreamGatewayService\Logs.