on 02-13-2011 4:24 AM
We are at a TDTIM "start data transfer" .
2 final sub-activities
RSBERRORLOG
X_CSZDORECNO
are in the queue called "Not yet started".
We have tried to start them several times, including the use of "automatic repair". However they are
still in "Not yet started".
Would you please share your experience on this. i.e. how to start them?
Thanks!
have you already checked that these conversion object are already defined and calculate in DTLMON txn.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You are right. This only final table is not calculated.
The background information is as follows:
This is a very big object. To avoid time-out during data selection, we ran this one in sender's bactch mode during data selection.
Therefore this is the ONLY one finished by batch during data selection.
And now this is the only one that cannot be started to transfer -- all other are finished.
Seems that TDMS has trouble to count it as "calculated".
Whenever I try to re-start it, I get a system error:
Transaction Canceled CNV_MBT 326 ( 'Start Data Transfer' 0009 90092 'Data Transfer' )
Perform rollback
Could you please tell how to fix this issue?
Thanks!
I have considered about what you said, but I have concerns as follows:
Because of its size I can ONLY set it to large and process in batch. This was what I did last time.
If I do what you recommended, I am repeating the same thing-- therefore TDMS still cannot count it as calculated.
Could you think of any table or txn with which I can manually set it to "calculated"? Because its data selection batch
was successfully done.
On DTLMON, I see that object is marked as "not calculated". But it does to allow me to reset it.
Thanks!
Because of its size I can ONLY set it to large and process in batch. This was what I did last time.
This is the reason why i asked you about the size category , you can run this particular conversion object for data selection in "batch " mode in TDMS , no issues at all . Only factor is correct size category that will be 'A'.( this can be done via trouble-shooter : Check the trouble shooter for activity 'Start data selection' -> chnage technical settings ->define technical settings -> select size category as "large"(A)-> save and activate).
Now do the force redefinition of conversion object and then data selection.
If I do what you recommended, I am repeating the same thing-- therefore TDMS still cannot count it as calculated.
Not actually , if you process as i suggested the DTLMON and related tables will be updated with the correct status for this conversion object and this will make life easier
I am sorry that I did not say clearly prviously.
In my last try, I did exactly as what you said that is choosing "Large (will run as a batch job in sender system)".
That is why it selected succussfully -- all tries before that with dia processess failed with TIMEOUT.
When I check cnvmbtcobj, it is the only one with SizeCat=A.
So if I do it again, perhaps it will end up with the same result.
Please advise.
Thanks!!
User | Count |
---|---|
78 | |
10 | |
9 | |
7 | |
6 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.