Skip to main content
K
kmd
Newcomer
September 1, 2023

Looking for list of max character limitations for metadata, including annotations

  • September 1, 2023
  • 2 replies
  • 0 views

Anyone have something they use?

Seems like OS has never provided a nice little reference like this.

Thanks in advance for anything anyone wants to share.

2 replies

C
ckattookaran
Newcomer
September 1, 2023

Name is 500 and description is 200 (seems backwards, but it is what it is)

K
kmdAuthor
Newcomer
September 1, 2023

Hm... I assume this limitation does not apply to other metadata or data source attributes.  Just tried to load a file where the Data Source was picking up a member description from the load file and refused to load due to field length (longest of the row items fields was 110 char).  

I'm looking for something a bit more comprehensive that will provide limitations as well for text fields and annotations etc. etc.  We ran into similar problem with Thing Planner and even the OS consultant wasn't sure what the field limitation was so.... that's not good.

But thanks very much for this.  Personally speaking, it seems like a member name over 40 characters is overkill anyhow.  Why on earth would they make the limit 500?

E
OneStream Employee
EricOsmanskiOneStream Employee
OneStream Employee
September 1, 2023

I am not aware of a list that current exists, but Stage Attributes are limited to 100. Annotations and Text fields don't have a max character limit, but I believe would be limited to a 2GB storage max. 

RobbSalzmann
RobbSalzmann
Legend
September 5, 2023

I used DanielWillis 's SQL to generate this result.  Maybe it can help:

 

 

SELECT COLUMN_NAME, DATA_TYPE, CHARACTER_MAXIMUM_LENGTH
FROM information_schema.columns 
WHERE table_name = 'StageSourceData'
ORDER BY COLUMN_NAME

 

RobbSalzmann_0-1693922437444.png

 

    Terms & ConditionsAccessibility statement