Do a DESCRIBE of the License_Cache table in prod and then compare to dev. Are there differences? How did you do the restore? Cold or hot backup?
On Thu, Sep 15, 2011 at 9:21 AM, David Abry <[email protected]> wrote: > ** > All, > > We are on version AR Server 7.5 Patch 4. Yes, we did a database restore > from production into development and have had this problem ever since. > > Regards, > Dave > > On Thu, Sep 15, 2011 at 8:38 AM, Joe Martin D'Souza <[email protected]>wrote: > >> Is this a new install? Or new upgrade? >> >> Has the licensing ever worked before? >> >> You haven't done a DB restoration of certain tables which may include that >> license table as well right? In which case maybe your current license table >> is not of the expected format (description) which results in that column not >> found?? >> >> Joe >> >> -----Original Message----- From: Misi Mladoniczky >> Sent: Thursday, September 15, 2011 8:29 AM Newsgroups: >> public.remedy.arsystem.general >> To: [email protected] >> Subject: Re: License_Cache >> >> >> Hi, >> >> To me this indicates that the license_cache-table is somehow broken... >> >> Maybe it could have something to do with case-sensitivity and column >> names? >> >> Best Regards - Misi, RRR AB, http://www.rrr.se >> >> Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10): >> * RRR|License - Not enough Remedy licenses? Save money by optimizing. >> * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. >> Find these products, and many free tools and utilities, at http://rrr.se. >> >> All, >>> >>> We are currently trying to add licenses to the AR System through the user >>> tool. We receive NO errors when adding the ARServer license and receive >>> the >>> message saying the the license was added to the system successfully. When >>> I >>> go to log into the Developer Studio, the server comes up as unlicensed. >>> >>> I found that when I add the license I get the following error: >>> >>> INSERT INTO License_Cache VALUES( (license information details) ... ) >>> >>> Error: Column Name or Number does not match table definition. >>> >>> The license never makes it into the license_cache table. >>> >>> BMC Support keeps having me try new licenses which is not helpful since >>> this >>> happens on all licenses. I removed all license and also ran arreload >>> which >>> did not solve the problem. Has anyone ever had this issue and what is >>> the >>> name of the table that updates the license_cache table. >>> >>> Thanks in advance, >>> >>> David Abry >>> >> >> ______________________________**______________________________** >> ___________________ >> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org >> attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are" >> > > _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
