• State Not Answered
  • Replies 6 replies
  • Subscribers 7 subscribers
  • Views 6925 views
  • Users 0 members are here
Related Discussions
Home » Discussions » Plug-Ins

Error in Export SQL to Excel

Pradeep Gudishana
A Score Level 1

Hi All,

I'm trying to export sql data to excel, I'm facing a issue.

Error : 

There is a problem with task “Export SQL to Excel” in the process “PKEDC_CaseManagement”. The following error was raised by the Export to Excel function: null
Problem:  An error occurred in executing an Activity Class.  
Recommended Action:  Examine the activity class to correct the error and then resume.  

 

can some one help with what data i'm missing

Thanks 

Pradeep

  Discussion posts and replies are publicly visible

Parents
  • 0
    A Score Level 1
    Hi Pradeep,

    Follow step by step process to generate document using Export SQL to Excel smartservice
    i took empty excel_base_template file
    configure the 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: ="select deptid,deptname from raldepartment "

    it is successfully generating document based on the sql query .


    Regards,
    Raju K
Reply
  • 0
    A Score Level 1
    Hi Pradeep,

    Follow step by step process to generate document using Export SQL to Excel smartservice
    i took empty excel_base_template file
    configure the 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: ="select deptid,deptname from raldepartment "

    it is successfully generating document based on the sql query .


    Regards,
    Raju K
Children
No Data
© 2024 Appian. All rights reserved.
We want to hear from you! Submit a review on Gartner or G2.