I have a 25 MB excel sheet that has an access macro on it and does it's own set of calculations behind and I want to use it as an Imported excel sheet in Narrowcast and store it in a location where users can access it.
When I run the service it comes back with a box that says
FAILED TO LOAD SERVICE DEFINITION.

The system log says:
Failed to load the Service object from the repository (ID "E0884C4F2E5D456FA05CD737F08D0C09")[EBDMWRC05::DM]:2200:[THR:0x1ab0[2005-07-12 14:59:35.191][Level:SEVERE ERROR][Code:0xa6d]
Service execution finished with error : Service ID [E0884C4F2E5D456FA05CD737F08D0C09] Execution ID [20D5094F05A240B28F80176FAAD05300] Segment ID [........][EBDMWRC05::DM]:2200:[THR:0x1ab0[2005-07-12 14:59:35.191][Level:SEVERE ERROR][Code:0x963]



Any ideas what's going on? - That Severe error scares me!

Thanks guys!

iolaper,

Sounds like TECH note TN6200-721-0451 from the MSTR KB describes what you have encountered.

Here it is.  I hope that it helps.

++++++++++++++++++++++++++++++++++++++++++++++++++

’Failed to load the Service object from the repository’ error message appears when executing a service in MicroStrategy Narrowcast Server 7i - 7.2.x and 7.5.x



SYMPTOM:
In MicroStrategy Narrowcast Server 7i - 7.2.x and 7.5.x, when users execute services, they see the following error message:
'Failed to load the Service object from the repository.'


CAUSE:
This issue can occur due to several reasons:
There is a conflict with the 'MCTypLib.dll' that exists in the Narrowcast Server machine.
The service definition is too large, due to having Information Objects with great amount of data or a large Excel template or a combination of both. For example: the service contains an Excel template of size around 19.5MB or the service contains more than 292 Information Objects.

WORKAROUND:
To resolve the issue caused by the dll conflict, users must execute the steps outlined below:
Locate the MCTypLib.dll file in C:\Winnt\System32.
Un-register this file by running the following script from the command line: regsvr32 /u C:\Winnt\System32\MCTypLib.dll
To resolve the issue caused by size of the service definition, it is necessary to use a smaller Excel template or break the service into smaller subsets of data.

++++++++++++++++++++++++++++++++++++++++++++++++++++++


p.s.  For your information......

Registry modification:
WARNING:
Modifying registry values incorrectly may cause serious, system-wide problems that may require the re-installation of Microsoft Windows NT. Any edit of the registry is done at the user's own risk. Since these are user-initiated changes, they are not covered by any MicroStrategy warranty. If using Microsoft Windows NT, the user should backup the registry and/or update an Emergency Repair Disk (ERD) prior to alterations.

thanks a lot dinzana and thanks for the disclaimer at the end too! ;)