- continue checking the application for fixing the missing UPC in some SKU in the invupc table
- modify the application to uncomment the query for extracting the UPC data in JDA and insert it into SQL
- test the modified application, but when testing an error is encountered, debug the application check the cause of the error
- as per checking, there is specific data that is causing the error, check why it is causing an error
- as per checking, the UPC is too long for the fields in the SQL with an int data type, the UPC from JDA is exceeding the data type limit
- discuss the findings to Arvin, and suggest to change the data type for UPC from an int into bigint, Arvin change the data type and I execute the application again
- the extraction and insertion of UPC data is completed successfully and as per checking the data in SQL is correct versus the data in JDA