I am migrating data from one Salesforce org to another.
My issue is with accessing attachments. My source org has almost 500,000 attachments and when I try to run a query it simply times out.
What I've found is that if I exclude the BODY field from the attachment table (its a base 64 string version of the attachment file) it returns data ok. However if I try to run the job with more than 50-60 attachments at time, it just times out. Here's the error message I get:
at Microsoft.VisualBasic.CompilerServices.Symbols.Container.InvokeMethod(Method TargetProcedure, Object Arguments, Boolean CopyBack, BindingFlags Flags)
at Microsoft.VisualBasic.CompilerServices.NewLateBinding.ObjectLateGet(Object Instance, Type Type, String MemberName, Object Arguments, String ArgumentNames, Type TypeArguments, Boolean CopyBack)
at Microsoft.VisualBasic.CompilerServices.NewLateBinding.LateGet(Object Instance, Type Type, String MemberName, Object Arguments, String ArgumentNames, Type TypeArguments, Boolean CopyBack)
at StarfishEngine.StarfishService.GetOrigRowCount(Connection conn)
The odd thing is that it is inconsistent. Sometimes it times out even when it gets the data set and is in the middle of the import.....so it could be on row 20 of 60 and it fails.
Any suggestions on what I can do to prevent the timeout? For now I'm having to restrict the Attachment.CreatedDate to a small date range and migrate data that way, but its very tedious and slow to do it this way. Any suggestions to speed up the process would be appreciated.
I am running Starfish 4.16 (and I know that's not the very latest version but the updater doesnt find any available updates for that version, maybe because its 32 bit?).
Login or sign up for our forums to connect to the user community.