Infrastructure

96 Topics

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
T_Kress
3 years ago Place Application Build
7.4KViews
8likes
6Comments
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.
OS_Pizza
2 years ago Place Application Build
1.9KViews
7likes
3Comments
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.
Solved
NicolasArgente
2 years ago Place Application Build
2.9KViews
2likes
10Comments
(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.
PMancoll
2 years ago Place Application Build
2.1KViews
2likes
1Comment
Task Activity Type
Our team has been working through an Infrastructure project, which requires pulling task activity from the Framework Database. When pulled directly from the database, we see task activity type in numeric format. To get the descriptions I ran an comparison by extracting the Task Activity dashboard tool and was able to identify the below descriptions: (CASE WHEN a.TaskActivityType= -1 THEN 'Unknown' WHEN a.TaskActivityType=10 THEN 'Recycle Application Server' WHEN a.TaskActivityType=100 THEN 'Get Data Cells' WHEN a.TaskActivityType=101 THEN 'Get Data Cells Using Script' WHEN a.TaskActivityType=110 THEN 'Cube View' WHEN a.TaskActivityType=111 THEN 'Cube View Report' WHEN a.TaskActivityType=112 THEN 'Export Cube View To Excel' WHEN a.TaskActivityType=120 THEN 'Quick View' WHEN a.TaskActivityType=200 THEN 'Book' WHEN a.TaskActivityType=1000 THEN 'Data Management' WHEN a.TaskActivityType=1100 THEN 'Data Management Scheduled Task' WHEN a.TaskActivityType=2000 THEN 'Load And Transform' WHEN a.TaskActivityType=2100 THEN 'BI-Blend Load And Transform' WHEN a.TaskActivityType=2200 THEN 'Direct Load And Transform' WHEN a.TaskActivityType=3000 THEN 'Retransform' WHEN a.TaskActivityType=4000 THEN 'Clear Stage Data' WHEN a.TaskActivityType=5000 THEN 'Validate Transformation' WHEN a.TaskActivityType=6000 THEN 'Validate Intersections' WHEN a.TaskActivityType=7000 THEN 'Load Cube' WHEN a.TaskActivityType=7001 THEN 'Load And Process Cube' WHEN a.TaskActivityType=7002 THEN 'Load Cube Batch' WHEN a.TaskActivityType=8000 THEN 'Process Cube' WHEN a.TaskActivityType=8500 THEN 'Clear Cube Data For Workflow' WHEN a.TaskActivityType=8600 THEN 'Confirm' WHEN a.TaskActivityType=9000 THEN 'Calculate' WHEN a.TaskActivityType=11000 THEN 'Consolidate' WHEN a.TaskActivityType=12000 THEN 'Workflow View Batch' WHEN a.TaskActivityType=12500 THEN 'Multi Workflow View Batch' WHEN a.TaskActivityType=13000 THEN 'Workflow File Batch' WHEN a.TaskActivityType=15000 THEN 'Load XML' ELSE 'Unknown' END) AS 'TaskActivityTypeDesc', Is there another place to get the official description equivalent for these? We can only test for tasks that have occurred in our application.
Solved
AnthonyShenk
3 years ago Place Application Build
3.9KViews
1like
2Comments
What is Upgrade Process for Cloud hosted Applications and Level of Internal Testing Recommended
Originally posted by Kavosh Soltani Hi, Is there a document that describes the upgrade process for clients hosted in the OneStream cloud? What level of client testing is recommended and how is the testing and potential failover is handled, in case unexpected issues are encountered? Thank you
Solved
OSAdmin
6 years ago Place Application Build
2.4KViews
1like
6Comments
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.
Clarke_Hair
4 years ago Place Application Build
1.3KViews
1like
1Comment
Member PropertyID Data Dictionary
Hello OneStream Community, A few days ago a colleague of mine wanted to know the meaning of the various PropertyId constants present in one of the Application Database Audit Tables. I was unable to find any OneStream specific documentation on this PropertyId code and its meaning, so I created a business rule to complete the puzzle and get what we needed for the metadata audit at a very granular level. For any one else experiencing an issue similar like this here is a table of the Member property Id's and their meaning. Dimension | PropertyID | PropertyDescription Entity PropertyID | 100 | Currency Scenario PropertyID | 100 | ScenarioType Account PropertyID | 100 | AccountType Entity PropertyID | 150 | IsConsolidated Entity PropertyID | 200 | IsIC Scenario PropertyID | 200 | InputFrequency Account PropertyID | 200 | FormulaType Flow PropertyID | 200 | FormulaType UDx PropertyID | 200 | FormulaType Scenario PropertyID | 300 | DefaultView Account PropertyID | 300 | AllowInput Flow PropertyID | 300 | AllowInput UDx PropertyID | 300 | AllowInput Scenario PropertyID | 400 | CalculateFromGridsGroup Account PropertyID | 400 | IsConsolidated Flow PropertyID | 400 | IsConsolidated UDx PropertyID | 400 | IsConsolidated Scenario PropertyID | 500 | ManageDataGroup Account PropertyID | 500 | IsIC Flow PropertyID | 500 | SwitchSign UDx PropertyID | 500 | AlternateCurrencyForDisplay Account PropertyID | 600 | UseAltInputCurrencyInFlow Flow PropertyID | 600 | SwitchType Account PropertyID | 700 | PlugAccount UDx PropertyID | 10100 | IsAttributeMember UDx PropertyID | 10200 | AttributeMemberSourceMember UDx PropertyID | 10300 | AttributeMemberExpressionType UDx PropertyID | 10400 | AttributeMemberRelatedDimType1 UDx PropertyID | 10500 | AttributeMemberPropType1 UDx PropertyID | 10600 | AttributeMemberComparisonText1 UDx PropertyID | 10700 | AttributeMemberOperatorType1 Scenario PropertyID | 30100 | InputViewForAdj Account PropertyID | 30100 | InputViewForAdj Scenario PropertyID | 30200 | NoDataZeroViewForAdj Account PropertyID | 30200 | NoDataZeroViewForAdj Scenario PropertyID | 30300 | NoDataZeroViewForNonAdj Account PropertyID | 30300 | NoDataZeroViewForNonAdj Scenario PropertyID | 30400 | ConsolidationView Scenario PropertyID | 30500 | Formula Scenario PropertyID | 40000 | UseInWorkflow Scenario PropertyID | 40100 | WorkflowTrackingFrequency Scenario PropertyID | 40500 | WorkflowNumNoInputTimePeriods Scenario PropertyID | 50100 | UseCubeFxSettings Account PropertyID | 50100 | UsedOnEntityDim Flow PropertyID | 50100 | FlowProcessingType Scenario PropertyID | 50200 | FxRateTypeForRevenueExpense Account PropertyID | 50200 | UsedOnConsDim Flow PropertyID | 50200 | AlternateInputCurrency Entity PropertyID | 300100 | FlowConstraint Account PropertyID | 300100 | FlowConstraint Entity PropertyID | 300200 | ICConstraint Account PropertyID | 300200 | ICConstraint Entity PropertyID | 300400 | UD1Constraint Account PropertyID | 300400 | UD1Constraint Entity PropertyID | 300500 | UD2Constraint Account PropertyID | 300500 | UD2Constraint UDx PropertyID | 300500 | UD2Constraint Entity PropertyID | 300600 | UD3Constraint Account PropertyID | 300600 | UD3Constraint UDx PropertyID | 300600 | UD3Constraint Entity PropertyID | 300700 | UD4Constraint Account PropertyID | 300700 | UD4Constraint UDx PropertyID | 300700 | UD4Constraint Entity PropertyID | 300800 | UD5Constraint Account PropertyID | 300800 | UD5Constraint UDx PropertyID | 300800 | UD5Constraint Entity PropertyID | 300900 | UD6Constraint Account PropertyID | 300900 | UD6Constraint UDx PropertyID | 300900 | UD6Constraint Entity PropertyID | 301000 | UD7Constraint Account PropertyID | 301000 | UD7Constraint UDx PropertyID | 301000 | UD7Constraint Entity PropertyID | 301100 | UD8Constraint Account PropertyID | 301100 | UD8Constraint UDx PropertyID | 301100 | UD8Constraint Account PropertyID | 500100 | WorkflowChannel UDx PropertyID | 500100 | WorkflowChannel Entity PropertyID | 500300 | SiblingConsolidationPass Entity PropertyID | 500500 | AutoTranslationCurrencies Entity PropertyID | 700100 | InUse Account PropertyID | 700100 | InUse Flow PropertyID | 700100 | InUse UDx PropertyID | 700100 | InUse Entity PropertyID | 700200 | AllowAdjustments Account PropertyID | 700200 | Formula Flow PropertyID | 700200 | Formula UDx PropertyID | 700200 | Formula Account PropertyID | 700210 | FormulaForCalcDrillDown Flow PropertyID | 700210 | FormulaForCalcDrillDown UDx PropertyID | 700210 | FormulaForCalcDrillDown Entity PropertyID | 700300 | AllowAdjustmentsFromChildren Account PropertyID | 700300 | AdjustmentType Entity PropertyID | 900100 | Text1 Scenario PropertyID | 900100 | Text1 Account PropertyID | 900100 | Text1 Flow PropertyID | 900100 | Text1 UDx PropertyID | 900100 | Text1 Entity PropertyID | 900200 | Text2 Scenario PropertyID | 900200 | Text2 Account PropertyID | 900200 | Text2 Flow PropertyID | 900200 | Text2 UDx PropertyID | 900200 | Text2 Entity PropertyID | 900300 | Text3 Scenario PropertyID | 900300 | Text3 Account PropertyID | 900300 | Text3 Flow PropertyID | 900300 | Text3 UDx PropertyID | 900300 | Text3 Entity PropertyID | 900400 | Text4 Scenario PropertyID | 900400 | Text4 Account PropertyID | 900400 | Text4 Flow PropertyID | 900400 | Text4 UDx PropertyID | 900400 | Text4 Entity PropertyID | 900500 | Text5 Scenario PropertyID | 900500 | Text5 Account PropertyID | 900500 | Text5 Flow PropertyID | 900500 | Text5 UDx PropertyID | 900500 | Text5 Entity PropertyID | 900600 | Text6 Scenario PropertyID | 900600 | Text6 Account PropertyID | 900600 | Text6 Flow PropertyID | 900600 | Text6 UDx PropertyID | 900600 | Text6 Entity PropertyID | 900700 | Text7 Scenario PropertyID | 900700 | Text7 Account PropertyID | 900700 | Text7 Flow PropertyID | 900700 | Text7 UDx PropertyID | 900700 | Text7 Entity PropertyID | 900800 | Text8 Scenario PropertyID | 900800 | Text8 Account PropertyID | 900800 | Text8 Flow PropertyID | 900800 | Text8 UDx PropertyID | 900800 | Text8
jwagner
3 months ago Place Application Build
99Views
1like
1Comment
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,
allanaklepko
2 years ago Place Application Build
5.2KViews
1like
8Comments
Not receiving emails
Hi! I just ran a parcel and didn't receive an email. This has been working fine. The log shows it was successful. Email's not in junk folder either. Do you know what else I can check?
marisolbritton
2 years ago Place Application Build
1KViews
1like
1Comment