NullReference exception error in Calculation view

[Former Member]

Hi ,

we are getting NullReference exception error in calculation view while tring to assisgn table data to a internal table :

Error:

column store error: search table error:  [2620]<VIEW NAME>: line 365 col 1 (at pos 8699): NullReference exception.

Statement for which error is coming:

AN =  Select 'A' as SOURCENAME,'A' as SOURCETYPE,'AA' as TARGETNAME,'AB' as TARGETTYPE, 'A'  as TRANID, 'A' as FLAG,'B' as TRANS_FLAG from <TABLE>;

Thanks

Pranay Sharma

[former_member182779]

You're SQL statement is not exactly right...

First...it should be "SELECT SOURCENAME AS 'A'" instead of "SELECT 'A' AS SOURCENAME'...also...you are assigning SOURCENAME, SOURCETYPE, TRANID and FLAG all to the variable 'A'....each field you have its own variable...

What is the format of AN? It should have "space" for all the fields you're selecting...

Greetings,

Blag.