slxdeveloper.com Community Forums

The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!

Architect Forums - SalesLogix Scripting & Customization
Forum to discuss writing script in Architect plugins for SalesLogix & general SalesLogix customization topics (for Windows client only). View the code of conduct for posting guidelines.

Forums RSS Feed

Back to Forum List | Back to SalesLogix Scripting & Customization | New Thread

View: Search:

Author

Thread: E_Fail Status

Steve Knowles
Posts: 657

E_Fail Status Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 14 Nov 06 9:29 AM

Hello,
I am trying to run a routine in an active form to get some data from a GoldMine table and update a one to many table off Opp_Product called C_Opportunity_Product - matching on the Goldmine Acct number which exists in my SLX table. The routine runs fine for a while, making the updates as it is supposed to. Evenutally the following error appears, or if I put 'On Error Resume Next' the client just crashes.

Data Provider or other service returned an E_Fail Status.

It fails on the line where the update is executed.

Any thoughts? I am really not sure where to go with this one. Tech support didn't know.. thanks

Steve Knowles
Systems Engineering

[Reply][Quote]

Ryan Farley
Posts: 2265

Re: E_Fail Status Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 14 Nov 06 10:04 AM

Your problem is likely one of the following (these aren't the only possible causes, just a few common ones I could think of)

1) Are you executing a SQL statement to do the update/insert? If so then you likely have invalid chars in the string. This is a non-issue if you use an updateable recordset instead. This one is probably the most likely cause - I've run into this with GoldMine notes fields before.

2) Could it be that you're attempting to put values longer than their target fields will allow?

3) What about data types (like putting th value "$1,000" into a numeric field or something). GoldMine sucks when it comes to enforcing user input, so you really should expect about *anything* to be in those fields. This could definitely cause an issue.

Start with these. Absolutely, if you're just executing a SQL statement change it to an updateable recordset. Other than that, I would guess the problem is coming from the data you are attempting to put into the database from GoldMine, not your code specifically.

-Ryan

[Reply][Quote]

Snow Monkey
Posts: 214

Re: E_Fail Status Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 17 Nov 06 11:33 AM

GM Notes field has some invalid chars in some recs and scribe(or any other tool) will show this error.Also if this happens once , from that point onwards the slx provider behaves erratically.You have to close that app and restart everything again.

Just as i had so many input rows(~300K) in there i put in some trace to find out which record it was and manually deleted that.Not sure you can do that in your case..

I called SLX and Scribe tech support.All thery did is to blame each other and this issue remained till i manually deleted them

[Reply][Quote]

Page 1 of 1

You can subscribe to receive a daily forum digest in your user profile. View the site code of conduct for posting guidelines.

Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!

slxdeveloper.com is brought to you courtesy of Ryan Farley & Customer FX Corporation. This site, and all contents herein, are Copyright © 2024 Customer FX Corporation. The information and opinions expressed here are not endorsed by Sage Software.	code of conduct \|

page cache (param): 11/26/2024 8:19:13 PM