#4536 Storage Report - Location Drop Down

R2.6.1
closed
sboda
5
2007-08-15
2007-08-06
contract16
No

Hi,

Version 261

When selecting "Storage Detail Report" and selecting a location, the drop down list of mlocartions is not displayed correctly. To reproduce:

1) Select Storagr Detail
2) Ensure that a warehouse with locations is selected
3) Select the locator lookup, and the system dispalys the locator window.
4) Problem: The locator drop down list displays no locatore.
Expected: A drop down list of locators, ideally just for the warehouse selected.

The following error message:

===========> MLocatorLookup.run: SELECT * FROM M_Locator WHERE IsActive='Y' AND AD_Client_ID IN(1000000,0) AND AD_Org_ID IN(1000013,1000038,1000024,1000016,100 0028,1000039,0,1000014,1000054,1000026,1000048,1000057,1000049,1000051,1000029,1 000001,1000043,1000021,1000044,1000000,1000037,1000012,1000056,1000005,1000042,1 000020,1000045,1000046,1000035,1000030,1000006,1000036,1000017,1000002,1000040,1 000011,1000050,1000019,1000033,1000031,1000052,1000027,1000003,1000041,1000025,1 000047,1000022,1000018,1000032,1000010,1000015,1000053,1000055,1000023,1000034) [12]
java.sql.SQLException: Invalid column index; State=null; ErrorCode=17003
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java :125)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java :162)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java :227)
at oracle.jdbc.driver.OraclePreparedStatement.setIntInternal(OraclePrepa redStatement.java:3970)

at oracle.jdbc.driver.OraclePreparedStatement.setInt(OraclePreparedState ment.java:3961)
at org.compiere.util.CPreparedStatement.setInt(CPreparedStatement.java:3 98)
at rg.compiere.model.MLocatorLookup$Loader.run(MLocatorLookup.java:378)

Thanks
Jeff

Discussion

  • Kai Egbert
    Kai Egbert
    2007-08-06

    • assigned_to: kmpink --> kviiksaar
    • milestone: --> R2.6.1
    • status: open --> pending
     
  • Kai Egbert
    Kai Egbert
    2007-08-06

    Logged In: YES
    user_id=1784380
    Originator: NO

    Hi Jeff,

    Could you please add additional locators to the GardenWorld Warehouse and test it from there. In latest 2.6.1 2007/05/10 this error is not occurring for GardenWorld.

    Regards,

    Kai

     
  • contract16
    contract16
    2007-08-07

    • status: pending --> open
     
  • contract16
    contract16
    2007-08-07

    Logged In: YES
    user_id=1742483
    Originator: YES

    Hi Kai,

    To reproduce in GardenWorld:
    1) Set HQ org and warehouse to be the defaults on login.
    2) Create extra 3 or 4 locators for the HQ warehouse, e.g.
    HQ X1-Y1-Z1,
    HQ X2-Y1-Z1, etc.
    I created 5 more locations as well as the default locator, so 6 in total.
    3) Create 3 or 4 locators for the Store warehouse

    4) Select Storage Detail Report.
    The Storage Detail Process window displays (with the message "This report shows storage details including ....."). Select Start.
    5) The Storage detail selection criteria window appears. On the window the HQ warehouse should be default.
    6) Select the Locator lookup.
    The Locator list window should appear.
    Select the drop down list and all the locators should appear correctly (6 in my example).
    7) Do not Select any locator but close the Locator list window and return to the Storage Detail window.

    8) Close the Storage Detail window and return to the process window (with the message "This report shows storage details including .....")

    9) Select Start to to return to the Storage Detail selection criteria window.
    Warehouse defaults to HQ warehouse.
    10) Change warehouse to Store warehouse.
    11) Select the Locator lookup.
    The Locator list window should appear.
    Select the drop down list and all the locators for Store warehouse should appear.
    PROBLEM: No locators are displayed.

    Thanks
    Jeff

     
  • Kai Egbert
    Kai Egbert
    2007-08-07

    • assigned_to: kviiksaar --> kmpink
     
  • Kai Egbert
    Kai Egbert
    2007-08-07

    Logged In: YES
    user_id=1784380
    Originator: NO

    Hi Kathy,

    I've replicated the problem with these steps. If the process starts the MLocatorLookup preloads the Locators for the current Warehouse. The Process is not reacting on changes of the Warehouse and therefore can't find any results of locators if the Warehouse has been switched.

     
  • Kathy Pink
    Kathy Pink
    2007-08-07

    • assigned_to: kmpink --> sboda
     
  • Kathy Pink
    Kathy Pink
    2007-08-07

    Logged In: YES
    user_id=329831
    Originator: NO

    Sabitha,
    Please confirm in 2.6.3
    thanks

     
  • sboda
    sboda
    2007-08-07

    Logged In: YES
    user_id=1705860
    Originator: NO

    *** Status set to PENDING *** If the issue solved, please CLOSE
    this request - otherwise set the status back to OPEN (we only
    check OPEN items). If there is no reaction within a week, the
    system will automatically CLOSE it. To speed up response time,
    you may want to consider a support agreement.
    ***

     
  • sboda
    sboda
    2007-08-07

    • status: open --> pending
     
  • sboda
    sboda
    2007-08-07

    Logged In: YES
    user_id=1705860
    Originator: NO

    Hi
    I followed the exact steps in 2.6.3. (Didn’t tried in 2.6.1)I could not able to reproduce the issue.
    I can see all the locators for the Store Ware house

    Thanks

     
  • sboda
    sboda
    2007-08-07

    Logged In: YES
    user_id=1705860
    Originator: NO

    *** Status set to PENDING *** If the issue solved, please CLOSE
    this request - otherwise set the status back to OPEN (we only
    check OPEN items). If there is no reaction within a week, the
    system will automatically CLOSE it. To speed up response time,
    you may want to consider a support agreement.
    ***

     
  • sboda
    sboda
    2007-08-07

    Logged In: YES
    user_id=1705860
    Originator: NO

    I just tried in 2.6.1 and I can replicate the problem, however before selecting the locator look up right click and click on ReQuery in the locator field (storage detail window),then you could able to see all the locators for the store ware house in locator lookup.

     
    • status: pending --> closed
     
  • Logged In: YES
    user_id=1312539
    Originator: NO

    This Tracker item was closed automatically by the system. It was
    previously set to a Pending status, and the original submitter
    did not respond within 7 days (the time period specified by
    the administrator of this Tracker).