Troubleshooting an import that is taking a long time to completeIssue <!-- div.margin{ padding: 10px 40px 40px 30px; } table.tocTable{ border: 1px solid; border-color:#E0E0E0; background-color: rgb(245, 245, 245); padding-top: .6em; padding-bottom: .6em; padding-left: .9em; padding-right: .6em; } table.noteTable{ border:1px solid; border-color:#E0E0E0; background-color: rgb(245, 245, 245); width: 100%; border-spacing:2; } table.internalTable{ border:1px solid; border-color:#E0E0E0; background-color: rgb(245, 245, 245); width: 100%; border-spacing:0; } .sp td{ border-bottom: 1px solid; border-right: 1px solid; border-color:#E0E0E0; background-color: #ffffff; height: 20px; padding-top: .5em; padding-bottom: .5em; padding-left: .5em; padding-right: .5em; } .sphr td{ border-right: 1px solid; border-bottom: 1px solid; border-color:#E0E0E0; background-color: rgb(245, 245, 245); padding-top: .5em; padding-bottom: .5em; padding-left: .5em; padding-right: .5em; height: 20px; } .title { color: #D1232B; font-weight:; font-size:25px; } .hd1{ color: #D1232B; font-weight:; font-size:18px; } .hd2{ color: #646464; font-weight:bold; font-size:16px; text-decoration: underline; } .hd3{ color: #7a7a7a; font-weight:; font-size:16 px; text-decoration:; } .hd4{ color: #000000; font-weight:bold; font-size:14 px; text-decoration:; } --> This article guides you through the process of troubleshooting an import that is taking a long time to complete. It provides steps to help you eliminate common causes for your problem by verifying that the configuration of your networking is correct. Symptoms may include the following: No rows are returnedConnectivity issues (log message)Import takes a really long timeImport does not completeImport stopped in the middleImport says complete, but not all data is presentUser cannot log in through LDAPScheduled import does not run at the defined timeData discrepency after reportData is truncatedImport fails after upgrade ResolutionDetermine whether any of the troubleshooting steps below are true for your environment. Each step provides a link to an article that can help you eliminate possible causes and take corrective action as necessary. Determine if there is a significant number of records being imported. For more information, see KB0538405: Determining if there is a significant number of records being imported.Determine if a business rule script is impacting your import. For more information, see KB0538161: Determining if a business rule is running on top of a transform map.Determine if another process is running at the same time as the import. For more information, see KB0538402: Determining if another process is running at the same time as the import. Note: If your problem still exists after trying the steps in this article, submit an incident to Technical Support and note this Knowledge Base article ID (KB0538434) in the problem description. For more information, see Submitting an Incident.