SQL Error message - Incompatible outer join key

Error:

com.sqrm.util.SqreamRunTimeException: prepareSql error : Incompatible outer join key types: [[Nullable Long],[Int]]

Meaning:

The type of the columns don't match. In the example above, one column is an Int and the other is BigInt.

Possible solution:

Use a CAST to cast the Int into a BigInt. 

  • 13
  • 27-Jul-2015
  • 504 Views