I think this is a really interesting issue. I thought it would be awesome to share with the group in case this ever happens to anyone else. We have Epicor involved, experts Joe and Nathan. They both love a Vexatious puzzle. It may be one we get our Consulting firm involved with if we can get a hold of them. Tricky bunch of people.
DISCLAIMER:
IF YOU WANT TO KNOW HOW TO READ THIS, IMAGINE A LARGE MAN WHO DRANK A LOT… AND I MEAN A LOT OF COFFEE AND DOWNED IT WITH A MOUNTAIN DEW… YEAH, THAT!
Anyway, so what we know so far.
- SQL database 2016 never changed:
** Microsoft SQL Server Management Studio 13.0.16106.4_**
** Microsoft Analysis Services Client Tools 13.0.1700.441**
** Microsoft Data Access Components (MDAC) 6.3.9600.17415**
** Microsoft MSXML 3.0 6.0 **
** Microsoft Internet Explorer 9.11.9600.18666**
** Microsoft .NET Framework 4.0.30319.42000**
** Operating System 6.3.9600**
-
The App Server changed from Epicor 10.1.500.14 to 10.1.600.5. A new version.NET, 4.6.2, was updated.
-
The upgrade was successful. We had no issues upgrading and the data is sound. Backups were taken and no animals were injured during this Major Release upgrade.
The problem is we can’t print reports. When we print any report at all we get this little botheration:
Program Ice.Services.Lib.RunTask raised an unexpected exception with the following message: RunTask: Client found response content type of ‘application/octet-stream’, but expected ‘text/xml’. The request failed with an empty response.
I can see the report server, “HTTP://EpiMagicDB/Reports” and HTTP://EpicMagicDB/ReportServer both work. Yes, I can interact with the reports using either Visual Studios or Report Builder.
We checked the web.config file and didn’t see any anomalies there because Nathan thought it may be a time out issue. Still an angle we’re perusing, so we may have more on that.
We checked and changed the RSSRVPolicy.Config for the report server. Basically I grabbed a backup of the policy and made it live. Nadda, didn’t work.
Joe thought it could be a hard disk space issue… HAHAHAHA, NOPE! Needless to say, I’m very proud of the size of my… Database. And so was Joe. Again, 90% or more space free on all drives.
One of the things I’m considering is that since the App server is using .NET 4.6.2 should the SQL database be as well. Kind of tricky when you upgrade a .NET version of a database and some of the consequences, I know. BUT! We have the magic of Hyper-V! And my company loves spend money on me, so pfffft. I’ll get started on that today. And it’s SATURDAY! Yeah, my wife either loves me or she stays for the kids.
If you’d like to chime in feel free. Don’t worry, we have plenty of Starbucks for everyone. Although we’re running low on Dew… Just sayin’.
[quote=“Jonathan_Lang, post:4, topic:38973, full:true”]
I think this is a really interesting issue. I thought it would be awesome to share with the group in case this ever happens to anyone else. We have Epicor involved, experts Joe and Nathan. They both love a Vexatious puzzle. It may be one we get our Consulting firm involved with if we can get a hold of them. Tricky bunch of people.
DISCLAIMER:
IF YOU WANT TO KNOW HOW TO READ THIS, IMAGINE A LARGE MAN WHO DRANK A LOT… AND I MEAN A LOT OF COFFEE AND DOWNED IT WITH A MOUNTAIN DEW… YEAH, THAT!
Anyway, so what we know so far.
- SQL database 2016 never changed:
** Microsoft SQL Server Management Studio 13.0.16106.4_**
** Microsoft Analysis Services Client Tools 13.0.1700.441**
** Microsoft Data Access Components (MDAC) 6.3.9600.17415**
** Microsoft MSXML 3.0 6.0 **
** Microsoft Internet Explorer 9.11.9600.18666**
** Microsoft .NET Framework 4.0.30319.42000**
** Operating System 6.3.9600**
-
The App Server changed from Epicor 10.1.500.14 to 10.1.600.5. A new version.NET, 4.6.2, was updated.
-
The upgrade was successful. We had no issues upgrading and the data is sound. Backups were taken and no animals were injured during this Major Release upgrade.
The problem is we can’t print reports. When we print any report at all we get this little botheration:
Program Ice.Services.Lib.RunTask raised an unexpected exception with the following message: RunTask: Client found response content type of ‘application/octet-stream’, but expected ‘text/xml’. The request failed with an empty response.
I can see the report server, “HTTP://EpiMagicDB/Reports” and HTTP://EpicMagicDB/ReportServer both work. Yes, I can interact with the reports using either Visual Studios or Report Builder.
We checked the web.config file and didn’t see any anomalies there because Nathan thought it may be a time out issue. Still an angle we’re perusing, so we may have more on that.
We checked and changed the RSSRVPolicy.Config for the report server. Basically I grabbed a backup of the policy and made it live. Nadda, didn’t work.
Joe thought it could be a hard disk space issue… HAHAHAHA, NOPE! Needless to say, I’m very proud of the size of my… Database. And so was Joe. Again, 90% or more space free on all drives.
One of the things I’m considering is that since the App server is using .NET 4.6.2 should the SQL database be as well. Kind of tricky when you upgrade a .NET version of a database and some of the consequences, I know. BUT! We have the magic of Hyper-V! And my company loves spend money on me, so pfffft. I’ll get started on that today. And it’s SATURDAY! Yeah, my wife either loves me or she stays for the kids.
If you’d like to chime in feel free. Don’t worry, we have plenty of Starbucks for everyone. Although we’re running low on Dew… Just sayin’.
SOLUTION
Unfortunately we weren’t able to answer the three questions:
What happened?
Why did it happen?
and How do we fix it?
What happened? We have to look at what changed. The only thing that changed was upgrading the App server and database to Epicor 10.1.600.x from 10.1.500.x.
That leads us to why did it happen? That’s the mystery. We don’t know, but we’re going to keep following up with Epicor Support. We won’t close this case until that is answered and when they do we’ll post the answer here.
How do we fix it? The link below is from Microsoft on how to uninstall reporting services.
I’d like to thank everyone that commented and tried to answer this valorous visitation of a by-gone vexation.
Jonathan