Clarity

Expand all | Collapse all

Create custom objects using gel script (SQL)

  • 1.  Create custom objects using gel script (SQL)

    Posted 04-10-2017 05:32 AM

    Hi all.

     

    I'm using Clarity PPM 13.3.0.286 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.

     

    Regards,

    AB



  • 2.  Re: Create custom objects using gel script (SQL)

    Posted 04-10-2017 06:00 AM

    See if Aurora can help you, too, in XOG and autonumbering Status Reports 



  • 3.  Re: Create custom objects using gel script (SQL)

    Posted 04-10-2017 07:10 AM

    Thank you for the reply. Reading the recommended post, I find the sequence generated in the database for the column. Now, I'm calling directly in sql to obtain the next val.

     

    select odf_ca_kpi1_s1.nextval from dual

     

    thanks again



  • 4.  Re: Create custom objects using gel script (SQL)

    Posted 04-11-2017 04:15 AM

    By the way you should NOT be creating data directly in Clarity/PPM using SQL 'insert' statements as this is not a supported integration method - you should be using XOG (ref the 'custom_object_instances_write.xml' file) which you can call from within your GEL.



  • 5.  Re: Create custom objects using gel script (SQL)

    Posted 04-13-2017 06:09 AM

    Yes, You are correct.  WSDL of custom object should be used for creating a custom object.