• State Not Answered
  • Replies 14 replies
  • Subscribers 8 subscribers
  • Views 12731 views
  • Users 0 members are here
Related Discussions
Home » Discussions » Plug-Ins

Excel Tools

Richard

We're on-premise running version 18.1 and are having no luck using the Parse Excel to CDT Smart Service.

We've configured all the data tab fields per the documentation, but get the following errors:

at com.appiancorp.ps.exceltools.smartservice.ParseExcelFileToCDT.run(Unknown Source)

 

Data Inputs are configured:

Excel Document:  Points to a file in the application that has been configured with all of the headers that match the destination CDT, no blank rows and some 100 rows of data

Sheet Number: integer (1)

Row Number to Read From: integer (2)

number of Columns to Read in Row: integer (3)

cdt:={'type!{urn:com:telus:types:SCE_Case}SCE_Case_IncidentCategory'()}

  Discussion posts and replies are publicly visible

Parents Reply Children
  • 0 in reply to Richard

    Fullscreen debuglog.txt Download 
    ####<Apr 24, 2018 6:46:57,910 PM GMT> <Notice> <Stdout> <btln007664> <AdminServer> <Appian Work Item - 1 - ProcessExec02 : UnattendedJavaActivityRequest> <<WLS Kernel>> <> <8b0f9be8-c68f-4104-af6d-332817149a02-000018d6> <1524595617910> <[severity-value: 32] [rid: 0:55:2] [partition-id: 0] [partition-name: DOMAIN] > <BEA-000000> <2018-04-24 18:46:57,909 [Appian Work Item - 1 - ProcessExec02 : UnattendedJavaActivityRequest] DEBUG com.appiancorp.ps.exceltools.smartservice.ParseExcelFileToCDT - Username :t071702> 
####<Apr 24, 2018 6:46:57,913 PM GMT> <Notice> <Stdout> <btln007664> <AdminServer> <Appian Work Item - 1 - ProcessExec02 : UnattendedJavaActivityRequest> <<WLS Kernel>> <> <8b0f9be8-c68f-4104-af6d-332817149a02-000018d6> <1524595617913> <[severity-value: 32] [rid: 0:55:2] [partition-id: 0] [partition-name: DOMAIN] > <BEA-000000> <2018-04-24 18:46:57,913 [Appian Work Item - 1 - ProcessExec02 : UnattendedJavaActivityRequest] DEBUG com.appiancorp.ps.exceltools.smartservice.ParseExcelFileToCDT - Excel Document :4240> 
####<Apr 24, 2018 6:46:57,913 PM GMT> <Notice> <Stdout> <btln007664> <AdminServer> <Appian Work Item - 1 - ProcessExec02 : UnattendedJavaActivityRequest> <<WLS Kernel>> <> <8b0f9be8-c68f-4104-af6d-332817149a02-000018d6> <1524595617913> <[severity-value: 32] [rid: 0:55:2] [partition-id: 0] [partition-name: DOMAIN] > <BEA-000000> <2018-04-24 18:46:57,913 [Appian Work Item - 1 - ProcessExec02 : UnattendedJavaActivityRequest] DEBUG com.appiancorp.ps.exceltools.smartservice.ParseExcelFileToCDT - Sheet Number :0> 
####<Apr 24, 2018 6:46:57,913 PM GMT> <Notice> <Stdout> <btln007664> <AdminServer> <Appian Work Item - 1 - ProcessExec02 : UnattendedJavaActivityRequest> <<WLS Kernel>> <> <8b0f9be8-c68f-4104-af6d-332817149a02-000018d6> <1524595617913> <[severity-value: 32] [rid: 0:55:2] [partition-id: 0] [partition-name: DOMAIN] > <BEA-000000> <2018-04-24 18:46:57,913 [Appian Work Item - 1 - ProcessExec02 : UnattendedJavaActivityRequest] DEBUG com.appiancorp.ps.exceltools.smartservice.ParseExcelFileToCDT - Row no to read from :2> 
####<Apr 24, 2018 6:46:58,052 PM GMT> <Notice> <Stdout> <btln007664> <AdminServer> <Appian Work Item - 1 - ProcessExec02 : UnattendedJavaActivityRequest> <<WLS Kernel>> <> <8b0f9be8-c68f-4104-af6d-332817149a02-000018d6> <1524595618052> <[severity-value: 32] [rid: 0:55:2] [partition-id: 0] [partition-name: DOMAIN] > <BEA-000000> <2018-04-24 18:46:58,051 [Appian Work Item - 1 - ProcessExec02 : UnattendedJavaActivityRequest] ERROR com.appiancorp.process.engine.UnattendedJavaActivityRequest - An error occurred while executing activity: id=536871348, classname=com.appiancorp.ps.exceltools.smartservice.ParseExcelFileToCDT
java.lang.NullPointerException
    And here's the debug log

  • 0
    Appian Employee
     in reply to Richard
    Not sure if you grabbed the right time slot for the app server log, since I do not see any exceptions in the stack trace pertaining to this plugin.
    One thing that was recently reported is that blank rows in the Excel can cause the smart service to fail.
  • 0 in reply to Mike Cichy
    It was in there, but perhaps buried too deep, here are the relevant lines:

    ####<Apr 24, 2018 4:09:21,212 PM GMT> <Notice> <Stdout> <btln007664> <AdminServer> <Appian Work Item - 1011 - ProcessExec01 : UnattendedJavaActivityRequest> <<WLS Kernel>> <> <8b0f9be8-c68f-4104-af6d-332817149a02-00000446> <1524586161212> <[severity-value: 32] [rid: 0:51:775] [partition-id: 0] [partition-name: DOMAIN] > <BEA-000000> <2018-04-24 16:09:21,212 [Appian Work Item - 1011 - ProcessExec01 : UnattendedJavaActivityRequest] ERROR com.appiancorp.process.engine.UnattendedJavaActivityRequest - An error occurred while executing activity: id=268439593, classname=com.appiancorp.ps.exceltools.smartservice.ParseExcelFileToCDT
    java.lang.NullPointerException
    at com.appiancorp.ps.exceltools.smartservice.ParseExcelFileToCDT.run(Unknown Source)
    at com.appiancorp.process.runtime.framework.DefaultActivityExecutor$1.lambda$call$0(DefaultActivityExecutor.java:119)
    at com.appiancorp.plugins.PluginUsageLogger.runWithPluginInformation(PluginUsageLogger.java:52)
    at com.appiancorp.process.runtime.framework.DefaultActivityExecutor$1.call(DefaultActivityExecutor.java:119)
    at com.appiancorp.process.runtime.framework.DefaultActivityExecutor$1.call(DefaultActivityExecutor.java:112)
    at com.appiancorp.common.ContextClassLoaderSwitcher.runInContext(ContextClassLoaderSwitcher.java:25)
    at com.appiancorp.process.runtime.framework.DefaultActivityExecutor.execute(DefaultActivityExecutor.java:112)
    at com.appiancorp.process.engine.UnattendedJavaActivityRequest.execute(UnattendedJavaActivityRequest.java:83)
    at com.appiancorp.process.engine.UnattendedJavaActivityRequest.execute0(UnattendedJavaActivityRequest.java:55)
    at com.appiancorp.process.engine.ContinuationRequest.executeOuter(ContinuationRequest.java:71)
    at com.appiancorp.process.engine.ContinuationRequest.execute(ContinuationRequest.java:84)
    at com.appiancorp.mdb.UnattendedRequestHandlerBean.onMessage(UnattendedRequestHandlerBean.java:37)
    at com.appiancorp.mdb.UnattendedRequestHandlerBean_kegq7u_MDOImpl.__WL_invoke(Unknown Source)
    at weblogic.ejb.container.internal.MessageDrivenLocalObject.invoke(MessageDrivenLocalObject.java:127)
    at com.appiancorp.mdb.UnattendedRequestHandlerBean_kegq7u_MDOImpl.onMessage(Unknown Source)
    at com.appiancorp.ra.workpoller.WorkItem.run(WorkItem.java:59)
    at weblogic.connector.security.layer.WorkImpl.runIt(WorkImpl.java:72)
    at weblogic.connector.security.layer.WorkImpl.run(WorkImpl.java:47)
    at weblogic.connector.work.WorkRequest.run(WorkRequest.java:123)
    at weblogic.work.SelfTuningWorkManagerImpl$WorkAdapterImpl.run(SelfTuningWorkManagerImpl.java:670)
    at weblogic.invocation.ComponentInvocationContextManager._runAs(ComponentInvocationContextManager.java:352)
    at weblogic.invocation.ComponentInvocationContextManager.runAs(ComponentInvocationContextManager.java:337)
    at weblogic.work.LivePartitionUtility.doRunWorkUnderContext(LivePartitionUtility.java:57)
    at weblogic.work.PartitionUtility.runWorkUnderContext(PartitionUtility.java:41)
    at weblogic.work.SelfTuningWorkManagerImpl.runWorkUnderContext(SelfTuningWorkManagerImpl.java:644)
    at weblogic.work.ExecuteThread.execute(ExecuteThread.java:415)
    at weblogic.work.ExecuteThread.run(ExecuteThread.java:355)>
© 2024 Appian. All rights reserved.
We want to hear from you! Submit a review on Gartner or G2.