Skip to main content
natarajanm0529
natarajanm0529
Known Participant
October 31, 2023
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
stewart.burchellAnswer
Employee
October 31, 2023

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 */
    )
  )

View in thread

8 replies

natarajanm0529
natarajanm0529Author
Known Participant
October 31, 2023

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

stewart.burchell
stewart.burchellAnswer
Employee
October 31, 2023

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
    natarajanm0529Author
    Known Participant
    October 31, 2023

    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
    stewart.burchell
    Employee
    October 31, 2023

    see my explanation below

    Terms & ConditionsAccessibility statement