Error when accessing the Workflow Import step
Hi Everyone, I wasrecently working within a Demo Environment where I suddenly started getting error message when trying to access the import step in the Load and Transform(Import) step in the Import Workflow. The Error above pops up every time anyone tries to access the Load and Transform (Import) step. Have anyone seen this issue before and knows how to fix it? NOTE: This issue is the same across all applications in this environment. Thanks, Hamza
Source Data Condition check before Import
Is there a way I can check my source records before importing data into a stage? If I am in a workflow for Import, Validate and Load, Even before the data is imported, I would like to check my source record for a condition like if it is less than a particular value. Only if the condition satisfies, I need to proceed to import else stop the workflow. If someone has done it, can you share the setup and code for the same. Appreciate your help!
Tasks Performance
Hi all, We have experienced that in our application, at specific times of high workload where many processes are executed simultaneously, some tasks in the workflow that involve loading data into the cube remain in the ‘Running’ state for hours. I wonder how to find the cause of this issue, which seems to be a performance problem during periods of high workload. Thank you.Data Sources Reading Rows with No Amounts
Is there a way to make a data source process rows that do not have a value in the Amount column? For example, an import file has 4 rows: Account Name Cost Center Name Amount Cash G&A 5,000 AR G&A 5,000 AP G&A Retained Earnings G&A 10,000 OneStream will only process the Cash, AR, and Retained Earnings rows becuase the AP row has no value in the Amount column. While a complex expression can evaluate the empty amount in the AP row and retun "0", the Data Sources only processes the three rows into Stage.
Smart Integration Cloud (SIC) error
Hello, I am trying to query a local app which have 200k rows on SQL server using SIC (Smart Integration Cloud). However, I get the message : "Received an unexpected EOF or 0 bytes from the transport stream." There is an online troubleshooting which I added below. It seems this is a memory issue. However, there's no mention on how to add memory (on the server ? on my local machine ? how to do it ?). --> could you please help me sorting this out ? Regards, EDIT : I get the same error message when querying a table of only 1 row, 1 column. Memory Issues If you receive any of the following errors, increase the memory in your Smart Integration Connector Local Gateway Server. For queries returning over 1 million records, 32 GB or more RAM is recommended. "Error while copying content to astream.ReceivedanunexpectedEOFor0bytesfrom thetransportstream." "An error occurred while sending the request. The response ended prematurely."
