Hi,
could it be, that you have to reinstall the APS? I have added the article
how to do it.
Please check it.
#####################################
How to rebuild the Crystal APS database in Microsoft?
ID: 862678.KB.EN-US CREATED: 2004-02-27 MODIFIED: 2004-08-31
-------------------------------------------------------------------------------
The information in this article applies to:
- Microsoft CRM 1.2 Reports
SUMMARY
This article discusses how to rebuild the Crystal APS database. Follow these
steps if the database has become corrupted in version 1.2 of Microsoft CRM.
MORE INFORMATION
Before you follow these steps, perform a back up of any custom reports. The
following steps will remove all reports from the database. Any custom
reports must be saved into Microsoft CRM after the process is completed.
1. A log file named addlicenskey.log exists in the Temp folder for the user
who installed Microsoft CRM. This is typically located at c:\Documents and
Settings\<Installing User>\Local Settings\Temp. Open this file to obtain
the license key for this installation. You must have this key in step
twelve.
If you do not see this log file, see step 4 to obtain the license key from
the APS_InfoObjects2 table under the ObjName column.
Note: If you cannot see the Local Settings folder, enable hidden files and
folders. Click
"FolderOptions" on the
"Tools" menu, click the
"View" tab, and select the option
"Show hidden files and folders".
2. Click
"Start", point to
"Programs", point to
"Microsoft SQL Server", and then click
"Enterprise Manager".
3. Expand
"Microsoft SQL Servers", expand
"SQL Server Group", expand the
"instance of SQL Server", expand
"Databases", expand
"Organization_Name_CRMCRYSTAL", and select
"Tables".
4. Find the APS_IdNumbers2 table. If the license key was not found in step
one, open the
"APS_InfoObjects2" table in SQL Enterprise Manager. Right-click the
"APS_InfoObjects2" table, point to
"Open Table" and select
"Return All Rows". Under the
"ObjName column" the license key will exist in the following format:
{00000-0000000-0000000}. Save this value in Notepad or another location
that can be referenced later. This is the Crystal APS license key. Close
the APS_InfoObjects2 table.
Find the "APS_IdNumbers2" and "APS_InfoObjects2" tables. Right-click each
table and then click
"Delete". Select to drop the tables when prompted.
5. Click
"Start", point to
"Programs", point to
"Crystal Enterprise 9", and then click
"Crystal Configuration Manager (CCM)".
6. Right-click the
"Crystal APS Service" and then click
"Stop".
7. Right-click the
"Crystal APS Service" and then click
"Properties". Select the
"Configuration" tab on the Crystal APS Properties dialog box. You may
receive the following error message:
"Failed to retrieve cluster name for the database. Reason: Database
Access Failure.."
Click OK if this message appears.
8. Click "Specify". Select "Recreate the current Data Source"and click "OK".
Click "Yes" to confirm that you want to continue.
9. Right-click the
"Crystal APS Service" and then click
"Restart". Restart all the other Crystal services.
Important: Wait one minute before the next step.
10. Open a command prompt. Click
"Start", click
"Run", type
"cmd" (without the quotation marks) and then click
"OK".
11. Type "cd
"c:\program files\microsoft crm\crystal decisions\enterprise 9\win32_x86""
(without the quotation marks) and press "enter".
12. Type
"addlicensekey.js /License <license key identified in step 1>" (without the
quotation marks) and press "enter".
13. The addlicensekey.log file will be recreated in the Temp folder of the
current user. Open the log file and look for errors. If there are errors,
contact Microsoft CRM Support.
Click the following link to log a support request
https://mbs.microsoft.com/support.: https://mbs.microsoft.com/support.
14.
"Restart" the
"Crystal APS Service" from the Crystal Configuration Manager (CCM).
Important: Wait one minute before the next step.
15. On the CCM click
"Enable/Disable Servers".
16. Type
"Administrator" (without the quotation marks) as the User. Enter the
correct APS
"Password" (without the quotation marks) (default is blank) and then click
"Connect".
17. Click
"Enable All" and then click
"OK".
18. Publish the standard reports using the version 1.2 Crystal Report
Toolkit. Visit the following Microsoft Business Solutions Web site to
obtain the Toolkit:
http://mbs.microsoft.com/downloads/customer/TK35006Report_Toolkit_12.zip
There is a readme document included for instructions on how to use the
Toolkit.
Otherwise, if this doesn�t help, pleas open a case at the MSCRM support.
--
Ich hoffe, das hilft / I hope, this helps.
Freundliche Gr�sse,
Alfred G�bel (MS)
(Microsoft kann f�r die Richtigkeit und Vollst�ndigkeit der Inhalte in
dieser Newsgroup keine Haftung �bernehmen.)
"emagine" <emagine@discussions.microsoft.com> schrieb im Newsbeitrag
news:98D4009F-57F0-49B1-BA1F-14600725709C@microsoft.com...
> MS CRM 1.2 on MS SBS 2003 SQL 2000 on same box.
>
> Get the typical license error when I try to run reports in CRM, have tried
> to change logon accounts for CRM Security, Crystal APS, and Crystal Page
> Server. The Crystal APS service just will not start. Below is my Event
> message:
>
> Event Type: Error
> Event Source: Crystal_CrystalAPS
> Event Category: Services
> Event ID: 35101
> Date: 12/23/2004
> Time: 4:03:56 PM
> User: N/A
> Computer: EMAGINE-CRM
> Description:
> The root server reported an error Initialization Failure. (Reason: An
> unexpected problem (exception) happened. Reason given: The port number
> specified for the server is already in use., The server has problems using
> TCP/IP. The port number you are using is probably already in use..).
>
|
Search |
Post Question |
Groups |
Stream |
About |
Register
Utf
35933 articles. 
24 followers. 
1 Replies
348 Views
bonnieraddatz
msandid