Information Systems:WebSmart Can't Upload File

If a WebSmart program won’t upload a file, use option 5 to work with the first CGI job of the affected web server. Then option 10 to display the job log, F10 to display detail, and F18 to go to the bottom. Page back to find an error message. There are a lot of messages in the log, so this could be difficult. Get the user to try the operation again, then look at the log immediately.

On March 26, 2015 we had the messages 'SQL system error' and 'Error occurred in SQL Call Level Interface'. This made no sense, as the line in the CL program where the error occurred (press F9 on the message to see this) was CPYFRMIMPF (copy from import file). When I googled the error code (SQL0901), I found that the problem was with the ODBC driver (according to Wikipedia; ‘ODBC (Open DataBase Connectivity) is a standard programming language middleware API for accessing database management systems (DBMS)’). As Web Orders was successfully uploading orders from the hand held units, I figured that the driver loaded into the InfoNet web server had been corrupted; not the facility itself. I didn’t think it was worth ending and restarting the server and disrupting everyone, so waited for it to happen as part of the overnight jobs. The next day the upload worked fine.