Skip to Content

SQL SCRIPT -Not a valid number string '' - Could not derive table type for variable

Hi expert,

Need help.

I am getting below error message while doing union all on two select statements.
it seems problem is coming because of quantity field of type decimal-


Message : Repository: Encountered an error in repository runtime extension;Model inconsistency. Deploy Calculation View: SQL: SqlScript: general error: not a valid number string '' - Could not derive table type for variable "IT_UNION1": line 38 col 1 (at pos 1867) Set Schema DDL statement: set schema "SYSTEM" Type DDL: create type

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers