Hi

I have at task that runs a procedure on a ms sql server.
The procedure is ok and execute succesfully but automate throws an error

Error code: 59999
Error Text: Object reference not set to an instance of an object[

Why do I get this error and what does error code 59999 mean?


-/Christian


Task Steps: (Right click, Select All, Copy to copy to the clipboard. Steps can then be pasted into the AutoMate Task Builder)
<AMIF ACTIVITY="file_exist" FILE="Restore.bak" /> <AMDATABASE SESSION="DB" CONNECTION="xxx" /> <AMDATABASE ACTIVITY="stored_procedure" SESSION="DB" PROCEDURE="sp_test" /> <AMDATABASE ACTIVITY="stored_procedure" SESSION="DB" PROCEDURE="sp_Restore_Ramos" /> <AMDATABASE ACTIVITY="close_sql_connection" SESSION="DB" /> <AMIF ACTIVITY="end" />

Christian,

Which step does the error occur on? What version of Automate 11 are you running?

-------------------------

Leonard Amabile | Director, Cross Platform Support
AutoMate | InterMapper | Skybot | Divisions of HelpSystems
T: +1.213.738.1700 | F: +1.213.738.7665

Problem solved, need to add a dataset to the sp.

-/cw

Hello,

We appreciate the update.

-------------------------

Ricardo Castaneda | Principal Support Analyst
AutoMate | Division of HelpSystems
HelpSystems, LLC | T: +1.213.738.1700