Skip to main content
natarajanm0529
Known Participant
Oct 31, 2023 1:14 PM UTC
Solved

I am getting CastInvalid Error Message . I verified all the datatypes . It looks good. I dont know where this error is pointing.

Expression evaluation error at function a!forEach [line 104]: Error in a!forEach() expression during iteration 1: Expression evaluation error at function 'cast' [line 106]: Could not cast from COSELM_coselm_eox_information to Number (Integer). Details: CastInvalidCould not cast from COSELM_coselm_eox_information to Number (Integer). Details: CastInvalid

stewart.burchell
Employee
Oct 31, 2023 1:22 PM UTC

You don't need the CAST. You can simply have the following:

a!forEach(
    items: local!productInfo,
    expression: 'type!{urn:com:appian:types:COSELM}COSELM_coselm_eox_information'(
      /* map your attributes from each instance of fv!item to your CDT attributes */
    )
  )

8 replies

natarajanm0529
Known Participant
Oct 31, 2023 1:15 PM UTC

I am not sure, How to debug this issue in order to isolate the where the error is originating?

stewart.burchell
Employee
Oct 31, 2023 1:22 PM UTC

You don't need the CAST. You can simply have the following:

a!forEach(
    items: local!productInfo,
    expression: 'type!{urn:com:appian:types:COSELM}COSELM_coselm_eox_information'(
      /* map your attributes from each instance of fv!item to your CDT attributes */
    )
  )

natarajanm0529
Known Participant
Oct 31, 2023 1:32 PM UTC

Thank you :). But in my other expression i am doing casting which is working i am not sure why i am getting error. However this solution works fine. Let me integrate this with process model and see if it actually post the data to db 

  a!forEach(
  items: local!productinfo,
  expression: 
  'type!{urn:com:appian:types:COSELM}COSELM_coselm_eox_information'(
    
      serialNumber: fn!index(fv!item, "EOXInputValue", null),
      createdBy: loggedInUser(),
      createdOn: now(),
      modifiedBy: loggedInUser(),
      modifiedOn: now(),
      eOlproductId: fn!index(fv!item, "EOLProductID", null),
      productIdDescription: fn!index(fv!item, "ProductIDDescription", null),
      productBulletinNumber: fn!index(fv!item, "ProductBulletinNumber", null),
      linkToProductBulletinUrl: fn!index(fv!item, "LinkToProductBulletinURL", null),
      eOxExternalAnnouncementDate: fn!index(fv!item, "EOXExternalAnnouncementDate", null),
      endOfSaleDate: fn!index(fv!item, "EndOfSaleDate", null),
      endOfSwMaintenanceReleases: fn!index(fv!item, "EndOfSWMaintenanceReleases", null),
      endOfSecurityVulSupportDate: fn!index(fv!item, "EndOfSecurityVulSupportDate", ""),
      endOfRoutineFailureAnalysisDate: fn!index(fv!item, "EndOfRoutineFailureAnalysisDate", null),
      endOfServiceContractRenewal: fn!index(fv!item, "EndOfServiceContractRenewal", null),
      lastDateOfSupport: fn!index(fv!item, "LastDateOfSupport", null),
      endOfSvcAttachDate: fn!index(fv!item, "EndOfSvcAttachDate", null),
      updatedTimeStamp: fn!index(fv!item, "UpdatedTimeStamp", null),
      pIdActiveFlag: fn!index(fv!item, "PIDActiveFlag", null),
      migrationProductInfoUrl: fn!index(fv!item, "MigrationProductInfoURL", null),
      migrationInformation: fn!index(fv!item, "MigrationInformation", null),
      migrationProductId: fn!index(fv!item, "MigrationProductId", null),
      migrationProductName: fn!index(fv!item, "MigrationProductName", null),
      migrationStrategy: fn!index(fv!item, "MigrationStrategy", null),
      migrationOption: fn!index(fv!item, "MigrationOption", null),
    
  ),

stewart.burchell
Employee
Oct 31, 2023 1:38 PM UTC

see my explanation below