Error on Skuid Page ORA-01722

  • 1
  • Problem
  • Updated 2 years ago
  • In Progress
Hi Everyone.

Having a strange error come up in a Skuid Page:

common.exception.SfdcSqlException:ORA-01722:invalid number

Anyone have any idea why this might have happened?

It should be noted that we changed some data types of fields on the Account, from pick-list to Text.. would this be causing the error maybe?

Photo of James Boutel

James Boutel

  • 190 Points 100 badge 2x thumb

Posted 2 years ago

  • 1
Photo of Michael Primessnig

Michael Primessnig

  • 252 Points 250 badge 2x thumb
When you change FieldTypes in SF, it can help to delete this field from your table in Skuid and get the field (with the new type) in again. Have you already tried this?
Or do you have any Conditions related to this field as a PicklistType?