Не пускает AOS

[Kozerog]

Переодически в течении дня возникает ситуация, когда AOS перестает пускать пользователей.

При этом в логе нахожу особщения:

Object Server EGO_WORK: Fatal SQL condition during login. Error message: "[Microsoft][ODBC Driver Manager] Driver's SQLAllocHandle on SQL_HANDLE_DBC failed"
 
Object Server EGO_WORK: SQL diagnostics: [Microsoft][ODBC Driver Manager] Driver's SQLAllocHandle on SQL_HANDLE_DBC failed. 
 
Object Server EGO_WORK: The database reported (session 25 (5609)): [Microsoft][ODBC Driver Manager] Connection not open. The SQL statement was: "INSERT INTO SYSTRACETABLESQL (TRACECONTAINER,STATEMENT,CALLSTACK,TEXT,TEXTDETAILS,TRACETIME,CATEGORY,CODE,CONNECTIONTYPE,CONNECTIONSPID,CONNECTIONID,ISLOBSINCLUDED,ISMOREDATAPENDING,ROWSAFFECTED,ROWSIZE,ROWSPERFETCH,ISSELECTEDFORUPDATE,ISSTARTEDWITHINTRANSACTION,STATEMENTTYPE,STATEMENTID,STATEMENTREUSECOUNT,DETAILTYPE,CREATEDDATE,CREATEDTIME,CREATEDBY,DATAAREAID,RECID) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?
 
Object Server EGO_WORK: The database reported (session 81 (152)): [Microsoft Business Solutions-Axapta] Unable to retrieve message for retval -1, ODBC call reason 
code 100, 
SQLSTATE = []
Error message []. The SQL statement was: "SELECT A.HRMORGANIZATIONID,A.HRMPOSITIONID,A.STARTDATE,A.ENDDATE,A.HRMVIRTUALNETWORKID,A.EMPLOYMENTFACTOR,A.RESIGNREASONCODEID,A.RECID,B.HRMVIRTUALNETWORKID,B.REFERENCETYPE,B.REFERENCE,B.MARITALSTATUS,B.GENDER,B.PERSONNUMBER,B.CITIZENSHIP,B.VISA,B.VISAENDDATE,B.LABOURPERMITENDDATE,B.COMPETENCESEARCHING,B.MOTHERTONGUE,B.HRMCOMPENTENCEREASONCODE,B.USERID,B.LABOURPERMIT,B.NOTESINTERNAL,B.NOTESEXTERNAL,B.RECID,C.EMPLID,C.NAME,C.DIMENSION,C.DIMENSION2_,C.DIMENSION3_,C.DIMENSION4_,C.TRAINING,C.ADDRESS,C.PHONE,C.PHONELOCAL,C.USERID,C.ALTNUM,C.ZIPCODEID,C.COUNTRYID,C.STATEID,C.COUNTYID,C.URL,C.EMAIL,C.TELEX,C.CELLULARPHONE,C.TELEFAX,C.CALENDARID,C.BIRTHDATE,C.ALIAS,C.ITEMBUYERGROUPID,C.CITY,C.STREET,C.PAGER,C.SMS,C.TITLE,C.REFZIPCODE,C.RESIGNREASONCODEID,C.SENIORITYDATE,C.OUTLOOKUSERID,C.DATELASTSYNCWITHOUTLOOK,C.SYNCINTERVAL,C.TIMELASTSYNCWITHOUTLOOK,C.SYNCWITHOUTLOOK,C.HRMABSENCESETUPID,C.ABSENCEFROMDATE,C.WORKINGHOURS,C.WORKINGHOURS2_,C.WORKINGHOURS3_,C.WORKINGHOURS4_,C.WORKINGHOURS5_,C.WORKINGHOURS6_,C.WORKINGHOURS7_,C.PROBATIONDATE,C.EMPLOYEETERMINATIONNOTICEUNIT,C.EMPLOYERTERMINATIONNOTICEUNIT,C.EMPLOYERTERMINATIONNOTICE,C.EMPLOYEETERMINATIONNOTICE,C.PENSIONSTARTDATEEMPLCONTRACT,C.PENSIONSTARTDATEEMPL,C.CURRENCY,C.HRMINCOMETAXCATEGORYID,C.HRMINCOMETAXCODEID,C.EMPLOYERSAVINGAMOUNT,C.EMPLOYEESAVINGAMOUNT,C.HOLIDAYS,C.VACATIONPAYMENT,C.MOVINGALLOWANCEAMOUNT,C.FIRSTNAME,C.MIDDLENAME,C.LASTNAME,C.SALUTATION,C.NAMESUFFIX,C.INTERNALEXTERNAL,C.EMAILSAVECOPY,C.STATUS,C.HRMUNIONIDNEGOTIATOR,C.HRMUNIONID,C.HRMSALARYTYPE,C.HRMSALARYSCALEDATE,C.HRMACTIVEINACTIVE,C.HRMVACATIONWITHSALARY,C.HRMDAYSOFFWITHSALARY,C.HRMCAREWITHSALARY,C.HRMSALARYSENIORITYDATE,C.ACTIVITYREMINDERMINUTES,C.SMMSYNCHRONIZEDAYSBACK,C.SMMSYNCHRONIZEDAYSFORWARD,C.PAYFORMTYPE_RU,C.PAYEMPLOYMENTDATE_RU,C.PAYRESIGNEDDATE_RU,C.PAYCALENDARID_RU,C.PAYBLOCKEDFROM_RU,C.PAYBLOCKED_RU,C.PAYINN_RU,C.PAYGNICODE_RU,C.PAYINNPF_RU,C.PAYMAINEMPLID_RU,C.PAYBANKPAYMENT_RU,C.ESTATE_RU,C.BUILDING_RU,C.FLAT_RU,C.STREETID_RU,C.SETTLEMENTID_RU,C.TOWNID_RU,C.IDENTITYCARDCODE_RU,C.IDENTITYCARDNUMBER_RU,C.RPAYHRMORGANISTIONID,C.EMPLGROUPID_RU,C.RHRMCREATEDATE,C.RHRMKINDOFWORK,C.RHRMTERMDATE,C.RHRMSORTOFWORK,C.IDENTITYCARDISSUEBY_RU,C.IDENTITYCARDISSUEDATE_RU,C.RHRMTRADEUNIONIST,C.RHRMEDUCATIONTYPEID,C.RHRMSCIENTIFICWORK,C.RHRMINVENTIONS,C.RHRMSTENOGRAPHY,C.RHRMCOMPUTERSKILL,C.RHRMTYPEWRITERSKILL,C.RHRMNATIONALITYID,C.RHRMINRESERVE,C.RHRMPENSIONER,C.RHRMDRIVINGLICENCE,C.RHRMZIPCODEFACTID,C.RHRMCOUNTRYFACTID,C.RHRMBUILDINGFACT,C.RHRMFLATFACT,C.RHRMSTREETFACTID,C.RHRMCOUNTRYBIRTHID,C.RHRMSTATEBIRTH,C.RHRMSTATEFACTID,C.RHRMCOUNTYBIRTH,C.RHRMCOUNTYFACTID,C.RHRMSETTLEMENTFACTID,C.RHRMTOWNBIRTH,C.RHRMTOWNFACTID,C.RHRMESTATEFACT,C.RHRMMILITARYSERVICE,C.RHRMMOBILIZATION,C.RHRMMILITARYRANK,C.RHRMMILITARYSPECIALITY,C.RHRMMILITARYSERVICEABLEBODIED,C.RHRMMILITARYREGISTRATION,C.RHRMMILITARYSPECIALREGIST16062,C.RHRMMILITARYTAKEOFFREGISTER,C.RHRMMILITARYCATEGORY,C.RHRMMILITARYGROUP,C.RHRMLABOURCONTRACTDATE,C.RHRMLABOURCONTRACT,C.RHRMADDRESSFACT,C.IDENTITYCARDSERIES_RU,C.RHRMCONTINUITYDATETEXT,C.RHRMSPECIALITYDATETEXT,C.RHRMUNHEALTHYSENIORITYDATETEXT,C.RHRMNORTHSENIORITYDATETEXT,C.RHRMSENIORITYDATETEXT,C.RHRMMILITARYCONSCRIPT,C.RHRMMILITARYRESERVED,C.RHRMPERSONNELCATEGORY,C.RHRMBIRTHPLACETYPE,C.ADVHOLDER_RU,C.RHRMCITYFACT,C.RHRMSTREETFACT,C.CPA_QUALIFICATIONLEVEL,C.CPA_POSTINGACCOUNTNUM,C.CPA_POSTINGOFFSETACCOUNT,C.CPA_POSTINGPROFILE,C.CPA_POSTINGOFFSETPROFILE,C.CPA_POSTINGDIMENSIONPROFILE,C.EGO_ASSISTENT,C.EGO_BANKACCOUNTNUM,C.EGO_HISTORICALKEY,C.EGO_TMPBANKACCOUNTID,C.EGO_ASSISTENT1,C.EGO_WORKPERMISSION,C.EGO_INTEMPLID,C.EGO_INTCOMPANYID,C.EGO_INTEMPLNAME,C.EGO_CURRENTEMPLBANKACCOUNTID,C.EGO_REGSTREET,C.EGO_REGZIPCODEID,C.EGO_REGCOUNTRYID,C.EGO_REGSTATEID,C.EGO_REGCITY,C.EGO_REGCOUNTYID,C.EGO_REGTOWNID_RU,C.EGO_REGSETTLEMENTID_RU,C.EGO_REGSTREETID_RU,C.EGO_REGESTATE_RU,C.EGO_REGBUILDING_RU,C.EGO_REGFLAT_RU,C.EGO_REGADDRESS,C.EGO_DRIVINGLICENSENUMBER,C.EGO_DRIVINGLICENSECATEGORY,C.EGO_REGION,C.EGO_CHECKDATE,C.EGO_CHECKRESPONSIBLE,C.EGO_SEX,C.EGO_EXTCOMPANY,C.EGO_ROOM,C.RECID,C.EGO_CHECKRESULT FROM HRMVIRTUALNETWORKHISTORY A,HRMVIRTUALNETWORKTABLE B,EMPLTABLE C WHERE ((A.DATAAREAID='эго') AND (((((A.STARTDATE>={ts '2007-06-01 00:00:00.000'}) AND (A.STARTDATE<={ts '2007-06-30 00:00:00.000'})) OR ((A.ENDDATE>={ts '2007-06-01 00:00:00.000'}) AND (A.ENDDATE<={ts '2007-06-30 00:00:00.000'}))) OR (((A.ENDDATE={ts '1900-01-01 00:00:00.000'}) OR (A.ENDDATE>={ts '2007-06-30 00:00:00.000'})) AND (A.STARTDATE<={ts '2007-06-30 00:00:00.000'}))) AND (A.HRMPOSITIONID='31000'))) AND ((B.DATAAREAID='эго') AND (A.HRMVIRTUALNETWORKID=B.HRMVIRTUALNETWORKID)) AND ((C.DATAAREAID='эго') AND (B.REFERENCE=C.EMPLID)) ORDER BY A.DATAAREAID,A.HRMVIRTUALNETWORKID,A.HRMORGANIZATIONID,A.STARTDATE,A.HRMPOSITIONID OPTION(FAST 1)"
 
Object Server EGO_WORK: User 10028 (wait w/o response in session 75, thread 0xd78) disconnected abnormally

Не подскажите, что может быть?

[vesna dba]

Буквально пару дней назад у меня такие ошибки были на сервере с AOS. Появились на ровном месте. Еще были ошибки на тему ".. ошибка драйвера ODBC ..".
После рестарта сервера ошибки ушли. (Windows Server 2003 R2 Std RU SP1).
Причину появления ошибки не выяснили.

[Kozerog]

У нас рестартом серверов не проблема не лечится. Переставили АОС для сервер БД для эксперимента - не помогло, кол-во выключений системы стало меньше, но проблема не решается.

[vesna dba]

как у вас AOS к БД цепляется? через ODBC или без него? Аксапта 3.0 у вас надеюсь.
После чего\после каких изменений настроек начались эти ошибки?

[somebody]

(Пере)установите самый свежий MDAC.
После на всякий случай пересоздайте ODBC-источник, соблюдая рекомендации мануала (опции).

[_AxDevel_]

Цитата:

Сообщение от Kozerog

Переодически в течении дня возникает ситуация, когда AOS перестает пускать пользователей.

При этом в логе нахожу особщения:

Object Server EGO_WORK: Fatal SQL condition during login. Error message: "[Microsoft][ODBC Driver Manager] Driver's SQLAllocHandle on SQL_HANDLE_DBC failed"
 
Object Server EGO_WORK: SQL diagnostics: [Microsoft][ODBC Driver Manager] Driver's SQLAllocHandle on SQL_HANDLE_DBC failed. 
 
Object Server EGO_WORK: The database reported (session 25 (5609)): [Microsoft][ODBC Driver Manager] Connection not open. The SQL statement was: "INSERT INTO SYSTRACETABLESQL (TRACECONTAINER,STATEMENT,CALLSTACK,TEXT,TEXTDETAILS,TRACETIME,CATEGORY,CODE,CONNECTIONTYPE,CONNECTIONSPID,CONNECTIONID,ISLOBSINCLUDED,ISMOREDATAPENDING,ROWSAFFECTED,ROWSIZE,ROWSPERFETCH,ISSELECTEDFORUPDATE,ISSTARTEDWITHINTRANSACTION,STATEMENTTYPE,STATEMENTID,STATEMENTREUSECOUNT,DETAILTYPE,CREATEDDATE,CREATEDTIME,CREATEDBY,DATAAREAID,RECID) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?
 
Object Server EGO_WORK: The database reported (session 81 (152)): [Microsoft Business Solutions-Axapta] Unable to retrieve message for retval -1, ODBC call reason 
code 100, 
SQLSTATE = []
Error message []. The SQL statement was: "SELECT A.HRMORGANIZATIONID,A.HRMPOSITIONID,A.STARTDATE,A.ENDDATE,A.HRMVIRTUALNETWORKID,A.EMPLOYMENTFACTOR,A.RESIGNREASONCODEID,A.RECID,B.HRMVIRTUALNETWORKID,B.REFERENCETYPE,B.REFERENCE,B.MARITALSTATUS,B.GENDER,B.PERSONNUMBER,B.CITIZENSHIP,B.VISA,B.VISAENDDATE,B.LABOURPERMITENDDATE,B.COMPETENCESEARCHING,B.MOTHERTONGUE,B.HRMCOMPENTENCEREASONCODE,B.USERID,B.LABOURPERMIT,B.NOTESINTERNAL,B.NOTESEXTERNAL,B.RECID,C.EMPLID,C.NAME,C.DIMENSION,C.DIMENSION2_,C.DIMENSION3_,C.DIMENSION4_,C.TRAINING,C.ADDRESS,C.PHONE,C.PHONELOCAL,C.USERID,C.ALTNUM,C.ZIPCODEID,C.COUNTRYID,C.STATEID,C.COUNTYID,C.URL,C.EMAIL,C.TELEX,C.CELLULARPHONE,C.TELEFAX,C.CALENDARID,C.BIRTHDATE,C.ALIAS,C.ITEMBUYERGROUPID,C.CITY,C.STREET,C.PAGER,C.SMS,C.TITLE,C.REFZIPCODE,C.RESIGNREASONCODEID,C.SENIORITYDATE,C.OUTLOOKUSERID,C.DATELASTSYNCWITHOUTLOOK,C.SYNCINTERVAL,C.TIMELASTSYNCWITHOUTLOOK,C.SYNCWITHOUTLOOK,C.HRMABSENCESETUPID,C.ABSENCEFROMDATE,C.WORKINGHOURS,C.WORKINGHOURS2_,C.WORKINGHOURS3_,C.WORKINGHOURS4_,C.WORKINGHOURS5_,C.WORKINGHOURS6_,C.WORKINGHOURS7_,C.PROBATIONDATE,C.EMPLOYEETERMINATIONNOTICEUNIT,C.EMPLOYERTERMINATIONNOTICEUNIT,C.EMPLOYERTERMINATIONNOTICE,C.EMPLOYEETERMINATIONNOTICE,C.PENSIONSTARTDATEEMPLCONTRACT,C.PENSIONSTARTDATEEMPL,C.CURRENCY,C.HRMINCOMETAXCATEGORYID,C.HRMINCOMETAXCODEID,C.EMPLOYERSAVINGAMOUNT,C.EMPLOYEESAVINGAMOUNT,C.HOLIDAYS,C.VACATIONPAYMENT,C.MOVINGALLOWANCEAMOUNT,C.FIRSTNAME,C.MIDDLENAME,C.LASTNAME,C.SALUTATION,C.NAMESUFFIX,C.INTERNALEXTERNAL,C.EMAILSAVECOPY,C.STATUS,C.HRMUNIONIDNEGOTIATOR,C.HRMUNIONID,C.HRMSALARYTYPE,C.HRMSALARYSCALEDATE,C.HRMACTIVEINACTIVE,C.HRMVACATIONWITHSALARY,C.HRMDAYSOFFWITHSALARY,C.HRMCAREWITHSALARY,C.HRMSALARYSENIORITYDATE,C.ACTIVITYREMINDERMINUTES,C.SMMSYNCHRONIZEDAYSBACK,C.SMMSYNCHRONIZEDAYSFORWARD,C.PAYFORMTYPE_RU,C.PAYEMPLOYMENTDATE_RU,C.PAYRESIGNEDDATE_RU,C.PAYCALENDARID_RU,C.PAYBLOCKEDFROM_RU,C.PAYBLOCKED_RU,C.PAYINN_RU,C.PAYGNICODE_RU,C.PAYINNPF_RU,C.PAYMAINEMPLID_RU,C.PAYBANKPAYMENT_RU,C.ESTATE_RU,C.BUILDING_RU,C.FLAT_RU,C.STREETID_RU,C.SETTLEMENTID_RU,C.TOWNID_RU,C.IDENTITYCARDCODE_RU,C.IDENTITYCARDNUMBER_RU,C.RPAYHRMORGANISTIONID,C.EMPLGROUPID_RU,C.RHRMCREATEDATE,C.RHRMKINDOFWORK,C.RHRMTERMDATE,C.RHRMSORTOFWORK,C.IDENTITYCARDISSUEBY_RU,C.IDENTITYCARDISSUEDATE_RU,C.RHRMTRADEUNIONIST,C.RHRMEDUCATIONTYPEID,C.RHRMSCIENTIFICWORK,C.RHRMINVENTIONS,C.RHRMSTENOGRAPHY,C.RHRMCOMPUTERSKILL,C.RHRMTYPEWRITERSKILL,C.RHRMNATIONALITYID,C.RHRMINRESERVE,C.RHRMPENSIONER,C.RHRMDRIVINGLICENCE,C.RHRMZIPCODEFACTID,C.RHRMCOUNTRYFACTID,C.RHRMBUILDINGFACT,C.RHRMFLATFACT,C.RHRMSTREETFACTID,C.RHRMCOUNTRYBIRTHID,C.RHRMSTATEBIRTH,C.RHRMSTATEFACTID,C.RHRMCOUNTYBIRTH,C.RHRMCOUNTYFACTID,C.RHRMSETTLEMENTFACTID,C.RHRMTOWNBIRTH,C.RHRMTOWNFACTID,C.RHRMESTATEFACT,C.RHRMMILITARYSERVICE,C.RHRMMOBILIZATION,C.RHRMMILITARYRANK,C.RHRMMILITARYSPECIALITY,C.RHRMMILITARYSERVICEABLEBODIED,C.RHRMMILITARYREGISTRATION,C.RHRMMILITARYSPECIALREGIST16062,C.RHRMMILITARYTAKEOFFREGISTER,C.RHRMMILITARYCATEGORY,C.RHRMMILITARYGROUP,C.RHRMLABOURCONTRACTDATE,C.RHRMLABOURCONTRACT,C.RHRMADDRESSFACT,C.IDENTITYCARDSERIES_RU,C.RHRMCONTINUITYDATETEXT,C.RHRMSPECIALITYDATETEXT,C.RHRMUNHEALTHYSENIORITYDATETEXT,C.RHRMNORTHSENIORITYDATETEXT,C.RHRMSENIORITYDATETEXT,C.RHRMMILITARYCONSCRIPT,C.RHRMMILITARYRESERVED,C.RHRMPERSONNELCATEGORY,C.RHRMBIRTHPLACETYPE,C.ADVHOLDER_RU,C.RHRMCITYFACT,C.RHRMSTREETFACT,C.CPA_QUALIFICATIONLEVEL,C.CPA_POSTINGACCOUNTNUM,C.CPA_POSTINGOFFSETACCOUNT,C.CPA_POSTINGPROFILE,C.CPA_POSTINGOFFSETPROFILE,C.CPA_POSTINGDIMENSIONPROFILE,C.EGO_ASSISTENT,C.EGO_BANKACCOUNTNUM,C.EGO_HISTORICALKEY,C.EGO_TMPBANKACCOUNTID,C.EGO_ASSISTENT1,C.EGO_WORKPERMISSION,C.EGO_INTEMPLID,C.EGO_INTCOMPANYID,C.EGO_INTEMPLNAME,C.EGO_CURRENTEMPLBANKACCOUNTID,C.EGO_REGSTREET,C.EGO_REGZIPCODEID,C.EGO_REGCOUNTRYID,C.EGO_REGSTATEID,C.EGO_REGCITY,C.EGO_REGCOUNTYID,C.EGO_REGTOWNID_RU,C.EGO_REGSETTLEMENTID_RU,C.EGO_REGSTREETID_RU,C.EGO_REGESTATE_RU,C.EGO_REGBUILDING_RU,C.EGO_REGFLAT_RU,C.EGO_REGADDRESS,C.EGO_DRIVINGLICENSENUMBER,C.EGO_DRIVINGLICENSECATEGORY,C.EGO_REGION,C.EGO_CHECKDATE,C.EGO_CHECKRESPONSIBLE,C.EGO_SEX,C.EGO_EXTCOMPANY,C.EGO_ROOM,C.RECID,C.EGO_CHECKRESULT FROM HRMVIRTUALNETWORKHISTORY A,HRMVIRTUALNETWORKTABLE B,EMPLTABLE C WHERE ((A.DATAAREAID='эго') AND (((((A.STARTDATE>={ts '2007-06-01 00:00:00.000'}) AND (A.STARTDATE<={ts '2007-06-30 00:00:00.000'})) OR ((A.ENDDATE>={ts '2007-06-01 00:00:00.000'}) AND (A.ENDDATE<={ts '2007-06-30 00:00:00.000'}))) OR (((A.ENDDATE={ts '1900-01-01 00:00:00.000'}) OR (A.ENDDATE>={ts '2007-06-30 00:00:00.000'})) AND (A.STARTDATE<={ts '2007-06-30 00:00:00.000'}))) AND (A.HRMPOSITIONID='31000'))) AND ((B.DATAAREAID='эго') AND (A.HRMVIRTUALNETWORKID=B.HRMVIRTUALNETWORKID)) AND ((C.DATAAREAID='эго') AND (B.REFERENCE=C.EMPLID)) ORDER BY A.DATAAREAID,A.HRMVIRTUALNETWORKID,A.HRMORGANIZATIONID,A.STARTDATE,A.HRMPOSITIONID OPTION(FAST 1)"
 
Object Server EGO_WORK: User 10028 (wait w/o response in session 75, thread 0xd78) disconnected abnormally

Не подскажите, что может быть?

Подскажите, в как решили вопрос, в чём была проблема?
У меня DAX 4.0: kernel 4.0.2503.27 , application 4.0.2501.121. Заметил, что "Unable to retrieve message for retval -1, ODBC call reason code 100" возникает в ситуации, когда AOS занимает много памяти, более 2ГБ.