NOTICE: Branded Content
NOTICE: Certain versions of content (“Material”) accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.
Service Manager / Service Center User Discussions
cancel

(SM) Support Tip: Allow the ability to upload a Microsoft Access 'accdb' file to SM tickets

Highlighted
 Micro Focus Expert Brett_Christlieb  Micro Focus Expert
 Micro Focus Expert

(SM) Support Tip: Allow the ability to upload a Microsoft Access 'accdb' file to SM tickets

Uploading a Microsoft Access database file with an extention of accdb fails with the following message: "Failed! File contains illegal content."  

This is due to the TIKA Parser is preventing the MS Access filetype accdb from being uploaded to a ticket.

To resolve update the custom-mimetypes.xml file 

1. On the Service Manager Server
     a. Shut down Service Manager
     b. Open the \RUN\lib\common-9.60.jar
     c. Drill down to edit org\apache\tika\mime\custom-mimetypes.xml
     d. It will look like this:
 
 
<?xml version="1.0" encoding="UTF-8"?>
<mime-info>
<mime-type type="application/unl">
<sub-class-of type="application/octet-stream"/>
<acronym>unl</acronym>
<_comment>HP Service Manager unload file</_comment>
<magic priority="55">
<match value="0x000219ca" type="string" offset="0"/>
<match value="0x000219cb" type="string" offset="0"/>
<match value="0x000219c9" type="string" offset="0"/>
<match value="0x00021965" type="string" offset="0"/>
<match value="0x00021966" type="string" offset="0"/>
<match value="0x00021967" type="string" offset="0"/>
<match value="0x000219fa" type="string" offset="0"/>
<match value="0x000219fb" type="string" offset="0"/>
<match value="0x000219fc" type="string" offset="0"/>
<match value="0x000219fd" type="string" offset="0"/>
<match value="0x000219fe" type="string" offset="0"/>
<match value="0x000219ff" type="string" offset="0"/>
</magic>
<glob pattern="*.unl"/>
</mime-type>
</mime-info>
 
     e. Add the following code in red
 
<?xml version="1.0" encoding="UTF-8"?>
<mime-info>
<mime-type type="application/unl">
<sub-class-of type="application/octet-stream"/>
<acronym>unl</acronym>
<_comment>HP Service Manager unload file</_comment>
<magic priority="55">
<match value="0x000219ca" type="string" offset="0"/>
<match value="0x000219cb" type="string" offset="0"/>
<match value="0x000219c9" type="string" offset="0"/>
<match value="0x00021965" type="string" offset="0"/>
<match value="0x00021966" type="string" offset="0"/>
<match value="0x00021967" type="string" offset="0"/>
<match value="0x000219fa" type="string" offset="0"/>
<match value="0x000219fb" type="string" offset="0"/>
<match value="0x000219fc" type="string" offset="0"/>
<match value="0x000219fd" type="string" offset="0"/>
<match value="0x000219fe" type="string" offset="0"/>
<match value="0x000219ff" type="string" offset="0"/>
</magic>
<glob pattern="*.unl"/>
</mime-type>
<mime-type type="application/x-msaccess">
<glob pattern="*.accdb"/>
<magic priority="60">
<match value="0x000100005374616d" type="string" offset="0"/>
</magic>
</mime-type>
</mime-info>
 
 
     f. Save
     g. Add back into the jar
     h. Close the updated jar
     i. Start Service Manager
     j. Using the Windows Client the file can now be uploaded to an Incident
 
2. Update the webtier
    a. Stop the webtier
    b. Navigate to and edit \WEB-INF\classes\org\apache\tika\mime\custom-mimetypes.xml
    c. Perform the same kind of add as listed in steps 1d and 1e above
   d. Start the webtier
   e. Test

 

1 REPLY
Micro Focus Frequent Contributor Danny_CV_OA_OMU_PM Micro Focus Frequent Contributor
Micro Focus Frequent Contributor

Re: (SM) Support Tip: Allow the ability to upload a Microsoft Access 'accdb' file to SM tickets

Thank you for the tip!