Attribute values too large - Intergraph Smart Reference Data - 2020 10.0 - Customization & Programming - Hexagon

Intergraph Smart Reference Data Integration (2020)

Language
English
Product
Intergraph Smart Reference Data
Search by Category
Customization & Programming
Smart Materials/Smart Reference Data Version
2020 (10.0)

Size conflicts raise a fatal error.

Progress Display

Looking at the progress display, you find that the error raised at stage Fill Interface Tables:

31

And, the error is the following:

32

Logfile

If you look at the end of the logfile, you see a listing of all the attributes and the values that the current row to be exported should get. Note that this "Going to set"-list is only produced if the message level was set to 30 or higher:

Here we have the value PPPABQPEACRAAGZ for AC0010_063 as denoted in the error message:

Going to set variable attr IndustryCommodityCode(AC0010_063) to this value: PPPABQPEACRAAGZ

Going to set variable attr CommodityType(AC0256_010) to this value: PIPE

Going to set variable attr MaterialGrade(AC0010_010) to this value: 162

Going to set variable attr GeometricIndustryStandard(AC0010_019) to this value: 100

Going to set variable attr Density(AC0060_003) to this value:

Going to set variable attr GraphicalRepresentationOrNot(AC0010_011) to this value:

Going to set variable attr PurchaseLength(AC0010_012) to this value:

After that, you see the data tables on which the problem occurred:

ORA-20000: Error fetching attribute values for data table PipeStock

ORA-06512: at "M_SYS.M_PCK_SP3D", line 266

ORA-06512: at "M_SYS.M_PCK_SP3D", line 1528

ORA-12899: value too large for column "M_SYS"."M_SP3D_EXP_JOB_DTA_CCI"."AC0010_063" (actual: 15, maximum: 10)

The error states that the value that the program is about to insert into AC0010_063 is fifteen characters wide, but the target column has space for ten characters only.

End of the logfile.

Solution(s)

Open Integration->Smart 3D->Smart 3D Configurations->Data Table Configurations, go to the PipeStock data table attribute configuration, and query for physical attribute AC0010_063. Check the retrieval method and source of the attribute. In our case, it turns out that the size of the value PPPABQPEACRAAGZ is bigger than the physical attribute. Decide if the error is there in value, or if you must select a bigger physical attribute for your IndustryCommodityCode attribute.

33