Results 1 to 8 of 8

Thread: import hangs - after deletion of leads records.

  1. #1
    TakeMarket is offline Sugar Community Member
    Join Date
    Apr 2007
    Posts
    133

    Exclamation import hangs - after deletion of leads records.

    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!
    Last edited by TakeMarket; 2008-04-19 at 01:11 AM.

    Kind regards
    Take Market™
    http://www.takemarket.com

    We take market for you.™

  2. #2
    TakeMarket is offline Sugar Community Member
    Join Date
    Apr 2007
    Posts
    133

    Question Re: import hangs - after deletion of leads records.

    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?
    Last edited by TakeMarket; 2008-04-19 at 01:30 PM.

    Kind regards
    Take Market™
    http://www.takemarket.com

    We take market for you.™

  3. #3
    kbrill's Avatar
    kbrill is offline SugarCRM PS Engineer
    Join Date
    Jul 2004
    Location
    St Louis, MO
    Posts
    3,183

    Default Re: import hangs - after deletion of leads records.

    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.
    Kenneth Brill - Help Forum Moderator

    I do not respond to 'Private Messages'. Please email me directly instead

    When asking for help, PLEASE give us your Server Information and Version Numbers as asked for on the 'Post New Message' screen as well as any JavaScript errors shown at the bottom of the browser window.
    Help us Help You

  4. #4
    TakeMarket is offline Sugar Community Member
    Join Date
    Apr 2007
    Posts
    133

    Thumbs up Re: import hangs - after deletion of leads records.

    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.

    Kind regards
    Take Market™
    http://www.takemarket.com

    We take market for you.™

  5. #5
    TakeMarket is offline Sugar Community Member
    Join Date
    Apr 2007
    Posts
    133

    Default Re: import hangs - after deletion of leads records.

    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.

    Kind regards
    Take Market™
    http://www.takemarket.com

    We take market for you.™

  6. #6
    TakeMarket is offline Sugar Community Member
    Join Date
    Apr 2007
    Posts
    133

    Default Re: import hangs - after deletion of leads records.

    Quote Originally Posted by 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.
    Hi Kenneth Brill,

    Got an new issue on our necks...

    Code:
    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?
    Last edited by TakeMarket; 2008-04-21 at 10:51 PM.

    Kind regards
    Take Market™
    http://www.takemarket.com

    We take market for you.™

  7. #7
    TakeMarket is offline Sugar Community Member
    Join Date
    Apr 2007
    Posts
    133

    Default Re: import hangs - after deletion of leads records.

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

    Thanks

    Kind regards
    Take Market™
    http://www.takemarket.com

    We take market for you.™

  8. #8
    TakeMarket is offline Sugar Community Member
    Join Date
    Apr 2007
    Posts
    133

    Default Re: import hangs - after deletion of leads records.

    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..?

    Kind regards
    Take Market™
    http://www.takemarket.com

    We take market for you.™

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 0
    Last Post: 2008-03-04, 05:22 PM
  2. Replies: 0
    Last Post: 2008-02-06, 08:17 PM
  3. Import Leads on fresh 5.0 - lead source and campaign data missing
    By Owl01 in forum Installation and Upgrade Help
    Replies: 2
    Last Post: 2008-01-04, 10:50 PM
  4. Categorize Leads Upon Import
    By eSolutions in forum Help
    Replies: 4
    Last Post: 2005-10-23, 10:39 PM
  5. Replies: 1
    Last Post: 2005-08-06, 06:38 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •