DTP Failed for infocube in BW 7.3

[Former Member]

HI Experts,

While Doing DTP for Target infocube its failed with Following Errors

1.Datapackage error

2.Process terminated

3. Exception in subset write to Fact table

Please find the below screenshot for more clarity

Any help much appreciated

Thanks,

Varun

[yashcp]

Hi Varun,

You ran Error DTP and it did not pick up any data?

[Former Member]

HI Yash,

Yes .it contains no data strange

Any Suggestions?

Thanks,

Varun

[Former Member]

remove the space in the PSA dude !

You can see there is a space at the end of methane...or write a routine to delete that space

Simple

BR,

Yash

[yashcp]

Hi

In that case go to PSA and remove the space, as from your screenshot it is seen that there is a space. Then reload from PSA. It should solve your issue

[former_member189845]

also please check the background job and see the job log in some cases it will show you the error message or if some thing wrong data like data field etc.

As Raman said , can you share the error message

[yashcp]

Hi Varun,

Please run error DTP and find out the erroneous record. Correct the same and push it to the target

Regards,

Yash Parikh

[Former Member]

Hi ,

When i Check in Error Stack it contains No data.

PFA

[KodandaPani_KV]

HI,

one error records is there in the target object.

in DTP monitor it is showing one error record.

click on the log view of error record and find it out in PSA.

edit in PSA or using error handling DTP.

Thanks,

Phani.

[RamanKorrapati]

Hi Varun,

please click on blue mark area and see the exact error message or share here.

Thanks

[Former Member]

HI Ramanjaneyulu,

Please find the screenshot  as you requested and please do needful

Thanks,

varun

[Former Member]

Hi,

info-object zchemname has lower case letters, that is why it is failing.. you can use formula to convert it to upper case in transformations, then delete bad request and then reload data.