Question

2
Replies
904
Views
Close popover
Venkata Suman Palukuru (Suman Palukuru)
Tata Consultancy Services Ltd
Lead System Architect
Tata Consultancy Services Ltd
US
View Profile Send Message
Suman Palukuru Member since 2015 62 posts
Tata Consultancy Services Ltd
Posted: July 5, 2017
Last activity: July 10, 2017
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
Close popover
Moderation Team has archived post,
Close popover This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.
Posted: 3 years ago
Close popover
Venkata Suman Palukuru (Suman Palukuru)
Tata Consultancy Services Ltd
Lead System Architect
Tata Consultancy Services Ltd
US
View Profile Send Message

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
Close popover
Mukul Rathod (mrathod_gcs)
PEGA
Sr. Software Solutions Engineer
Pegasystems Inc.
US
View Profile Send Message

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 Share via LinkedIn Copying...
Copied!