AnsweredAssumed Answered

Create custom objects using gel script (SQL)

Question asked by abarbosa on Apr 10, 2017
Latest reply on Apr 13, 2017 by HCL-Gaurav.Gupta

Hi all.


I'm using Clarity PPM with Oracle and at this point we are trying to collect some data in other systems (using external data sources) and put this information in Clarity using for this custom objects. To data collect I create a process (on demand) to be executed by a job in the future and in the process I create some custom script (gel script) to collect the data, using sql:query and sql:update. Here, in the sql:update I have an issue, because I can't run the update sucessfully ([CA Clarity][Oracle JDBC Driver][Oracle]ORA-01400: cannot insert NULL into ("PMT"."ODF_CA_KPI1"."ID") .)

The custom object is a Master Object with some additional fields. I set the column ID with autonumbering, but this sequence is not executed. My question is, there is some way in Clarity to do this? Or I need to execute each insert calling the next val for a SEQUENCE in Oracle? I'm open to other solutions if more suitable to that situation.