HI,
I am facing the following problem .
working on DataStage7.5 EE using SAP BW Load PAck to load data to BW.But when i run the job in DataStage log it is showing 200 records sent to Bw .But in BW side it is giving "No Data LOaded connection broken".
Sometimes it is giving problem Infosource Zterm.txt is not created .
Can any one help me on this.
Not able to load data to BW
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Does this happen every time reliably, or intermittently? Do you ever achieve fully successful loads? Do the 200 rows actually make it into BW?
Check for permissions and available disk space where the directory for BW load files exists.
Have your network administrator check for unexpected dropouts or timeouts.
Check for permissions and available disk space where the directory for BW load files exists.
Have your network administrator check for unexpected dropouts or timeouts.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Hi Ray,ray.wurlod wrote:Does this happen every time reliably, or intermittently? Do you ever achieve fully successful loads? Do the 200 rows actually make it into BW?
Check for permissions and available disk space where the directory for BW load files exists.
Have your network administrator check for unexpected dropouts or timeouts.
Thanks for u r reply.Yeah we are able to load the record previously only today we were facing the problem.
We resolved this by restarting the RFC server connections.
Sree
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Get one of your SAP gurus to check the RFC logs to find out - if possible - why the problem occurred and, indeed, what it may have been. Some kind of timeout would be my guess, but why?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Etiquette Notes
1. You do not hijack threads. This thread is not about installing. Start a new one.
2. You do not post multiple times. If a timeout occurs, go Back. You will find that the post has occurred. Proceed from there.
3. The word "hey" at the beginning of your post is superfluous and, to some, could be offensive. Eschew its use.
4. English sentences begin with a capital letter.
1. You do not hijack threads. This thread is not about installing. Start a new one.
2. You do not post multiple times. If a timeout occurs, go Back. You will find that the post has occurred. Proceed from there.
3. The word "hey" at the beginning of your post is superfluous and, to some, could be offensive. Eschew its use.
4. English sentences begin with a capital letter.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.