Lasso 9 with libxml error from FileMaker query

classic Classic list List threaded Threaded
6 messages Options
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Lasso 9 with libxml error from FileMaker query

Johan Solve
Running into issues with Lasso 9.2.3 and FileMaker 15 Server. Certain FM
records in two different tables makes the FM connector XML parser crash
with this error reported in error_msg
libxml error while parsing document: Premature end of data in tag DATA line
1 Premature end of data in tag COL line 1 Premature end of data in tag ROW
line 1 Premature end of data in tag RESULTSET line 1 Premature end of data
in tag FMPXMLRESULT line 1

Running the FM query directly against FM WPE returns perfectly valid XML
for the same records.

Previously when I’ve come across similar issues it has been caused by
garbage data in FM fields, but in those cases the returned XML is in fact
invalid also for raw WPE queries.
I’m running out of good ideas after sinking as low as rebooting the FMS
machine. Any clever thoughts?

Btw these errors have appeared recently after working for a year

--
Mvh
Johan Sölve
____________________________________
Montania System AB
Halmstad   Stockholm
http://www.montania.se

Johan Sölve
Mobil +46 709-51 55 70
[hidden email]

Kristinebergsvägen 17, S-302 41 Halmstad, Sweden
Telefon +46 35-136800 |  Fax +46 35-136801

#############################################################

This message is sent to you because you are subscribed to
  the mailing list Lasso [hidden email]
Official list archives available at http://www.lassotalk.com
To unsubscribe, E-mail to: <[hidden email]>
Send administrative queries to  <[hidden email]>
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: [SPAM] Lasso 9 with libxml error from FileMaker query

maxwellk2
Any portals or related fields on the layouts used for those Lasso calls? Specifically empty portals or related fields.

After that I would try deleting fields off the layout until the error goes away, then focus on the field(s) in question. Most likely it's characters in the data that Lasso can't properly parse. Maybe try tweaking the Storage->Default Language setting for the fields causing the issue.

HTH,
Max



> On Jun 1, 2017, at 3:35 PM, Johan Solve <[hidden email]> wrote:
>
> Running into issues with Lasso 9.2.3 and FileMaker 15 Server. Certain FM
> records in two different tables makes the FM connector XML parser crash
> with this error reported in error_msg
> libxml error while parsing document: Premature end of data in tag DATA line
> 1 Premature end of data in tag COL line 1 Premature end of data in tag ROW
> line 1 Premature end of data in tag RESULTSET line 1 Premature end of data
> in tag FMPXMLRESULT line 1
>
> Running the FM query directly against FM WPE returns perfectly valid XML
> for the same records.
>
> Previously when I’ve come across similar issues it has been caused by
> garbage data in FM fields, but in those cases the returned XML is in fact
> invalid also for raw WPE queries.
> I’m running out of good ideas after sinking as low as rebooting the FMS
> machine. Any clever thoughts?
>
> Btw these errors have appeared recently after working for a year
>
> --
> Mvh
> Johan Sölve
> ____________________________________
> Montania System AB
> Halmstad   Stockholm
> http://www.montania.se
>
> Johan Sölve
> Mobil +46 709-51 55 70
> [hidden email]
>
> Kristinebergsvägen 17, S-302 41 Halmstad, Sweden
> Telefon +46 35-136800 |  Fax +46 35-136801
>
> #############################################################
>
> This message is sent to you because you are subscribed to
>  the mailing list Lasso [hidden email]
> Official list archives available at http://www.lassotalk.com
> To unsubscribe, E-mail to: <[hidden email]>
> Send administrative queries to  <[hidden email]>


#############################################################

This message is sent to you because you are subscribed to
  the mailing list Lasso [hidden email]
Official list archives available at http://www.lassotalk.com
To unsubscribe, E-mail to: <[hidden email]>
Send administrative queries to  <[hidden email]>
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Lasso 9 with libxml error from FileMaker query

stevepiercy
In reply to this post by Johan Solve
That looks like an error returned by libxml that Lasso passes
along to error_msg.

Can you get the raw XML object returned from FMS to inspect it?  
Maybe you can see where it is not validly formed?  Or then pass
it into Lasso to see where it barfs?

--steve


On 6/1/17 at 3:35 PM, [hidden email] (Johan Solve) pronounced:

>Running into issues with Lasso 9.2.3 and FileMaker 15 Server. Certain FM
>records in two different tables makes the FM connector XML parser crash
>with this error reported in error_msg
>libxml error while parsing document: Premature end of data in tag DATA line
>1 Premature end of data in tag COL line 1 Premature end of data in tag ROW
>line 1 Premature end of data in tag RESULTSET line 1 Premature end of data
>in tag FMPXMLRESULT line 1
>
>Running the FM query directly against FM WPE returns perfectly valid XML
>for the same records.
>
>Previously when I’ve come across similar issues it has been caused by
>garbage data in FM fields, but in those cases the returned XML is in fact
>invalid also for raw WPE queries.
>I’m running out of good ideas after sinking as low as rebooting the FMS
>machine. Any clever thoughts?
>
>Btw these errors have appeared recently after working for a year
>

-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
Steve Piercy              Website Builder              Soquel, CA
<[hidden email]>               <http://www.stevepiercy.com/>


#############################################################

This message is sent to you because you are subscribed to
  the mailing list Lasso [hidden email]
Official list archives available at http://www.lassotalk.com
To unsubscribe, E-mail to: <[hidden email]>
Send administrative queries to  <[hidden email]>
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Lasso 9 with libxml error from FileMaker query

Johan Solve
Thanks Steve, but as I wrote, Running the FM query directly against FM WPE
returns perfectly valid XML for the same records.

On 1 juni 2017 21:58, Steve Piercy - Website Builder <[hidden email]>
wrote:

> That looks like an error returned by libxml that Lasso passes along to
> error_msg.
>
> Can you get the raw XML object returned from FMS to inspect it?  Maybe you
> can see where it is not validly formed?  Or then pass it into Lasso to see
> where it barfs?
>
> --steve
>
>
> On 6/1/17 at 3:35 PM, [hidden email] (Johan Solve) pronounced:
>
> Running into issues with Lasso 9.2.3 and FileMaker 15 Server. Certain FM
>> records in two different tables makes the FM connector XML parser crash
>> with this error reported in error_msg
>> libxml error while parsing document: Premature end of data in tag DATA
>> line
>> 1 Premature end of data in tag COL line 1 Premature end of data in tag ROW
>> line 1 Premature end of data in tag RESULTSET line 1 Premature end of data
>> in tag FMPXMLRESULT line 1
>>
>> Running the FM query directly against FM WPE returns perfectly valid XML
>> for the same records.
>>
>> Previously when I’ve come across similar issues it has been caused by
>> garbage data in FM fields, but in those cases the returned XML is in fact
>> invalid also for raw WPE queries.
>> I’m running out of good ideas after sinking as low as rebooting the FMS
>> machine. Any clever thoughts?
>>
>> Btw these errors have appeared recently after working for a year
>>
>>
> -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
> Steve Piercy              Website Builder              Soquel, CA
> <[hidden email]>               <http://www.stevepiercy.com/>
>
>
>
> #############################################################
>
> This message is sent to you because you are subscribed to
>  the mailing list Lasso [hidden email]
> Official list archives available at http://www.lassotalk.com
> To unsubscribe, E-mail to: <[hidden email]>
> Send administrative queries to  <[hidden email]>
>



--
Mvh
Johan Sölve
____________________________________
Montania System AB
Halmstad   Stockholm
http://www.montania.se

Johan Sölve
Mobil +46 709-51 55 70
[hidden email]

Kristinebergsvägen 17, S-302 41 Halmstad, Sweden
Telefon +46 35-136800 |  Fax +46 35-136801

#############################################################

This message is sent to you because you are subscribed to
  the mailing list Lasso [hidden email]
Official list archives available at http://www.lassotalk.com
To unsubscribe, E-mail to: <[hidden email]>
Send administrative queries to  <[hidden email]>
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: [SPAM] Lasso 9 with libxml error from FileMaker query

Johan Solve
In reply to this post by maxwellk2
Status report: Recreated layout from scratch, no difference.

Moves on with removing fields until error goes away.

There is one portal on the layout, but the portal isn’t empty on problem
records. I’m aware of the problems with empty portals. No other related
fields except this portal.


On 1 juni 2017 17:18, Maxwell Klein <[hidden email]> wrote:

> Any portals or related fields on the layouts used for those Lasso calls?
> Specifically empty portals or related fields.
>
> After that I would try deleting fields off the layout until the error goes
> away, then focus on the field(s) in question. Most likely it's characters
> in the data that Lasso can't properly parse. Maybe try tweaking the
> Storage->Default Language setting for the fields causing the issue.
>
> HTH,
> Max
>
>
>
> > On Jun 1, 2017, at 3:35 PM, Johan Solve <[hidden email]> wrote:
> >
> > Running into issues with Lasso 9.2.3 and FileMaker 15 Server. Certain FM
> > records in two different tables makes the FM connector XML parser crash
> > with this error reported in error_msg
> > libxml error while parsing document: Premature end of data in tag DATA
> line
> > 1 Premature end of data in tag COL line 1 Premature end of data in tag
> ROW
> > line 1 Premature end of data in tag RESULTSET line 1 Premature end of
> data
> > in tag FMPXMLRESULT line 1
> >
> > Running the FM query directly against FM WPE returns perfectly valid XML
> > for the same records.
> >
> > Previously when I’ve come across similar issues it has been caused by
> > garbage data in FM fields, but in those cases the returned XML is in fact
> > invalid also for raw WPE queries.
> > I’m running out of good ideas after sinking as low as rebooting the FMS
> > machine. Any clever thoughts?
> >
> > Btw these errors have appeared recently after working for a year
> >
> > --
> > Mvh
> > Johan Sölve
> > ____________________________________
> > Montania System AB
> > Halmstad   Stockholm
> > http://www.montania.se
> >
> > Johan Sölve
> > Mobil +46 709-51 55 70
> > [hidden email]
> >
> > Kristinebergsvägen 17, S-302 41 Halmstad, Sweden
> > Telefon +46 35-136800 |  Fax +46 35-136801
> >
> > #############################################################
> >
> > This message is sent to you because you are subscribed to
> >  the mailing list Lasso [hidden email]
> > Official list archives available at http://www.lassotalk.com
> > To unsubscribe, E-mail to: <[hidden email]>
> > Send administrative queries to  <[hidden email]>
>
>
> #############################################################
>
> This message is sent to you because you are subscribed to
>   the mailing list Lasso [hidden email]
> Official list archives available at http://www.lassotalk.com
> To unsubscribe, E-mail to: <[hidden email]>
> Send administrative queries to  <[hidden email]>




--
Mvh
Johan Sölve
____________________________________
Montania System AB
Halmstad   Stockholm
http://www.montania.se

Johan Sölve
Mobil +46 709-51 55 70
[hidden email]

Kristinebergsvägen 17, S-302 41 Halmstad, Sweden
Telefon +46 35-136800 |  Fax +46 35-136801

#############################################################

This message is sent to you because you are subscribed to
  the mailing list Lasso [hidden email]
Official list archives available at http://www.lassotalk.com
To unsubscribe, E-mail to: <[hidden email]>
Send administrative queries to  <[hidden email]>
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: [SPAM] Lasso 9 with libxml error from FileMaker query

Johan Solve
[SOLVED]

This turned out to be due to bad data after all. Email addresses had been
copied and pasted from somewhere else (I bet it was from Outlook Mac), and
a trailing null character was included in the paste.
This has appeared differently in earlier cases I’ve come across, but then
it was FM11 or 12 instead of 15.

What tripped me here was that the XML appeared well-formed in the Chrome
XML extension that I use, but Lasso’s database connector that seems to use
libxml to parse the response från FM WPE freaked out by the unencoded NULL
characters.

Now, fixing this at the source required a neat trick that can be worth
sharing. The FM function Char(0) stupidly returns an empty string instead
of a NULL character so it couldn’t be used for substitution in an FM
calculation. But the infinitely wise Google told me to use
Base64Decode("AA==”) and that works great to use in a FM Substitute
calculation to weed out the NULL crap.


On 2 juni 2017 14:51, Johan Solve <[hidden email]> wrote:

> Status report: Recreated layout from scratch, no difference.
>
> Moves on with removing fields until error goes away.
>
> There is one portal on the layout, but the portal isn’t empty on problem
> records. I’m aware of the problems with empty portals. No other related
> fields except this portal.
>
>
> On 1 juni 2017 17:18, Maxwell Klein <[hidden email]> wrote:
>
>> Any portals or related fields on the layouts used for those Lasso calls?
>> Specifically empty portals or related fields.
>>
>> After that I would try deleting fields off the layout until the error
>> goes away, then focus on the field(s) in question. Most likely it's
>> characters in the data that Lasso can't properly parse. Maybe try tweaking
>> the Storage->Default Language setting for the fields causing the issue.
>>
>> HTH,
>> Max
>>
>>
>>
>> > On Jun 1, 2017, at 3:35 PM, Johan Solve <[hidden email]> wrote:
>> >
>> > Running into issues with Lasso 9.2.3 and FileMaker 15 Server. Certain FM
>> > records in two different tables makes the FM connector XML parser crash
>> > with this error reported in error_msg
>> > libxml error while parsing document: Premature end of data in tag DATA
>> line
>> > 1 Premature end of data in tag COL line 1 Premature end of data in tag
>> ROW
>> > line 1 Premature end of data in tag RESULTSET line 1 Premature end of
>> data
>> > in tag FMPXMLRESULT line 1
>> >
>> > Running the FM query directly against FM WPE returns perfectly valid XML
>> > for the same records.
>> >
>> > Previously when I’ve come across similar issues it has been caused by
>> > garbage data in FM fields, but in those cases the returned XML is in
>> fact
>> > invalid also for raw WPE queries.
>> > I’m running out of good ideas after sinking as low as rebooting the FMS
>> > machine. Any clever thoughts?
>> >
>> > Btw these errors have appeared recently after working for a year
>> >
>> > --
>> > Mvh
>> > Johan Sölve
>> > ____________________________________
>> > Montania System AB
>> > Halmstad   Stockholm
>> > http://www.montania.se
>> >
>> > Johan Sölve
>> > Mobil +46 709-51 55 70
>> > [hidden email]
>> >
>> > Kristinebergsvägen 17, S-302 41 Halmstad, Sweden
>> > Telefon +46 35-136800 |  Fax +46 35-136801
>> >
>> > #############################################################
>> >
>> > This message is sent to you because you are subscribed to
>> >  the mailing list Lasso [hidden email]
>> > Official list archives available at http://www.lassotalk.com
>> > To unsubscribe, E-mail to: <[hidden email]>
>> > Send administrative queries to  <[hidden email]>
>>
>>
>> #############################################################
>>
>> This message is sent to you because you are subscribed to
>>   the mailing list Lasso [hidden email]
>> Official list archives available at http://www.lassotalk.com
>> To unsubscribe, E-mail to: <[hidden email]>
>> Send administrative queries to  <[hidden email]>
>
>
>
>
> --
> Mvh
> Johan Sölve
> ____________________________________
> Montania System AB
> Halmstad   Stockholm
> http://www.montania.se
>
> Johan Sölve
> Mobil +46 709-51 55 70
> [hidden email]
>
> Kristinebergsvägen 17, S-302 41 Halmstad, Sweden
> Telefon +46 35-136800 <035-13%2068%2000> |  Fax +46 35-136801
> <035-13%2068%2001>
>



--
Mvh
Johan Sölve
____________________________________
Montania System AB
Halmstad   Stockholm
http://www.montania.se

Johan Sölve
Mobil +46 709-51 55 70
[hidden email]

Kristinebergsvägen 17, S-302 41 Halmstad, Sweden
Telefon +46 35-136800 |  Fax +46 35-136801

#############################################################

This message is sent to you because you are subscribed to
  the mailing list Lasso [hidden email]
Official list archives available at http://www.lassotalk.com
To unsubscribe, E-mail to: <[hidden email]>
Send administrative queries to  <[hidden email]>
Loading...