Skip to main content
S
Sitaga214
Inspiring
January 26, 2010
Question

Advanced Setting in Datasource Edit

  • January 26, 2010
  • 1 reply
  • 1672 views

I am getting the following error when opening the Datasource Advanced Settings:

Element DISABLE_AUTOGENKEYS is undefined in STDSN.

The error occurred in _cfsettings.cfm: line 95
Called from sqlserver.cfm: line 723
Called from sqlserver.cfm: line 1
-1 : Unable to display error's location in a CFML template.

It happens when adding a new Datasource or when editing an existing datasrouce.  Has anyone else seen this or know how to fix it?
This is Coldfusion 9 on Windows Server 2003.  Coldfusion was upgraded from CF8 right before this error started.
Thanks,
Bill
    This topic has been closed for replies.
    1 reply
    A
    Adam Cameron.
    Inspiring
    January 26, 2010
    Just to confirm, did you do an inline upgrade of the CF8 server?  It's a bit late now, but you really shouldn't upgrade a CF server, you should always set up a new CF instance and port the sites/applications across.  The reason being if you do an upgrade and it goes wrong (like it seems this one has), you're stuffed.
    Did you do a back-up of your CF install before you did the upgrade?  The quickest thing might be to revert to that so you're up and running again, and start the migration again.
    And... no... I have never seen that error.
    --
    Adam
    S
    Sitaga214Author
    Inspiring
    January 26, 2010
    I believe it was an inline upgrade, however the CF8 install directory is still present.  This is on our development server, so I wasn't too concerned with down time.  Do you think an uninstall/reinstall of CF9 would correct the issue or should I restore a back up and try the upgrade again?
    Thanks,
    Bill
    J
    Joshua_Cyr
    Participating Frequently
    January 26, 2010
    I would be interested to see the comparison of those files in cf 8 and cf 9.  Maybe install cf 9 locally fresh, then compare the files in question?  Perhaps a file permission issue caused the upgrade to miss or skip updating a few files?
    
        
                                                
    
        
    
    
    

            
    
                                        
    
            
                        
    
                                                                                                            
            

    

    

    

        
    
                    
    
    
    
    

    

    
    
    

                                        
    
                                                        
    
            
        
    
    

    

    

                                    
    Terms & ConditionsAccessibility statement
    
            
        

    

        
            
    
        
    
        



        
        
            


        
    

        
        
        
        
                                                        

                            
    
    
                    
    
  
    
    
    
      
        
      
    
    
    
    
      
        Using the community
      
      
        Terms of use
      
      
        Privacy
      
      
        Cookie preferences
      
      
        Do not sell or share my personal information
      
      
        ad choicesAdChoices