Skip to main content
Newcomer
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

OneStream Employee
April 13, 2026

What version of OneStream are you using?  

MadeshKAuthor
Newcomer
April 14, 2026

Hi JJones,
We are using 9.1.1 version

Contributor
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
Newcomer
April 14, 2026

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

 

OneStream Employee
April 14, 2026

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

%programdata%\OneStream Software\OneStreamGatewayService\Logs.