Back to forum list… Back to How Do I?...

Insufficient Resources to perform operation (4 replies)

Arline Welty
4 years ago
Arline Welty 4 years ago

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.

Support
4 years ago
Support 4 years ago

Not sure...what does Errors.txt say?

Arline Welty
4 years ago
Arline Welty 4 years ago

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"'

Support
4 years ago
Support 4 years ago

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

Arline Welty
4 years ago
Arline Welty 4 years ago

Oh super! I'll try that. Yes that's probably too much auditing for one person to consume. Thanks for the suggestion.

Contact

Realisable Software Ltd provides code-free, cost-effective applications integration solutions for SMEs. Our core IMan product is designed to integrate almost any application with a number of Sage solutions and online payment processors.

Looking to purchase IMan, please see our resellers here.

Realisable Software
Ph: +44 (0) 208 123 1017

Copyright © Realisable. All rights reserved.
Realisable is a registered trademark

Close

Request Demo

Realisable Software Ltd provides code-free, cost-effective applications integration solutions for SMEs. Our core IMan product is designed to integrate almost any application with a number of Sage solutions and online payment processors.

Looking to purchase IMan, please see our resellers here.

Realisable Software
Ph: +44 (0) 208 123 1017

Copyright © Realisable. All rights reserved.
Realisable is a registered trademark

Close

Access Downloads

Realisable Software Ltd provides code-free, cost-effective applications integration solutions for SMEs. Our core IMan product is designed to integrate almost any application with a number of Sage solutions and online payment processors.

Looking to purchase IMan, please see our resellers here.

Realisable Software
Ph: +44 (0) 208 123 1017

Copyright © Realisable. All rights reserved.
Realisable is a registered trademark

Close