Skip to main content
K
Kai
Newcomer
November 9, 2023
Solved

Application Database Folder and System Database Folder

  • November 9, 2023
  • 2 replies
  • 0 views

I am wondering where are the files in the Application Database Folder and System Database Folder physically stored? I am able to find the files under FileShare in the directory where OneStream is installed, but I cannot find the physical folder structure of the Application Database Folder and System Database Folder. Please advise. Thank you

Best answer by MarcusH

These refer to the databases that OneStream maintains. If you go to the System tab and select Tools | Database you will see something like this:

MarcusH_0-1699629721761.png

Expand Tables and then go to the table FileContents in either of the databases. That is where the data resides.

2 replies

P
PeterFu
Newcomer
November 10, 2023

Hi Kai,

 

See Print screen below. This is from my local laptop (that is why is showing C:), but this field should give you what you are looking for.

PeterFu_0-1699603913449.png

 

    K
    KaiAuthor
    Newcomer
    November 10, 2023

    Thank you Peter! I am able to find the Fileshare folders. Do you know where we can find the Application Database Folder and System Database Folder, as shown below (Not the Applications and System folder within FileShare Folder)? Thank you

    Kai_0-1699628286724.png

     

    M
    MarcusHAnswer
    Expert
    November 10, 2023

    These refer to the databases that OneStream maintains. If you go to the System tab and select Tools | Database you will see something like this:

    MarcusH_0-1699629721761.png

    Expand Tables and then go to the table FileContents in either of the databases. That is where the data resides.

    K
    KaiAuthor
    Newcomer
    November 10, 2023

    Hi Marcus, 

    Thank you for your response. This is what I am thinking as well. In the table structure, there are three relevant tables - FileContents, FileInfo and Folder. In the FileContents table, the ContentFileBytes column saved file data in Bytes. I guess OneStream stores files such as word, excel, pdf as Bytes. Do you think this is the case? Thank you

    Kai_0-1699630432725.png

     

    Terms & ConditionsAccessibility statement