Thanks Ludwig. Yes it is apx. 5000 lines. The problem is when we try to do same using DMF it gives some weird SQL Message so excel add-in appears to be the only option. You dont know if you can alter the timeout settings on the local machine?
Cheers
: Results. Cannot execute the required database operation.
The SQL database has issued an error.
Object Server Azure:
[Microsoft][ODBC Driver 17 for SQL Server][SQL Server]UPDATE is not allowed because the statement
updates view "ASSETFIXEDASSETENTITY" which participates in a join and has an INSTEAD OF UPDATE
trigger.
UPDATE ASSETFIXEDASSETENTITY SET ACTIVITYCODE = T1.ACTIVITYCODE,ACTIVITYCODEDESCRIPTION = T1.ACTIVITYCODEDESCRIPTION,AGENT = T1.AGENT,ASSETCONDITIONDESCRIPTION = T1.ASSETCONDITIONDESCRIPTION,ASSETCONDITIONID = T1.ASSETCONDITIONID,ASSETLOCATIONID = T1.ASSETLOCATIONID,BARCODE = T1.BARCODE,COMMENTS = T1.COMMENTS,CONTACTPERSONNELNUMBER = T1.CONTACTPERSONNELNUMBER,DEPARTMENTOPERATINGUNITNUMBER = T1.DEPARTMENTOPERATINGUNITNUMBER,DEPARTMENTSEARCHNAME = T1.DEPARTMENTSEARCHNAME,DISPOSALRESTRICTIONS = T1.DISPOSALRESTRICTIONS,DOCUMENTLOCATION = T1.DOCUMENTLOCATION,FIXEDASSETGROUPID = T1.FIXEDASSETGROUPID,FIXEDASSETNUMBER = T1.FIXEDASSETNUMBER,GISREFERENCENUMBER = T1.GISREFERENCENUMBER,GUARANTEEDATE = T1.GUARANTEEDATE,INFORMATION1 = T1.INFORMATION1,INFORMATION2 = T1.INFORMATION2,INFORMATION3 = T1.INFORMATION3,INSURANCEDATE1 = T1.INSURANCEDATE1,INSURANCEDATE2 = T1.INSURANCEDATE2,INSURANCEVENDOR = T1.INSURANCEVENDOR,INSUREDATFAIRMARKETVALUE = T1.INSUREDATFAIRMARKETVALUE,INSUREDVALUE = T1.INSUREDVALUE,LASTMAINTENANCE = T1.LASTMAINTENANCE,LASTPERIODICVALUECOSTUPDATE = T1.LASTPERIODICVALUECOSTUPDATE,LEASENOTE = T1.LEASENOTE,LOCATIONID = T1.LOCATIONID,LOCATIONMEMO = T1.LOCATIONMEMO,MAINASSETID = T1.MAINASSETID,MAJORTYPEDESCRIPTION = T1.MAJORTYPEDESCRIPTION,MAJORTYPEID = T1.MAJORTYPEID,MAKE = T1.MAKE,MISSINGASSET = T1.MISSINGASSET,MODEL = T1.MODEL,MODELYEAR = T1.MODELYEAR,NAME = T1.NAME,NEXTMAINTENANCE = T1.NEXTMAINTENANCE,PARCELID = T1.PARCELID,PHYSICALINVENTORY = T1.PHYSICALINVENTORY,POLICYAMOUNT = T1.POLICYAMOUNT,POLICYEXPIRATIONDATE = T1.POLICYEXPIRATIONDATE,POLICYNUMBER = T1.POLICYNUMBER,PROPERTYGROUPDESCRIPTION = T1.PROPERTYGROUPDESCRIPTION,PROPERTYGROUPID = T1.PROPERTYGROUPID,PROPERTYTYPE = T1.PROPERTYTYPE,QUANTITY = T1.QUANTITY,REFERENCE = T1.REFERENCE,REPLACEMENTCOST = T1.REPLACEMENTCOST,RESPONSIBLEPERSONNELNUMBER = T1.RESPONSIBLEPERSONNELNUMBER,ROOMNUMBER = T1.ROOMNUMBER,SEARCHNAME = T1.SEARCHNAME,SERIALNUMBER = T1.SERIALNUMBER,SORTFIELD1DESCRIPTION = T1.SORTFIELD1DESCRIPTION,SORTFIELD1ID = T1.SORTFIELD1ID,SORTFIELD1SORTING = T1.SORTFIELD1SORTING,SORTFIELD2DESCRIPTION = T1.SORTFIELD2DESCRIPTION,SORTFIELD2ID = T1.SORTFIELD2ID,SORTFIELD2SORTING = T1.SORTFIELD2SORTING,SORTFIELD3DESCRIPTION = T1.SORTFIELD3DESCRIPTION,SORTFIELD3ID = T1.SORTFIELD3ID,SORTFIELD3SORTING = T1.SORTFIELD3SORTING,TECHNICALINFORMATION1 = T1.TECHNICALINFORMATION1,TECHNICALINFORMATION2 = T1.TECHNICALINFORMATION2,TECHNICALINFORMATION3 = T1.TECHNICALINFORMATION3,TITLEHOLDER = T1.TITLEHOLDER,TYPE = T1.TYPE,UNITCOST = T1.UNITCOST,UNITOFMEASURE = T1.UNITOFMEASURE FROM ASSETFIXEDASSETSTAGING T1 CROSS JOIN ASSETFIXEDASSETENTITY T2 WHERE ((T1.PARTITION=5637144576) AND (((T1.DEFINITIONGROUP=N'fixed asset import') AND (T1.EXECUTIONID=N'fixed asset import-2020-06-08T03:02:51-4995F1C32D3B4FD58C2DED4A5CA5DF6B')) AND NOT ((T1.TRANSFERSTATUS=2)))) AND (((((((((((((((((((((((((((((((T2.PARTITION=5637144576) AND (T2.DATAAREAID=N'spco')) AND ((T2.PARTITION#2=5637144576) OR (T2.PARTITION#2 IS NULL))) AND ((T2.DATAAREAID#2=N'spco') OR (T2.DATAAREAID#2 IS NULL))) AND ((T2.PARTITION#3=5637144576) OR (T2.PARTITION#3 IS NULL))) AND ((T2.DATAAREAID#3=N'spco') OR (T2.DATAAREAID#3 IS NULL))) AND ((T2.PARTITION#4=5637144576) OR (T2.PARTITION#4 IS NULL))) AND ((T2.PARTITION#5=5637144576) OR (T2.PARTITION#5 IS NULL))) AND ((T2.PARTITION#6=5637144576) OR (T2.PARTITION#6 IS NULL))) AND ((T2.DATAAREAID#6=N'spco') OR (T2.DATAAREAID#6 IS NULL))) AND ((T2.PARTITION#7=5637144576) OR (T2.PARTITION#7 IS NULL))) AND ((T2.DATAAREAID#7=N'spco') OR (T2.DATAAREAID#7 IS NULL))) AND ((T2.PARTITION#8=5637144576) OR (T2.PARTITION#8 IS NULL))) AND ((T2.DATAAREAID#8=N'spco') OR (T2.DATAAREAID#8 IS NULL))) AND ((T2.PARTITION#9=5637144576) OR (T2.PARTITION#9 IS NULL))) AND ((T2.DATAAREAID#9=N'spco') OR (T2.DATAAREAID#9 IS NULL))) AND ((T2.PARTITION#10=5637144576) OR (T2.PARTITION#10 IS NULL))) AND ((T2.DATAAREAID#10=N'spco') OR (T2.DATAAREAID#10 IS NULL))) AND ((T2.PARTITION#11=5637144576) OR (T2.PARTITION#11 IS NULL))) AND ((T2.DATAAREAID#11=N'spco') OR (T2.DATAAREAID#11 IS NULL))) AND ((T2.PARTITION#12=5637144576) OR (T2.PARTITION#12 IS NULL))) AND ((T2.PARTITION#13=5637144576) OR (T2.PARTITION#13 IS NULL))) AND ((T2.DATAAREAID#13=N'spco') OR (T2.DATAAREAID#13 IS NULL))) AND ((T2.PARTITION#14=5637144576) OR (T2.PARTITION#14 IS NULL))) AND ((T2.PARTITION#15=5637144576) OR (T2.PARTITION#15 IS NULL))) AND ((T2.DATAAREAID#15=N'spco') OR (T2.DATAAREAID#15 IS NULL))) AND ((T2.PARTITION#16=5637144576) OR (T2.PARTITION#16 IS NULL))) AND ((T2.DATAAREAID#16=N'spco') OR (T2.DATAAREAID#16 IS NULL))) AND ((T2.PARTITION#17=5637144576) OR (T2.PARTITION#17 IS NULL))) AND ((T2.DATAAREAID#17=N'spco') OR (T2.DATAAREAID#17 IS NULL))) AND (T1.FIXEDASSETNUMBER=T2.FIXEDASSETNUMBER))
session 1032 (simon.smith)
'5303' 'Fixed assets' record(s) inserted in staging
