Can't call method "Delete" on an undefined value


#1

Hi

I was wondering if anyone could help me on this one.

We have upgraded our RT to a new database, and wanting to carry on the
numbering from where we left off, created a load of blank tickets to fill
the table row IDs.

Now when we are trying to change the owner (currently Nobody) on any of the
old tickets, we are getting the error listed below (regardless of whether it
is using “Take”, “Steal” or Assignment via “Jumbo” update).

Is there anything obvious within this dump that would suggest any database
columns that aren’t populated and should be (or that are and shouldn’t).
New tickets created normally are OK.

Regards

Neil Turner

System error
error: Can’t call method “Delete” on an undefined value at
/usr/local/rt3/lib/RT/Ticket_Overlay.pm line 3045.
context:

3041:
3042: # Delete the owner in the owner group, then add a new one
3043: # TODO: is this safe? it’s not how we really want the API to work
3044: # for most things, but it’s fast.
3045: my ( $del_id, $del_msg ) =
$self->OwnerGroup->MembersObj->First->Delete();
3046: unless ($del_id) {
3047: $RT::Handle->Rollback();
3048: return ( 0, $self->loc("Could not change owner. ") . $del_msg );
3049: }

code stack: /usr/local/rt3/lib/RT/Ticket_Overlay.pm:3045
/usr/local/rt3/lib/RT/Ticket_Overlay.pm:3107
/usr/local/rt3/share/html/Ticket/Display.html:129
/usr/local/rt3/share/html/autohandler:292

[raw error]

Can’t call method “Delete” on an undefined value at
/usr/local/rt3/lib/RT/Ticket_Overlay.pm line 3045.

Trace begun at /usr/local/share/perl/5.8.7/HTML/Mason/Exceptions.pm line 129
HTML::Mason::Exceptions::rethrow_exception(‘Can’t call method “Delete” on
an undefined value at /usr/local/rt3/lib/RT/Ticket_Overlay.pm line 3045.^J’)
called at /usr/local/rt3/lib/RT/Ticket_Overlay.pm line 3045
RT::ticket::SetOwner(‘RT::Ticket=HASH(0xa7da29c)’, 154, ‘Take’) called at
/usr/local/rt3/lib/RT/Ticket_Overlay.pm line 3107
RT::ticket::Take(‘RT::Ticket=HASH(0xa7da29c)’) called at
/usr/local/rt3/share/html/Ticket/Display.html line 129
HTML::Mason::Commands::ANON(‘Action’, ‘Take’, ‘id’, 22828) called at
/usr/local/share/perl/5.8.7/HTML/Mason/Component.pm line 135
HTML::Mason::Component::run(‘HTML::Mason::Component::FileBased=HASH(0xa10f50
0)’, ‘Action’, ‘Take’, ‘id’, 22828) called at
/usr/local/share/perl/5.8.7/HTML/Mason/Request.pm line 1256
eval {…} at /usr/local/share/perl/5.8.7/HTML/Mason/Request.pm line 1246
HTML::Mason::Request::comp(undef, undef, undef, ‘Action’, ‘Take’, ‘id’,
22828) called at /usr/local/rt3/share/html/autohandler line 292
HTML::Mason::Commands::ANON(‘Action’, ‘Take’, ‘id’, 22828) called at
/usr/local/share/perl/5.8.7/HTML/Mason/Component.pm line 135
HTML::Mason::Component::run(‘HTML::Mason::Component::FileBased=HASH(0x9e3743
c)’, ‘Action’, ‘Take’, ‘id’, 22828) called at
/usr/local/share/perl/5.8.7/HTML/Mason/Request.pm line 1251
eval {…} at /usr/local/share/perl/5.8.7/HTML/Mason/Request.pm line 1246
HTML::Mason::Request::comp(undef, undef, undef, ‘Action’, ‘Take’, ‘id’,
22828) called at /usr/local/share/perl/5.8.7/HTML/Mason/Request.pm line 460
eval {…} at /usr/local/share/perl/5.8.7/HTML/Mason/Request.pm line 460
eval {…} at /usr/local/share/perl/5.8.7/HTML/Mason/Request.pm line 412
HTML::Mason::Request::exec(‘HTML::Mason::Request::ApacheHandler=HASH(0xa7ec3
78)’) called at /usr/local/share/perl/5.8.7/HTML/Mason/ApacheHandler.pm line
168
HTML::Mason::Request::ApacheHandler::exec(‘HTML::Mason::Request::ApacheHandl
er=HASH(0xa7ec378)’) called at
/usr/local/share/perl/5.8.7/HTML/Mason/ApacheHandler.pm line 826
HTML::Mason::ApacheHandler::handle_request(‘HTML::Mason::ApacheHandler=HASH(
0x9415fe4)’, ‘Apache2::RequestRec=SCALAR(0xa7b8fb8)’) called at
/usr/local/rt3/bin/webmux.pl line 123
eval {…} at /usr/local/rt3/bin/webmux.pl line 123
RT::Mason::handler(‘Apache2::RequestRec=SCALAR(0xa7b8fb8)’) called at -e
line 0
eval {…} at -e line 0


#2

Hi

Just sending this message again because it got into the Users Digest but
no-one replied to it.

Thanks

Hi

I was wondering if anyone could help me on this one.

We have upgraded our RT to a new database, and wanting to carry on the
numbering from where we left off, created a load of blank tickets to fill
the table row IDs.

Now when we are trying to change the owner (currently Nobody) on any of the
old tickets, we are getting the error listed below (regardless of whether it
is using “Take”, “Steal” or Assignment via “Jumbo” update).

Is there anything obvious within this dump that would suggest any database
columns that aren’t populated and should be (or that are and shouldn’t).
New tickets created normally are OK.

Regards

Neil Turner

System error
error: Can’t call method “Delete” on an undefined value at
/usr/local/rt3/lib/RT/Ticket_Overlay.pm line 3045.
context:

3041:
3042: # Delete the owner in the owner group, then add a new one
3043: # TODO: is this safe? it’s not how we really want the API to work
3044: # for most things, but it’s fast.
3045: my ( $del_id, $del_msg ) =
$self->OwnerGroup->MembersObj->First->Delete();
3046: unless ($del_id) {
3047: $RT::Handle->Rollback();
3048: return ( 0, $self->loc("Could not change owner. ") . $del_msg );
3049: }

code stack: /usr/local/rt3/lib/RT/Ticket_Overlay.pm:3045
/usr/local/rt3/lib/RT/Ticket_Overlay.pm:3107
/usr/local/rt3/share/html/Ticket/Display.html:129
/usr/local/rt3/share/html/autohandler:292

[raw error]

Can’t call method “Delete” on an undefined value at
/usr/local/rt3/lib/RT/Ticket_Overlay.pm line 3045.

Trace begun at /usr/local/share/perl/5.8.7/HTML/Mason/Exceptions.pm line 129
HTML::Mason::Exceptions::rethrow_exception(‘Can’t call method “Delete” on
an undefined value at /usr/local/rt3/lib/RT/Ticket_Overlay.pm line 3045.^J’)
called at /usr/local/rt3/lib/RT/Ticket_Overlay.pm line 3045
RT::ticket::SetOwner(‘RT::Ticket=HASH(0xa7da29c)’, 154, ‘Take’) called at
/usr/local/rt3/lib/RT/Ticket_Overlay.pm line 3107
RT::ticket::Take(‘RT::Ticket=HASH(0xa7da29c)’) called at
/usr/local/rt3/share/html/Ticket/Display.html line 129
HTML::Mason::Commands::ANON(‘Action’, ‘Take’, ‘id’, 22828) called at
/usr/local/share/perl/5.8.7/HTML/Mason/Component.pm line 135
HTML::Mason::Component::run(‘HTML::Mason::Component::FileBased=HASH(0xa10f50
0)’, ‘Action’, ‘Take’, ‘id’, 22828) called at
/usr/local/share/perl/5.8.7/HTML/Mason/Request.pm line 1256
eval {…} at /usr/local/share/perl/5.8.7/HTML/Mason/Request.pm line 1246
HTML::Mason::Request::comp(undef, undef, undef, ‘Action’, ‘Take’, ‘id’,
22828) called at /usr/local/rt3/share/html/autohandler line 292
HTML::Mason::Commands::ANON(‘Action’, ‘Take’, ‘id’, 22828) called at
/usr/local/share/perl/5.8.7/HTML/Mason/Component.pm line 135
HTML::Mason::Component::run(‘HTML::Mason::Component::FileBased=HASH(0x9e3743
c)’, ‘Action’, ‘Take’, ‘id’, 22828) called at
/usr/local/share/perl/5.8.7/HTML/Mason/Request.pm line 1251
eval {…} at /usr/local/share/perl/5.8.7/HTML/Mason/Request.pm line 1246
HTML::Mason::Request::comp(undef, undef, undef, ‘Action’, ‘Take’, ‘id’,
22828) called at /usr/local/share/perl/5.8.7/HTML/Mason/Request.pm line 460
eval {…} at /usr/local/share/perl/5.8.7/HTML/Mason/Request.pm line 460
eval {…} at /usr/local/share/perl/5.8.7/HTML/Mason/Request.pm line 412
HTML::Mason::Request::exec(‘HTML::Mason::Request::ApacheHandler=HASH(0xa7ec3
78)’) called at /usr/local/share/perl/5.8.7/HTML/Mason/ApacheHandler.pm line
168
HTML::Mason::Request::ApacheHandler::exec(‘HTML::Mason::Request::ApacheHandl
er=HASH(0xa7ec378)’) called at
/usr/local/share/perl/5.8.7/HTML/Mason/ApacheHandler.pm line 826
HTML::Mason::ApacheHandler::handle_request(‘HTML::Mason::ApacheHandler=HASH(
0x9415fe4)’, ‘Apache2::RequestRec=SCALAR(0xa7b8fb8)’) called at
/usr/local/rt3/bin/webmux.pl line 123
eval {…} at /usr/local/rt3/bin/webmux.pl line 123
RT::Mason::handler(‘Apache2::RequestRec=SCALAR(0xa7b8fb8)’) called at -e
line 0
eval {…} at -e line 0


#3

Hello All,

I just migrated our RT 363 instance from a RHEL 4/Oracle Express
instance to a RHEL5.1 64bit Oracle instance. All went fairly well, the
data import seemed to be fine. However, I am having trouble with the
"Take" and assign actions.
If I create a new ticket and then try to take it or assign it to a
person, I get the following error on the web:

error: Can’t call method “Delete” on an undefined value
at /usr/local/rt/lib/RT/Ticket_Overlay.pm line 3045, line 95.
context:

3041:

3042:

Delete the owner in the owner

group, then add a new one
3043:

TODO: is this safe? it’s not how

we really want the API to work
3044:

for most things, but it’s fast.

3045:
my ( $del_id, $del_msg ) = $self-

OwnerGroup->MembersObj->First-
Delete();
3046:
unless ($del_id) {
3047:
$RT::Handle->Rollback();
3048:
return ( 0, $self->loc("Could not
change owner. ") . $del_msg );
3049:
}

code stack: /usr/local/rt/lib/RT/Ticket_Overlay.pm:3045
/usr/local/rt/lib/RT/Ticket_Overlay.pm:3107
/usr/local/rt/local/html/Ticket/Display.html:129
/usr/local/rt/share/html/autohandler:292

I’m not sure what the problem would be here, I know that I had to update
the sequence numbers when I moved to the new instance. That resolved
ticket creation issues fine.

Cheers

Paul

“This email is confidential. Any unauthorized use or disclosure is
strictly prohibited.”


#4

Paul O’Leary wrote:

Hello All,

I just migrated our RT 363 instance from a RHEL 4/Oracle Express
instance to a RHEL5.1 64bit Oracle instance. All went fairly well, the
data import seemed to be fine. However, I am having trouble with the
"Take" and assign actions.
If I create a new ticket and then try to take it or assign it to a
person, I get the following error on the web:

I’m not sure what the problem would be here, I know that I had to update
the sequence numbers when I moved to the new instance. That resolved
ticket creation issues fine.

Don’t know if the two are related but you shouldn’t have to adjust the
sequence numbers if you used Oracle export and import utilities.
Judging from the sequence problem it looks like you did a csv or insert
kind of import and it looks like there is something out of sync.

I regularly exp/imp from my Oracle XE prod instance to my test instance
and never had problems with that and I wouldn’t expect problem going
from XE (32bit) to Oracle Standard/Enterprise Edition 64bit either when
using import/export.

Please let me know if I can be of any further help,

Joop