03.07.2007, 17:08 | #1 |
Участник
|
Не пускает AOS
Переодически в течении дня возникает ситуация, когда 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 |
|