>>>>BTW, our temp directory is on another drive (D). My colleague thinks, it could also be the problem.
>>>
>>>It could be if there were something particular about that drive ( i.e external drive )
>>>
>>>Jaime
>>
>>Not, it's not external. It's C partitioned.
>
>Then i don't see any particular reason for it to be the problem...
Well, I had no luck with your suggestion :(
I got one Invalid Seek, then called Reindex routine, removed what you and Jason told me to add and got another one:
Error: 1103
LineNo: 1129
Message: Invalid seek offset.
Procedure: runprocess
Details:
StackLevel: 2
LineContents: insert into Load_Payments ( cTrans_fk, cPayment_type_code_fk, cPayment_source_code_fk, cAdjustment_type_code_fk, cBounced_check_payer_code_fk, cPayment_recipient_fk, cReference_number, dReceived_date, dPayment_date, dPosting_date, yAmount_paid, iBatch_number, iAdjustment_flag, cDepartment_Code) select m.lcTrans_pk as cTrans_fk, cPayment_type_code_fk, cPayment_source_code_fk, cAdjustment_type_code_fk, cast(.null. as C(16)) as cBounced_check_payer_code_fk, cPayment_recipient_fk, cReference_number, dReceived_date, dPayment_date, dReceived_date as dPosting_date, yAmount_paid, iBatch_number, iAdjustment_flag, m.tcDept_code as cDepartment_Code from load_stage_payments where cStage_trans_fk = m.lcStage_Trans_pk Time spent: 48 sec.
I think I will call it a day <g>
If it's not broken, fix it until it is.
My Blog