Skip to main content
April 13, 2026
Solved

SQL Table Editor on External Connection

  • April 13, 2026
  • 3 replies
  • 0 views

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



 

Best answer by DanielWillis

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.

3 replies

April 13, 2026

What version of OneStream are you using?  

MadeshKAuthor
April 14, 2026

Hi JJones,
We are using 9.1.1 version

Employee
April 13, 2026

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.

MadeshKAuthor
April 14, 2026

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

 

April 14, 2026

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

%programdata%\OneStream Software\OneStreamGatewayService\Logs.