Resolution:
Database : Oracle
Problem :   When one runs Archive script with protocol field as "ALL" it does not delete records from database and trace log shows following error  
                      SP2-0027:  Input is too long (> 2499 characters) - line ignored

Reason :        The sql query, internally formed by Archive tool, hits limit of 2499 character , which can not be handled by SQLPLUS oracle utility.

Workaround : In Archive script (bat or sh) file do not specify protocol as 'ALL' . Run the Archive utility one by one for different protocol like protocol=RosettaNet. This will help limit the size of sql query formed and avoid above exception.