Discussion

5
Replies
3039
Views
MatthewC8454 Member since 2014 1 post
CapTech Consulting
Posted: 5 years ago
Last activity: 2 years 1 month ago
Closed

Database Table Mapping - Postgresql auto-increment column

I am facing an issue with a class generated with the database table mapping wizard. The table is in a postgres database, and is defined like this:

CREATE TABLE event
(
id serial NOT NULL,
description character varying(4000),
endwhen timestamp without time zone NOT NULL,
slots integer NOT NULL,
startwhen timestamp without time zone NOT NULL,
title character varying(255),
eventtype_id integer NOT NULL,
owner_id integer NOT NULL,
organization character varying(255) NOT NULL,
CONSTRAINT event_pkey PRIMARY KEY (id),
CONSTRAINT fk403827a8337183 FOREIGN KEY (eventtype_id)
REFERENCES eventtype (id) MATCH SIMPLE
ON UPDATE NO ACTION ON DELETE NO ACTION,
CONSTRAINT fk403827a9ee32829 FOREIGN KEY (owner_id)
REFERENCES users (userid) MATCH SIMPLE
ON UPDATE NO ACTION ON DELETE NO ACTION
)

If I create a simple report definition against this class and attempt to run it, I receive:

Error:
** ** No enum constant com.pega.pegarules.data.external.rd.constants.ColumnType.SERIAL ** No enum constant com.pega.pegarules.data.external.rd.constants.ColumnType.SERIAL
Is PRPC unable to handle the "serial" (autoincrement) type on the id column?

**Moderation Team has archived post**

This post has been archived for educational purposes. Contents and links will no longer be updated. If you have the same/similar question, please write a new post.

Data Integration
Moderation Team has archived post
Share this page LinkedIn