Skip to main content
Member
Apr 13, 2026 7:42 AM UTC
Solved

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.

 

Contributor
Apr 13, 2026 10:41 PM UTC

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.

5 replies

OneStream Employee
Apr 13, 2026 4:07 PM UTC

What version of OneStream are you using?  

MadeshKAuthor
Member
Apr 14, 2026 4:48 PM UTC

Hi JJones,
We are using 9.1.1 version

Contributor
Apr 13, 2026 10:41 PM UTC

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
Member
Apr 14, 2026 4:51 PM UTC

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

 

OneStream Employee
Apr 14, 2026 7:16 PM UTC

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

%programdata%\OneStream Software\OneStreamGatewayService\Logs.