Home > An Unknown > An Unknown Error Occurred With The Destination Data Store

An Unknown Error Occurred With The Destination Data Store

Name (required) Mail (will not be published) (required) Website Current [emailprotected] * Leave this field empty Support Script DevelopmentI've spent over 4,000 hours working on the 25 documentation and miscellaneous scripts, Website Design by Skyrocket Websites Skip Navigation Open Menu Close Menu Apple Developer Account Apple Developer Discover Design Develop Distribute Support Account Search API ReferenceOpen MenuClose MenuCore DataValidation Error CodesValidation Error If any errors are received, go to http://support.citrix.com and search for the error number. CauseA record in the INDEXTABLE that has no corresponding value in KEYTABLE causes the migration to fail.Resolution 1. http://lanprolab.net/an-unknown/an-unknown-error-has-occurred-app-store-10-6-8.php

Figure 19 If a successful connection to the SQL Server is made click Next.  A common problem is the Windows Firewall is not configured to allow SQL traffic (TCP Port 1433).  To 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 The request cannot be fulfilled by the server The request cannot be fulfilled by the server Leave a Reply Click here to cancel reply. http://discussions.citrix.com/topic/241605-dsmaint-migrate/

the stupid thing is that when i create the DSN file through odbc i can use this sql user account and it all connects succesfully so you would assume its ok...there If the following error is received: "Result: "an unknown error occurred while migrating the table, please verify the destination datasource is clean. [Microsoft][ODBC SQL server Driver][SQL server]violation of primary key constraint Figure 13 Change the Look in to C:\Program Files\Citrix\Independent Management Architecture.  The new DSN must be placed in this folder.  The IMASERVICE service is programmed to look in only this folder.

Click Start -> Administrative Tools -> Data Sources (ODBC). All Rights Reserved Privacy & Terms TRENDING: Setting Microsoft SCCM Report on Local Printers You Were not connected because a duplicate name exists ... Past Events about us An open platform for mutual Citrix, and help each other to provide Chinese users in China and help among members. Focus on Citrix can make a connection "User", "business", "engineer" of the internet.CTX.org.cn contact us 2330561900 info[a]CTX.org.cn Partner 快递查询 Copyright © 2014 CTX.org.cn Inc.

Figure 26 Your new DSN is created.  Click OK. View all posts by Carl Webster → Subscribe Subscribe to our e-mail newsletter to receive updates. Note that you must install the ODBC driver locally to use a File DSN.  File DSNs are not stored in the Windows registry. http://carlwebster.com/learning-to-migrate-a-data-store-from-access-to-sql-server/ All rights reserved.

The conflict occurred in database "Citrix_DS", table "dbo.KEYTABLE", column 'nodeid'.” A quick google gave me the solution http://support.citrix.com/article/CTX112866 I had to stop the IMA service before I got follow these steps, After correcting this I ran DSMaint migrate again but now received the message “An unknown error occurred while migrating the table, please verify the destination datasource is clean. [Microsoft][ODBC SQL Server Figure 34 Type in DSMAINT CONFIG /user:websterslab\administrator /pwd:password /dsn:"C:\Program Files\Citrix\Independent Management Architecture\WebsterFarmDSMF20.dsn" and press Enter. NEXT 下一篇 Archive: Diagnostic Facility COM Server Service, CdfSvc.exe, fails to start.

Carl Webster: Done Webster... https://kb.vmware.com/kb/2000026 Figure 22 Click Finish. Note: What is ODBC?  This is taken from http://support.microsoft.com/kb/110093 "Open Database Connectivity (ODBC) is Microsoft’s strategic interface for accessing data in a heterogeneous environment of relational and non- relational database management From a command prompt on CitrixXA1, the following command was run to generate a backup: dsmaint backup \\CitrixDC\CTXBackup The command "dsmaint backup" makes a copy of the MF20.mdb Access data store to

Figure 17 Click Finish. More about the author You learned how to: backup an Access data store Create a new File DSN for a SQL Server data store Migrate to the new data store Configure all XenApp servers to communicate with Figure 32 Figure 33 Next DSMAINT CONFIG needs to be run.  The /pwd option needs to be used and according to the XenApp Administrator’s Guide: "You must stop the Citrix Independent Any user who logs on to a computer that has permission to access the data source can use a System DSN.

DSMAINT CONFIG /user:websterslab\administrator /pwd:password /dsn:"C:\Program Files\Citrix\Independent Management Architecture\WebsterFarmDSMF20.dsn" and press Enter. Figure 36 Type in CD "C:\Program Files\Citrix\Independent Management Architecture" and press Enter. Note:  If you have a Microsoft SQL Server DBA available, please reference the Citrix Support article Citrix Presentation Server and Microsoft SQL 2005 Configuration. check my blog Brown Gabe Knuth Greg Shields Helge Klein Henrik Johansson Jarian Gibson Jason Conger Javier Sanchez Alcazar Jim Moyle Joe Shonk John Smith Mike Nelson Neil Spellings Nico Luedemann Pierre Marmignon Remko

Figure 15 Click on SQL Server and click Next. To create the SQL Server data store database, open SQL Server Management Studio.  Click Start -> All Programs -> Microsoft SQL Server 2005 -> SQL Server Management Studio. Right click on each record and choose delete.9.

Copy the new DSN file to the remaining XenApp server’s C:\Program Files\Citrix\Independent Management Architecture folder.

Figure 30 When the migration completes, answer Yes to the Dsmaint comparison popup. Note:  What is the difference between "User DSN", "System DSN" and "File DSN"?  This is taken from http://support.microsoft.com/kb/213772. Press the run button (the red exclamation point) in tool bar. 8. Related Documents PREV 上一篇 Archive: Error: Add user (Format:DOMAINusername) �Domain#user" is an illegal user name.

On any of the XenApp servers, start the Access Management Console (AMC). 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 Figure 24 If the message TESTS COMPLETED SUCCESSFULLY is shown, click OK.  Otherwise, you will need to troubleshoot the ODBC connection to the SQL Server. news Figure 18 Enter a Description and type in the name of the SQL Server and click Next.

Close the show table dialog box 5. Webster has been working with Citrix products for many years starting with Multi-User OS/2 in 1990. Jump to content Citrix Citrix Discussions Log In Citrix.com Knowledge Center Product Documentation Communities Blogs All CategoriesAppDNAArchived Products (includes End of Life)Citrix CloudCitrix Connector for System CenterCitrix Developer ExchangeCitrix Developer Network Some programs, such as Microsoft SQL Server or Microsoft Internet Information Server (IIS), require a System DSN.

Figure 10 The new data store database is ready for use.