Yes, XYZ has CDATA and CGLOBAL in it. Let me know if you need more information. I am stumped.
Thanks for the reply. <Ajas Mohammed /> http://ajashadi.blogspot.com We cannot become what we need to be, remaining what we are. No matter what, find a way. Because thats what winners do. You can't improve what you don't measure. Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives. On Tue, May 5, 2009 at 1:42 PM, Teddy R. Payne <teddyrpa...@gmail.com>wrote: > Can you confirm that the client store tables exist in the CF DSN that you > are referencing in your application file? > > Does XYZ have CDATA and CGLOBAL in it? > > > Teddy R. Payne, ACCFD > Google Talk - teddyrpa...@gmail.com > > > > On Tue, May 5, 2009 at 1:11 PM, Ajas Mohammed <ajash...@gmail.com> wrote: > >> Hi, >> >> I believe so because same sql server account/user is used to for all DSN >> we have i.e. about 10-15 dsn's and we never had this problem with any of the >> dsn's. So its really weird. >> >> We have two appl's lets say MainApp and SubApp where MainApp is /MainApp >> and subApp is /MainApp/SubApp. Both have there own Appplication.cfm file and >> we have clientmanagement yes and clientstorage pointing to same DSN lets say >> XYZ like this sessionmanagement="no" setclientcookies="yes" >> clientmanagement="yes" clientstorage="XYZ" >> >> One user was getting this error in MainApp and I was getting the same >> error in subApp. Some users were not getting *any* errors at all. >> >> I got rid of MainApp error using this code at very end of logout screen. >> <cfset >> client.hitcount = 1> .Thats strange because I dont use >> StructClear(Client). Someone mentioned that if you used StructClear then use >> hitcount. >> >> I am so confused now because client.hitcount thing worked and we havent >> used it for any of our sites which work fine. >> >> Any suggestions? By the way, I have not tried hitcount method on the >> SubApp application yet. >> >> >> <Ajas Mohammed /> >> http://ajashadi.blogspot.com >> We cannot become what we need to be, remaining what we are. >> No matter what, find a way. Because thats what winners do. >> You can't improve what you don't measure. >> Quality is never an accident; it is always the result of high intention, >> sincere effort, intelligent direction and skillful execution; it represents >> the wise choice of many alternatives. >> >> >> On Tue, May 5, 2009 at 12:51 PM, Teddy R. Payne <teddyrpa...@gmail.com>wrote: >> >>> Does the user that you bind for the datasource have access to create >>> table? >>> >>> Client storage creates two database tables: CDATA, CGLOBAL >>> >>> >>> Teddy R. Payne, ACCFD >>> Google Talk - teddyrpa...@gmail.com >>> >>> >>> >>> >>> On Tue, May 5, 2009 at 11:15 AM, Ajas Mohammed <ajash...@gmail.com>wrote: >>> >>>> Hi, >>>> >>>> I have a datasource defined lets say XYZ and I use this XYZ dsn as >>>> clientstorage. >>>> >>>> I am getting this error message after page request. Everything works >>>> fine except that the page has this error at end of page. >>>> >>>> 500 Operation failed on the data source named "XYZ". >>>> Operation failed on the data source named "XYZ". >>>> >>>> My search on google gave me clues that it could be a client variable >>>> causing problem or space for table storing client variables or Oracle >>>> db(which doesnt apply to me). So far, not sure what is the root of this >>>> problem. Which log file I need to check to track more info about this >>>> error? >>>> >>>> Any ideas as to what could be causing this error. >>>> >>>> Thanks, >>>> >>>> <Ajas Mohammed /> >>>> http://ajashadi.blogspot.com >>>> We cannot become what we need to be, remaining what we are. >>>> No matter what, find a way. Because thats what winners do. >>>> You can't improve what you don't measure. >>>> Quality is never an accident; it is always the result of high intention, >>>> sincere effort, intelligent direction and skillful execution; it represents >>>> the wise choice of many alternatives. >>>> >>> >>> >> >