Upgrade RT and AT and now can not create assets

RT Users
1

I have a system that we upgraded from RT 3.6.7 to 3.8.8 back in Aug.

I did a fresh install of RT. Then restored the database. Then
one-by-one added back in any customizations, plugins, etc.

We where using Asset Tracker on our 3.6.7 install (so the data was
restored when the DB was restored). I have installed
rt-extension-assettracker-2.0.0b2-0-g2b51b9a.tar.gz

We can see, search, and even edit assets without any problem. The
(only?) problem comes when I try to create new assets. When I try to
create new assess, error shows in web browser:
Can’t call method “HasRight” on an undefined value
at /usr/share/request-tracker3.8/lib/RT/User_Overlay.pm line 1357.

When I did the install of AT, I was able to do the first 3 steps no
problem:
$ RTHOME=/path/to/rt perl Makefile.PL
$ make
$ make install

When I would run ‘make initdb’ I would get an error:
Now populating database schema.
DBD::Pg::st execute failed: ERROR: relation “at_types” already exists
at /usr/share/request-tracker3.8/lib/RT/Handle.pm line 506. …returned
with error: 65280 make: *** [initdb] Error 255

I have attached a segment of my syslog output. What is shown is Right
after hitting the ‘submit’ button when trying to create an asset.

Any help fixing this so we can create new assets again would be greatly
appreciated.

Associate yourself with men of good quality if you esteem
your own reputation; for 'tis better to be alone then in bad
company. - George Washington, Rules of Civility

Asset_Making.syslog.txt (5.41 KB)

2

When I would run ‘make initdb’ I would get an error:
Now populating database schema.
DBD::Pg::st execute failed: ERROR: relation “at_types” already exists
at /usr/share/request-tracker3.8/lib/RT/Handle.pm line 506. …returned
with error: 65280 make: *** [initdb] Error 255

You don’t run make initdb when you upgrade. You should read
documentation to perform proper upgrade. It’s possible that your DB
inconsistent right now.

Best regards, Ruslan.

3

When I would run ‘make initdb’ I would get an error:
Now populating database schema.
DBD::Pg::st execute failed: ERROR: relation “at_types” already
exists at /usr/share/request-tracker3.8/lib/RT/Handle.pm line
506. …returned with error: 65280 make: *** [initdb] Error 255

You don’t run make initdb when you upgrade. You should read
documentation to perform proper upgrade. It’s possible that your DB
inconsistent right now.

I have tried reading documentation… searching list… etc… I just
can’t seem to find how I can correct this problem.

It will be acceptable for our install for me to ‘loose’ all of the
Asset Tracker stuff… but I can not just dump the DB and start over -
We need to keep the ticket side of things.

Any way I can do a complete ‘uninstall’ of Asset Tracker, and start
over?

Associate yourself with men of good quality if you esteem
your own reputation; for 'tis better to be alone then in bad
company. - George Washington, Rules of Civility

4

When I would run ‘make initdb’ I would get an error:
Now populating database schema.
DBD::Pg::st execute failed: ERROR: relation “at_types” already
exists at /usr/share/request-tracker3.8/lib/RT/Handle.pm line
506. …returned with error: 65280 make: *** [initdb] Error 255

You don’t run make initdb when you upgrade. You should read
documentation to perform proper upgrade. It’s possible that your DB
inconsistent right now.

I have tried reading documentation… searching list… etc… I just
can’t seem to find how I can correct this problem.

It will be acceptable for our install for me to ‘loose’ all of the
Asset Tracker stuff… but I can not just dump the DB and start over -
We need to keep the ticket side of things.

Any way I can do a complete ‘uninstall’ of Asset Tracker, and start
over?

No automation for that. You should go over etc/initialdata file in the
extension and delete tables and records it creates during
installation. Strongly recommend to do it in a test environment
before performing it on production.

–
http://www.wikiak.org

#############################################################
Associate yourself with men of good quality if you esteem
your own reputation; for 'tis better to be alone then in bad
company. - George Washington, Rules of Civility

RT Training Sessions (http://bestpractical.com/services/training.html)

  • Boston March 5 & 6, 2012

Best regards, Ruslan.