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!
|
|
Error on exporting group to Excel
Posted: 21 Sep 06 4:01 AM
|
fiogf49gjkf0d I am getting an error when attempting to export a group in SalesLogix to Excel:
"Error exporting group in ExportCurrentGroupToExcel function OLE Error 800A03EC"
Anyone ever seen something like this? |
|
|
|
Re: Error on exporting group to Excel
Posted: 22 Sep 06 6:45 AM
|
fiogf49gjkf0d Most likely one or more of the records selected in the group are duplicates (not distinct). In otherwords a many to many type relationship. I have see this many times where they add notes/history into the groups with their opps. |
|
|
|
Re: Error on exporting group to Excel
Posted: 19 May 08 2:25 PM
|
Hello, Ina.
I was wondering if you ever found the solution to this problem as one of my clients is now experiencing the exact same error.
Thanks!
Melissa |
|
|
|
Re: Error on exporting group to Excel
Posted: 19 May 08 2:29 PM
|
Hi, David.
One of my clients is receiving the same error when exporting a group to Excel (Error exporting group in ExportCurrentGroupToExcel Function. OLE error 800A03EC). I've read your response on this error and was wondering if you could give a little more info on how to correct the problem. From what I've been told, my client is getting an error when trying to export a group when they have a column that is a long string field (such as 1000 characters). Specifically it is the notes column on the shownto table (under opp).
If you have any hints, I would greatly appreciate them!
Melissa
|
|
|
|
Re: Error on exporting group to Excel
Posted: 19 May 08 2:58 PM
|
Hi Melissa,
In my case this turned out to be version conflict on the software between the client and the server. The IT department loaded the latest client service packs, and never informed us to update the server.
Let me know what you find with yours - it will be interesting to know. (Also check their O/S and Excel just in case)
Best regards
Ina |
|
|
| |
|
Re: Error on exporting group to Excel
Posted: 30 May 08 9:32 AM
|
This type pf error can normally be attributed to the configuration of the report conditions. Ensure that the following common mistakes have not been made on the condition & layout pages:
-Ensure that all closed expressions have a bracket pair , ie opened & closed Brackets under the "Conditiond Tab"
- Review the associated boolean expression & check for coherence under the "Condition Tab"
-Ensure that the right data types are specified in the Layout options under the "Layout Tab"
- Ensure that you do not have duplicate Column names under the "Layout Tab"
|
|
|
|
Re: Error on exporting group to Excel
Posted: 16 Jul 08 8:53 AM
|
Try a manual export as follows:
Edit the group (right click the tab name and select edit group)
Select "View SQL"
Cut and paste the SQL statement to query analyzer
Select all the records
Paste to Excel.
This may give a more intelligent error message
In one case, the number of records generated exceeded 65535, the maximum for the version of Excel. We found this was the cause of the problem by limiting the number of records generated using "select top 65000".
In another case, we found that exporting from SalesLogix as a CSV file, and then opening the CSV file in Excel worked.
Taking the problem outside SalesLogix and working directly from SQL to Excel made troubleshooting a lot easier. |
|
|
|
Re: Error on exporting group to Excel
Posted: 17 Jul 08 9:14 AM
|
I recently ran into a problem with DateTime values. There were a few records in the DB that had Date values for year 1899, just prior to the oldest date that excel 2003 was able to recognize.
Here is a similar debugging technique:
Create a group for teh entity in question, put a condition on the group to ensure a fairly small number of records. For columns, only add the ID for the entity, and one text field (the main Name or Description field). Try exporting that group list. If that works, slowly reproduce the columns from the original group defintion, then begin relaxing the conditions to allow more records. Somewhere along the way the error will re-occur and this will shed light on the actual problem.
I also like Tony's technique of pulling the SQL and investigating outside SLX when you can. |
|
|
| |
| |
| |
|
Re: Error on exporting group to Excel
Posted: 27 Feb 14 11:02 AM
|
I just ran into this problem. I had a few records that had a date of '12/31/1899' that displayed in the group. I set them to 1/1/1970 and BAM success! |
|
|
|