FileMaker 7 Server Advanced... Need Help

[rfranco]

Is anybody out there having trouble with FileMaker 7 Server Advanced and stylesheets?

FileMaker will not process my XSLT. I have made sure that my stylesheets have the correct processing instructions, namespaces, etc. I put them in the correct folder on the server. Each stylesheet has the .xsl extension. I have tried to access them in many different browsers and still no luck. I get the same error with every stylesheet:

An unexpected error has occurred

File: /fmi/fmresultset.xml

Line:

Column:

I am able to access XML information from all of my databases using the fmresultset grammer, but when accessing an XSLT file, I get the same error every time.

This error is not listed in the documentation, so I don't know what it means.

Does anybody out there have XSLT working on their server?

Can anyone help?

[rfranco]

Correction on the error:

Here is the error that appears in my browser window:

FileMaker Web Publishing with XSLT

An Unexpected error has occurred

File: /fmi/xml/fmresultset.xml

Line:

Column:

[Martin Brändle]

Check /Library/FileMaker Server 7/Web Publishing/logs/pe_application_log.txt

You get some useful hints there.

Martin

[rfranco]

Thanks.

I looked at the pe_application_log.txt and found the same error that I've been getting. No additional infomation that could help. However, I did check the other logs and found the following error several times in the wpc_access_log.txt:

[Wed Dec 01 10:36:50 2004] [jk_ajp_common.c (1050)]: Error reading reply from tomcat. Tomcat is down or network problems.

[Wed Dec 01 10:36:50 2004] [jk_ajp_common.c (1187)]: ERROR: Receiving from tomcat failed, recoverable operation. err=0

It looks like I have a Tomcat problem. Does Tomcat have anything to do with XSLT?

[Martin Brändle]

Tomcat is the container for Java servlets, e.g. the custom web publishing engine that is a Java servlet which most probably contains the Xalan Java XSLT engine or parts of it. Tomcat serves as a link and a mapper between the Apache web server and the Java servlets in /Library/FileMaker Server 7/Web Publishing/publishing-engine/cwpe/WEB-INF/lib/

Just guessing:

Did you add the "fmxslt" extended privilege to your database you want to allow custom web publishing?

Do you always use http://somedomain/fmi/xsl/something.xsl?-db=yourdb&-grammar=fmresultset&-lay=neededlayout&restofyourquery

as a query?

In /etc/httpd/httpd.conf, do the last two lines read like this?

# Web Publishing Engine request redirection feature to Apache Web Server.

Include '/Library/FileMaker Server 7/Web Publishing/web-configuration/WEB-INF/conf/mod_jk.conf'

If not, then Apache has not been configured to work with Tomcat, and a reinstall of the Advanced Part of FMS7A is indicated.

Also, stopping and starting both the Web Publishing Engine AND the Apache web server might help.

Can you show us a snippet of the XSLT file where the problem occurs?

Martin

[rfranco]

Thanks for your suggestions and your help with tomcat.

I looked in /Library/FileMaker Server 7/Web Publishing/publishing-engine/cwpe/WEB-INF/lib/ and all the Java servlets are there as you specified.

I did add the "fmxslt" extended privilage to the database, and it has been assigned to the admin user of the database.

I did also make sure that I am using the correct query syntax as you specified. I made sure to include the fmresultset grammer.

I checked the httpd.conf file, and the statement is there, at the end:

# Web Publishing Engine request redirection feature to Apache Web Server.

Include '/Library/FileMaker Server 7/Web Publishing/web-configuration/WEB-INF/conf/mod_jk.conf'

It still gives me the same error, so it must be something else.

I could show you a snippet of one of the stylesheets I am using, but I'm not sure where the stylesheets are failing. The crazy thing is that I have about 10 stylesheets and all of them give me the same error. Usually an error will state the problem with the stylesheet so that I can go in and fix it, but this error is different, there is no mention of it in the documentation.

We have a firewall, perhaps tomcat is not working because of the firewall? Do you know what ports FileMaker uses for Tomcat?

Do you know of anything else I could check?

[Martin Brändle]

According to the FMSA Web Publishing Installation Guide, p. 15, the following ports are used:

FileMaker Proprietary Networking: 5003

Apache Jakarta Protocol 16016, 16018

Tomcat Control: 16010

FileMaker Internal: 16008, 16012

HTTP: 16014

Martin