on 04-04-2019 11:12 AM
Hi Team,
We are loading data from DSO to target (DSO & a CUBE) .
We are in bI 7.0 but aata source is in 3.x version.
Getting below errors. Getting error in TRFC's.
In SM21, I could see below data.
Database error 60 with INS access to table /BIC/FZFIXX_C11 >
ORA-00060: deadlock detected while waiting for resource
Run-time error "DBIF_RSQL_SQL_ERROR" occurred
> Short dump "190404 054130 eeiapbwp1700_BWP_17\0102345 " created. Run-time error "MESSAGE_TYPE_X" occurred
Short dump "190404 054329 eesapbw_BW_17 012345 " created.
Transaction Canceled SY 002 ( The current application triggered a termination with a short d )
Pls advice how can we fix this, there are huge volume of data, so need to fix without delete whole request and reload.
Can we fix only this package?
Thanks,
Saravanan
To fix problem try drop indexes on cube ZFIXX_C11 before loading data.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
82 | |
9 | |
9 | |
7 | |
7 | |
7 | |
7 | |
6 | |
5 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.