Oracle error

Hello, I’m getting the next oracle error ORA-00972: identifier is too long, my database columns are under 30 characters long and on previous versions i had no issues when quering, only updated from v0.34.3 to v.0.38, any idea on how to fix this? thx in advance

Hi @luisma

  1. Please post “Diagnostic Info” from Admin > Troubleshooting. Latest release is 0.38.1
  2. Which version of ojdbc8.jar are you using?
  3. Which version of Oracle Server are you using?
  4. Do you have Friendly Names enabled in Admin > Settings > General?
    https://www.metabase.com/docs/latest/administration-guide/08-configuration-settings.html#friendly-table-and-field-names

hi @flamber currently using ojdbc8.jar, oracle version is 11g, friendly names are active (all of this was also used on previous version, database hasn’t changed and on previous version querying didn’t had any issue). Sending logs screenshot

@luisma

  1. I’m asking for “Diagnostic Info” from Admin > Troubleshooting. Not the logs.
  2. And which version of ojdbc8.jar are you using?
  3. There’s a limitation of max 30 characters in version before Oracle 12.2
  4. Have you tried to disable friendly names? A lot has changed in Metabase since 0.34.3

sorry for logs @flamber, i don’t know why is not getting displayed on administration (screenshot of tool administration attached), ojdbc8 version is 19.3.0.0.

The database hasn’t changed queries were done with current columns names and results were given

@flamber seems .jar got damaged somehow while downloading, will download again .jar file and reinstall, if problem persistent will ask again, thx for replies :blush: