I was getting a error after Migrating to newer version it is creating & file when i compare with old version script both are same .
some thing is causing here and creating & file for each table
for each vFile in FileList('$(vQVD)*.qvd') let vFileName = mid(vFile, index(vFile, '\', -1) + 1, 99); let vFileNameOnly = subfield(vFile,'\',-1) ; let vFilePK = replace(vFileNameOnly,'.QVD','_PK'); let vFilenoQVD = replace(vFileNameOnly,'.QVD',''); let vIncFile = '$(vQVD)'&'$(vFileName)'; let vRawFile = '$(vQVDRaw)'&'$(vFileName)';
//if '$(vFileName)' = 'F0911.QVD' then [$(vFilenoQVD)]: load distinct * from $(vIncFile)(qvd); Concatenate load distinct * from $(vRawFile)(qvd) where not exists ([$(vFilePK)]);
we have recently migrated to new server and causing the error, it may be some syntax error we are suspecting.
and it is creating &F42119 file as a temp file some thing is fishy here. and saying file not found we have another file with name F42119 it suppose to pick that as per script it is working in older version