>>>>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...
What do you think I got on my first attempt right after I reindex the set (and on a small file with only 225 records)? Well, you probably don't want to know <g>
Error: 1103
LineNo: 1081
Message: Invalid seek offset.
Procedure: runprocess
Details:
StackLevel: 2
LineContents: select cInsurances_pk, iInsurance_type_flag, cCarrier_name from load_insurances INNER join carrier_branches on cCarrier_branches_fk = cCarrier_branches_pk INNER join carriers on cCarriers_fk = cCarriers_pk where cPatients_fk = m.lcPatients_pk into cursor c_patient_insurances Time spent: 86 sec.
If it's not broken, fix it until it is.
My Blog