SugarCRM 6.4 import parsing issue

**Tostino** · 2012-02-22, 03:31 PM

Hello all, this is my first post =).

So I have been tasked by my boss with getting all of our data from our old, in-house-built CRM system (which was HORRIBLE... worst thing you could ever imagine), into SugarCRM.

I have sugar running on windows server 2008 r2, with IIS and php 5.3.10. It is connecting to our database server which is running Sql Server 2008 R2.

I've written some export queries to get account data, and now contact data into csv files in the right format.

So i've got an accounts file with about 400,000 records, and a contacts file with a little over 2 million records.
The issue comes up when importing either accounts or contacts... When I have an accounts record that contains "union" in the name, or a contacts record that has "union" in the accounts name: the import will blow up. The following error log is from trying to import contacts (see the bolded line at the bottom). It fails on the same records every time (until I change the word "union" to something else).

Code:

02/21/12 22:43:37 [2172][1a77e952-6180-94d5-1e98-4f3441c196ea][FATAL] Loading import map properties.
02/21/12 22:43:59 [2172][1a77e952-6180-94d5-1e98-4f3441c196ea][ERROR] File upload://IMPORT_Contact_1a77e952-6180-94d5-1e98-4f3441c196ea-0 cannot be touched
02/21/12 22:43:59 [2172][1a77e952-6180-94d5-1e98-4f3441c196ea][ERROR] File upload://import/dupes_1a77e952-6180-94d5-1e98-4f3441c196ea.csv cannot be touched
02/21/12 22:43:59 [2172][1a77e952-6180-94d5-1e98-4f3441c196ea][ERROR] File upload://import/dupesdisplay_1a77e952-6180-94d5-1e98-4f3441c196ea.csv cannot be touched
02/21/12 22:43:59 [2172][1a77e952-6180-94d5-1e98-4f3441c196ea][ERROR] File upload://import/errorrecords_1a77e952-6180-94d5-1e98-4f3441c196ea.csv cannot be touched
02/21/12 22:43:59 [2172][1a77e952-6180-94d5-1e98-4f3441c196ea][ERROR] File upload://import/errorrecordsonly_1a77e952-6180-94d5-1e98-4f3441c196ea.csv cannot be touched
02/21/12 22:43:59 [2172][1a77e952-6180-94d5-1e98-4f3441c196ea][ERROR] File upload://IMPORT_Contact_1a77e952-6180-94d5-1e98-4f3441c196ea-1 cannot be touched
02/21/12 22:43:59 [2172][1a77e952-6180-94d5-1e98-4f3441c196ea][ERROR] File upload://IMPORT_Contact_1a77e952-6180-94d5-1e98-4f3441c196ea-2 cannot be touched
02/21/12 22:43:59 [2172][1a77e952-6180-94d5-1e98-4f3441c196ea][ERROR] File upload://IMPORT_Contact_1a77e952-6180-94d5-1e98-4f3441c196ea-3 cannot be touched
02/21/12 22:43:59 [2172][1a77e952-6180-94d5-1e98-4f3441c196ea][ERROR] File upload://IMPORT_Contact_1a77e952-6180-94d5-1e98-4f3441c196ea-4 cannot be touched
02/21/12 22:43:59 [2172][1a77e952-6180-94d5-1e98-4f3441c196ea][ERROR] File upload://IMPORT_Contact_1a77e952-6180-94d5-1e98-4f3441c196ea-5 cannot be touched
02/21/12 22:43:59 [2172][1a77e952-6180-94d5-1e98-4f3441c196ea][ERROR] File upload://IMPORT_Contact_1a77e952-6180-94d5-1e98-4f3441c196ea-6 cannot be touched
02/21/12 22:44:16 [2172][1a77e952-6180-94d5-1e98-4f3441c196ea][FATAL] Caught error: stat(): stat failed for upload/import/error_1a77e952-6180-94d5-1e98-4f3441c196ea.csv
02/21/12 22:44:16 [2172][1a77e952-6180-94d5-1e98-4f3441c196ea][FATAL] Caught error: touch(): Unable to create file upload://import/error_1a77e952-6180-94d5-1e98-4f3441c196ea.csv because Invalid argument
02/21/12 22:44:16 [2172][1a77e952-6180-94d5-1e98-4f3441c196ea][ERROR] File upload://import/error_1a77e952-6180-94d5-1e98-4f3441c196ea.csv cannot be touched
02/21/12 22:44:23 [2172][1a77e952-6180-94d5-1e98-4f3441c196ea][FATAL] Caught error: stat(): stat failed for upload/import/status_1a77e952-6180-94d5-1e98-4f3441c196ea.csv
02/21/12 22:44:23 [2172][1a77e952-6180-94d5-1e98-4f3441c196ea][FATAL] Caught error: touch(): Unable to create file upload://import/status_1a77e952-6180-94d5-1e98-4f3441c196ea.csv because Invalid argument
02/21/12 22:44:23 [2172][1a77e952-6180-94d5-1e98-4f3441c196ea][ERROR] File upload://import/status_1a77e952-6180-94d5-1e98-4f3441c196ea.csv cannot be touched
02/21/12 22:45:22 [2936][1a77e952-6180-94d5-1e98-4f3441c196ea][FATAL] Want only a single row Query Failed:SELECT TOP 1 * FROM () as top_count  order by select id from accounts where name = N'union pacific' and deleted != 1::: [Microsoft][SQL Server Native Client 10.0][SQL Server]Incorrect syntax near ')'.
02/21/12 22:45:28 [2936][1a77e952-6180-94d5-1e98-4f3441c196ea][FATAL] Slow Query (time:0.60177111625671
 SELECT  TOP 6  accounts.id , accounts.name , accounts.website , accounts.phone_office , accounts.billing_address_country , accounts.assigned_user_id  FROM accounts  where ((accounts.assigned_user_id = '1a77e952-6180-94d5-1e98-4f3441c196ea')) AND accounts.deleted=0 ORDER BY accounts.date_entered DESC

I did a test, and I went and did a replace in the csv file to change the word "union" to "unlon". The import went fine.
This tells me that there is an issue parsing the data in my csv, and it is erroneously thinking that "union" in the name, is trying to run it as the T-Sql union.

I have no idea what else I can do.

I have attached an example file, one of those records will work on import, the other will always fail.

I am kinda new to the community, and new to CRM systems in general. If I have missed any key information, please let me know and I will try and get you that asap.

**Tostino** · 2012-02-22, 08:21 PM

I have submitted a bug report on this issue: SugarCRM Bug Tracker | Open Source Business & Social CRM - SugarCRM

It seems to be an issue with the Sql Server codebase. I did a new install connected to MySQL, and the exact same .csv files are importing fine.