Author Topic: runtime error '-2147217887, Multiple-step operation generated errors  (Read 8407 times)

Offline Deeps

  • Full Member
  • ***
  • Posts: 49
  • Karma: +0/-0
    • View Profile
i get this error while saving one form
but even if it shows this message it saves the data
so is it a problem of sql? because this form saves data in a database which is not on he same where the dev machine server is.

Offline Rus

  • Administrator
  • Hero Member
  • *****
  • Posts: 122
  • Karma: +0/-1
    • View Profile
Re: runtime error '-2147217887, Multiple-step operation generated errors
« Reply #1 on: April 04, 2007, 09:10:24 AM »
Convert this to HEX and google for the result.

It might tell you more.
One Stop Shop Pivotal CRM Support and Development Service

http://www.pivotalcrmsupport.com

Offline pivotalnd

  • Sr. Member
  • ****
  • Posts: 55
  • Karma: +0/-0
  • Gender: Male
    • View Profile
Re: runtime error '-2147217887, Multiple-step operation generated errors
« Reply #2 on: April 04, 2007, 11:31:43 AM »
it would help if you check the event viewer for additional logs. also check the relation.err to see if any ODBC errors have ocurred. usually multiple step operation errors are middle tier runtime errors that might not be handled.
Regards,
Pivotalnd.

Offline Deeps

  • Full Member
  • ***
  • Posts: 49
  • Karma: +0/-0
    • View Profile
Re: runtime error '-2147217887, Multiple-step operation generated errors
« Reply #3 on: April 05, 2007, 03:35:12 AM »
Actually my problem is as follows,

In my form i want to add an attachement file
Once i add it and click save/update, it shows me an error message 'unable to save' or ' multiple step operation'
So according to our program, when we save attachements , these are saved in another server database (so not on the same development server).
and once saving its shows the error message , shows the added file in the form, but it doesnt save it in the database .

And this problem is not shown for every client machine. For some systems its working and saving for attachement successfully and others not.

Hope you understood my problem.

Offline Dean Wooldridge, Jr.

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 494
  • Karma: +9/-0
  • Gender: Male
    • View Profile
Re: runtime error '-2147217887, Multiple-step operation generated errors
« Reply #4 on: April 05, 2007, 07:39:17 AM »
I'd suggest it is a timing (timeout) issue.

Offline Deeps

  • Full Member
  • ***
  • Posts: 49
  • Karma: +0/-0
    • View Profile
Re: runtime error '-2147217887, Multiple-step operation generated errors
« Reply #5 on: April 05, 2007, 07:56:11 AM »
and is there any solution to increase the time delay? because yeah its a heavy form with aroung somewhat 254 tables included in the view filter.
is it that a reason to have a time out?

Offline Dean Wooldridge, Jr.

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 494
  • Karma: +9/-0
  • Gender: Male
    • View Profile
Re: runtime error '-2147217887, Multiple-step operation generated errors
« Reply #6 on: April 05, 2007, 08:50:22 AM »
I don't know to tell you the truth.  Maybe there's somethingon the SQL side that can be set.  I said timing because of two experiences:

1.  When debugging, if I step the code sometimes the action will fail with odd errors and if I takeout the breakpoints the error disappears.  Of course this only works after I have found my error.

2.  We did some enhancement work to the "Process Lead to Opportunity" ASR and found that we would be sporatic failures.  After much work, the opinion was that the process was tasking too long and the transaction was timing out.  Had to rewrite a bunch of code and the problem disappeared.  That's not a real good technical explaination but its what Pivotal told us.  I would guess that if they thought there was some simple setting change to make in SQL, then they would have tried that first.

Offline pivotalnd

  • Sr. Member
  • ****
  • Posts: 55
  • Karma: +0/-0
  • Gender: Male
    • View Profile
Re: runtime error '-2147217887, Multiple-step operation generated errors
« Reply #7 on: April 06, 2007, 02:41:27 AM »
i think  there is a limitation of 250 tables in a query. with 254 this error seems to be pretty obvious and to be expected. could you reduce the number of tables and then check once?
Regards,
Pivotalnd.

Offline Deeps

  • Full Member
  • ***
  • Posts: 49
  • Karma: +0/-0
    • View Profile
Re: runtime error '-2147217887, Multiple-step operation generated errors
« Reply #8 on: April 06, 2007, 02:47:46 AM »
yeah we did reduce and we found wat was bugging it had nothing to do with sql
ayway thanx for the suggestion

Offline eladfrn

  • Sr. Member
  • ****
  • Posts: 60
  • Karma: +0/-0
    • View Profile
Re: runtime error '-2147217887, Multiple-step operation generated errors
« Reply #9 on: July 20, 2010, 11:35:20 PM »
Hi all.
I have the same problem and I dont know what is causing it. I am trying to save a step and the error apears.
I've added the screenshot of the event viewer.
If someone knows how to solve this thing I will be happy to hear.

Thanks,
Elad

Offline DreamWeaver

  • Independent CRM Consultant
  • Full Member
  • ***
  • Posts: 30
  • Karma: +6/-12
  • Gender: Male
    • View Profile
Re: runtime error '-2147217887, Multiple-step operation generated errors
« Reply #10 on: August 29, 2010, 09:53:59 PM »
This happens when you are trying to save a form that has a value(s) in some field(s) more than its length/limit.

Offline jaybee

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 125
  • Karma: +12/-0
  • Gender: Male
  • Up the irons !
    • View Profile
Re: runtime error '-2147217887, Multiple-step operation generated errors
« Reply #11 on: April 29, 2015, 05:43:21 AM »
Thanks man, saved my life today.
Jérôme BERGES
Carmis
France