Yes its very likely the descriptions will not be the same.. What is the ARS version on the production and what is it on Development?
If it’s a version mismatch, you are lucky the server even starts.. If the database version does not match the server version that is installed, usually the service will not start with an unexpected version error.. Joe From: Frank Caruso Sent: Thursday, September 15, 2011 9:28 AM Newsgroups: public.remedy.arsystem.general To: [email protected] Subject: Re: License_Cache ** 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"_ _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"
