ARATools.jar Not Advancing Package States

Document ID : KB000084799
Last Modified Date : 14/04/2018
Show Technical Document Details
Affects Release version(s): 7

Error Message :
D:\Automic\Agents\windows\bin>java -jar ARATools.jar rm ExecuteApplicationWorkflow -u "" -un "AUTOMIC/10/ARA/JACKSONNATIONAL" -p "--10BD896E9A6B873615F1444588CF1F62B08E16989A5792953B47A704041C47154B23C85B22BDC450D03ADF2F1775

When there is a general workflow and want to advance the package state using ARATools.jar request executions of deployment workflows, the executions of  GENERAL_CALL_INSTALL_WF will encounter a SQL error. 
OS Version: N/A
Cause type:
Root Cause: The action in AE is sending wrong XML to ARA
Use the Deployment Manager Action Pack instead of the ARAtools.jar. It is available on the marketplace:

Fix Status: No Fix

Additional Information:
Workaround :
Change the package state using ImportExportCLI.exe. 
  1. Create a CSV file with following content: 

in which 856 is the package ID, state is the target (desired) state 
  1. Execute the command: 
ImportExportCli.exe IMPORT -con %url% -usr %username% -pwd %password% -format CSV -mt Package -fi %fileName% 
The password can be mapped to EXT:@global/token