Discussion

5
Replies
3165
Views
Matthew Comer (MatthewC8454)
CapTech Consulting

CapTech Consulting
US
MatthewC8454 Member since 2014 1 post
CapTech Consulting
Posted: April 28, 2015
Last activity: October 4, 2018
Posted: 28 Apr 2015 15:41 EDT
Last activity: 4 Oct 2018 11:08 EDT
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, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Discussion, please write a new Discussion.