CA Service Management

Expand all | Collapse all

To insert new records in ca_contact - Urgent!!!

  • 1.  To insert new records in ca_contact - Urgent!!!

    Posted 08-03-2015 02:31 AM


    Hi Team,

     

    We need to insert new multiple records in ca_contact (SDP) using the pdm functions.

    Earlier we updated existing records using the below command suggested by CA and it worked.

    pdm_userload -a -u -m -f file1.dat

    Now similarly we want to know the command to insert new multiple records.

    Kindly suggest on priority as it is very important now.

     

    Thanks,

    Hemalatha S



  • 2.  Re: To insert new records in ca_contact - Urgent!!!

    Posted 08-03-2015 02:41 AM

    Hello Hemalath,

     

    Please note that for urgent issues where CA Support can assist, you may be best off logging a Support issue, and/or using the "Chat" option that comes up when you start that process for Service Desk Manager. That way you may be able to reach out directly to an engineer, who can then speak with you and being a remote session if needed.

     

    Your load command looks right for updating records. But for new records you may want to consider "pdm_load" with the "-i" switch.

     

    Use "-c" to "check" what will happen. Maybe don't use the "-a" command.

     

    And try all of this on a test system first, of course!

     

    C:\PROGRA~2\CA\SERVIC~1\site\temp>pdm_userload /?

    An input file name parameter must be entered

    usage: pdm_userload -f [filename | -]

            [-a (update all matching data)]

            [-c (check only, no change to data)]

            [-e (treat escapes literally)]

            [-h (help)]

            [-m (notify domsrvr of mass update)]

            [-v (verbose)]

            [-r (remove) | -u (update only)]

            [-x (use locale sensitive numeric input formats)]

     

     

    C:\PROGRA~2\CA\SERVIC~1\site\temp>pdm_load /?

    An input file name parameter must be entered

    usage: pdm_load -f [filename | -]

            [-a (update all matching data)]

            [-c (check only, no change to data)]

            [-e (treat escapes literally)]

            [-h (help)]

            [-i (insert only)]

            [-m (notify domsrvr of mass update)]

            [-v (verbose)]

            [-r (remove) | -u (update only)]

            [-x (use locale sensitive numeric input formats)]

     

     

     

    You haven't covered off a bit of information?

     

    * You don't get your load to occur. But what happens? Error message? Log file update? Hang?

     

    * What are you uploading? All fields? Some fields? Fields that already have similar values? A sample of the .DAT that you are uploading may help.

     

    * Try using "-v" which will write verbose information to the logs.

     

    * How is this scenario different to your prior working scenario?

     

    Thanks, Kyle_R.



  • 3.  Re: To insert new records in ca_contact - Urgent!!!

    Posted 08-03-2015 03:13 AM

    Hi Hemalatha,

     

    As you wanted to insert contact records in CA_CONTACT table,  then the best approach will be to use deref functionality.  The reason to use Deref is ca_contact will have reference to multiple tables like Access type, location Etc.

    For more details refer to R12.9  Administration Guide Page 490  " Data Dereferencing".

    You need to involve CA Services  team to customize it according to you recommendation. This will be beyond the scope of CA support.

    ~Vinod.