Hi all,
We recently had to reinstall our midtier server. The old version had IIS and NewAtlanta, while the new one is set up with IIS, Midtier 7 and Tomcat. Most of it works fine, but we get following error while trying to access some .jsp-reports: ------------------------------------------------------------------------------------------------------------------------------------------------------------ Error ARException... MessageType: 2 MessageNum: 1587 MessageText: Unknown field referenced in query line AppendedText: position 16 (1=1 AND 'Omr?de' = "Prosjekter" AND 1=1 AND 1=1 AND 'Status' < "Lukket" AND 1=1) ------------------------------------------------------------------------------------------------------------------------------------------------------------ The address bar URL says: http://kbg-remedy-v1/arsys/KDA/ADB/oversikt.jsp?qual=1%3D1+AND+%27Omr%3Fde%27+%3D+%22Prosjekter%22+AND+1%3D1+AND+1%3D1+AND+%27Status%27+%3C+%22Lukket%22+AND+1%3D1 For some reason special Norwegian characters (Æ, Ø and Å, if you can read those letters normally) have been used on Category, Type and Item, and somewhere on the line this causes problems. In the URL above, the letter Å is transformed to percent sign 3F. I have tried to change %3F to an "å" but it still changes it to a question mark. However, the old midtier with NewAtlanta it worked fine with those characters. The application also works great while filtering on those same categories purely via the midtier. It is when I try to excecute the jps.report I get the error. Language on the win 2003 server is set to Norwegian, the same goes for default input language and language for nor-Unicode programs. Locations is also set to Norwegian. Does anyone have suggestions on further debugging? Best regards, Runar _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"