DD issue: How to insert data for autogenerated primary key

I am inserting data to a table where the primary key id autogenerated field.

Now if I do not provide data for this perticular column it gives Null pointer exception. But If I provide this filed it is not able to insert the data. It is giving error as
"DBD: ERROR:WriteTuple failure to consumer[0]
DBD: ERROR:Unable to process TeamSite source
templatedata/templatedata_US_en/avatar/data
DBD: ERROR:deployment [testddshiv] FAILED"

Please help me with this. Is there a way to define a primary key as autogenerated field? Need this ASAP. ANy help would be appreciated. Attached is the configuration file

Thanks and regards,
Shiv

Find more posts tagged with

Comments

jagadesh

I am inserting data to a table where the primary key id autogenerated field.

Now if I do not provide data for this perticular column it gives Null pointer exception. But If I provide this filed it is not able to insert the data. It is giving error as
"DBD: ERROR:WriteTuple failure to consumer[0]
DBD: ERROR:Unable to process TeamSite source
templatedata/templatedata_US_en/avatar/data
DBD: ERROR:deployment [testddshiv] FAILED"

Please help me with this. Is there a way to define a primary key as autogenerated field? Need this ASAP. ANy help would be appreciated. Attached is the configuration file

Thanks and regards,
Shiv

You can use lots of method to solve this issue.
1. using in DD as Callout to generate id
Reference

Limitation:
Replicant wont support, not sure in TS7.1 whether it has resolved or not

2. using Datasource in FormApi while creating DCR itself generate id
the below one used for cascading execution. look for WFM guide for more details
Reference_Datasource

I hope the above one helps you

cute_guy

I am inserting data to a table where the primary key id autogenerated field.

Now if I do not provide data for this perticular column it gives Null pointer exception. But If I provide this filed it is not able to insert the data. It is giving error as
"DBD: ERROR:WriteTuple failure to consumer[0]
DBD: ERROR:Unable to process TeamSite source
templatedata/templatedata_US_en/avatar/data
DBD: ERROR:deployment [testddshiv] FAILED"

Please help me with this. Is there a way to define a primary key as autogenerated field? Need this ASAP. ANy help would be appreciated. Attached is the configuration file

Thanks and regards,
Shiv

Another Simple way, is do not have that field has a primary key & not null field in the dd config file, instead have the "path" as a primary key in the config file.

So when you pass empty value, data deploy will ignore validation of the field since it is not a primary key field. The DB (mysql or mssql) will automatically insert next value to the primary field in DB.