Test Data Manager

Expand all | Collapse all

Unable to create data in data pool

Jump to Best Answer
  • 1.  Unable to create data in data pool

    Posted 11-21-2019 04:15 PM
      |   view attached

    we are trying to create data for the Datapool(generator) based on the subset rules that we created in GT SUBSET.

    we see that one table has a column name as "KEY" (which is a keyword)

    Below is the error that we are getting and these tables which has this error are not being USED in the Datapool.

    Failed to insert data for TABLE_NAME

    SQLSTATE = 42000
    Microsoft SQL Server Native Client 11.0
    Incorrect syntax near the keyword 'KEY'.

    No changes made to database.

    INSERT INTO MV_196_98626_3100 ( column_1, KEY, VALUE, DELETED, DELETED_DT, DELETEDBY, CREATED_DT, CREATEDBY, MODIFIED_DT, MODIFIEDBY, VERSION ) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )

    please advise


  • 2.  RE: Unable to create data in data pool
    Best Answer

    Posted 11-22-2019 03:17 PM
    Hi Akhilesh:

    Please see this techtip on how to instruct Datamaker to ignore the reserved SQL keyword.