RE: [Axapta-Knowledge-Village] Axapta and indexes

[Malcolm Burtt]

Title: Message





Hi
 
Find the USERINFO table under your database in SQL Manager. 
Right click and select Design Table. Right Click on a field name and select 
indexes. You'll see a combobox with the index names and a button that lets you 
delete the index.
 
The index name 'I_65531OSACCOUNTNAME'  is correct 
though (I have the same index in Ax 3.0), so it sounds more like you just need 
to synchronise your database. My guess is that if you go looking for the index 
so that you can delete it you'll not actually find it (which is, after all, what 
the error message that you got is saying).
 
Malcolm


From: Axapta-Knowledge-Village@yahoogroups.com 
[mailto:[EMAIL PROTECTED] On Behalf Of James 
FlavellSent: 01 August 2005 08:12To: 
Axapta-Knowledge-Village@yahoogroups.comSubject: RE: 
[Axapta-Knowledge-Village] Axapta and indexes

Thanks 
Malcom but where can I find indexes in SQL manager....are they in master 
sysindexes table??? maybe I am missing something very simple I just dont seem to 
be able to locate indexes via the SQL manager...
Thanks
James
 

  
  -----Original Message-----From: 
  Axapta-Knowledge-Village@yahoogroups.com 
  [mailto:[EMAIL PROTECTED] On Behalf Of Malcolm 
  BurttSent: 01 August 2005 17:01To: 
  Axapta-Knowledge-Village@yahoogroups.comSubject: RE: 
  [Axapta-Knowledge-Village] Axapta and indexes
  Hi
   
  You could try deleting that index from SQL Enterprise 
  Manager and then run a synchronise from Axapta.
   
  Good luck
   
  Malcolm.
  
  
  From: Axapta-Knowledge-Village@yahoogroups.com 
  [mailto:[EMAIL PROTECTED] On Behalf Of James 
  FlavellSent: 30 July 2005 04:34To: 
  Axapta-Knowledge-Village@yahoogroups.comSubject: 
  [Axapta-Knowledge-Village] Axapta and indexes
  
  Hi 
  Malcom, Andrea, David and everyone else in the group
   
  This 
  question is a mix of std Axapta understanding and help for a Ax 2.1 SQl7 to 
  SQL2000 upgrade ....
   
  I 
  have finally managed to do an upgrade of my customers SQL7 AX DB to 
  SQL2000 using DTS.  Everything looks okay on the SQL side but when I 
  try to launch Axapta 2.1 with the SQL2000 I get the error 
  message:
   
  Index 'I_65531OSACCOUNTNAME' on table 'USERINFO' (specified in the FROM 
  clause) does not exist
   
  A 
  few things I am not sure of:
  1) 
  Is this index a temporary index or is this a permanent index (just wondering 
  why it has a number on the front)?  The problem is I cannot see indexes 
  for this table in Axapta as it is a system table....
   
  2)Is 
  there any way to view indexes in SQL manager? As I say everything looks okay 
  in SQL but from what I know there is no way to see indexes so not sure whether 
  they exist in SQL and have not been copied in the DTS....
   
  3) 
  Any reason I might get this message and anyway to try to fix 
  it?
   
  I 
  look forward to cracking this and moving my customer into the 21st 
  century (aka SQL2000 ...although only partially since they still want to use 
  Ax2.1 ;) )
  Thanks
  James
   
  
    
    -----Original Message-----From: 
    Axapta-Knowledge-Village@yahoogroups.com 
    [mailto:[EMAIL PROTECTED] On Behalf Of 
    Malcolm BurttSent: 29 June 2005 23:52To: 
    Axapta-Knowledge-Village@yahoogroups.comSubject: RE: 
    [Axapta-Knowledge-Village] Ax 2.1 with SQL2000 wnd Windows 
    2003
    Hi
     
    Using "Change user /install" puts the terminal server 
    into a special mode that ensures registry changes made during the install 
    process happen in a manner compatible with terminal server usage of the 
    software. You still need admin rights to be able to do the 
    install.
     
    Using the standard Add/Remove programs option on the 
    control panel automatically executes a "Change user /install" command before 
    the installation begins and reverses it ("Change user /execute") once it 
    completes.
     
    Regards
     
    Malcolm
    
    
    From: 
    Axapta-Knowledge-Village@yahoogroups.com 
    [mailto:[EMAIL PROTECTED] On Behalf Of James 
    FlavellSent: 29 June 2005 14:24To: 
    Axapta-Knowledge-Village@yahoogroups.comSubject: RE: 
    [Axapta-Knowledge-Village] Ax 2.1 with SQL2000 wnd Windows 
    2003
    
    Hi 
    Malcom,
     
    Thanks agian for the input.
     
    Reading your post agian I just realised I have never installed 
    anything on a terminal server!!!  The change user/install and execute 
    you talk about I am guessing is basically to make sure the install is run 
    with adminstrator rights is it and therfore available to all terminal server 
    users??
     
    Thanks
    James
     
    
      
      -----Original Message-----From: 
      Axapta-Knowledge-Village@yahoogroups.com 
      [mailto:[EMAIL PROTECTED] On Behalf Of Raul 
      Llorente Peña/OPENSOLUTIONSSent: 24 June 2005 
      19:34To: 
      Axapta-Knowledge-Village@yahoogroups.comSubject: RE: 
      [Axapta-Knowledge-Village] Ax 2.1 with SQL2000 wnd Windows 
      2003I Agree Malcolm. 
      Raúl Llorente Peña 
      Análisis, Desarrollo e Implementación en Microsoft Bussiness 
      Solutions-AxaptaOPEN SOLUTIONS 
      
        
        
          "Malcolm Burtt" 
            <[EMAIL PROTECTED]> Enviado por: 
            Axapta-Knowledge-Village@yahoogroups.com 
            24/06/2005 09:35 
            
              
              
                
                  Por favor, 
                  responda 
                  aAxapta-Knowledge-Village@yahoogroups.com
          
            
              
              
                
                  Para
                <Axapta-Knowledge-Village@yahoogroups.com> 

              
                
                  cc
                
              
                
                  Asunto
                RE: 
                  [Axapta-Knowledge-Village] Ax 2.1 with SQL2000 wnd Windows 
                  2003
            
              
              
                
                Hi James   Our first 
      experience of Axapta was with version 2.1 running on SQL 2000, so I know 
      that works. I don't recall having to do anything special to make it work 
      (probably just as well as we were SQL Server & Axapta newbies at the 
      time).   We have always run inside terminal services and don't 
      get any problems with that either. You will need to install Axapta through 
      the Add/Remove programs function in Windows (or execute the command 
      "Change user /install" before installing and then "Change user /execute" 
      afterwards) or it won't load correctly.   I would 
      install 2.1 as described above from the installation CD (including 
      applying any services packs using the same approach) then replace the Appl 
      directory with your existing one.   
      Hope that helps. 
        Regards   
      Malcolm Burtt 
      Global IT Group"Business Solutions designed for 
      YOUR business processes"Global IT Group is the trading name of Touchstone Global 
      Business Solutions Ltd. and is part of the Touchstone Group 
      PLC. 
      -----Original Message-----From: 
      Axapta-Knowledge-Village@yahoogroups.com 
      [mailto:[EMAIL PROTECTED]On Behalf Of James 
      FlavellSent: 24 June 2005 00:42To: 
      Axapta-Knowledge-Village@yahoogroups.comSubject: 
      [Axapta-Knowledge-Village] Ax 2.1 with SQL2000 wnd Windows 
      2003Hi I hope some out 
      there are able to help with a rather old setup...   I have a 
      customer who is running Ax2.1 and they are very happy with it, therefore 
      they do not want to have to go through all the trouble of upgrading etc 
      but they want to run on SQL2000 (due to IT audit security concerns 
      etc).   Does anyone know if it is possible to run Ax2.1 with 
      SQL2000?  I know it will not work straight out of the box as I recall 
      for Ax2.5 there was some configuration on SQL you had to do (something 
      about Axapta and SQL reserved words clashing so you had to turn off some 
      features in SQL...or something like that...)   Anyone have an 
      actual site/experience with this configuration?   Also they want 
      to run on Windows 2003 via terminal services, to move the application to 
      such a machine what is the best approach? 1) install a standard ax2.1 and then delete the folders 
      and replace with the actual application? OR 2) just 
      copy the files to new server (I think this has possible system files not 
      registered problems right)   Is there any know issues with Windows 2003 
      termainl services and axapta?   
      Hoping some one can help 
      Thanks James   Sharing the knowledge on 
      Axapta. Sharing the knowledge on Axapta. 
      
      
      Yahoo! Groups Links 
      
        To visit your group on the web, go 
        to:http://groups.yahoo.com/group/Axapta-Knowledge-Village/  
        To unsubscribe from this group, send an email 
        to:[EMAIL PROTECTED]  
        Your use of Yahoo! Groups is subject to the 
        Yahoo! Terms of Service. Sharing the knowledge on 
      Axapta. Sharing the knowledge on Axapta. 
      Sharing 
    the knowledge on Axapta. 





Sharing the knowledge on Axapta.





  




  
  
  YAHOO! GROUPS LINKS



   Visit your group "Axapta-Knowledge-Village" on the web. 
   To unsubscribe from this group, send an email to: [EMAIL PROTECTED] 
   Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.