Question

2
Replies
855
Views
Suman Palukuru Member since 2015 60 posts
Tata Consultancy Services Ltd
Posted: 3 years ago
Last activity: 3 years 2 months ago
Closed

Enum constant error while executing Report Definition

I am getting the below error while executing the report definition. A data class is mapped to external database table. Any thoughts? I am not able to insert any data as well , its throwing the same error

Error:
** ** No enum constant com.pega.pegarules.priv.database.sqlgen.constants.ColumnType.SERIAL
Low-Code App Development Data Integration Java and Activities Reporting System Administration Data Integration
Close popover
Moderation Team has archived post
Posted: 3 years ago

When I tried to insert the data , getting the below error.





** Batch entry 0 WITH source as (SELECT 100::serial "PixelActivityID" , NULL::bpchar "DELETE_IND" , 'Test'::varchar "Description" , NULL::varchar "created_by" , NULL::timestamptz "created_dt" , NULL::varchar "updated_by" , NULL::timestamptz "updated_dt"), upsert AS (UPDATE pnl_data.PNLSDP_AFFILIATE_PIXEL_ACTIVITY_REF t SET pixel_activity_id = source."PixelActivityID" , delete_ind = source."DELETE_IND" , pixel_activity_descr = source."Description" , created_by = source."created_by" , created_dt = source."created_dt" , updated_by = source."updated_by" , updated_dt = source."updated_dt" FROM source WHERE t.pixel_activity_id = source."PixelActivityID" RETURNING *) INSERT INTO pnl_data.PNLSDP_AFFILIATE_PIXEL_ACTIVITY_REF (pixel_activity_id , delete_ind , pixel_activity_descr , created_by , created_dt , updated_by , updated_dt) SELECT source."PixelActivityID" , source."DELETE_IND" , source."Description" , source."created_by" , source."created_dt" , source."updated_by" , source."updated_dt" FROM source WHERE NOT EXISTS (SELECT null FROM upsert) was aborted.  Call getNextException to see the cause. 


 


 

Posted: 3 years ago

Hi,


Based on the error it looks like an issue with the JDBC driver. Please check if you are using the right type and version of the JDBC driver.


Thanks,


Mukul


 


 


 
Share this page LinkedIn
Copied!