Test Data Manager

  • 1.  Publish Updates To Target

    Posted Nov 16, 2016 01:39 AM

    Hi, I am using GT datamaker 3.8. Just i want to publish updates to target instance(here my instance is oracle db). For example my table is 'employee' where it contains columns EmpNo & EmpName and i have applied nextval function to EmpNo column so i can preview the data in data definition window and it is fine now i want to publish these updates to target(target already had set of records)  i am getting the message dialog box "This is not a Data only Data Pool and possibly there would be no updates to publish. Would you like to proceed?"  so i am proceeding further step by clicking "Yes" and ends with 0 rows updated.

    I have tried:

    1. I have changed Data only data pool from drop down, but when i chose data only data pool it was giving the value of column(@nextval(temp,4444444)@)) instead of (4444444 which is actual resultant of my function) so data only data pool will not work for my scenario

    2. I have added unique key constraint on ENO column at db level, but this is not recommened, However it doesnt worked

     

    Can CA grid data maker have the capability to push the updates onto unique constraint column

     

    To conclude my issue: i want to update data where the db column is unique constraint.

     

    Thanks,

    Kumar



  • 2.  Re: Publish Updates To Target
    Best Answer

    Posted Nov 17, 2016 09:23 AM

    Hi Satish, 

     

    The problem might be in how the data pool is defined or another configuration that is slightly off. 

     

    I think this issue will take a WebEx in order to investigate further. Please open a support case by going to https://support.ca.com/irj/portal/newhome or calling CA Customer Care using one of these numbers http://www3.ca.com/us/support/customer-assistance.aspx

     

    We will post the resolution to the issue here once the case is closed. 

     

    Best regards,

    Taylor