Error writing to SAP BW 'Load to BW failed: RequestID = <

system · June 21, 2010, 12:15pm

Hi,

We are trying to write data into a SAP BW target.

When writing to a demo Master Transfer Structure …
We get the error:
Load to BW failed: RequestID = <>, Packet Number = <-1>

We have a second DF that writes to a Transaction Transfer Structure …
This has no errors, but no rows are written to the SAP Target.

Can anyone enlighten us?
Where are the log files?

We are AIX unix DS version 12.2.2 to SAP BW 7.01.

Thanks in advance

pxbaker (BOB member since 2007-01-09)

system · June 21, 2010, 7:25pm

Is the datastore set to UTF-8 codepage?

Werner Daehn (BOB member since 2004-12-17)

system · June 22, 2010, 7:44am

Werner,

for the BW Target datastore …
the language : E -English
the codepage :

In DSConfig …
AL_Engine=_.utf-8

We also tried calling from BW. This produced errors when global variables were defined for the Job, but when we changed this to invoke without globals then it worked OK and posted data!

Thanks
Pat

pxbaker (BOB member since 2007-01-09)

system · June 22, 2010, 1:01pm

Other way around. The engine should be and the datastore utf-8.

There is no reason to change the engine codepage anymore as it will align itself to the best possible codepage. But the datastores have to match the reality.

No idea on the global variable thing.

Werner Daehn (BOB member since 2004-12-17)

system · June 22, 2010, 4:20pm

this is a bug, this issue is already fixed in 12.2.2.1, there is a Fix Pack for AIX, use that

following is from the release notes
ADAPT01372403:
Data Services was unable to load data into BW Master Transfer Structure and failed with error
message Load data to BW failed: RequestID = <>, Packet Number = <-1>. The issue has been
resolved.

manoj_d (BOB member since 2009-01-02)

system · June 23, 2010, 12:29pm

Manoj

Any idea on the Global Variables?

pxbaker (BOB member since 2007-01-09)

system · June 23, 2010, 3:57pm

you are using a global variable in your job, and when you try to schedule/execute this job from SAP BW you get an error ? if yes what are the parameters that you are passing to start the job ?

are you able to execute this job from Management Console ?
what is the error you get ?
how is this global variable used in the Job/DF ?

manoj_d (BOB member since 2009-01-02)

system · June 24, 2010, 12:38pm

Yes all is good from the Management Console.

The Globals are used for file paths, execution ids etc.

pxbaker (BOB member since 2007-01-09)

system · June 26, 2010, 6:39pm

with global varibles what is the error that you are getting ?
how are you starting the Job from BW ? by passing RepoName/JobName ? are you passing the value of global variable as additional args or these variables are initialised in the job

check the JobServer event log file on which the Job is launched, check the command that is used to start the job

since the GV name starts with $, if its not escaped it may cause problem on unix

manoj_d (BOB member since 2009-01-02)

system · July 13, 2010, 8:11am

hi,
I am getting loader error and attached the error log.

(12.2) 07-13-10 01:03:57 (E) (5032:2624) BIW-230108: |Data flow df_MATERIAL_ATTR_Load|Loader q_MATERIAL_ATTR_Load_0MATERIAL_ATTR_CD_ATTR@BODI
Load data to BW failed: RequestID = <REQU_4ICQQ9KY1K5LSWE7LQ1MXT54N>, Packet Number = <1>.
(12.2) 07-13-10 01:03:57 (E) (5032:2624) RUN-050507: |Data flow df_MATERIAL_ATTR_Load|Loader q_MATERIAL_ATTR_Load_0MATERIAL_ATTR_CD_ATTR@BODI
Unknown error <1> in transform q_MATERIAL_ATTR_Load_0MATERIAL_ATTR_CD_ATTR@BODI.

Please suggest the issue?

akundu (BOB member since 2010-07-13)

system · July 15, 2010, 2:07pm

Hi,

Try installing Oracle Client Version of 10.2.0.3 in BODS Server.The error might get Solved.

Regards,

SV BHALAJI

svbhalaji (BOB member since 2010-07-14)

system · October 18, 2010, 7:22pm

Hi,

If I install this version of Oracle client, the problem is solved?

I have been installed the version 10.2.0.1 and I have been the same problem:

i 10-18-10 17:15:10 (E) (18964:1113397568) BIW-230108: |Data flow DF_PS_TRANSACTION_HISTORY|Loader QY_FINAL_DI_PS_HISTORY_STATUS_CJ
Load data to BW failed: RequestID = <REQU_238F39TIMRB5P1VETUPZMWZCC>, Packet Number = <1>.
(12.2) 10-18-10 17:15:10 (E) (18964:1113397568) RUN-050507: |Data flow DF_PS_TRANSACTION_HISTORY|Loader QY_FINAL_DI_PS_HISTORY_STATUS_CJ
Unknown error <ŀᔚ> in transform <QY_FINAL_DI_PS_HISTORY_STATUS_CJ>.
[/i]

Thank you,
Vinícius F.

ViniciusFossaluza (BOB member since 2009-09-02)

system · October 18, 2010, 7:46pm

what is the version of DS ? I think this issue was fixed in 12.2.2.1, try with the latest 12.2 SP/FP i.e 12.2.2.3

manoj_d (BOB member since 2009-01-02)

system · October 18, 2010, 8:22pm

My Data Services version is 12.2.2.1, and yet, I’m having the error.

I don’t believe that the problem is the version of Oracle Client.

The Job worked fine. So, I have included one column in the target (BW), re-import the Data Source, mapped the new column and now, I getting the error.

I already destroyed the last query and created it again, remapped all columns, but I cannot solve the problem.

Thank you,
Vinícius F.

ViniciusFossaluza (BOB member since 2009-09-02)

system · October 20, 2010, 1:34pm

Hi guys,

I suspected that the problem was in BW target.

I ran other Jobs to prove this, and these Jobs were executed with success.

So, I went to BW and dropped and re-created the object. Reimported the object again to Data Services and the job was executed with success.

Thanks for the support.
Vinícius F.

ViniciusFossaluza (BOB member since 2009-09-02)

system · August 2, 2011, 9:49am

Hi,

Thanks, this helped me.
With me it was exactly like that my DS dev is connected to BW dev and BW tst.
BW dev datastore (it is transfer structure) have ending _CD and after transport to tst it had _PA.
So I had to reimport transfer structure and change in data flow _CD one to _PA one.

ak

aksik (BOB member since 2011-08-02)

Error writing to SAP BW 'Load to BW failed: RequestID = &lt;

Error writing to SAP BW 'Load to BW failed: RequestID = <