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!

Administration Forums - Database Administration
Forum to discuss SQL Server or Oracle database administration related to SalesLogix databases. View the code of conduct for posting guidelines.

Forums RSS Feed

Back to Forum List | Back to Database Administration | New Thread

View: Search:

Author

Thread: DataDictionary problem

Andrew Risbey
Posts: 3

DataDictionary problem Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 16 Apr 08 1:03 PM

I've just moved a 6.1.2 setup from SQL 2000 to a new Windows Server 2003 server with SQL Server 2005 (Standard Ed). I can login to Administrator and Architect and connect to the database - but data changes are not being saved. Every time I try to update data in Administrator it creates this error in the event log:

Source : odbcdrv_open_cursor
Description : An error occurred attempting to retrieve table information from the datadictionary component.
Table method returned : SalesLogix OLEDB DataDictionary Access - ERROR Invalid Table Not Found in DataDictionary Buffer

I did the usual stuff with the sysdba orphaned user and I have also confirmed the sysdba login works via SQL Management Studio.

When I try to login to the Sales client, it logs the user in (shown as logged in via Administrator) but it fails to load correctly - seems to fail when loading activities.

If anyone can cast any light on this it would be much appreciated.

[Reply][Quote]

Matt Dockins
Posts: 159

Re: DataDictionary problem Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 20 May 08 10:35 AM

Andrew is sounds as if you didn't apply the upgrade bundle after running the conversion. You get this error when that step is skipped because required tables weren't created.

EDIT: I just noticed you posted this on April 16th, hopefully you haven't been foundering around with this problem for a month!

[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 \|

page cache (param): 11/25/2024 2:36:18 PM