Maximo

Maximo

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

 View Only
Back to discussions
Expand all | Collapse all

Suggestion on adding relationships and domains(table ,numeric etc) in maximodev-cli .dbc file

  • 1.  Suggestion on adding relationships and domains(table ,numeric etc) in maximodev-cli .dbc file

    Posted Mon December 14, 2020 10:06 AM
    HI Team , 

    I added below mention code in maximodev -cli  .dbc file for deploying relationship and table domain content in Target maximo environment  , but these changes are not updated in target environment after perform maximodev -cli build , deploy , updatedb and creation of maximo.ear file also . can any one suggestion missing  deployment work on this process

    Sample table domain

    <specify_table_domain domainid="ASSETLIST" objectname="ASSET" validationwhereclause="1=1" description="Table domain with a list of assets" listwhereclause="1=1" />
    sample relationship

    <create_relationship name="SKDODMECONSTRAINTINFO" parent="SKDODMECONFLICTMESSAGE" child="SKDODMECONSTRAINTINFO" whereclause="constraintname=:constraintname" remarks="Relationship to list constraint description for the given conflict message" />
    Thank you 



    ------------------------------
    Bala Chendrayudu
    ------------------------------

    #Maximo
    #AssetandFacilitiesManagement


  • 2.  RE: Suggestion on adding relationships and domains(table ,numeric etc) in maximodev-cli .dbc file

    Posted Tue December 15, 2020 10:12 AM
    You want to use the "run-dbc" to execute schema changes (or use the native runscriptfile in your Maximo install if you don't want to use the maximodev-cli tool at that point). EARs aren't involved at all as it's just database changes and while updatedb COULD execute it, it depends heavily on how you package your DBC files. If you create a product XML and use the proper naming scheme and have files in the proper place then updatedb would execute your DBC files. But if you're creating individual files you need to manually execute them.

    Also, while adding a table domain or relationship can typically be done while the app is up, please be aware that DBC files perform SQL inserts (since they're intended to run when the app is down) and thus caches won't reflect the change and will require a restart if the app was running when the DBC file was ran.

    ------------------------------
    Steven Shull
    Director of Development
    Projetech Inc
    Cincinnati OH
    ------------------------------

    Original Message


  • 3.  RE: Suggestion on adding relationships and domains(table ,numeric etc) in maximodev-cli .dbc file

    Posted Thu December 17, 2020 07:19 AM

    Thank you so much for your response Sterven Shull



    ------------------------------
    Bala Chendrayudu
    ------------------------------

    Original Message