Jovie modified the program that will generate the textfile in 9 parts, with this we can easily identify the brands that cause the error.

With the testing, I decided to upload the generated text file into invbalsql2021 as test table, with this we can play with the data make sure the data is accurate and consistent before we upload it to the production table which is invbalsql2020.

Just to give you an update regarding the status of my testing. I did use the updated exe as instructed and successfully generated the text files in 9 parts at the moment I'm 4 out 9 in the uploading not sure why it's taking so long to upload the files. As per checking in the process running in the database, there is an activity in the infozone database, not sure if this may cause making the uploading slow.

Progress update on my testing. I've successfully uploaded the files from 1-8 until 9 that I encountered an error. Kindly see below the screenshot of the error. I think it has something to do with the JDA data that causes the error. But first, we need to identify the specific brand's data that causes the error.

If we can, we need to finish this today because two days will past and there will be a lot of movement that might happen.

We planned out to break down part 9 by the department this will make our testing and debugging much faster as we will be able to identify the brands cause the error.

Jovie will modify the program and I'll be the one to generate and upload the files into the database.

the error message tells us the specific but when we try to generate the specific brand with error based on the error based, it was successfully uploaded. Now we are sure that we can't rely only on the error message.

We call it a day.