CA Service Management

  • 1.  Inactivate data from Behavior_Template table

    Posted Mar 20, 2017 04:33 PM

    Hi Everyone,

    I'm trying to inactive some data from the Behavior_Template table.

    I make the .txt file with the delete field set to "1" to import using the pdm_load.

     

    But when I use the command pdm_load with parameters -a -v -f file.txt, appears the follow error menssage:

     

    Behavior_Template: No numeric or logical key.
    ERROR: Cannot create mapping for table (Behavior_Template)
    ERROR: Skipping table.

    I understand that there isn't a ID field.

     

    Anyone knows how to inactivate a data from this table through pdm_load ?

     

    Thanks,

    Felipe Nunes



  • 2.  Re: Inactivate data from Behavior_Template table
    Best Answer

    Broadcom Employee
    Posted Mar 20, 2017 04:47 PM

    Felipe, I think your input file file.txt could miss the "id" field.You could use something like this:

    TABLE Behavior_Template

          del id

    {"1", "400003" }

    Thanks _Chi



  • 3.  Re: Inactivate data from Behavior_Template table

    Posted Mar 21, 2017 07:54 AM

    Chi,

    I really forgot the ID field.
    I extracted again the TABLE Behavior_Template and got the ID field.

     

    Thank you.
    Felipe Nunes