Storage Type Codes / Data Record Status Fields
In the data record tables in the database, there are status code columns. For example. Here are what those status codes mean: Status (Stored Bits) Existence Type Storage Type 16 NoData StoredButNoActivity 17 IsRealData StoredButNoActivity 18 IsDerivedData StoredButNoActivity 32 NoData Input 33 IsRealData Input 34 IsDerivedData Input 37 IsDerivedData StoredButNoActivity 48 NoData Journals 49 IsRealData Journals 50 IsDerivedData Journals 64 NoData Calculation 65 IsRealData Calculation 66 IsDerivedData Calculation 80 NoData Translation 81 IsRealData Translation 82 IsDerivedData Translation 96 NoData Consolidation 97 IsRealData Consolidation 98 IsDerivedData Consolidation 113 IsRealData DataCellDetail 144 NoData DurableCalculation 145 IsRealData DurableCalculation 146 IsDerivedData DurableCalculation
TIP : Deleting all Scheduled task after application copy
After an application copy , We usually go to the newly copied application and disable/delete the tasks. TIP-> You can press CTRL+A or can select multiple task by pressing shift and then Delete it. It might be that you already know about this, but just sharing the tip for the wider community.
OnPrem and RestApi : Help for the config
Hi there! I am trying to use Postman to run a DM job sequence. I test the DM job locally and it works fine with no parameter. I am using Azure SSO to log on the server. I can retrieve a token from microsoft for my tenant ID using : https://login.microsoftonline.com/bec456-my-t3n4nt-id-e2aba/oauth2/v2.0/token (In green in the printscreen) On my second RestApi call, I use the token I retrieved and I drop the token under Authorization > Bearer Token in Postman. Because I need to run a sequence the URL is :https://aiqos.io:50001/onestreamapi/api/DataManagement/ExecuteSequence?api-version=5.2.0 and the body is : { "BaseWebServerUrl": "https://aiqos.io:50001/onestreamweb", "ApplicationName": "GolfStreamV65", "SequenceName": "RestApi", "CustomSubstVarsAsCommaSeparatedPairs": "" } I also created an admin user in OneStream that matches the Application (client) ID found in Azure. (In red in the printscreen) The on the back end in the server config, I added the OS Werb Api Cliend ID and the Web Api App Custom Scopes. (in red and yellow) When I run the RestApi for the DM Sequence, I get an error 500. I have no clue on what I am missing after reading few times the doc. I used to make it work for previous OS versions... I see that the api is reaching the windows server , but nothing in the OneStream logs... Thanks for your help.
(answer found) "ERROR. Invalid Connection" in Database Configuration Tool
Posting this because I searched for the answer before putting in a ticket with OneStream support (who were excellent, by the way). One of our applications wasn't working in a lower environment. The connection to the application SQL DB wasn't working. Tried removing and adding it back using the OneStream Database Configuration tool. What the fix was: The “Invalid Connection” issue was due to the DB security settings for the service account user (that was running the OneStream server application). Not quite sure what the issue was -- it might have been the default schema for the user. In any case, looking at the permissions for the user in the other application SQL databases where it was working correctly gave us the guide towards fixing the issue.
how to monitor your Azure environment
Hosted by Azure/Managed by OS, so never spent anytime learning how to monitor our environment other than at the very high level (System-Environment-Refresh). Hoping someone can point me in the right direction. Really looking to see how long Excel queries take, steps within consolidations and just general overhead. I seem to remember something provided within Azure to monitor but not sure if that is still around or not. We are heavy for 8 days and adding more functionality so need to make sure we can still run acceptable during that time.SQL Blocking detected Warning
Hello, does anyone know if we need to worry about this warning? There aren't much details provided in the error log. Summary: SQL Blocking detected: Database Name: , Request Session ID: 72, Blocking Session ID: 12, Blocked Object Name: , Resource Type: FILE: 9:0, Requesting Text: , Blocking Text: , Request Mode: , Blocking Time: 12/2/2023 8:05:57 AM. Thank you,
Data Refresh between applications for on-premise
Hello experts, How can we copy just data from an application to another? We have an on-premise setup and would like to copy data from prod environment to lower environment application. I know we can do simply do entire DB copy for that application, but it'll replace everything (like app artefacts). Is there a way we can just copy underlying data of an application? I noticed some data tables (BinaryData20xx, DataRecord20xx), but not sure if simply copying them will work. Thanks, Gaurav
Saving customization for ribbon for a spreadsheet component
Hi All, We are using a spreadsheet component to capture some drivers from end users in our application, how do we customize the ribbon of the spreadsheet component to show only OneStream option in the ribbon? If I do right click, "Customize ribbon", it lets me display only OneStream in the ribbon , but the customization is lost on refreshing the page. Any guidance on how to retain this customization would be helpful.
