Maximo

Maximo

Come for answers, stay for best practices. All we're missing is you.

 View Only

Imported view - length limit

  • 1.  Imported view - length limit

    Posted 12/18/24 04:47 AM

    I'm confused.

    In summer I created view in DB2, then imported it trough Maximo Database configuration. Import SQL had 6977 symbols.

    Now I'm trying to import view with some 5500 symbols, but I get error

    BMXAA4049E - The value specified exceeds the maximum field length that is allowed for this attribute: Value = create view mxastrspec as select
    assetnum,
    MAX(case when assetattrid = 'MXASDZES..., Object Name=MAXVIEWCFG, Attribute Name=VIEWSELECT, Maximum Length=4,000.

    I don't understand, why in summer it was OK, there was no error. Since then nothing has changed in version (7.6) not in configuration etc. (I'm pretty shure)

    I see where is the issue, but in summer similar view was imported successfully without that error.

    In that "summer" view, I see that in field MAXOBJECTCFG.VIEWWHERE there is no full SQL select, and there is no particular WHERE clause, there is second part of whole sql clause, first part is in field MAXOBJECTCFG.VIEWSELECT. So, it looks like, it somehow splitted that sql clause between those fields, so that it fitted. Now it doesn't do that at that import. Why?



    ------------------------------
    Juris Flugins
    ------------------------------