#19 WebRequests: NullPointerException

X_Unsupported
closed-fixed
5
2001-11-05
2001-11-04
No

WebRequests: NullPointerException

(Win2k - Oracle 8.1.7 Enterprise)

When I click on "Web Requests" in Garden World, the
cursor changes to an hourglass, and "hangs"
indefinately when the progress indicator is at about
60%. Here is the -debug:

===========> MLookup.getLookup_TableDir - No
Identifier records found: User_ID
===========> MLookup.getLookupSQL - No SQL
java.lang.NullPointerException
at org.compiere.model.MLookup.getLookupSQL
(MLookup.java:579)
at org.compiere.model.MLookup.access$2
(MLookup.java:39)
at org.compiere.model.MLookup$Loader.run
(MLookup.java:482)

Discussion

  • Jorg Janke

    Jorg Janke - 2001-11-05

    Logged In: YES
    user_id=87038

    Caused by a script wich ensures that columns ending with
    _ID are an ID.
    Workaround: In Maintain Table/Column change DisplayType of
    column W_Request.User_ID from ID to String(20).

    a) The columnName should not end with _ID as this is a
    standard text field; Column renames to UserID.

    b) It should not fail, but interpret it as Number

     
  • Jorg Janke

    Jorg Janke - 2001-11-05
    • labels: 364562 --> Application Dictionary
    • status: open --> open-fixed
     
  • Jorg Janke

    Jorg Janke - 2001-11-05
    • status: open-fixed --> closed-fixed
     
  • Jorg Janke

    Jorg Janke - 2001-11-05

    Logged In: YES
    user_id=87038

    ** Fixed in R2.4 **

     
  • Dan Browning

    Dan Browning - 2001-11-05

    Logged In: YES
    user_id=703

    Great! I did your work around and it worked swimmingly.
    Thank you!

     
  • Jorg Janke

    Jorg Janke - 2001-11-05

    Logged In: YES
    user_id=87038

    ColumnName changed to WebUserID as UserID used for
    PaymentProcessor - same in W_Basket

     

Log in to post a comment.

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:





No, thanks