Question Re: DTP Execution Error While deriving hierarchy Info Object in Technology Q&A

DTP Execution Error While deriving hierarchy Info Object

Former Member — Wed, 14 Jan 2015 15:42:38 GMT

Hi Experts,

I am working on finance G/L line item data where i have to Use G/L account Hierarchical data.so i am loading the G/L Account Hierarchies by creating transformations between 0GLACCEXT_T001_HIER->IOBJ 0GL_ACC .

Data is successfully loaded;But the error is coming at the time of execution of DTP.I checked my transformations RSDS also which is ok .so exact point of error ,i am unable to figure out.

So can you guys please provide me the solution for this issue.I have attached the screenshots of error in DTP.

Thanks

Ashish

Re: DTP Execution Error While deriving hierarchy Info Object

RamanKorrapati — Wed, 14 Jan 2015 15:47:07 GMT

Hi,

Are you able to see dtp montior screen, menu Request-->push manually option in enable mode?

if yes then select failed data packet and select push manually.

Thanks

Re: DTP Execution Error While deriving hierarchy Info Object

Former Member — Wed, 14 Jan 2015 15:47:32 GMT

Have you tried debugging the DTP?

Re: DTP Execution Error While deriving hierarchy Info Object

Former Member — Wed, 14 Jan 2015 17:11:18 GMT

ya, i tried.but found that some problem in transformation with GLACCEXT IOBJ ,but not sure exactly.

Re: DTP Execution Error While deriving hierarchy Info Object

Former Member — Wed, 14 Jan 2015 17:15:21 GMT

Hi Rama,Thanks for response;

But i am n't able to get that option- "menu request in monitor screen" Can you send some screenshot of this steps.

Thanks

Ashish

Re: DTP Execution Error While deriving hierarchy Info Object

Former Member — Wed, 14 Jan 2015 19:59:47 GMT

Hi,

Once Psa requst delete and same also delete requst in DTP then load once agin..check it

Thanks

Dinesh

Re: DTP Execution Error While deriving hierarchy Info Object

RamanKorrapati — Thu, 15 Jan 2015 09:25:09 GMT

Can you share your whole dtp monitor screen.

I want to see all menu and tool bar options.

Re: DTP Execution Error While deriving hierarchy Info Object

Former Member — Fri, 16 Jan 2015 08:56:25 GMT

Hi Raman,

Thanks for response . Ya absolutely i can share my detail DTP monitor screen with you.

Just check the screenshots below.and i have already attached the ERROR Screenshot.

Thanks

Ashish

Re: DTP Execution Error While deriving hierarchy Info Object

RamanKorrapati — Fri, 16 Jan 2015 09:16:42 GMT

Hi Ashis,

I asked DTP monitor screen along with menu and tool bar screen shot dear.

You shared information is DTP details not monitor screen.

No problem.

Am sharing my dtp monitor screen and check push manual(red mark) option(between refresh and debuggiong options) was availbale on our screen.

After the error if you didn't take any actions then you may see above options.

Thanks

Re: DTP Execution Error While deriving hierarchy Info Object

Former Member — Fri, 16 Jan 2015 09:35:48 GMT

Hi Ashish,

Please check the Transformation Mapping for Hierarchy structure.

There are chances that the mapping are not proper and give this error.

Regards,

Bhavya K

Re: DTP Execution Error While deriving hierarchy Info Object

Former Member — Fri, 16 Jan 2015 09:50:16 GMT

Hi raman,

I didn't get that option of PUSH MANUAL between Refresh and Debug Button.I am using BW 7.3.

i am attaching the screenshots.please check that.

Thanks

Ashish

Re: DTP Execution Error While deriving hierarchy Info Object

RamanKorrapati — Fri, 16 Jan 2015 09:53:42 GMT

Hi,

reactivate your transformations and delete failed request.

I again trigger and load the data.

processing terminated is general error message.

Can you click on yellow icon against your error and share that info here.

Thanks

Re: DTP Execution Error While deriving hierarchy Info Object

Former Member — Fri, 16 Jan 2015 10:00:34 GMT

Hi Bhavya,Thanks for Response.

I have checked the transformations already. Still I am sharing the Screenshots of Hierarchy Data Transformations for G/L account.please check that and suggest me the solution.

Thanks

Ashish

Re: DTP Execution Error While deriving hierarchy Info Object

Former Member — Fri, 16 Jan 2015 10:59:19 GMT

Hi Ashish,

I have seen the screen shots.

Just to check once, can you remove the mapping for 0OBJECTID in all and make it initial and try to load.

Thanks,

Bhavya

Re: DTP Execution Error While deriving hierarchy Info Object

Former Member — Fri, 16 Jan 2015 13:43:33 GMT

Hi Raman,

Please check - this is the Detail Description of my error Message While executing the DTP.

Thanks..

Re: DTP Execution Error While deriving hierarchy Info Object

RamanKorrapati — Fri, 16 Jan 2015 13:51:29 GMT

Hi,

Have you used error handling/dtp concept?

if yes please check those settings. But form your previous reply error handling was deactivated.

Cross check your dtp error handling settings and remove them if its deactivated.

Even please share Long text of your error.

click on below red mark area which shows exact error details.

Thanks

Re: DTP Execution Error While deriving hierarchy Info Object

Former Member — Fri, 16 Jan 2015 14:10:35 GMT

Yes Raman , I am checking that ERROR HANDLING Setting - you can check in screenshot that It has two options:

A. DEACTIVATED

B.NO UPDATE,NO REPORTING.

I just want to know which option should i select or how to remove this DEACTIVATED Option.?

Thanks.

Re: DTP Execution Error While deriving hierarchy Info Object

RamanKorrapati — Fri, 16 Jan 2015 14:23:53 GMT

Hi,

Go to DTP in change mode and use Error handling - no update and no reporting.

Later save and activate your dtp.

if its not allowed then create new dtp and set above settings.

Later run your dtp.

Thanks

Re: DTP Execution Error While deriving hierarchy Info Object

Former Member — Fri, 16 Jan 2015 14:47:46 GMT

Ya i followed your suggestion and make Error Handling Setting - No Update,No reporting and activate DTP and Execute it Newly.But here also i faced errors for Error handling Settings.check it.I.E in both options for Error Handling Settings i got the same error-"Update Terminated in accordance With Error handling setting".so where is the Exact prob is. Is it a prob in default Transformation ?or something else??

Thanks