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.
(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
