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!
 External Development Forums - General External Development
Forum to discuss general external development topic (related or not to SalesLogix development). View the code of conduct for posting guidelines.
Forums RSS Feed


 Back to Forum List | Back to General External Development | New ThreadView:  Search:  
 Author  Thread: unable to initialize data dictionary
veeranjan
Posts: 19
 
unable to initialize data dictionaryYour last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 11 Dec 06 3:31 AM
fiogf49gjkf0d
when i tried to connect saleslogix server wich is located in other machine i got error like unable to initialize data dictionary what is the reason for this ?

thanx,
veeranjan
[Reply][Quote]
Guy Barrett
Posts: 63
 
Re: unable to initialize data dictionaryYour last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 12 Apr 07 11:13 AM
fiogf49gjkf0d
If your main SLX host server is running SQL Server 2005 then you will need to install the SQL Server 2005 - Native Client on the client machine. It is on the SQL Server 2005 install disk.
[Reply][Quote]
Melch
Posts: 1
 
Re: unable to initialize data dictionaryYour last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 29 Aug 07 9:14 AM
I have the same problem on oracle 9i(2.0.4). Can somebody help with it?
[Reply][Quote]
Dave
Posts: 36
 
Re: unable to initialize data dictionaryYour last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 30 Aug 07 1:41 AM
SLX version? DB?

I've had the same trouble with SLX 6.2 on Oracle 9i DB because of different regional settings.
Oracle Client "learns" from regional settings...

Dave.
[Reply][Quote]
shilpa
Posts: 18
 
Re: unable to initialize data dictionaryYour last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 09 Oct 07 6:17 AM
Windows firewall may be blocking the SLXSYSTEM
so go to control panel -->windowsfirewall
disable it
[Reply][Quote]
Ron Buchanan
Posts: 72
 
Re: unable to initialize data dictionaryYour last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 22 Oct 07 2:59 PM
Guy,
Thanks for posting the fix!!!

After wasting a couple hours trying to debug (thinking it was McAffee.... so did tech support). I actually ended up taking the SLXNCLI.msi file from the CD and posting to our install directory on the network.

My thanks to you dude!

Cheers,
Ron
[Reply][Quote]
Guy Barrett
Posts: 63
 
Re: unable to initialize data dictionaryYour last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 23 Oct 07 3:30 AM
No problem at all. You can also download the native client directly from the Microsoft site...

http://www.microsoft.com/downloads/details.aspx?familyid=d09c1d60-a13c-4479-9b91-9e8b9d835cdc&displaylang=en

The native client install is about halfway down the page.

[Reply][Quote]
Snow Monkey
Posts: 214
 
Re: unable to initialize data dictionaryYour last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 25 Oct 07 9:03 AM
I got it yesterday with a 7.2 system sitting on 2005.But i also got the message that invalid table systeminfo.So i looked at the new sql server and got to know that sysdba had admin roles associated with it and when i removed that role , it worked!

dont know if that is the case here.....
[Reply][Quote]
RJ Eaton
Posts: 234
 
Re: unable to initialize data dictionaryYour last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 29 Oct 07 10:13 AM
Got the error this morning, script was working fine on Wednesday and errored today same code with the above error.

On SQL 2000 not 2005...


sysdba only has a db-owner role, that comes default even with slx-eval db


[Reply][Quote]
Frank Chaffin
Posts: 475
 
Re: unable to initialize data dictionaryYour last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 29 Oct 07 11:41 AM
Very strange that the issue is coming and going.

Why don't you run the SLX SQL Profiler and see what is going on when the error happens.

[Reply][Quote]
RJ Eaton
Posts: 234
 
Re: unable to initialize data dictionaryYour last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 29 Oct 07 12:23 PM
Frank,

strangest thing, I tried a bit later and the issue has disappeared. It seems the DBA's forgot to set the name pipes for SQL server after applying some patches over the weekend. I tried this same script nho changes to it and it ran perfectly fine. This is a strange issue that creeps up.
[Reply][Quote]
joe
Posts: 26
 
Re: unable to initialize data dictionaryYour last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 10 Feb 09 2:13 PM
This was my solution to the GENERIC (data dictionary) problem.

http://www.egilh.com/blog/archive/2005/08/04/1217.aspx
[Reply][Quote]
Chris Fleetwood
Posts: 35
 
Re: unable to initialize data dictionaryYour last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 17 May 11 9:30 AM
fiogf49gjkf0d

I know this is an old post, but I'm getting the same "Unable to Initialize Data Dictionary" message when trying to make a OleDBConnection from a .NET web page.  The connection string in question is valid and works on another of our web servers.  I activated the SLX Profiler and tried to execute the same page/command again.  Here is the last command it was trying to execute in the profiler:


 SELECT P.COCLASS, P.NAME, P.SLXOLEDBPLUGINDATAID, P.PRIMARYDLL, PD.MODIFYDATE, S.FUNCTIONNAME FROM slxsqlscalarfn s INNER JOIN sysdba.slxoledbplugin p ON (s.SLXOLEDBPLUGINID = p.SLXOLEDBPLUGINID)INNER JOIN sysdba.SLXOLEDBPLUGINDATA PD ON (P.SLXOLEDBPLUGINDATAID = PD.SLXOLEDBPLUGINDATAID) WHERE P.OBJECTTYPE = 'S' AND P.ENABLED =

'T'



 


We're on SQL 2005.  The SQL Native Client is installed.  Any ideas or insights?

[Reply][Quote]
Raul A. Chavez
Posts: 1300
Top 10 forum poster: 1300 posts
 
Re: unable to initialize data dictionaryYour last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 17 May 11 2:55 PM
fiogf49gjkf0d

How about Name resolution?


  Are you able to create a connection directly to the SQL server (you could test it using an UDL file)?


  Make sure if you do so, to use the exact name for the SQL server as defined on the entry within Connection Manager on the Server.


 


 

[Reply][Quote]
Chris Fleetwood
Posts: 35
 
Re: unable to initialize data dictionaryYour last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 18 May 11 9:30 AM
fiogf49gjkf0d
Yes.  I created a UDL file on the web server and used the SQL Native Client as the provider.  The connection worked.

 

The Connection Manager on the Saleslogix server has the expected name in the entry.  I also manually created a Saleslogix UDL on the web server and it worked as well.

 

It appears not to work only when the OleDBConnection is instantiated from the page on the web server.  I compared the connection string used in the web page with the one in the UDL file and they are basically the same.

 

 
[Reply][Quote]
Chris Fleetwood
Posts: 35
 
Re: unable to initialize data dictionaryYour last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 26 May 11 12:54 PM
fiogf49gjkf0d

One thing I have noticed:  On the server where the connection is working,  the Event Viewer shows the "Privilege Use" Success Audit record; that server is set up in IIS as "Anonymous access" with Windows Authentication and the corresponding user account as "IUSR_ServerName".  On the server that has the issue, IIS is also set up as "Anonymous access "with Windows Authentication and the corresponding user account as "IUSR_ServerName"; However, my personal login ID is showing up as the user in the Failure Audit log record. 


 


 

[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 6:12:55 PM