Hi all, I'm having some trouble with the Read Excel Spreadsheet t

caz

A Score Level 1

over 11 years ago

Hi all,

I'm having some trouble with the Read Excel Spreadsheet to CDT smart service. It isn't throwing an alert when executed but the application logs are saying that there's a mismatch of types, see below:

ERROR com.appiancorp.suiteapi.common.TypedValueParameterConverter - Cannot convert TypedValue
com.appiancorp.suiteapi.common.exceptions.AppianException: Invalid Type: com.appiancorp.kougar.mapper.exceptions.ParameterException: Record value length (33) does not match instance property length (13) unable to convert <4974> of type <class java.lang.Long> to type <class [Ljava.lang.Object;> (APNX-1-4047-000)

The CDT has only text and date fields, and I've tried forcing the Excel to format the cells as text/date where appropriate, and the column headers match the CDT fields exactly. This means I'm getting null values in my output CDT.

Is there something obvious that I'm doing wrong? How would I go about resolving this?

Thanks!...

Discussion posts and replies are publicly visible

0 sariqs over 10 years ago

Hi Caroline,

Were you able to find any solution for the problem described above ?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 sariqs over 10 years ago

I have found the root cause for the problem above it was in my configuration of the smart service.

While configuring the smart service we need to make sure that we configure correct CDT variable based on CDT type configured and also configured CDT variable should be an array of CDT rather than single CDT object.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel