Καλησπέρα,
έχει γίνει change of plan.. οπότε το εκτέλεσα και έκανα δοκιμές στο test environment (single-server deployment):
- Backup then format the server
- install Windows Server 2008 Enterprise Edition SP2 (με IIS κλπ)
- install SQL Server 2008 Enterprise Edition SP1 (DBengine, Reporting Services 2008, Integration Services)
- install MS CRM 4.0, temporary organization
- install Reporting Services Connector component
- install Rollup 9 (Server + reporting services component)
μεχρι εδώ το νέο/άδειο CRM ανοίγει κ παίζει μια χαρά.
- Τώρα restore το .bak αρχείο του actual CRM που είχα παραμετροποιήσει (όταν είχα SQL Srv 2005 με Reporting Services 2005) με σκοπό το 'Import Organization' (όπως προτείνει το: http://social.microsoft.com/Forums/en-US/crmdeployment/thread/af5fe48e-c255-4a2d-af66-4ee7aff54d73)
- Deployment Manager --> Import Organization --> choose database, user mapping --> Import --->... και error!
λίγο πριν σκάσει δημιουργεί reports το ένα μετά το άλλο. Σκαει εκεί που πάει να δημιουργήσει 1 συγκεκριμένο report όπως φαίνεται απο το log:
17:24:32| Info| PublishReportsFromDatabase: Creating report in Reporting Services. ReportId: {d6d31d81-f575-de11-aeb9-0019bb22900d}, Name: Report_name_here
17:24:48| Error| Import Organization (Name=HAU, Id=2ef250b3-334e-df11-bb96-001e2a3ee09e) failed with Exception:
Microsoft.Crm.CrmReportingException: The Value expression for the subreport ‘subreport1’ refers to the field ‘field_name_here’. Report item expressions can only refer to fields within the current dataset scope or, if inside an aggregate, the specified dataset scope. ---> System.Web.Services.Protocols.SoapException: System.Web.Services.Protocols.SoapException: The Value expression for the subreport ‘subreport1’ refers to the field ‘field_name_here’. Report item expressions can only refer to fields within the current dataset scope or, if inside an aggregate, the specified dataset scope.
at Microsoft.ReportingServices.WebServer.ReportingService2005Impl.CreateReport(String Report, String Parent, Boolean Overwrite, Byte[] Definition, Property[] Properties, Warning[]& Warnings)
at Microsoft.ReportingServices.WebServer.ReportingService2005.CreateReport(String Report, String Parent, Boolean Overwrite, Byte[] Definition, Property[] Properties, Warning[]& Warnings)
at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
at Microsoft.Crm.ReportingServices2005.ReportingService2005.CreateReport(String Report, String Parent, Boolean Overwrite, Byte[] Definition, Property[] Properties)
at Microsoft.Crm.Reporting.ReportServer.UploadReport(String path, Byte[] reportDefinition, String name, String description)
--- End of inner exception stack trace ---
at Microsoft.Crm.Reporting.ReportServer.UploadReport(String path, Byte[] reportDefinition, String name, String description)
at Microsoft.Crm.Reporting.ReportServer.UploadReport(Byte[] reportDefinition, String reportId, String name, String description)
at Microsoft.Crm.Reporting.ReportServer.UploadReport(SRSReport report, String reportId, String name, String description)
at Microsoft.Crm.Setup.Server.Utility.ReportsUtility.OrganizationPublishReportsScaleGroup(IDbCommand command, Uri reportingUrl, String orgUniqueName)
at Microsoft.Crm.Tools.Admin.DBImportHelper.RePublishReports(IDbCommand command, String organizationUniqueName, Uri reportUrl)
at Microsoft.Crm.Tools.Admin.ImportOrganizationInstaller.Import(Guid organizationId, String organizationUniqueName, String organizationFriendlyName, String sqlServerName, String databaseName, Uri reportServerUrl, String privilegedUserGroupName, String sqlAccessGroupName, String userGroupName, String reportingGroupName, String privilegedReportingGroupName, ICollection`1 users, MultipleTenancy multipleTenancy)
17:24:48|Warning| Attempting to cancel a long running process: ProgressWizard. This might leave the data in an invalid state and the application might not function correctly.
Φυσικά το συγκεκριμένο report επαίζε άψογα στη προηγούμενη αρχιτεκτονική με SQL Srv 2005... και θα έπρεπε να μπορώ να ολοκληρώσω το import του συστήματος, έστω και χωρίς να παίζει εκείνο το ένα report.. Αντι αυτού όμως κοβεται μαχαίρι όλη η διαδικασία του 'redeploy'..
Υπάρχει καμμία ιδέα?
Ευχαριστώ προκαταβολικά..
MS CRM Consultant/Developer