On Tuesday 23 December 2008 9:57:01 pm justin wrote:

>
> I have taken your idea and made sure all the variables all appear the
> same and add raise notice for each portion of the command that is failing.
>
> -------------------------------------------------------------
> NOTICE:  _wipvalue: <NULL>
> CONTEXT:  SQL statement "SELECT postProduction(  $1 ,  $2 , FALSE,
> false, 0, Current_User, Current_User,  $3  )"
> PL/pgSQL function "forceclosewo" line 66 at SQL statement
>
> NOTICE:  _wipqty: 1.00000000
> CONTEXT:  SQL statement "SELECT postProduction(  $1 ,  $2 , FALSE,
> false, 0, Current_User, Current_User,  $3  )"
> PL/pgSQL function "forceclosewo" line 66 at SQL statement
>
> NOTICE:  _wipvalue/_wipqty= <NULL>
> CONTEXT:  SQL statement "SELECT postProduction(  $1 ,  $2 , FALSE,
> false, 0, Current_User, Current_User,  $3  )"
> PL/pgSQL function "forceclosewo" line 66 at SQL statement
>
> NOTICE:  pwoid: 6916
> CONTEXT:  SQL statement "SELECT postProduction(  $1 ,  $2 , FALSE,
> false, 0, Current_User, Current_User,  $3  )"
> PL/pgSQL function "forceclosewo" line 66 at SQL statement
>
> NOTICE:  TotalCost: <NULL>
> CONTEXT:  SQL statement "SELECT postProduction(  $1 ,  $2 , FALSE,
> false, 0, Current_User, Current_User,  $3  )"
> PL/pgSQL function "forceclosewo" line 66 at SQL statement
>
> ----------------------------------------------------------------
>
> So it appears that something is causing _wipvalue to get set to NULL
> somewhere else in the code.  Now when running the failing select
> statement manually  works is because the modified record is still not
> committed yet and its reading the unmodified record.
>
> the ForceCloseWo() calls several other functions before PostProduction()
> that beat on the header record a few times.  ForceCloseWo does extactly
> what it sounds like closes Work Orders forcible  based on default values
> set in the database.  I'm betting this record has some flaky setting
> somewhere thats either in the posting of raw material or  labor
> operations.
>
>
> its late i'm going to bed fight this again later this morning.
>
> thanks

Looks like you are narrowing it down. Good luck on that and if you need 
another set of eyes don't hesitate to post.

-- 
Adrian Klaver
akla...@comcast.net

-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to