Skip to Content
0
Jun 03, 2009 at 10:26 AM

DTP Delta issue when error occurs

166 Views

Dear all. This is the first time I work with BI7 so I might be asking something obvious , but for me, the issue I am facing is quite strange, I hope someone can help me.

I am loading Falt file to ODS. First to PSA with an infopackage and then from PSA to ODS wit a DTP.

I have set the DTP to be Delta and with "execute delta only once" (well I tried also without this option).

My issue is that when a file has an error and the DTP fails (integrity check if a characteristic), then next files are also failing becuase the DTP is extracting also the previous request from PSA (or from tenporary storage, I am not sure), so the same error happens even when I am loading a new file without issues.

IS this situation normal? Am I doing something wrong?

I have solve the issue by know, by deleting the full PSA before loading a new file, but this is not what I want since I want to keep old PSAs at least for some time. The fact that the DTP in delta mode is bringing more than just the latest request is anoying me.

Thanks a lot in advance,

Alfonso.