AnsweredAssumed Answered

FM 12 Advanced Server Intermittent Functioning

Question asked by compudav on May 14, 2012
Latest reply on Oct 8, 2012 by TSGal

Summary

FM 12 Advanced Server Intermittent Functioning

Product

FileMaker Server

Version

12

Configuration information


Mac OS X Server 10.6
FileMaker 12 Advanced Server
Firewall, etc. appears to be configured correctly.

Operating system version

Mac OS X Server 10.6

Description of the issue

New FileMaker 12 Advanced Server installation has problems with intermittent ability to produce the correct results using the web publishing engine interface with FX.php. Periodically, when querying a database served by FM12AS, FX.php will show FX_error "ExecuteQuery XML error: Mismatched tag at line 1"; however, other times the results will be retrieved correctly. When accessing the XML layout directly via the web, FM12 seems to return a 500 internal server error periodically.

Restarting the server does not help and each database is a direct conversion from a completely working FM11 installation. As such, the only change was the upgrade from FM11 server to FM12 server. Ports as far as we know are configured correctly, and the FM12 native client has no issues with connectivity.

Steps to reproduce the problem

Query any web list using FM12 and FX.php repeatedly. After the fifth time or so, you will get the error message for a couple tries then you'll get back to the expected result. There is no pattern to when you will or won't see the query execute correctly.

Exact text of any error message(s) that appear

Partial FX.php Error Message (some parts have been changed that contain server-specific information):^M ^M object(FX_Error)#2 (8) { ["error_message_prefix"]=> string(0) "" ["mode"]=> int(1) ["level"]=> int(1024) ["code"]=> int(100) ["message"]=> string(52) "FX: ExecuteQuery XML error: Mismatched tag at line 1" ["userinfo"]=> NULL ["backtrace"]=> array(4) { [0]=> array(7) { ["file"]=> string(30) "/phplib/FX/FX.php" ["line"]=> int(1363) ["function"]=> string(8) "FX_Error" ["class"]=> string(8) "FX_Error" ["object"]=> object(FX_Error)#2 (8) { ["error_message_prefix"]=> string(0) "" ["mode"]=> int(1) ["level"]=> int(1024) ["code"]=> int(100) ["message"]=> string(52) "FX: ExecuteQuery XML error: Mismatched tag at line 1" ["userinfo"]=> NULL ["backtrace"]=> array(4) { [0]=> array(7) { ["file"]=> string(30) "/phplib/FX/FX.php" ["line"]=> int(1363) ["function"]=> string(8) "FX_Error" ["class"]=> string(8) "FX_Error" ["object"]=> *RECURSION* ["type"]=> string(2) "->" ["args"]=> array(1) { [0]=> string(48) "ExecuteQuery XML error: Mismatched tag at line 1" } } [1]=> array(7) { ["file"]=> string(30) "/phplib/FX/FX.php" ["line"]=> int(1530) ["function"]=> string(12) "ExecuteQuery" ["class"]=> string(2) "FX" ["object"]=> object(FX)#1 (58) { ["dataServer"]=> string(17) "myserver.test.com" ["dataServerType"]=> string(6) "FMPro7" ["dataPort"]=> string(2) "80" ["dataPortSuffix"]=> string(3) ":80" ["urlScheme"]=> string(4) "http" ["database"]=> string(14) "mydatabase.fmp12" ["layout"]=> string(9) "my_list" ["responseLayout"]=> string(0) "" ["groupSize"]=> string(3) "100" ["currentSkip"]=> int(0) ["defaultOperator"]=> string(2) "bw" ["dataParams"]=> array(1) { [0]=> array(3) { ["name"]=> string(7) "orgtype" ["value"]=> string(8) "business" ["op"]=> string(0) "" } } ["sortParams"]=> array(4) { [1]=> array(2) { ["field"]=> string(11) "county_sort" ["sortOrder"]=> string(6) "ascend" } [2]=> array(2) { ["field"]=> string(13) "district_sort" ["sortOrder"]=> string(6) "ascend" } [3]=> array(2) { ["field"]=> string(12) "businessname" ["sortOrder"]=> string(6) "ascend" } [4]=> array(2) { ["field"]=> string(10) "department" ["sortOrder"]=> string(6) "ascend" } } ["primaryKeyField"]=> string(0) "" ["modifyDateField"]=> string(0) "" ["dataKeySeparator"]=> string(0) "" ["fuzzyKeyLogic"]=> bool(false) ["genericKeys"]=> bool(false) ["selectColsSet"]=> bool(false) ["selectColumns"]=> string(0) "" ["fieldInfo"]=> array(0) { } ["currentData"]=> array(0) { } ["valueLists"]=> array(0) { } ["totalRecordCount"]=> int(-1) ["foundCount"]=> int(-1) ["dateFormat"]=> string(0) "" ["timeFormat"]=> string(0) "" ["dataURL"]=> string(300) "http://myserver.test.com:80/fmi/xml/FMPXMLRESULT.xml?-db=mydatabase.fmp12&-lay=my_list&-max=100&-find" ["dataURLParams"]=> string(247) "-db=mydatabase.fmp12&-lay=my_list&-max=100&-find" ["dataQuery"]=> string(0) "" ["charSet"]=> string(0) "" ["dataParamsEncoding"]=> string(0) "" ["currentFlag"]=> string(0) "" ["currentRecord"]=> string(0) "" ["currentField"]=> string(0) "" ["currentValueList"]=> string(0) "" ["fieldCount"]=> int(0) ["columnCount"]=> int(-1) ["fxError"]=> string(15) "No Action Taken" ["errorTracking"]=> int(0) ["useInnerArray"]=> bool(true) ["DBUser"]=> string(2) "FX" ["DBPassword"]=> string(0) "" ["userPass"]=> string(0) "" ["defaultPostPolicy"]=> bool(true) ["isPostQuery"]=> bool(true) ["useCURL"]=> bool(true) ["lastLinkPrevious"]=> string(0) "" ["lastLinkNext"]=> string(0) "" ["lastFoundCount"]=> int(-2) ["lastFields"]=> array(0) { } ["lastURL"]=> string(0) "" ["lastQuery"]=> string(0) "" ["lastErrorCode"]=> int(-2) ["lastValueLists"]=> array(0) { } ["invalidXMLChars"]=> array(3) { [0]=> string(1) "^K" [1]=> string(1) "^L" [2]=> string(1) "^R" } ["UTF8SpecialChars"]=> array(6) { [0]=> string(17) "|([Â-ß])([€-¿])|e" [1]=> string(20) "|(à)([ -¿])([€-¿])|e" [2]=> string(24) "|([á-ï])([€-¿])([€-¿])|e" [3]=> string(27) "|(ð)([<90>-¿])([€-¿])([€-¿])|e" [4]=> string(31) "|([ñ-ó])([€-¿])([€-¿])([€-¿])|e" [5]=> string(27) "|(ô)([€-<8f>])([€-¿])([€-¿])|e" } ["UTF8HTMLEntities"]=> array(6) { [0]=> string(35) "$this->BuildExtendedChar('\1','\2')" [1]=> string(40) "$this->BuildExtendedChar('\1','\2','\3')" [2]=> string(40) "$this->BuildExtendedChar('\1','\2','\3')" [3]=> string(45) "$this->BuildExtendedChar('\1','\2','\3','\4')" [4]=> string(45) "$this->BuildExtendedChar('\1','\2','\3','\4')" [5]=> string(45) "$this->BuildExtendedChar('\1','\2','\3','\4')" } } ["type"]=> string(2) "->" ["args"]=> array(1) { [0]=> string(5) "-find" } } ^M ^M The remainder of the error message is a repeat of the above.

Workaround

FM11 using the same configuration has no issues. Only 12 experiences this connectivity issue.


Outcomes