Recent Discussions
Integration from MS SQL DB to OneStream
Hi Dears, Could anyone please provide me the practical steps to Integrate the MS SQL DB to OneStream. we are at presently testing with the data integration to learn the integration. Kindly provide the real time steps which can work Onestream - On-prem envi SQL DB - Local host regards, BCG
Execution Timeout Expired
Error Message: Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. Operation cancelled by user. The statement has been terminated. (SQL Error Number -2146232060, -2, 0, 3621). The wait operation timed out This happened after running Load and Transform for one of my import workflows. Any idea what's causing this? It stops at the PostFileArchives stage:
D365 Fixed Assets Subledger Integration
Hi All, Just curious if anyone has had success pulling data (SQL) from D365's Asset Ledger to get the continuity / movements for Fixed Asset accounts? In other words, it would provide the Flow movements like Additions and Disposals for the Fixed Asset accounts to justify the change in the Balance Sheet account balance. Has anyone ever successfully done this, specifically using SQL from D365? Thx, Mike
FTP File Load Best Practice
When I pull a flat file from an SFTP server, I have been parsing that file in VB .net into a Data Table and loading it that way. Is this the best way to do this, or is there a way to make the Import read the file from the filesystem once it has been downloaded? I feel like parsing a csv file using Split() is risky. Thanks, Scott
Dynamic Time Filter in Data Management Export Step
I'm building a Data Management step to export data, and I need to set the time filter dynamically. For example, if the scenario is Budget_Final_FY26, the export should include 5 years of data: the current year, plus current year +1 through current year +4. The challenge is that I don’t see a way to directly use “current year” in the time filter. My idea is to substitute the time filter with an XFBR string that pulls the current year and applies it dynamically. Has anyone implemented something similar, or is there a recommended approach for handling this?Intermittent 500 Error when calling OS Data Adaptor using Rest API 5.2.0
We have several applications calling OneStream data adaptor via Rest API. Very frequently and randomly the connection fails with a 500 error. If we wait and retry the connection is successful. We have not been able to find the root cause. We observed that when the Rest API has 2 entries in the Log Activity table in OneStream the connection is successful. The screen shot is from the Logon Activity table in OneStream. Every so often the connection fails with a HTTP 500 Error and we observed that only one the set is entered in the table. Have any of you encountered this type of issue.
