11/25/2024 7:38:51 AM
|
| |
| 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!
Forum to discuss reports for SalesLogix including Crystal, SQL Reports, etc. View the code of conduct for posting guidelines.
|
|
|
|
Error "Multiple-Step OLE DB Operation generated errors...." 
Posted: 12 Feb 07 11:03 PM
|
fiogf49gjkf0d SalesLogix v7..Crystal XI release 2...
Crystal first started throwing this error..but digging deeper found out it's an SLX OLE DB error because we can recreate it in the Administrator Execute SQL.
Spent an hour on the phone w/SLX tech support trying to trouble shoot this error...Doing an inner join to a View in my SLX database that is pointed to a non SLX database on the same server...the query runs fine in Query analyzer...but in Crystal & in the Administrator Execute SLX I get this Multiple step error. We narrowed it down to fields of datatype Money...and we Cast the field as Money again in the view and the script would run in Administrator...but came home to complete the work and error started appearing again. Tried Convert, Cast to Varchar, Money, int...I can pull any field from the ERP database that is not a Money type....but the second i pull in a money type the SLX OLE DB crashes and burns...been fighting this for 2 weeks and thought we had it whipped... 
Google points to MS KB articles suggesting changes to the registry...etc....but i don't want to go that deep yet. Anyone else had any luck joining data from non-SLX sql databases with the SLX Reports? |
|
|
|
Re: Error "Multiple-Step OLE DB Operation generated errors...."
Posted: 13 Feb 07 12:16 AM
|
fiogf49gjkf0d How about building an SQL view to join the data between the tables (creating the view on the SLX DB).
Then Enable the view on SLX and use it rather than building the Query.
I think if you do something like this, apply all cast on the View, etc. by the time the provider gets to it it may not issue any error messages.
Again, just something to try |
|
|
|
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!
|
|
|
|
|
|
|
|