import hangs - after deletion of leads records.

[TakeMarket]

We have a new installed instance of sugarcrm, in which we uploaded/imported the leads DB to successfully.

In all 2 leads lists/db's

1 with Swedish leads. (about 677 leads)

2 with danish leads (about 250 leads)

Now - we saw we had made a mistake with the import so we had to delete all imported leads, and start all over again.

So we did,

We started with importing the Swedish database/leads with a successful import.

After that we tried to import the danish database/leads and sugar hands on the step "Import started at time XX:xx" (at Step 3)

Very odd, any ides to help us out on this one??

Specs:
Sugarcrm Version 5.0.0b (Build 3150)
Ms 2003 server ent. SP2
MS SQl server Enterprise SP2
php 5.2

Thanks in advance!

[TakeMarket]

Hm... this is weird...

We can delete all data, and import the Swedish DB, again and again but the danish DB doesn't work.

Note that when we imported the databases the first time it went smoothly and without any issues at all.

But now the only DB that is accepted by sugarcrm is the Swedish, and the weirdest part is that we haven't really changed any fields/cells in the .csv file/s, with 1 exception - we have added exactly the same data in 4 new fields.

But that should'nt make any difference since its the same data replicated in both BDs and sugar is importing the Swedish leads wihtout any issues at all.

So.. what could be the answer to the riddle here?

[kbrill]

change your logging level to "info" (in log4php.properties) and this will show you each SQL query that is run (in the sugarcrm.log file). Import your data and see which line is the last one to be imported and then you know that the issue is either on that line or the next line. Let us know if you find something or can't see it.

[TakeMarket]

Hi Kenneth,

Thank you for your reply and you input, we try do the suggested.


Hope it wil work , because for now we 2 emplyees manually entering the data of the Danish leads...

We post how it went.

[TakeMarket]

Kenneth...

You are a star!


It worked more then well - it worked excellent!

You have saved us from entering around 700 leads manally! (had already done 200)

Thank you a LOT!

It was a one lead that made the fuss, the account name was to long, and sugar saw it as it had "odd quotes".

Again Kenneth, thank you a lot - you have saved our day.

[TakeMarket]

change your logging level to "info" (in log4php.properties) and this will show you each SQL query that is run (in the sugarcrm.log file). Import your data and see which line is the last one to be imported and then you know that the issue is either on that line or the next line. Let us know if you find something or can't see it.

Hi Kenneth Brill,

Got an new issue on our necks...

04/22/08 00:21:08,835 [684] FATAL SugarCRM - SQL Server error: Error converting data type varchar to numeric.
  04/22/08 00:21:08,836 [684] INFO SugarCRM - Query:SELECT * FROM email_addresses WHERE email_address = 'someonesmailadress@live.dk' and deleted=0
  04/22/08 00:21:08,837 [684] INFO SugarCRM - Query Execution Time:0.00070800000000004
  04/22/08 00:21:08,838 [684] INFO SugarCRM - Query:INSERT INTO email_addr_bean_rel (id, email_address_id,bean_id, bean_module,primary_address,reply_to_address,date_created,date_modified,deleted) VALUES('cbec7e91-ec24-5493-8e29-480d13160618', 'd8a3d6f5-8c88-0ad0-acd8-480cd4398ae1', 'c4e6f5a7-c362-f6e1-124e-480d13d2a0a5', 'Leads', 1, 0, '2008-04-22 00:21:08', '2008-04-22 00:21:08', 0)
  04/22/08 00:21:08,840 [684] INFO SugarCRM - Query Execution Time:0.001212
  04/22/08 00:21:08,843 [684] INFO SugarCRM - Insert: INSERT INTO users_last_import (id,assigned_user_id,bean_type,bean_id,deleted ) VALUES ( 'cd3caff7-3bd0-cde5-bc4c-480d132d68d0','1','Leads','c4e6f5a7-c362-f6e1-124e-480d13d2a0a5','0')
  04/22/08 00:21:08,844 [684] INFO SugarCRM - Save: INSERT INTO users_last_import (id,assigned_user_id,bean_type,bean_id,deleted ) VALUES ( 'cd3caff7-3bd0-cde5-bc4c-480d132d68d0','1','Leads','c4e6f5a7-c362-f6e1-124e-480d13d2a0a5','0')
  04/22/08 00:21:08,844 [684] INFO SugarCRM - Query:INSERT INTO users_last_import (id,assigned_user_id,bean_type,bean_id,deleted ) VALUES ( 'cd3caff7-3bd0-cde5-bc4c-480d132d68d0','1','Leads','c4e6f5a7-c362-f6e1-124e-480d13d2a0a5','0')
  04/22/08 00:21:08,846 [684] INFO SugarCRM - Query Execution Time:0.001482

"Error converting data type varchar to numeric."

Any ideas on this one?

[TakeMarket]

I forgot to mention that is a Microsoft 2005 SQL server...

Thanks

[TakeMarket]

thats odd. Its only the last record (cells) that is triggered - there was 127 records to be imported - 126 is actually imported - but last one in the .cvs db is always with errors. This alos applies to we delete the records 127, then 126 is triggered with errors and "only 125 get imported"

Hmmm..?