RT3: Couldn't create a ticket- Internal error message

RT Users
1

Hi,

I have migrated the RT2 data into the newly installed RT3 ( 3.0.2 running on
PostgreSql 7.3.2 ), and everything looked fine until I attempted to create a
ticket. At ‘Create’, I got the error message ‘Could not create ticket due to
internal error’. The Apache error log has the following:

Couldn’t create a ticket (/usr/local/rt3/lib/RT/Ticket_Overlay.pm:483)

Any help would be appreciated… I noticed this problem had been posted
before, didn’t see any responses though.

Thanks!
Sophie

2

Hi,

I have migrated the RT2 data into the newly installed RT3 ( 3.0.2 running
on PostgreSql 7.3.2 ), and everything looked fine until I attempted to
create a ticket. At ‘Create’, I got the error message ‘Could not create
ticket due to internal error’. The Apache error log has the following:

Couldn’t create a ticket (/usr/local/rt3/lib/RT/Ticket_Overlay.pm:483)

Any help would be appreciated… I noticed this problem had been posted
before, didn’t see any responses though.

you need to do setval() on the sequences for users, tickets, and
transactions.

Thanks!
Sophie

rt-users mailing list
rt-users@lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-users

Have you read the FAQ? The RT FAQ Manager lives at http://fsck.com/rtfm

Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 972-414-9812 E-Mail: ler@lerctr.org
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749

3

Yeap, that did it. I can’t believe I forgot about the seq’s… :slight_smile:
Thanks!!On Wednesday 28 May 2003 05:37 pm, Larry Rosenman wrote:

–On Wednesday, May 28, 2003 17:31:58 -0400 Sophie Rockhsar sophia@aps.org wrote:

Hi,

I have migrated the RT2 data into the newly installed RT3 ( 3.0.2 running
on PostgreSql 7.3.2 ), and everything looked fine until I attempted to
create a ticket. At ‘Create’, I got the error message ‘Could not create
ticket due to internal error’. The Apache error log has the following:

Couldn’t create a ticket (/usr/local/rt3/lib/RT/Ticket_Overlay.pm:483)

Any help would be appreciated… I noticed this problem had been posted
before, didn’t see any responses though.

you need to do setval() on the sequences for users, tickets, and
transactions.

Thanks!
Sophie

rt-users mailing list
rt-users@lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-users

Have you read the FAQ? The RT FAQ Manager lives at http://fsck.com/rtfm

4

Yeap, that did it. I can’t believe I forgot about the seq’s… :slight_smile:
Thanks!!

Having been burned by this recently I remembered it. Jesse said he would
make sure
the Docs got updated at some point.

Any time…

Helping others is how I pay back the community for all the help I’ve gotten
over the
years.

LER

Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 972-414-9812 E-Mail: ler@lerctr.org
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749