BODS and Rapid Mart - illogic behaviour

[Former Member]

Hello,

We are actually running BODS 4.0 SP03 and we are trying to use FIGL rapid Mart.

- Installation works Fine

- Test Connection job runs fine

- Data Model job runs fine

We've an issue regarding GL_New_Load_SAP.

Once we launch it, it starts fine but then a strange behaviour appears.

The job seems to freeze and not always on the same step.

On log page, we can see a line like :

"Dataflow <DF_xxxx> using PAGEABLE Cache with <10000 MB> buffer pool" (freeze always appens during a PAGEABLE Cache step)

and then nothing appened.

If we look at Server Task Manager, we can see process al_engine.exe don't move (RAM and CPU don't change).

We monitor al_engine during a run and we observe that :

- RAM is increasing during the different steps.

- CPU usage moves from 00 to 50 for example.

And it seems that when CPU usage is 00 and RAM don't move, it means job stops.

But we have no error or anything on Data Services.

Have you any idea about that issue ?

Thanks in advance.

regards,

Thomas.

[Former Member · Accepted solution]

Hi Thomas.

  I've upgrade DataService to SP3 patch 1 in our lab system.

Now it seem to work.

We have some difference between our system and customer system ( where DS don't work ).

We use Oracle Standard Edition so I'm not sure that PATCH 1 resolve the problem.

Now you can try to upgrade your system or wait SAP response.

Please tell me if you find the right solution.

Regards,

Marco

[Former Member · Accepted solution]

Hi,

Thank you for your feedback, we will wait for SAP answer before upgrading.

[Former Member]

Hello Guys,

I am also haveing installed BOBJ SP6 and Dataservices SP3 and I am doing Rapid mart for Sales and while running slaes job it didnt error out but unable to complete job successfully.I have make Pagaabale Memeroy to 6 GB yet the job cannot complete.resousrec while server doen have probleme.I have also adjuested some data flow to INM EMORY.I saw this blog and now i can see on SAP portal Dataservices SP4 and  dataservices Designer SP4 is available not sure which patch i need to apply i doont see Patch 1

Is any one has any latest update or any sap support meesage can any one share...I am in urgent need...

need to fix this soon....

Any help appreciated...

[Former Member]

Just to add these are latest BOBJ 4.0 SP6 and Data services 4.0 SP3

[Former Member]

Hi,

I have also managed to successfully run the AP Rapidmart extraction using the Data Services 4.0 SP3 Patch1 on Mssql Server (enterprise) thanks to all of you.

Regards,

Hans

[Former Member]

Hi all,

  just a clarification.

We also changed datastore R3 in Excute in Backgroud( Batch ) to YES otherwise the job in R3 go to time out error.

Marco

[Former Member]

Hi,

Yes I already know about that option.

We upgrade and it seems to be ok about our initial issue (we will test a little before closing SAP ticket).

We have another one about null value (we're looking at it).

Regards,

Thomas.

[Former Member]

Hi

if you are looking for converting SAP null to null,

go to BODS designer, Tools -> options -> SAP -> environment and then check the option

[Former Member]

Hi,

I tried your option (option checked) and unfortunally it throw me a null error in a dataflow before the other one.I'm trying to search bad value in debug mode but i'm facing a "Job Server connection lost" which is under investigation.

Regards,

Thomas.

[Former Member]

Hello,

Thank you for your feedback.

As we thought, SAP ask us to upgrade.

We will choose SP3 Patch 1 and will see if it solve the issue.

[former_member277195]

Patch 1, worked for me too,

I'm using SQL Enterprise DB

[Former Member]

Hi Marco,

Have you already upgrade to SP3.1 ?

Is the issue solved ?

Cause I still have no answer from SAP.

[Former Member]

Ciao Thomas,

  I'm working about that. Give me few hours and I let you know.

Marco

[Former Member]

Hi,

can you send me the CSS Ticket numbers for these please so I can take a look at them,

regards,

Adrian

[Former Member]

Hi,

Ticket number is :

973993/2012

Regards,

Thomas.

[Former Member]

We just upgrade to very high through ticket number 1027652 / 2012

[Former Member]

Hi Thomas,

Currently we are facing the same problem. Im using BO 4.0 SP04 with DS 4.0 SP03, and when i tried to run the AP Rapidmart it gets stuck without any error at different steps of the rapidmart. Sometimes the place where it got stuck were successfully run without any changes a couple of times before. If you or anybody here have any solution on this it would very much appreciated. Thank you.

[Former Member]

Hi,

As I said before, we have a call open with SAP. We do not have answer yet.

But do not downgrade because it's worst. DataServices don't work anymore.

I hope SAP will answer shortly.

[Former Member]

Hi Thomas,

also we tried to downgrade DataService to SP2 but now we have problem with CMC of BO.

I see that there is a new patch for Dataservice SP 3 Patch 1. tomorrow we install it and we hope that work.

[Former Member]

Hi marco,

We still wait for SAP next move but I hope your upgrade in SP 3.1 will solve the issue.

If it works, we certainly will follow you in new version.

[Former Member]

For information, we just downgrade but we have a new issue.

"BI SP 4.0  and BI FP 3 are not certified for DS pre SP3 as documented in Release Restriction Note for FP3."

So we can't use DataServices anymore.

We are waiting information from SAP.

But if you are with BO 4.0 SP04, do not downgrade.

[Former Member]

Hi Thomas,

Just a thought here:

Does your DSConfig.txt file in the /bin directory contain a value for the pagable cache (say not 0)?

I'm asking because 10000 seems

a) Very regular number - rather than 3854..

b) A pretty high number of 10GB.

You are having sort problems which is normally very work intensive and could be cached or attempted to be cached..

Is there any benefit from setting to 0 or a lower number than 10G (assuming you set it manually?)

Regards

Norbert

[Former Member]

Hello,

Yes we try to put the value 10000 in buffer size but it didn't solve the issue.

We also install Cost Center and Sales Rapid Mart and we have the same issue on the 3 rapid marts.

If nothing is better this afternoon, we will downgrade this week I think.

[Former Member]

Thank you.

We're also calling SAP for other information.

I'll let you know.

[Former Member]

I've try to add some trace in debug mode (Parallel execution trace for example).

It seems that job alway freeze after a line :

"Sort <sortX> completed.

I've also noticed that issue always appens on a Dataflow which contains an "Order By" Process.

Could you tell me if it's the same in your case ?

[Former Member]

Thomas,

  I've execute the job with all trace log:

but last log message was :

10252 12556 ROW 10/29/2012 4:01:51 PM Transform <FirstDelta_FirstLoad_DOCUMENT_CATEGORY:bf05ee0> is importing EOS row <>.

10252 12556 TRAN 10/29/2012 4:01:51 PM Transform <FirstDelta_FirstLoad_DOCUMENT_CATEGORY> is completed.

The line

10252 3632 PE 10/29/2012 4:01:51 PM Sort <sort 0> completed.

was before.

So I think that the stop is random.

[Former Member]

No it's because you trace more elements (like Transform and SQL transform) which I didn't check.

I will try later with more traces.

[Former Member]

Good morning Thomas,

about our problem.

Which database you use?

We use Oracle 11 enterprise.

Thanks

Marco

[Former Member]

Hi,

We also use Oracle 11 entreprise.

We try until Tuesday to succeed with this version.

if we fail, we will downgrade as asked by SAP.

[Former Member]

Hi Marco.

I've opened a call SAP and their answer is to downgrade DataServices to SP2 patch 6.

It seems that compatibility between Rapid Marts and DataServices SP3 hasn't been proved yet.

We're trying to find another way cause we would like to keep latest version of the application.

If you try the downgrade option, thank you to tell if it works better.

regards,

Thomas.

[Former Member]

Thank you.

I'll call with my boss about this solution.

I let you know.

Did you open a SAP Note?

Marco

[Former Member]

As I said before, yes a note is opened and SAP support asked us to downgrade to SP2 patch 6.

[vnovozhilov]

Dear Thomas,

I believe this problem has been reported to the SAP Support and investigated by Rapid Mart Team. Let's see if there will any input from the Forum participants, otherwise I suggest you to stick to the action plan provided in the case.

Thank you,

Viacheslav.

[Former Member]

Hi all.

  I have the same problem.

It's necessary call SAP support or there are some way to resolve the problem?

Thanks,

Marco