Openbravo Issue Tracking System - Localization Pack: Spain
View Issue Details
0030870Localization Pack: SpainAlertspublic2015-09-18 10:182016-02-19 21:47
ngarcia 
markmm82 
highminoralways
scheduledopen 
5
 
 
0030870: Alert process finishes with error if the identifier of the product exceeds 100 characters
Alert process finishes with error if the identifier of the product exceeds 100 characters. The problem is caused by the Product Without Accounting alert
As system admin role:
   Set the Search Key, Name and Description as Record Identifiers for M_PRODUCT table
Compile and restart Tomcat
As group admin role:
   Go to Enterprise Module Management and apply the Alerts:Accounting dataset
   Create a new product and define the previous three values in order to exceed 100 characters
   Remove the entries of the Accounting tab
   Go to Process Request window and launch the Alert Process and check it finishes with error
   The log shows:
      @CODE=0@ERROR: value too long for type character varying(100)
No tags attached.
Issue History
2015-09-18 10:18ngarciaNew Issue
2015-09-18 10:18ngarciaAssigned To => Triage Finance
2015-09-18 10:19ngarciaIssue Monitored: networkb
2015-10-05 22:12heccamIssue Monitored: heccam
2016-02-17 18:06markmm82Statusnew => scheduled
2016-02-17 18:06markmm82Assigned ToTriage Finance => markmm82
2016-02-18 14:56rqueraltaNote Added: 0084324
2016-02-18 15:46ngarciaSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=11167#r11167
2016-02-18 16:26ngarciaSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=11170#r11170
2016-02-19 21:47rqueraltaNote Added: 0084376

Notes
(0084324)
rqueralta   
2016-02-18 14:56   
Test Plan

As System Admin role

  Go to Tables and Columns
    Select M_PRODUCT table
    Set the Search Key, Name and Description columns as "Uses as Record Identifiers"

  Go to Process Request window
    Reschedule Alert process to small interval
    
As F&B Internationa Group Admin
  
  Go to Payment In window
    Create a new product and define the previous three values in order to exceed 100 characters
    Remove the entries of the Accounting tab
   
  Go to Process Request window
   Launch the Alert Process and check that not have an error
   This issue is not reproduceable
(0084376)
rqueralta   
2016-02-19 21:47   
Test Plan

As System Admin role

  Go to Enterprise Module Management
    Apply the Alerts:Accounting dataset
  
  Go to Tables and Columns
    Select M_PRODUCT table
    Set the Search Key, Name and Description columns as "Uses as Record Identifiers"

  Go to Process Request window
    Reschedule Alert process to small interval
    
As F&B Internationa Group Admin
  
  Go to Payment In window
    Create a new product and define the previous three values in order to exceed 100 characters
    Remove the entries of the Accounting tab
   
  Go to Alert Management and you will see the a "Product without Accounting" alert for the new product