According to customer feedback today, the data in the TXT files uploaded in the system cannot be stored into the database.
Warehouse receiving is in the systemProgramSQL loader implementation
1) Check the uploaded file records and find that the size of the uploaded file is 0;
2) Check the SQL loader log file and prompt: The generated CTL file cannot be read;
SQL * loader-501: unable to read file (/trustel/ctltemp/20121220155817.ctl) SQL * loader-561: End of File
3) Check the/trustel/ctltemp/20121220155817. CTL file. The file size is 0;
4) I have been doing well before. Why did this problem suddenly occur? I couldn't understand it for a while, so I tested it on the local server and found that I could upload and store the data in the database. It was really strange.
5) Check the disk space of the server and find that disk 100% is used. This problem should be solved, so we immediately cleared some space:
Some space is cleared and then uploaded to the server.
It seems that expansion is coming.