Skip to Content
0

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

Feb 21 at 09:41 AM

72

avatar image

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

10 |10000 characters needed characters left characters exceeded

Hi,

Is it scripted calculation view?

Can you post here the code (if it is not a hundreds of rows...)?

BR,

0

Hi Andrey Uryukin,

Yah it is scripted calculation view, i was converting from graphical to scripted .

i had solved the problem, thank for your reply.

Regards,
Gyanendra Dubey.

0

How did you solve the problem?

0
* Please Login or Register to Answer, Follow or Comment.

0 Answers