Question
2
Replies
1018
Views
Tata Consultancy Services Ltd
US
Posted: July 5, 2017
Last activity: July 10, 2017
Last activity: 10 Jul 2017 13:41 EDT
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
Show More
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
Show Less
Posted: 4 years ago
Tata Consultancy Services Ltd
US
When I tried to insert the data , getting the below error.
Show More
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. |
|
|
Show Less
Posted: 4 years ago
Pegasystems Inc.
US
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