75,730
I just deployed my first set of SSRS report onto a GP 2013 instralltion running on a W2012 server. The reports displayed just fine but at the bottom appears to be the corresponding xml text version of the report. Is there some setting on a W2012 server to turn off the xml version?
*This post is locked for comments
We have not deployed SSRS nor Business Analyzer. We also haven not moved our database to another server. I think your issue is slightly different that ours.
But, we did just discover that if you uninstall the eOne SmartConnect (both the server and client components) from the server where the client is properly rendering the XML, it breaks it. After the uninstall, I see the raw XML code as I do on the terminal servers. So that application is changing SOMETHING that makes the XML render properly... Installing the eOne SmartConnect client/server on our terminal servers really isn't an option, so we need to figure out what exactly it's changing. Probably a registry setting or something trivial like that.
He claims my script for the views fixed the home page.
Have you deployed the SSRS reports for this company? How about Business Analyzer?
Our problem was I had done that on our server and then sent the databases up to their server and their server name was different. I beleive there about 392 views. Try running this script inserting your server name and see what comes back. Perhaps the views are not there or the name has gotten changed.
SELECT REPLACE(REPLACE(OBJECT_DEFINITION(object_id), 'Old_Server_Name', 'New_Server_Name'), 'CREATE VIEW', 'Alter view') + CHAR(13) + CHAR(10) + 'GO'
FROM
sys.views
WHERE
CHARINDEX('Old_Server_Name', OBJECT_DEFINITION(object_id)) > 0
That is the exact problem I ahve on our T/S. That is the way where it does not work. Let me ask the tech who worked on that what he did to alleviate that problem.
In our case, we did not copy our databases between servers. They have always resided on the same server. And again, the client works fine on the SQL database server itself. It's only the clients on on our terminal servers that are not working properly.
Did you copy your company daabases from one server to another? I am wondering if this is related to the SQL view issue with the SQL Server name being embedded in the views.
Any updates? I am having the same problem. Please let us know what you figured out. Thank you.
Neil at MotorcycleMarket.com
I should mention that we also have one W2012 server that DOES work properly. It is the one that actually hosts the SQL database. The GP client is installed on that server, and the XML renders as expected. All of these W2012 servers are running in VMware ESXi 5.1. Yesterday, I built a brand new VM from scratch, and then installed GP on it, and it still didn't work properly. I even tried installing SQL 2012 on it, and no dice.
This is extremely frustrating. We requested a call-back from MS on Tuesday, but we have yet to hear from them. I'm going to be in a lot of hot water if I can't get this working very soon...
We've got a few extra lines in ours referring to some paths for .DIC files, and you've got two lines we don't have (WebConfigure=TRUE and EnablePerUserIni=TRUE), but they are otherwise pretty much identical. No great discoveries there, I'm afraid.
Since it's server-based I don't think it should matter. I must have gotten mixed up, I don't think SSRS would play a role in this at all.
I'm stumped; I'm really sorry. I hate spinning my wheels and I'll be honest, I'm not very familliar with Windows Server 2012, but I'm really curious.
Here is a copy of my dex.ini file. Is there something different?
[General]
SQLLogSQLStmt=FALSE
SQLLogODBCMessages=FALSE
SQLLogAllODBCMessages=FALSE
SQLRprtsTimeout=0
ReportViewMode=2
Initial=FALSE
Synchronize=FALSE
AutoDisplayUpdate=TRUE
DynHelpPath=C:\Program Files (x86)\Microsoft Dynamics\GP2013\
DexHelpPath=C:\Program Files (x86)\Microsoft Dynamics\GP2013\
Word Macro File=C:\Program Files (x86)\Microsoft Dynamics\GP2013\Data\Letters\WordIntegration.dot
Letters Directory=C:\Program Files (x86)\Microsoft Dynamics\GP2013\Data\Letters\
Workstation=WINDOWS
Workstation2=Windows
WindowMax=TRUE
BTInterface=NoLoad
Pathname=DYNAMICS/dbo/
FileHandler=SQL
SQLQueryTimeout=0
SQLProcsTimeout=0
DPSInstance=1
BuildSQLMessages=FALSE
OLEPath=C:\Program Files (x86)\Microsoft Dynamics\GP2013\Data\Notes\
ReportDictionaryPath=C:\Program Files (x86)\Microsoft Dynamics\GP2013\Data\
FormDictionaryPath=C:\Program Files (x86)\Microsoft Dynamics\GP2013\Data\
SQLLastDataSource=Dynamics GP 2013
UpdateLogin=mbsupdates.microsoft.com/.../login.aspx
WebConfigure=TRUE
EnablePerUserIni=TRUE
SQLLastUser=sa
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (