Critical error with data load

[Former Member]

Hello Gurus,

I was trying to load data ffrom ODS to a Cube using DTP when I got the following error:

Exceptions in Substep: End Routine - RSBK231

The database returned a value containing an error

Do you know what this error message means. It refers to a end routine and I had no syntaxt errors with the endroutine. It also worked fine with previous data loads.

Any help in this regards is appreciated.

Thanks

Rishi

[Former Member]

You may wish to check this

Note 1063541 - Error during time split with fiscal year variant

Hope it Helps

Chetan

@CP..

[Former Member]

Click on the data source under your data target. In the bar menu, there will be PSA icon. You can see the PSA data here. After running the DTP. data will be posted to the data target. To see this data, go the manage of data target.

Thanks..

Shambhu

[Former Member]

Hey Shambhu

I still didn't find the PSA in the DTP. Can you please help me if I am missing anything. I am loading a Cube from ODS using DTP and got a bad record. I want to locate this record in DTP.

Thanks,

Rishi

[Former Member]

as said above, use debug mode,try to find exactly the record which cause this issue and rectify the data for that record and reload again.

Ramesh

[Former Member]

Hello Friends

Where can i see the bad record while loading with DTP. In Infopackages, we used to have a PSA maintenance option but I wonder how can i check which record has bad data while loading with DTP.

Thanks

Rishi

[Former Member]

Hi Rishi,

There might be some syntactical error in your end routine e.g division by a zero. This is just an example. Try running the DTP in Debug mode (you will get the option under execute tab of DTP) and see what the end routine code is doing. There might be some exception which you need to take care of.

Thanks..

Shambhu