Skip to Content
0
Former Member
Mar 16, 2010 at 03:40 PM

Problems with DBConnect datasources when triggered from pchain (DB2 databas

70 Views

Hello,

We are using BI 7 and DB Connect functionality to remotely connect to our DB2/DB6 database to extract some data.

We created source system and data sources based on dbconnect and included infopackages, etc. into our process chains to load.

When we schedule process chain to run at certain times, InfoPackages fail at random or continue to run indefinitely. There is no clear error message, other than: Database system cannot be reached or The request is still running in the source system.

We made sure database was up during the times we are trying to schedule process chain. So, this is not the issue. The interesting thing is that whenever we try to run InfoPackages manually (not through pchain), we do not get any errors ever.

It appears that this issue occurs only when the load is triggered from the process chain (BWREMOTE user). And it happens at random. One day it could work fine, another day the same infopckage would fail.

Any ideas of what might be happening?

Thanks

Edited by: AG on Mar 16, 2010 1:30 PM