Resource DTPA DTP_XXX Could not be Created Successfully Created.(B4 HANA)

[former_member562354]

Dear All,

I am Facing Problem on Creating DTP on B4 HANA(HANA Studio 2.0).

Source: BEx Query as a Source

Target: Open Hub Destination.(Type: Flat File)

Actually i have created Composite Provider top on BEX Query(in this no complex logic, Direct CHAR and KF. No Formula aslo). Then I made a Query as a Info Provider on Trans.Code: RSRT - Property.

Second I have created Open Hub Destination Target.

Third I have Created Transformation between BEx Query(Query as Info Provider) and Open Hub Destination.

Then Creating DTP for the Transformation it's giving Error "Resource DTPA DTP_XXX Could not be Created Successfully Created."

Please Help me.

I have searched on SCN but no one provided answer.

[former_member182878]

Hi Gokul Raja sekar,

I too faced similar issue but with different objects between source and target. I deleted the transformation and recreated transformation later i was able to create DTP successfully.

Please see the below question for reference.

https://answers.sap.com/questions/722829/dtp-creation-error-resource-dtpa-xxx-couldnt-be-su.html

Regards,

Prakash

[former_member562354 · Accepted solution]

Hi Prakash,

Actually, it's Bug. So I have Applied SAP NOTES 2746641. Please if Someone facing Similar Issues, You can Apply this Note. Problem get Resolved.

NOTE: We Faced Some Other Issues.

Please have a look bellow Issues and Solution.

Issues 1: We are not able to create Transformation between Composite Provider to any Target. It's Giving SAP Message X Dump. If you face any of one creating Transformation between any of Target, Please Apply This SAP Note: 2749313. Then Problem get Resolved.

Issues 2: When we are loading data from Any source to Any Target, If you face problem, like Below:

Error in BW: _HCPR_PROCESS-1A-

Error while extracting from source XXXXX (type InfoProvider)

Data package processing terminated

Data package 1 / 05/03/2019 14:47:42 / Status 'Processed with Errors'

Then Please apply This SAP Note: 2640607. Then Problem get Resolved.

Thanks & Regards,

Gokul R