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. >>> >> >> >
