[SOLVED] WebFOCUS Reporting Server ACX File case Sensative
I am setting up my new Reporting Server (765). I am copying in some ACX files from the old 533 Server. The text in the ACX is all upper case but when I test the synonym it gives me an error ((FOC1677) UNDECLARED SERVER "SITSTAT" REFERENCED FOR DB2 INTERFACE ) If I change the CONNECTION= to lower case it works just fine. Is there a setting in the Reporting Server where I can have it accept both lower and upper case?This message has been edited. Last edited by: Kerry,
Jim Prod: WebFOCUS 7.6.5 CGI - Self Service - AIX 5.2 - IBM DB2 V9 Env 3 Local: DevStudio 7.6.5 Servlet - Self Service - MS Windows XP SP2 - Output: HTML, Excel 2000 and PDF
January 28, 2009, 10:08 AM
GinnyJakes
Unix is very case sensitive. If the connection in the acx file is upper case, then see if you can change the name of the connection in edasprof.prf to upper case so that they match.
Jim, wouldn't be preferable to recreate the metadata, rather than copying them from the old environment?
Francis
Give me code, or give me retirement. In FOCUS since 1991
Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
January 28, 2009, 10:38 AM
JimBowe
Edasprof is what I was looking for. I think I will chnage the CONNECTION= to lower case. Our metadata is unique where I can not recreate it. I have 1000+ acx files I will have to edit. It is a one time deal so it should be that bad. Thanks for the suggestions.
Jim Prod: WebFOCUS 7.6.5 CGI - Self Service - AIX 5.2 - IBM DB2 V9 Env 3 Local: DevStudio 7.6.5 Servlet - Self Service - MS Windows XP SP2 - Output: HTML, Excel 2000 and PDF