Continuation of testing and debugging the cause of the error when uploading the inventory in SSI-IAS


I tried to generate again the textfile in 1.13 as the EOM program work on this server.
Used the old program to generate the textfiles but I encounter an error Inputtype mismatch.
Used the modified program provided by Jovie, I was able to generate the textfile.
I tried to upload the text file were I encountered the error, but still, an error occurred.
Upload the textfiles as is not insert to invbal table instead, I upload the by file by default what I did was the if you did not assign the table on where you are gonna insert the data into the database. The database will create a table using the filename of the server, with this I will be able to insert the data at the same it will give a chance to validate the data. If there are null values or anomaly in the data.
As per checking, I did find any data that may cause the error in the uploading. If there are none I should be able to upload the textfile successfully like the first two textfiles,
I called Jovie to discuss my findings and also on how are we gonna plan this out.
Jovie will email her findings and plan the testing tomorrow.