BW HANA Transformation AMDP with Infoobject as source

[vctorabad_garcasosa]

Hi,

I have a HANA transformation with an Infoobject as a source. I'm getting wrong results in all the fields that have an AMDP script routine. I also checked the values retrieved on my start routine and notice that both RECORD and SQL__PROCEDURE__SOURCE__RECORD fields are empty

Any ideas?

I'm on BW 7.50 SP 10

Regards

[former_member302041]

Did you try to debug the AMDP routine?

Is data in in_table seem ok?

Id your logic ok?

Is data in out_table seem ok?

[vctorabad_garcasosa]

Yes,

The inTab table is fine but the RECORD and SQL__PROCEDURE__SOURCE__RECORD fields are empty in both start and field routines.

Start routine

Field routine

I also check the logic and it seems to be ok (it's only a left outer join with another table)

[vctorabad_garcasosa]

Trying to make the transformation simpler, we remove the start routine and try to load the data again. After that the error with the RECORD field is more evident:

SQL error with code '256'. See the following SQL message:

sql processing error: search table error: "SAPBWD"."/BIC/954HF5M39R5ZJ0NGR531OODNU=>PROCEDURE": [102] (range 1) TypeMismatch exception: Column 'RECORD' has unecpected type '(Null)Int32' that is not compatible to type '(Null)String'