Giving Error Message: "the memory request for 4056 bytes could not be com" while running the DMP

[karan_kothari2]

Hi Everyone,

I am trying to load data from one model to another and doing it through the DMP having following script logic.

*XDIM_MEMBERSET H_CURRENCY=LC

*XDIM_MEMBERSET H_COSTINOUT=COST_IN

*XDIM_MEMBERSET H_COA_ACCOUNT AS %ACC% =%H_COA_ACCOUNT_SET%

*XDIM_MEMBERSET H_CATEGORY AS %CAT% = %H_CATEGORY_SET%

*XDIM_MEMBERSET H_TIME = %H_TIME_SET%

*DESTINATION_APP = SOA_V1.0

*WHEN H_CATEGORY

*IS *

*REC(EXPRESSION=%VALUE%)

*ENDWHEN

*COMMIT

It is giving me the Error as below:

"the memory request for 4056 bytes could not be com"

Further, I am able to load the same data from back end (BW transformation) but why its not working from the front end.!!

[former_member186338 · Accepted solution]

Absolutely strange code...

The following lines:

*XDIM_MEMBERSET H_COA_ACCOUNT AS %ACC% =%H_COA_ACCOUNT_SET%

*XDIM_MEMBERSET H_CATEGORY AS %CAT% = %H_CATEGORY_SET%

will not set the scope, just set variables.

Useless COMMIT

[former_member186338 · Accepted solution]

P.S. Provide additional info in line with

[karan_kothari2 · Accepted solution]

Hi Vadim,

Please find the following details for your reference:

• BPC version (10.1 NW – Classic) and SP level

    

• Requirement:

          *DESTINATION_APP

          Other Details:

Source Model	Dimensions	Member ID Examples	SCOPE	Target Model	Dimensions
“COA”	HC_COSTCENTER	CC_3000032145	ALL	“SOA_V1.0”	HC_COSTCENTER
	H_AUDITTRAIL	INPUT	ALL		H_AUDITTRAIL
	H_CATEGORY	ACTUAL	ALL		H_CATEGORY
	H_COA_ACCOUNT	ABCD3001	ALL		H_COA_ACCOUNT
	H_COA_DEPT_NAME	Agency	ALL		H_COA_DEPT_NAME
	H_COA_PARTNERCCT	AB_32145	ALL		H_COA_PARTNERCCT
	H_COA_SEQUENCE	AB_001	ALL		H_COA_SEQUENCE
	H_COSTINOUT	COST_IN, COST_OUT	“COST_IN”		H_COSTINOUT
	H_CURRENCY	LC	ALL		H_CURRENCY
	H_TIME	2015.001	ALL		H_TIME

          Wants to load the data through script logic from model COA to SOA_V1.0 with scope in           dimensions H_COSTINOUT = COST_IN.

• The above requirement needs to be triggered through a DMP in front end (Excel Client).
• The DMP should ask the prompts as below before running:

          H_COA_ACCOUNT, H_CATEGORY and H_TIME.

          The above data is having huge content so that please suggest me an optimized script logic           code from performance point of view.

[former_member186338 · Accepted solution]

Not clear:

"Wants to load the data through script logic from model COA to SOA_V1.0 with scope in dimensions H_COSTINOUT = COST_IN"

And

"The DMP should ask the prompts as below before running:H_COA_ACCOUNT, H_CATEGORY and H_TIME"

May be you want to scope H_COA_ACCOUNT, H_CATEGORY and H_TIME based on the user selection?

P.S. How do you want to scope H_CURRENCY? Always LC or...?

[former_member186338 · Accepted solution]

Please show your advanced DM script!

The script logic has to be like:

*XDIM_MEMBERSET H_CURRENCY=LC //??

*XDIM_MEMBERSET H_COSTINOUT=COST_IN

*XDIM_MEMBERSET H_COA_ACCOUNT=%H_COA_ACCOUNT_SET%

*XDIM_MEMBERSET H_CATEGORY=%H_CATEGORY_SET%

*XDIM_MEMBERSET H_TIME=%H_TIME_SET%

*DESTINATION_APP = SOA_V1.0

*WHEN H_CATEGORY

*IS *

*REC(EXPRESSION=%VALUE%)

*ENDWHEN

[karan_kothari2 · Accepted solution]

Hi Vadim,

Please find my revert as below with regards to your queries.

1. "Wants to load the data through script logic from model COA to SOA_V1.0 with scope in dimensions H_COSTINOUT - COST_IN" - Both, source and target models are having the same dimensions. I want to load all the data as it is except for dimensions H_COSTINOUT. In which i want to scope the data only for member "COST_IN".

2. "The DMP should ask the prompts as below before running:H_COA_ACCOUNT, H_CATEGORY and H_TIME" - Yes, you are getting correct that i want to scope H_COA_ACCOUNT, H_CATEGORY and H_TIME based on the user selection.

3. How do you want to scope H_CURRENCY? Always LC or...? - I don't want to scope dimension H_CURRENCY and wants to transfer all the value as it is having in source.

Thanks

Karan

[former_member186338 · Accepted solution]

Then:

*XDIM_MEMBERSET H_CURRENCY=<ALL>

Please test the script in UJKT and show results.

[karan_kothari2 · Accepted solution]

Hi Vadim,

I have tested the following script in UJKT:

*XDIM_MEMBERSET H_COSTINOUT=COST_IN

*XDIM_MEMBERSET H_COA_ACCOUNT=%H_COA_ACCOUNT_SET%

*XDIM_MEMBERSET H_CATEGORY=%H_CATEGORY_SET%

*XDIM_MEMBERSET H_TIME=%H_TIME_SET%

*DESTINATION_APP = SOA_V1.0

*WHEN H_CATEGORY

*IS *

*REC(EXPRESSION=%VALUE%)

*ENDWHEN

Result:It is giving me following Error log:

I have also tried the same task from front end through DMP. Please find following advanced DMP script:

Result: After execution, it is getting aborted within a minute.

Observation: Further, it has been observed that if i execute the above script for single account then it is able to execute successfully but when i am trying to execute it with all accounts, it is getting aborted.

[former_member186338 · Accepted solution]

You have a memory issue on your server! Ask basis to check!

Also in UJKT you can also provide scope - test with different settings - number of accounts, etc!

Also provide scope for time and category!

[Former Member]

Hi Karan,

Does both of your model have the same dimensions?

anything before or after the code you showed here?

Andy

[karan_kothari2]

Hi Andy,

Yes, both of my models are having same dimensions. I described the whole code here.

Thanks

Karan