Hi,

I am using LLBLGen Pro 3.1, Oracle 11i and SQL 2008

Can you tell me how i can set infinite commandtimeout to sql and oracle?

Rishi

Why do you want to set it to infinite? That's quite extreme IMHO. Anyway if you can use DbUtils.CommandTimeOut (for SelfServicing) or yourAdapterInstance.CommandTimeOut (for Adapter). Setting it to 0 won't have any effect: the commandtimeout is then not set.

Hi,

I have set command timeout to 120 seconds but still i am getting timeout. Oracle is taking approx 6 minutes to execute command, any idea ?

The Import has been terminated. Reason:BusinessManager_RunProductEmployeeImport Program exited with error: The following exception occured at Void HandleErrorHe lper(Int32, Oracle.DataAccess.Client.OracleConnection, IntPtr, Oracle.DataAccess .Client.OpoSqlValCtx*, System.Object, System.String): ORA-01013: user requested cancel of current operation The following exception occured at Int32 Execute(): An exception was caught during the execution of an action query: ORA-01013: user requested cancel of current operation. Check InnerException, QueryExecuted and Parameters of this exception to examine the cause of this exception. The following exception occured at Grb.PlugIn.Assist.Business.ProfileResponse Se tEmployeeEntity(Grb.Framework.Business.Lower.EntityClasses.EmpGeneralEntity, SD. LLBLGen.Pro.ORMSupportClasses.IDataAccessAdapter): BusinessManager_SetEmployeeEntity for employeeId: 679097The ADO.Net adapter.Comm andTimeout is found to be 120, but it took 00:06:23.3724575 seconds to run the c ommand. The following exception occured at Int32 WriteProfileData(System.Collections.Arr ayList, Int32, Grb.PlugIn.Assist.Business.Import.Xml.Employee.ProfileType[], Grb .PlugIn.Assist.Business.Import.Xml.Employee.DomainType[], Grb.PlugIn.Assist.Busi ness.Import.Xml.Employee.FormTemplateType[], Int32, Int32, Boolean, Boolean, Boo lean, SD.LLBLGen.Pro.ORMSupportClasses.IDataAccessAdapter, Boolean, Boolean, Int 32, Boolean, System.String): ProductEmployeeImportManager_WriteProfileData for domainId: 62. The following exception occured at Grb.Framework.Core.Status CompleteProductEmpl oyeeXmlImport(System.IO.Stream, System.String, System.String, Int32, System.Stri ng, SD.LLBLGen.Pro.ORMSupportClasses.IDataAccessAdapter): ProductEmployeeImportManager_CompleteProductEmployeeImport_WriteProfileData for file: C:\Temp\AssistWebExportBIA3d.zip. The following exception occured at Grb.Framework.Core.Status CompleteProductEmpl oyeeXmlImport(System.IO.Stream, System.String, System.String, Int32, System.Stri ng, SD.LLBLGen.Pro.ORMSupportClasses.IDataAccessAdapter):

The following exception occured at Grb.Framework.Core.Status CompleteProductEmpl oyeeXmlImport(System.IO.Stream, System.String, System.String, Int32, System.Stri ng, SD.LLBLGen.Pro.ORMSupportClasses.IDataAccessAdapter): Error when calling CompleteImport. The following exception occured at Grb.Framework.Core.Status ProcessProductEmplo yeeXmlImport(System.String, System.IO.Stream, System.String, Int32, System.Strin g, SD.LLBLGen.Pro.ORMSupportClasses.IDataAccessAdapter): ProductEmployeeImportManager_ProcessProductEmployeeXmlImport_CompleteProductEmpl oyeeImport for original file: C:\Temp\AssistWebExportBIA3d.zip The following exception occured at Grb.Framework.Core.Status ProcessProductEmplo yeeXmlImport(System.String, System.String, System.String, Int32, System.String, SD.LLBLGen.Pro.ORMSupportClasses.IDataAccessAdapter): ProductEmployeeImportManager_ProcessProductEmployeeXmlImport_OpeningFile for ori ginal file: C:\Temp\AssistWebExportBIA3d.zip, temporary file: C:\Users\sehanssen \AppData\Local\Temp\2\civjmtbh.l0m\AssistEmployeeProfiles.xml. The following exception occured at Grb.Framework.Core.Status RunProductEmployeeI mport(Grb.PlugIn.Assist.Business.ProductEmployeeImportManager, System.String, Sy stem.String, System.String, Boolean, Int32): BusinessManager_RunProductEmployeeImport The following exception occured at Grb.Framework.Core.Status RunProductEmployeeI mport(Grb.PlugIn.Assist.Business.ProductEmployeeImportManager, System.String, Sy stem.String, System.String, Boolean, Int32): BusinessManager_RunProductEmployeeImport Stack Trace: at Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src , String procedure) at Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, Oracle Connection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx , Object src) at Oracle.DataAccess.Client.OracleCommand.ExecuteNonQuery() at SD.LLBLGen.Pro.ORMSupportClasses.ActionQuery.Execute() at SD.LLBLGen.Pro .ORMSupportClasses.ActionQuery.Execute() at SD.LLBLGen.Pro.ORMSupportClasses.BatchActionQuery.Execute() at SD.LLBLGen.Pro.ORMSupportClasses.DataAccessAdapterBase.ExecuteActionQuery( IActionQuery queryToExecute) at SD.LLBLGen.Pro.ORMSupportClasses.DataAccessAdapterBase.PersistQueue(List`1 queueToPersist, Boolean insertActions, Int32& totalAmountSaved) at SD.LLBLGen.Pro.ORMSupportClasses.DataAccessAdapterBase.SaveEntity(IEntity2 entityToSave, Boolean refetchAfterSave, IPredicateExpression updateRestriction, Boolean recurse) at SD.LLBLGen.Pro.ORMSupportClasses.DataAccessAdapterBase.SaveEntity(IEntity2 entityToSave, Boolean refetchAfterSave, Boolean recurse) at Grb.PlugIn.Assist.Business.BusinessManager.SetEmployeeEntity(EmpGeneralEnt ity employeeEntity, IDataAccessAdapter externalAdapter) in D:\Source\WorkingSour ce\Production\AssistWeb\PlugIn\Assist\Business\BusinessManager.vb:line 5659 at Grb.PlugIn.Assist.Business.BusinessManager.SetEmployeeEntity(EmpGeneralEntity e mployeeEntity, IDataAccessAdapter externalAdapter) in D:\Source\WorkingSource\Pr oduction\AssistWeb\PlugIn\Assist\Business\BusinessManager.vb:line 5667 at Grb.PlugIn.Assist.Business.ProductEmployeeImportManager.WriteProfileData(A rrayList employeeValidationData, Int32 validationIndex, ProfileType[] profileLis t, DomainType[] domainList, FormTemplateType[] formTemplateList, Int32 domainId, Int32 domainCustomIdType, Boolean importedFromPreviousProduct, Boolean partialR eportImportAllowed, Boolean partialCollectionImportAllowed, IDataAccessAdapter a dapter, Boolean insertFlag, Boolean updateFlag, Int32 userId, Boolean isImportRe portAndFormAllowed, String zipBaseDirectory) in D:\Source\WorkingSource\Producti on\AssistWeb\PlugIn\Assist\Business\ProductEmployeeImportManager.vb:line 3550 at Grb.PlugIn.Assist.Business.ProductEmployeeImportManager.WriteProfileData(Arra yList employeeValidationData, Int32 validationIndex, ProfileType[] profileList, DomainType[] domainList, FormTemplateType[] formTemplateList, Int32 domainId, In t32 domainCustomIdType, Boolean importedFromPreviousProduct, Boolean partialRepo rtImportAllowed, Boolean partialCollectionImportAllowed, IDataAccessAdapter adap ter, Boolean insertFlag, Boolean updateFlag, Int32 userId, Boolean isImportRepor tAndFormAllowed, String zipBaseDirectory) in D:\Source\WorkingSource\Production\ AssistWeb\PlugIn\Assist\Business\ProductEmployeeImportManager.vb:line 3566 at Grb.PlugIn.Assist.Business.ProductEmployeeImportManager.CompleteProductEmp loyeeXmlImport(Stream xmlStream, String filePathAndName, String physicalApplicat ionPath, Int32 userId, String zipBaseDirectory, IDataAccessAdapter adapter) in D :\Source\WorkingSource\Production\AssistWeb\PlugIn\Assist\Business\ProductEmploy eeImportManager.vb:line 721 at Grb.PlugIn.Assist.Business.ProductEmployeeImpor tManager.CompleteProductEmployeeXmlImport(Stream xmlStream, String filePathAndNa me, String physicalApplicationPath, Int32 userId, String zipBaseDirectory, IData AccessAdapter adapter) in D:\Source\WorkingSource\Production\AssistWeb\PlugIn\As sist\Business\ProductEmployeeImportManager.vb:line 740 at Grb.PlugIn.Assist.Bu siness.ProductEmployeeImportManager.CompleteProductEmployeeXmlImport(Stream xmlS tream, String filePathAndName, String physicalApplicationPath, Int32 userId, Str ing zipBaseDirectory, IDataAccessAdapter adapter) in D:\Source\WorkingSource\Pro duction\AssistWeb\PlugIn\Assist\Business\ProductEmployeeImportManager.vb:line 75 0 at Grb.PlugIn.Assist.Business.ProductEmployeeImportManager.CompleteProductEm ployeeXmlImport(Stream xmlStream, String filePathAndName, String physicalApplica tionPath, Int32 userId, String zipBaseDirectory, IDataAccessAdapter adapter) in D:\Source\WorkingSource\Production\AssistWeb\PlugIn\Assist\Business\ProductEmplo yeeImportManager.vb:line 755 at Grb.PlugIn.Assist.Business.ProductEmployeeImportManager.ProcessProductEmpl oyeeXmlImport(String originalFileName, Stream fileStream, String physicalApplica tionPath, Int32 userId, String zipBaseDirectory, IDataAccessAdapter adapter) in D:\Source\WorkingSource\Production\AssistWeb\PlugIn\Assist\Business\ProductEmplo yeeImportManager.vb:line 450 at Grb.PlugIn.Assist.Business.ProductEmployeeImpo rtManager.ProcessProductEmployeeXmlImport(String originalFileName, Stream fileSt ream, String physicalApplicationPath, Int32 userId, String zipBaseDirectory, IDa taAccessAdapter adapter) in D:\Source\WorkingSource\Production\AssistWeb\PlugIn\ Assist\Business\ProductEmployeeImportManager.vb:line 457 at Grb.PlugIn.Assist.Business.ProductEmployeeImportManager.ProcessProductEmpl oyeeXmlImport(String originalFileName, String filePathAndName, String physicalAp plicationPath, Int32 userId, String zipBaseDirectory, IDataAccessAdapter adapter ) in D:\Source\WorkingSource\Production\AssistWeb\PlugIn\Assist\Business\Product EmployeeImportManager.vb:line 387 at Grb.PlugIn.Assist.Business.ProductEmploye eImportManager.ProcessProductEmployeeXmlImport(String originalFileName, String f ilePathAndName, String physicalApplicationPath, Int32 userId, String zipBaseDire ctory, IDataAccessAdapter adapter) in D:\Source\WorkingSource\Production\AssistW eb\PlugIn\Assist\Business\ProductEmployeeImportManager.vb:line 390 at Grb.PlugIn.Assist.Business.BusinessManager.RunProductEmployeeImport(Produc tEmployeeImportManager importManager1, String filePathAndName, String originalFi leName, String xsdFolderPath, Boolean testMode, Int32 userId) in D:\Source\Worki ngSource\Production\AssistWeb\PlugIn\Assist\Business\BusinessManager.vb:line 687 4 at Grb.PlugIn.Assist.Business.BusinessManager.RunProductEmployeeImport(Produ ctEmployeeImportManager importManager1, String filePathAndName, String originalF ileName, String xsdFolderPath, Boolean testMode, Int32 userId) in D:\Source\Work ingSource\Production\AssistWeb\PlugIn\Assist\Business\BusinessManager.vb:line 68 91 at Grb.PlugIn.Assist.Business.BusinessManager.RunProductEmployeeImport(Prod uctEmployeeImportManager importManager1, String filePathAndName, String original FileName, String xsdFolderPath, Boolean testMode, Int32 userId) in D:\Source\Wor kingSource\Production\AssistWeb\PlugIn\Assist\Business\BusinessManager.vb:line 6 909 at Grb.PlugIn.Assist.Business.BusinessManager.DoProductEmployeeImport(String filePathAndName, String originalFileName, String xsdFolderPath, String productDo mainName, String frameworkDomainName, AddLogMessageMethod addMessageDelegate, Cl earLogMessagesMethod clearMessageDelegate, Int32 userId, Boolean verboseLogging, Boolean validateAllFormsAndReportsInZipFile, Boolean logDetails) in D:\Source\W orkingSource\Production\AssistWeb\PlugIn\Assist\Business\BusinessManager.vb:line 6798

You'd better consult your DBA about it.