Insufficient Resources to perform operation (4 replies)
Not sure...what does Errors.txt say?
2019-12-04 04:42:49:911 - System.Messaging.MessageQueueException: Insufficient resources to perform operation.
at System.Messaging.MessageQueue.SendInternal(Object obj, MessageQueueTransaction internalTransaction, MessageQueueTransactionType transactionType)
at System.Messaging.MessageQueue.Send(Object obj)
at Realisable.Log.QueueSend.WriteLogEntry(ErrorEntry logEntry, MessageQueue logQueue, MessageQueue logViewQueue)
at Realisable.Log.QueueSend.WriteLogEntry(ErrorEntry logEntry)
at Realisable.Data.Transform.TransformAuditController.WriteSummaryToLog(String transformId, String summary)
at Realisable.Data.Transform.TransformAuditController.AddTransformSummaries(TransactionFactory transactionFactory)
at Realisable.Data.Transform.TransformControllerInterop.Process()
Insufficient resources to perform operation.
Time='12/04/19 04:42:51' App='IManEngine:3.2.100' ADO-version='6.3' Computer='VIOLET'
Method: TransformControllerInterop.PerformTransform
Number: -2147467259 = &H80004005 = vbObjectError - 245755 = ERRMAP_APP_FIRST - 250953
Source: System.Messaging
Description: Insufficient resources to perform operation.
Call Stack: TransformControllerInterop.PerformTransform() ----------------------------------------
Env: sFileStorePath={Text}, bPassDataAsString=False
Value Of sFileStorePath:
'C:\IMan\Debug\XXXDAT_MASTERMP_ICITEM Kit Drop and Load-65'
Call Stack: TransformControllerInterop.ITransformController_Process() ----------------------------
Call Stack: TransformCoordinator.RunTransform(sTransformId='InsertItemCost_Stock') ---------------
Env: eTransformType=2, bWriteSummaries=False, bSummariesHandled=False
Call Stack: TransformCoordinator.RunTransformStream(sParentTransform='VBZQIKUX') -----------------
Env: sTransformId='InsertItemCost_Stock', l=0, m=0
Call Stack: TransformCoordinator.RunTransformStream(sParentTransform='') -------------------------
Env: sTransformId='VBZQIKUX', l=3, m=3
Call Stack: TransformCoordinator.Process() -------------------------------------------------------
Call Stack: IntManEng.Main() ---------------------------------------------------------------------
Env: sCmd={Text}
Value Of sCmd:
'"XXXDAT_MASTERMP_ICITEM Kit Drop and Load"'
I suspect what's happening is that you're blowing up the MessageQueue service!
Why do you want to write the outcome of 100k's records of updates to the Audit log?
The email you generate will be too big.
Remove the audit to just have %Record.PROCESSED %Record.INSERTED %Record.UPDATED (obviously replace Record with the actual record id).
Thanks
Oh super! I'll try that. Yes that's probably too much auditing for one person to consume. Thanks for the suggestion.
Hi there,
Just so I can better troubleshoot this, can you advise on how to handle this error? This transform failed when trying to insert several hundred thousand records to a custom Extender table. I am not sure if this is related to our upgrade to v4.0 or if it's just related to server resources. Advice please?
Transform error message:
RESULTREASON
Error occurred whilst processing transform [InsertItemCost_Stock]. Insufficient resources to perform operation.