User Community
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • Don’t miss your chance to experience Discovery Summit Europe at our best available rate! Early bird registration through 31 Oct.
  • Graph Builder Toolbar streamlines interactive graphing. Creates shortcuts on Report and GraphBuilder Helpers toolbars. Download and install the extension.
  • JMP will suspend normal business operations for our Rest and Recharge Day on Friday, October 2, 2026.
    Regular business hours will resume on Monday, October 5, 2026.

JMP Knowledge Base

Choose Language Hide Translation Bar
ActualTech 5.1.12 Oracle ODBC driver causes Invalid Identifier error when importing data.
Jul 14, 2025 10:29 AM

Issue

ActualTech 5.1.12 ODBC driver does not work well with JMP. When connecting to any Oracle database using this version of the Oracle-specific Actual Technologies driver the following error will be thrown. 

 

[Actual] (Oracle Error (904) - ORA-00904: "T1". "WEIGHT"': invalid identifier

 

Workaround

The workaround is to downgrade to the 5.1.11 version of their driver. This version will pull the data, avoiding this error. This is an Actual Technologies issue, so JMP Support cannot provide an estimated resolution time.

0 Kudos
Details
Products JMP JMP Pro JMP Clinical

Recommended Articles