Bogus 401 Error

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

Bogus 401 Error

lizquigg
I am trying to understand why I get error 401 in the Error_Code when I use an inline statement that seems to be adding a record correctly.  I took the [action_statement] the inline statement generated and used it directly to the Filemaker server and it worked fine.

It may be related to the fact that I have another file “quadrats” that has a layout with a portal in it that points to records in “plant_data”.

[inline(-host=Array(
-datasource='filemakerds',
-name=($hostfm),
-port=($portfm),
-username=($userfm),
-password=($pwfm)),
-database='plant_data',
-table='entry_only',
'quadrat id'=var('quadrat_id') ,
'prairie_id'=var('prairie_id') ,
'plantid'=var('p1ID') , 'n'=var('n1') ,
'percent'=var('p1') ,-add)]

If I run code to update this record, it has no problem.

It seems only to give this error when I add a record.   The permissions are the same as far as I can tell.

I am tempted to just ignore the error because it is doing what I want it to do - namely, making the record.
It does not fail when I add a record that is related to a record I made before I migrated to Lasso 9.

Has anyone experienced this?

Liz


Elizabeth K. Quigg
Education Technology Specialist

Education Office
Fermi National Accelerator Laboratory
630 840 2631 office
ed.fnal.gov<http://ed.fnal.gov/>
[hidden email]<http://person@...>

Connect with us!
Facebook <http://www.facebook.com/FermilabEd>  |  Twitter<http://twitter.com/FermilabEd>





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

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
|

Re: Bogus 401 Error

maxwellk2
Hi Liz,

Just a guess here, but are you sure both the quadrats and plant_data databases (and any other related databases) have an account with the same username/password and XML permissions? The account also need add and edit privileges in both databases and read/write access to the entry_only layout. However, I’m not sure this is a permission issue, and I don’t have a lot of Lasso solutions that talk to a FM database with layouts that link to another separate FM database.

Also new in Lasso 9 is that I have to manually update Lasso if I make any layout changes in FM, in Lasso 9.2.7 this is done by simply clicking the "Edit Host" button.

Thanks,
Max



> On Aug 11, 2015, at 9:17 AM, Elizabeth K Quigg <[hidden email]> wrote:
>
> I am trying to understand why I get error 401 in the Error_Code when I use an inline statement that seems to be adding a record correctly.  I took the [action_statement] the inline statement generated and used it directly to the Filemaker server and it worked fine.
>
> It may be related to the fact that I have another file “quadrats” that has a layout with a portal in it that points to records in “plant_data”.
>
> [inline(-host=Array(
> -datasource='filemakerds',
> -name=($hostfm),
> -port=($portfm),
> -username=($userfm),
> -password=($pwfm)),
> -database='plant_data',
> -table='entry_only',
> 'quadrat id'=var('quadrat_id') ,
> 'prairie_id'=var('prairie_id') ,
> 'plantid'=var('p1ID') , 'n'=var('n1') ,
> 'percent'=var('p1') ,-add)]
>
> If I run code to update this record, it has no problem.
>
> It seems only to give this error when I add a record.   The permissions are the same as far as I can tell.
>
> I am tempted to just ignore the error because it is doing what I want it to do - namely, making the record.
> It does not fail when I add a record that is related to a record I made before I migrated to Lasso 9.
>
> Has anyone experienced this?
>
> Liz
>
>
> Elizabeth K. Quigg
> Education Technology Specialist
>
> Education Office
> Fermi National Accelerator Laboratory
> 630 840 2631 office
> ed.fnal.gov<http://ed.fnal.gov/>
> [hidden email]<http://person@...>
>
> Connect with us!
> Facebook <http://www.facebook.com/FermilabEd>  |  Twitter<http://twitter.com/FermilabEd>
>
>
>
>
>
> #############################################################
>
> 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]>