Home | Forums | Contact | Search | Syndication  
 
 [login] [create account]   Monday, November 25, 2024 
 
slxdeveloper.com Community Forums  
   
The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!
 Architect Forums - Legacy Development
Forum to discuss SalesLogix legacy development including views, scripts, etc.. View the code of conduct for posting guidelines.
Forums RSS Feed


 Back to Forum List | Back to Legacy Development | New ThreadView:  Search:  
 Author  Thread: Unknown error connecting to database with 5.2.4
Chris Donaldson
Posts: 30
 
Unknown error connecting to database with 5.2.4Your last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 19 Jan 11 8:50 AM
fiogf49gjkf0d

I know this is probably not the right place for this, however I am running out of options.  With no changes to the db, we came in this morning and are unable to connect any client software to the database.  The error we receive at login says:


Error reading _1.OpportunityWizardViews.Strings:  Invalid property value.


We had one client which did not reboot last night and with a reboot of the server and an F5 at the client, it is still able to access data and perform functions as normal.  We just cannot connect any other clients (Sales/Support/or WGA/Architect). 


After clearing the error above, you get the following extremely informative message:


An unknown error has occured trying to connect to the database.


 


If anyone can shed some light, we would greatly appreciate it.


 


Thanks...ChrisD

[Reply][Quote]
Raul A. Chavez
Posts: 1300
Top 10 forum poster: 1300 posts
 
Re: Unknown error connecting to database with 5.2.4Your last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 19 Jan 11 11:28 AM
fiogf49gjkf0d

Were there any Windows updates applied to the Clients prior to the reboots ?


 

[Reply][Quote]
Chris Donaldson
Posts: 30
 
Re: Unknown error connecting to database with 5.2.4Your last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 19 Jan 11 12:04 PM
fiogf49gjkf0d

No, that was one of the first things I checked...


We did a restore to the previous days backup and it works fine.  Something changed yesterday in a table somewhere that we are trying to identify.  It appears that it will not even connect to the data.  When you try to login, everything works fine (bde, etc.).  Right now, when you type in your password and hit ok, the cursor doesn't even move from that field.  It is as if it is doing nothing and then if you hit ok again, you get the second error mentioned in the original post.


If anyone could suggest which tables to replace between the two days to see if there is something configuration wise that could be the issue, that would be appreciated.  Along this line, we have already tried replacing the plugin table and it did not change anything.


 


Thanks...


ChrisD

[Reply][Quote]
Chris Donaldson
Posts: 30
 
Re: Unknown error connecting to database with 5.2.4Your last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 19 Jan 11 1:00 PM
fiogf49gjkf0d

Not sure what happened but we had to replace the following tables from a previous day that was working fine...


GlobalSettings


Plugin


Resynctable


sectabledef


systeminfo


 


Strange yet we are back up and running...Thanks...

[Reply][Quote]
RJ Samp
Posts: 973
Top 10 forum poster: 973 posts
 
Re: Unknown error connecting to database with 5.2.4Your last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 24 Jan 11 12:55 PM
fiogf49gjkf0d

Well you know the old TRUNCATE TABLE stuff can wreak havoc on a SLX database.....

[Reply][Quote]
 Page 1 of 1 
  You can subscribe to receive a daily forum digest in your user profile. View the site code of conduct for posting guidelines.

   Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!
 

 
 slxdeveloper.com is brought to you courtesy of Ryan Farley & Customer FX Corporation.
 This site, and all contents herein, are Copyright © 2024 Customer FX Corporation. The information and opinions expressed here are not endorsed by Sage Software.

code of conduct | Subscribe to the slxdeveloper.com Latest Article RSS feed
   
 
page cache (param): 11/25/2024 7:44:29 AM