AXForum  
Вернуться   AXForum > Microsoft Dynamics AX > DAX: Администрирование
All
Забыли пароль?
Зарегистрироваться Правила Справка Пользователи Сообщения за день Поиск

 
 
Опции темы Поиск в этой теме Опции просмотра
Старый 03.07.2007, 17:08   #1  
Kozerog is offline
Kozerog
Участник
 
45 / 12 (1) ++
Регистрация: 22.05.2006
Не пускает 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
Не подскажите, что может быть?
Теги
ax3.0

 

Похожие темы
Тема Автор Раздел Ответов Посл. сообщение
daxis: Troubleshooting blocked SPIDS in AOS Blog bot DAX Blogs 0 01.04.2009 18:05
После установки KR2 на AX3 SP3 не пускает на AOS больше 100 пользователей Alexandr A. Osipkin DAX: Администрирование 14 06.12.2008 02:33
Arijit Basu: AX 4 AOS Basics: [Level 100] Blog bot DAX Blogs 0 18.11.2007 14:30
DynamicsTech: What's New in Dynamics Ax 4.0 AOS? Blog bot DAX Blogs 0 12.04.2007 11:50
axaptapedia: Control AOS from command line Blog bot DAX Blogs 0 09.03.2007 14:50

Ваши права в разделе
Вы не можете создавать новые темы
Вы не можете отвечать в темах
Вы не можете прикреплять вложения
Вы не можете редактировать свои сообщения

BB коды Вкл.
Смайлы Вкл.
[IMG] код Вкл.
HTML код Выкл.
Быстрый переход

Рейтинг@Mail.ru
Часовой пояс GMT +3, время: 02:15.