Problem with CRM 2013 On Premise workflows failing and reporting not working

John Tolmachoff
John Tolmachoff used Ask the Experts™
on
I have 2 problems, but they are inter-related.

MS CRM 2013 on premise, all functions on a Windows Server 2008 R2 VM with the SQL DB on a separate Windows Server 2008 R2 server.

1) Report Server not working as expected
2) CRM workflows stopped working.

CRM 2013 has been installed and working fine for years. About a month ago they wanted to start using reports, but the report server was never used or tested before. Tried to do some subscriptions and got the error message about credentials not stored. So I researched and at that time the SQL server was SQL 2008 standard. The requirements stated it must be at least SQL 2008 R2. So on Sept 4 I upgraded the SQL server to 2008 R2. Everything still working as normal after that but still no reports or subscriptions. Further research suggested that both the CRM server and the SSRS needed to be at 2013 SPM U4. The Server was 2013 SP1 U3 but SSRS was only 2013 SP1. So Friday afternoon I installed 2013 SP1 U3 on SSRS but it prompted for a restart. Well can not do that so waited until Saturday morning. At that time I restarted the SSRS server then installed 2013 SP1 U4 on the CRM server and on the SSRS server and both were restarted.

So, Monday morning I get an email saying all workflows failed after Friday afternoon.  I was told this AFTER I had been attempting to get reports to work by making some changes to the SSRS via the SQL Reporting Services Configuration Manager.

So, I need urgent help. First to get the workflows back working again and the to get the reports and subscriptions working.

Another indication of a problems is that in the Deployment Manager on the CRM server, the organization version shows 6.1.3.119 when it should be showing 6.1.4.145 and with a status of failed.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Feridun KadirPrincipal Consultant

Commented:
This could be tricky to solve remotely. However, it sounds like your deployment was upgraded but not the database. I fyou right-click on the organization in deployment manager do you see an option to update the database?  If so you should try that BUT it would be wise to have a SQL backup of the CRM database first.  If the update fails, review the log which is somewhere in the depths of the profile for the user that you are logged in as.

Also, does Windows Event viewer report anything useful around the time of the upgrade?
John TolmachoffNetwork Administrator

Author

Commented:
There is no option to update the organization.
John TolmachoffNetwork Administrator

Author

Commented:
Forgot to attach screen shotC--Users-jtolmachoff-Desktop-Temp-20.gif
CompTIA Security+

Learn the essential functions of CompTIA Security+, which establishes the core knowledge required of any cybersecurity role and leads professionals into intermediate-level cybersecurity jobs.

John TolmachoffNetwork Administrator

Author

Commented:
And no errors or warnings in the event log recorded. How can I manually update the database?
Feridun KadirPrincipal Consultant
Commented:
Hmm, tricky.  How about this?  In SQL Server, perform a backup of your CRM database (the one that ends in _MSCRM). Then restore the backup to a database with a different name, so you are making a copy.
Then in deployment manager, use Import Organization to see if the database will import will come in succesfully and get updated. During this wizard there will be a page on mapping users, select the option to keep existing mappings. This will help decide if the org can be upgraded. If it fails I suspect you will need to contact MS support.
John TolmachoffNetwork Administrator

Author

Commented:
Can that be done with users connected to the existing DB or does that need to be off line?
Feridun KadirPrincipal Consultant

Commented:
They can be still connected. But performing the backup , the restore and import might slow things down so do consider doing it out of hours.
John TolmachoffNetwork Administrator

Author

Commented:
Also will then import take on the same organization name, or can I assign a new organization name to avoid any conflict?
Feridun KadirPrincipal Consultant

Commented:
You can and indeed must specify a new organization name during the Import process.
John TolmachoffNetwork Administrator

Author

Commented:
OK got to the point of choose existing user mappings. That resulted in an error. Looking at details, there are users which are no longer in AD but still exist in CRM. 15 users do not have a mapping of a total of 51. What should I do?
Feridun KadirPrincipal Consultant

Commented:
You can accept the error message and continue anyway. You'll get a message of something like "not all users are mapped"
John TolmachoffNetwork Administrator

Author

Commented:
OK that test did complete and did work successfully updating the organization.

So now I will delete that and delete that test DB and then make a full backup of the existing DB and delete the existing organization and then recreate the DB restoring from backup and then import the organization.
Principal Consultant
Commented:
Glad to hear that worked.  Thought I don't think you need to delete the database from SQL..

I would in Deployment Manager Disable the test db
In SQL delete the test tb
In SQL make a backup of the production database
In Deployment Manager disable the production database
In Deployment Manager delete the production database but not from SQL
In Deployment Manager, import the production database
John TolmachoffNetwork Administrator

Author

Commented:
OK thank you for your help. I completed that early this morning and it works as expected. I will open a different question with the report server issue later.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial