Export SQL to Excel node issue

Question

Hi All, 
 I am getting below error while using the Export SQL to Excel smart service in the process model. 
 Problem: An error occurred in executing an Activity Class. 
 Details: The following error was raised by the Export to Excel function: Null Arguments are Invalid 
 Recommended Action: Examine the activity class to correct the error and then resume. 
 Priority of this problem: High Priority 
 Details of the node are attached, I am getting this error while trying to export a single column from the DB. DB has values for the column, but still facing this error. 
 
 Please help me in resolving this issue. Thanks in advance. 
 
 Regards, 
 Someshwar

Hema · Accepted Answer

Hi Somershwarp, Please provide the value (a folder) for document_save_directory attribute in Inputs tab. That will solve the error. 
 Hope this helps!!! Thanks, Hema

ravalik · Answer

Hi someshwarp,

Follow step by step process to generate document using Export SQL to Excel smartservice 
 
I took empty excel_base_template file 
Configuredthe following properties : 
 
Document_name_to_create: "SQL_Excel" 
Document_save_directory: RAL_Backup 
Excel_base_template: sql_template 
Include_header_row: true 
Jndi Name: "jdbc/secondarydatabase" 
Sheet_number: 0 
Sql: ="Your select query " 
 
Ensure that your query is able to handle null values otherwise enforce via the process model that the node cannot be passed a null value. 
 
it is successfully generating a document based on the sql query . 
 
Thanks, 
ravalik