How to Import if the Inserted Value is Too Big for Column Error Appears?

1. Select the required time series database in the folder tree of the object navigator. The list of objects will display its internal objects.

2. Open the Data folder (the FOLDER_DATA identifier). The list of metadictionaries of time series database is displayed.

3. Double click on fact metadictionary. It has name of the Facts_N type and identifier of the METAFACTS_K type, where N is name of the tie series database, and K is its key. The fact table will be displayed.

4. Open table editing wizard:

• Select the facts table and click F4.

• Select the Edit item in the context menu.

5. Go to the Fields page in the table edit wizard.

6. Select the Mnemonics box (the MNEMO identifier) and double-click it or click the Edit button. The Table Field Properties dialog box opens.

7. In the Total Length box enter the mnemonics required length.

8. Click the OK button in the Table Field Properties dialog box and then the Finish button in the table edit wizard.

The given example of code increases field length for the MNEMO attribute in the time series database with the TSDB_MNEMO identifier.

Add links to the Cubes, Db, Metabase, Rds system assemblies.

Example:

Sub UserProc;
Var
    mb: IMetabase;
    TSDB: IRubricator;
    FactDic: IMetaDictionary;
    MnemoAttr: IMetaAttribute;
    MnemoTable: ITable;
    MnemoField: ITableField;
Begin
    mb := MetabaseClass.Active;
    // Get time series database
    TSDB := mb.ItemById("TSDB_MNEMO").Edit As IRubricator;
    // Get metadictionary of facts for editing
    FactDic := TSDB.EditFacts;
    MnemoTable := FactDic.Attributes.Table;
    // Get the MNEMO field
    MnemoField := MnemoTable.Fields.FindById("MNEMO");
    // Increase field length
    MnemoField.Size := 300;
    // Save changes
    (TSDB As IMetabaseObject).Save;
End Sub UserProc;

1. Select any required time series database in the object navigator.

2. Click F4 or select the Edit item in the context menu. The time series database edit wizard opens.

3. Go to the Attributes page.

4. Deselect the Series Have Identifiers checkbox.

5. Click the Finish button.

Mnemonics generation rules are determined using the Fore language. To do this, use the IMetaDictionary.AttributeMnemoNamings property. The example of rule setting is given in property description.