{"id":2689,"date":"2017-08-23T04:15:53","date_gmt":"2017-08-23T04:15:53","guid":{"rendered":"http:\/\/pariswells.com\/blog\/?p=2689"},"modified":"2017-08-23T04:15:53","modified_gmt":"2017-08-23T04:15:53","slug":"worksite-import-failed-imanageworksite-email","status":"publish","type":"post","link":"https:\/\/pariswells.com\/blog\/research\/worksite-import-failed-imanageworksite-email","title":{"rendered":"Worksite Import Failed – iManage\/Worksite Email"},"content":{"rendered":"
  1. Login to iManage \/ Worksite Communication Server\u00a0<\/li>
  2. Go to : C:\\inetpub\\mailroot\\Badmail to see the bad mail<\/li>
  3. Open up one of the emails with wordpad \/ notepad<\/li>
  4. Get the Folder ID ( FID ) of where the email is being filed<\/li>
  5. Get the username of the operator trying to file the email\u00a0(Control + F “ref” can help alot)<\/li><\/ol>

    Subject: RE: xxxxxxxxxxxxx\u00a0(Our Ref: \u00a0xxxxxx)[xxx-xxx.FID102361] <\/strong>
    \u00a0
    If the IRN is not visible in the subject, look for the folder ID<\/p>

    “{F102361}.xxx@dms.xxxx.com”<\/p>

    From this example, the folder ID is 650594.<\/p>


    Put that folder id into this SQL query and run it against the iManage SQL database:<\/p>


    Replace the XXXXXXX with the folder ID<\/p>


    select * from [%imanageDBName%].[MHGROUP].[PROJECT_NVPS] where PRJ_ID=’XXXXXXXX’<\/strong>
    \u00a0
    Look for the value of iMan_26. this is the IRN:<\/p>

    You may also use:
    select * from [%imanageDBName%].[MHGROUP].[PROJECTS] where PRJ_ID=’XXXXXXXXX’<\/strong><\/p>

    The IRN can be found under the PRJ_DESCRIPT column:
    \u00a0
    Once you have IRN,

    In Outlook search for the workspace that is found in the reference number.
    if reference number does not exsist search for a document and use the FID number to find workspace number.
    open the IRN Workspace in Filesite\/Outlook
    expand the IRN so you can see the “File” Folder
    right click on the “File” folder , click properties
    click profile tab
    select the operator Click “Add\/Edit” button
    The operator might have a Red Circle on it
    this means the User is disabled – Enable the user or change to the live user.
    Change to the live user is prefered
    Click yes to the prompt (don’t need to tick any boxes) let it update, once complete click “close”
    \u00a0
    Now cut + paste the email from C:\\inetpub\\mailroot\\Badmail to C:\\inetpub\\mailroot\\Drop , make sure it does not go back into C:\\inetpub\\mailroot\\Badmail.
    \u00a0
    If we see many emails (over 3) in the badmail folder the comms server may have lost contact with the DB server.
    Start the worksite service manager from deskop (imanage user)<\/p>

    Check that the service account isn’t locked out\u00a0
    Move all badmails to the drop folder and see what get’s bounced to badmail and work from there.
    \u00a0
    If doing alot of these, you may want to edit Communications Server port so it doesn’t bombard users with emails
    \u00a0
    Check User filing with email Enabled in the Database?
    User filing has write access to database ( Archive01 only read only ) ?
    User filing has the same Email Address she’s sending from then the Same in AD as iManage ?
    Try enabling all users and refilling all
    Check the Workspace Folder double check the author \/ operator is installed and change to enabled user
    \u00a0


    <\/p>","protected":false},"excerpt":{"rendered":"

    Login to iManage \/ Worksite Communication Server\u00a0Go to : C:\\inetpub\\mailroot\\Badmail to see the bad mailOpen up one of the emails with wordpad \/ notepadGet the Folder ID […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[1025,622,623,2046],"class_list":["post-2689","post","type-post","status-publish","format-standard","hentry","category-research","tag-communication-server","tag-imanage","tag-worksite","tag-worksite-import-failed"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t