What database?? Can you compare the structure of the License_Cache table from both environments?
If you look closely at your INSERT statement you should see the column names. Are they the same as what the table definition has? If all else has failed you could try doing an upgrade install of the same version ARS. Fred -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of David Abry Sent: Thursday, September 15, 2011 8:21 AM To: arslist@ARSLIST.ORG Subject: Re: License_Cache ** 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 -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Joe Martin D'Souza Sent: Thursday, September 15, 2011 7:39 AM To: arslist@ARSLIST.ORG Subject: Re: License_Cache 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: arslist@ARSLIST.ORG 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. -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of David Abry Sent: Thursday, September 15, 2011 7:15 AM To: arslist@ARSLIST.ORG Subject: License_Cache 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"
