An Unknown Error Occurred With The Destination Data Store
Developer Network (CDN) ForumsCitrix Insight ServicesCitrix ReadyCitrix Success KitsCloud Provider PackCloudBridgeCloudPlatform (powered by Apache CloudStack)CloudPortalDemo CenterDesktopPlayerEdgeSightEducationForum PrototypeHDX MonitorHDX RealTime Optimization PackHotfix Rollup PackJapanese ForumsKnowledge Center FeedbackLicensingLTSRNetScalerNetScaler E-Business CommunityNetScaler Gateway (Formerly Access Gateway)Profile ManagementProof of Concept KitsProvisioning ServerQuick Demo ToolkitReceiver, Plug-ins, and Merchandising ServerSecure GatewayShareFileSingle Sign-On (Password Manager)SmartAuditorStoreFrontTechnology PreviewsTrial SoftwareUniversal Print ServerUser Group CommunityVDI-in-a-BoxWeb InterfaceXenAppXenClientXenDesktopXenMobileXenServer Discussions Support Forums Products XenApp XenApp 5.0 for Windows Server 2008 XenApp 5.0 for 2008 - General Javascript Disabled Detected You currently have javascript disabled. Several functions may not work. Please re-enable javascript to access full functionality. DSMAINT MIGRATE Started by Tom Foster , 09 February 2009 - 03:40 AM Login to Reply 4 replies to this topic Tom Foster Members #1 Tom Foster 15 posts Posted 09 February 2009 - 03:40 AM Hi all, I am having a problem migrating the data store from access to sql... i have read heaps of stuff on the internet an am quite confident in its use however i keep getting an error and would really love any help from you guys...i have setup a database on my sql server and have set a sql user with access to it. i am able to log into server manager on the box locally with his user account....when i run dsmaint migrate i get the error:"An unknown error occured with the destination datastore while starting the migration process"so i assume its something to do with the user not authenticated to make changs to it or somethng? but i cant see what i have done wrong...does anyone have specific steps for creating the sql database and exactly what access is required...?thanks for your help.Tom. 1350-241605-1362801 Back to top - Arbil - Members #2
accidentally Active Directory Blog Certification PVS Web Interface Receiver Secure Gateway Presentations PowerShell XenApp XenApp 5 for Windows Server 2003 XenApp 5 for Windows Server 2008 XenApp 6 for Windows Server 2008 R2 XenApp 6.5 for Windows Server 2008 R2 XenDesktop XenServer Learning to Migrate a Citrix XenApp Data Store from Microsoft Access to Microsoft SQL Server May 27, 2010 XenApp, XenApp 5 for Windows Server 2003 27When a Citrix Farm is created, by default, the data store is created on the first server of the Farm using an Access database. This article will teach you how to backup an Access data store and migrate that data store from Access to SQL Server. There are a couple of http://discussions.citrix.com/topic/241605-dsmaint-migrate/ advantages to using Access for the data store: Easy to setup during XenApp installation No complicated ODBC DSN file to create or configure The disadvantages to using Access for the data store: If the XenApp server hosting the data store goes down or is restarted, Farm functionality is severely crippled Only recommended for very small Farms because of performance reasons No High Availability options Rarely included in backup or disaster recovery planning The advantages to http://carlwebster.com/learning-to-migrate-a-data-store-from-access-to-sql-server/ using SQL Server for the data store: Is not run on a XenApp server Can be used for any size Farm High Availability options Usually included in backup and disaster recovery planning For this article, VMware Workstation 6.5.1-126130 will be used with Windows Server 2008 Standard (x86) and Citrix XenApp for Windows Server 2008 Platinum (x86). The following Virtual Machines (VM) will be used: Domain Controller: CitrixDC The VM will be assigned one processor, 1GB of RAM and 16GB of Hard Drive space Domain Controller for the WebstersLab.com Active Directory domain Terminal Server License server and Citrix Licensing server Static IP Address 192.168.1.100 SQL Server: CitrixSQL1 The VM will be assigned one processor, 2GB of RAM and 16GB of Hard Drive space This VM will host the new migrated to SQL Server data store This VM will use SQL Server 2005 SP3 Static IP Address 192.168.1.101 XenApp 5 #1: CitrixXA1 The VM will be assigned one processor, 2GB of RAM and 16GB of Hard Drive space This VM will host the original Access data store Static IP Address 192.168.1.102 XenApp 5 #2: CitrixXA2 The VM will be assigned one processor, 2GB of RAM and 16GB of Hard Drive space This VM is used to show how to change additional XenApp servers to use the new SQL Server data store Static IP Address 192.168.1.103 CitrixDC has a file share named CTXBACKUP that I will use to store the data store back
/Thai /Arabic /Russian language /Portuguese /Cantonese /German /Italian language /Dutch /Greek /Classical ) CTX104535 MetaFrame Presentation Server 3.0 for Microsoft Windows 2000,MetaFrame Presentation Server 3.0 for Microsoft Windows 2003,MetaFrame XP 1.0 for Microsoft Windows 2000,MetaFrame XP 1.0 for Microsoft Windows 2003,Presentation Server 4.0 for Microsoft Windows MetaFrame Presentation Server 3.0 for Microsoft Windows 2000,MetaFrame Presentation Server 3.0 for Microsoft Windows 2003,MetaFrame XP 1.0 for Microsoft Windows 2000,MetaFrame XP 1.0 for Microsoft Windows 2003,Presentation Server 4.0 for Microsoft Windows 1970-01-01 1970-01-01 Archive:Error: An unknown error occurred while migrating the table... null SymptomsWhile migrating the data store from Access to SQL, the following error message appears and the migration fails:C:Documents and SettingsAdministrator.FTLRLAB>dsmaint migrate /srcdsn:"C:Program FilesCitrixIndependent Management Architecturemf20.dsn" /srcuser: /srcpwd: /dstdsn:"C:Program FilesCitrixIndependent Management Architecturemps31.dsn" /dstuser:sa /dstpwd:saAn unknown error occurred while migrating the table, please verify the destination datasource is clean.[Microsoft][ODBC SQL Server Driver][SQL Server]INSERT statement conflicted withCOLUMN FOREIGN KEY constraint 'FK__INDEXTABL__nodei__060DEAE8'. The conflict occurred in database 'MPS31', table 'KEYTABLE', column 'nodeid'. CTX107800 – [Document Not Found] does not report any errors in the data store.This behavior has been observed after upgrading and MetaFrame Presentation Server 3.0 server to Presentation Server 4.0. CauseA record in the INDEXTABLE that has no corresponding value in KEYTABLE causes the migration to fail.Resolution 1. Ensure that Microsoft Access is installed on the server holding the mf20.mdb. 2. Use Access to open the database (mf20.mdb) 3. Choose “Query” from the left menu and open “create query in design view” 4. Close the show table dialog box 5. Under the “view” menu, choose “SQL