29 November 2012

Export Excel to XML error : A mapped element's relationship with other elements cannot be preserved

 When trying to export some data from an Excel file to an XML, I got the following error :
A mapped element's relationship with other elements cannot be preserved
To get around this error, I've simply deleted the unused/unmapped columns in order that all my exported columns were contiguous.

The reason is that when you map the fields described in your XSD schema with the columns in Excel, Excel is creating a table.
If the mapped columns are not contiguous, your data will be included in more than one table and Excel does not allow to export it.

25 September 2012

Alfresco on Windows Server 2008 R2 causing error 'no buffer space available'

On a Windows Server 2008 R2 x64 SP1 with Alfresco installed we were getting the following errors in a loop :
"An operation on a socket could not be performed because the system lacked sufficient buffer space or because a queue was full"
"no buffer space available"
"No buffer space available (maximum connections reached?)"
 Simply installing this hotfix should do the trick

#1

14 September 2012

Error in Analysis Services : The system is out of memory (Event ID 2)

If Analysis Services is repeatedly crashing with the following error on a Windows Server 2008 R2 x64 running SQL Server R2 x64 SP1 :
1
Log Name:      Application
2
Source:        MSSQLServerOLAPService
3
Date:          6/09/2012 08:58:13
4
Event ID:      2
5
Task Category: (289)
6
Level:         Information
7
Keywords:      Classic
8
User:          N/A
9
Computer:      rto-dwu.effigy.be
10
Description:
11
The system is out of memory.
12
Event Xml:
13
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
14
  <System>
15
    <Provider Name="MSSQLServerOLAPService" />
16
    <EventID Qualifiers="16673">2</EventID>
17
    <Level>4</Level>
18
    <Task>289</Task>
19
    <Keywords>0x80000000000000</Keywords>
20
    <TimeCreated SystemTime="2012-09-06T06:58:13.000000000Z" />
21
    <EventRecordID>332713</EventRecordID>
22
    <Channel>Application</Channel>
23
    <Computer>rto-dwu.effigy.be</Computer>
24
    <Security />
25
  </System>
26
  <EventData>
27
  </EventData>
28
</Event>
You should simply consider to install the SP2 for SQL Server 2008 R2 ;)

This solves an incomprehensible error seeing that the server has 18GB of RAM installed and the data volume is not so huge.

10 September 2012

BSOD : Stop 0x0000006B PROCESS1_INITIALIZATION_FAILED (caused by bootcat.cache)

If you get a BSOD on your Windows 7 system with the following error code : 0x0000006B, the problem could be caused by a corrupted bootcat.cache file (normal file's size is ~6MB and on a corrupted system the file is around ~14kb).
A workaround is to boot on a live system (linux, Windows repair, ...), delete the corrupted bootcat.cache file (in %SystemRoot%\system32\codeintegrity), copy it from a working copy (downloaded from internet, taken from a healthy system, ...) and reboot your computer on Windows session.
Once logged in as an administrator, edit asap the bootcat.cache's properties (if the file size is already around 14kb, you have to restart the procedure) and set the file as readonly.

This should do the trick...

#1 #2

03 September 2012

Fix Resource Monitor not working after installing DSM 4.1

Seems to be a problem linked to the ipkg's package net-snmp.
Simply remove it, reboot and the problem should be fixed.
(You may have to remove some dependencies if asked for)
> ipkg remove ntop
> ipkg remove net-snmp

#1

08 August 2012

Error 'file was not found' when running Add-SPSolution on sharepoint mangament shell

If you get the error message
The specified file was not found.
when running the command 
Add-SPSolution -LiteralPath XXXXXXXX
but the XXXXXXX file exists and the connected user has the right to read this file, execute the two following steps before executing the command:
  1. Run the Power Shell as Administrator (right click > Run as administrator)
  2. Do NOT copy paste the command, parameter and file but write it by hand entirely! Use the tab completion to ensure correct spelling.
(In my case the XXXXXXX file was  'C:\Program Files\Microsoft\SharePoint 2010 Administration Tookit\Content Management Interoperability Services (CMIS) Connectors\spcmis.wsp')

27 June 2012

Unable to create new logical volume with no extents

If you try to make a snapshot and that you get the following error message :
Unable to create new logical volume with no extents
Simply list the active logical volumes using this command :

lvdisplay

 If you see in the list a logical volume that corresponds to your snapshot, you can simply delete it with the following command :

lvremove /dev/YOUR_PATH/YOUR_LV_NAME

22 June 2012

Fix Domain Controler time not syncing

Simply execute the following command :
w32tm /config /manualpeerlist:"europe.pool.ntp.org time.nist.gov 192.43.244.18 193.67.79.202" /syncfromflags:manual /reliable:yes /update
 #1

Synology network backup failed

There is probably lot of reasons for a network backup to fail, but I would like to expose here my case.

I got the following message each time I've tried to backup my files using synology network backup system :
Network Backup failed to backup task [shared folders and local config] to [mydestinationserver]. ([23] Some files could not be transferred. Possible reasons: 1) backup user has no permission to access the files, 2) files are deleted, 3) illegal file name, 4) too many folders.)
 If I look the network backup log, I see this warning :
Network Backup failed to backup shared folder [/homes] to [mydestinationserver].
After several tests, I've discovered that the cause was the path lenght of certain folders and files in my 'homes' folder.
The path was exceeding 256 characters.

I've simply deleted those folders and finally my network backup ran smoothly.

#1

23 May 2012

Workaround for not visible Windows updates

If you are facing problem with available updates for Windows but not visible in the updates selection panel of the Windows Update window, here is a workaround :

Simply launch the task manager and kill explorer.exe, then run it again with File menu > New Task (Run...) > explorer


Your updates should now be visible.

#1

08 May 2012

Logitech Lcore.exe Microsoft Visual c++ Runtime Library Exception

If you suddenly get this error, simply check the file settings.json in the hidden folder C:\Users\yourname]\AppData\Local\Logitech\Logitech Gaming Software\.

On my PC the file's size was 1GB !

I've simply deleted the file and the application went back to normal.

07 May 2012

Install redmine on ubuntu server 12.04 (also work for 13.04)


This is a configuration for a redmine only server.

Prerequisites:

  • LAMP installed

    Install redmine:

    apt-get install redmine redmine-mysql libapache2-mod-passenger

    Create the file /etc/apache2/sites-available/redmine and write:
    <virtualhost *:80>
       DocumentRoot /usr/share/redmine/public
       PassengerResolveSymlinksInDocumentRoot on
    </virtualhost>


    Set the redmine site as the only site:
    a2dissite 000-default
    a2ensite redmine


    Reload apache :
    service apache2 reload

    You should be able to access redmine on the following address:
    http://yourserver_ip_or_name/

    #1 #2

    03 May 2012

    Set DNS name server on Ubuntu 12.04 LTS

    If you wish to change the dns nameserver information in ubuntu 12.04, you have to use the file /etc/network/interfaces instead of /etc/resolv.conf.

    Edit /etc/network/interfaces and append or replace the following line to set your dns server :
    dns-nameservers 1.2.3.4  5.6.7.8
    And optionally this one to specify the domain to be append when you request a non fully qualify name :
    dns-search foo.org bar.com

    #1

    12 April 2012

    Browse entire Active Directory catalog from apache/svn

    If you want subversion to be able to browse your entire Active Directory catalog, you have to use the port 3268 (globalcatLDAP) instead of the 389 in your apache configuration:

    AuthLDAPURL "ldap://youradserver:3268/DC=yourdomain,DC=local?sAMAccountName?sub?(objectClass=*)"

    #1 #2

    27 March 2012

    cifs mount error : block device is write-protected, mounting read-only

    I ran into an issue while trying to mount a windows' share on an ubuntu server today.

    I used the following command:
    mount -t cifs //10.1.2.3/share /mnt/sharewood/ -o username=user,password=pwd

    And I got this error message:
    mount: block device //10.1.2.3/share is write-protected, mounting read-only
    mount: cannot mount block device //10.1.2.3/share read-only


    Simply installing smbfs did the trick
    apt-get install smbfs

    20 March 2012

    Fix VLC 2 remote HTTP control

    If you recently upgraded your VLC to the version 2, you could face to an issue with the HTTP interface.
    If you try connect from a remote device, you could get a 403 Forbidden.
    In such case, edit the .hosts file located in C:\Program Files (x86)\VideoLAN\VLC\lua\http and add your local ip range or the ip of your device into the white list.

    e.g. : 192.168.1.0/24
    or : 192.168.1.60

    #1

    07 March 2012

    Restore ipkg and related application after DSM 4 upgrade

    After upgrading your DSM to the 4 version, you should get your ipkg broken.

    In order to get anew your ipkg up and running, simply edit the file
    /root/.profile
    Edit the line starting with PATH= and add the following directly after PATH=:
    /opt/bin:/opt/sbin:
    Disconnect from your ssh session and reconnect.

    Enjoy !

    #1

    03 February 2012

    Unlock/desimlock your blackberry for free

    Some advertising today :)

    I've found a website offering free blackberry unlock/desimlock:
    http://freemyblackberry.com/index.html

    You need to follow the instructions, send your information and after 24 hours maximum, you should receive the code to unlock your phone.

    I got the code after only 18h and it was working fine.

    I didn't notice more spam incoming or anything annoying after using the service from this website...

    #1

    VirtualBox not allowing to delete a snapshot

    Today I got an error while trying to delete a VirtualBox snapshot :
    "Failed to delete the snapshot XXXX of the virtual machine YYYY" (english)
    "Échec de la suppression de l'instantané XXXX de la machine virtuelle YYYY" (french)
    Hard disk 'XXXX.vdi' has more than one child hard disk (2).
    In the snapshot manager, there were only two snapshots linked to my virtual machine.
    I could delete the newest one, but I was not able to delete the oldest one/root snapshot.

    To resolve this issue, I went to the "File > Virtual Media Manager" menu, then the [Hard Disks] tab and I've expanded the tree under my virtual machine.
    I've deleted one snapshot that was not linked to any virtual machine, or snapshot.
    After what I was able to delete my oldest/root snapshot.

    11 January 2012

    Bash script launched by cron on OpenBSD not working

    In the pink world of Ubuntu from where I come, things are easy, and PATH variable is fully set in each context.
    But in the dark world of OpenBSD, things aren't always obvious ;)

    If you decide to write a bash script intended to be used as a cron task, DO NOT forget to fully qualify path of non standard commands :
    e.g. zip or smbclient should be written as /usr/local/bin/zip and /usr/local/bin/smbclient.

    Hope it could save time for others...


    10 January 2012

    Use squid on ubuntu server 11.10 joined to a domain in order to force NTLM authentication (review ubuntu 11.10)

    This installation was made on an ubuntu server 11.10 and is partially based on my previous tutorial.


    Install squid:
    sudo apt-get install squid

    You can already test the installation by configuring your web browser to use your server on port 3128 as the proxy server. You should receive an error web page generated by squid or the requested web page.

    In order to request your domain controler, you have to install the following packages:
    sudo apt-get install samba krb5-user libpam-krb5 winbind

    During the installation, you should be prompted for a default kerberos realm.
    Enter your domain name in capital letters : YOURDOMAIN.COM

    You can test that all is running fine by typing the following command:
    sudo kinit Administrator
    You will be prompted for the administrator password.
    If all is correctly configured, the command should return no result.

    You can also check the credential cache with:
    sudo klist

    Edit /etc/samba/smb.conf and add or modify the following items:
    [global]
    workgroup = YOURDOMAIN
    realm = YOURDOMAIN.COM
    security = ads
    winbind use default domain = yes
    # only add the next line if your server's name is longer
    # than 18 characters and truncate the name to 18 chars
    netbios name = mysquidserver
    [...]

    Please note that workgroup option is not ended with the Top Level Domain (.COM or whatever)

    Restart samba and winbind services:
    sudo service smbd restart
    sudo service winbind restart


    Try to join the domain with the following command:
    sudo net ads join -U Administrator
    sudo net join -U Administrator


    You should get a similar result:
    Using short domain name -- YOURDOMAIN
    Joined 'mysquidserver' to realm 'yourdomain.com'

    If you get a warning message about the DNS, you can simply ignore it ;)

    You can now test the configuration with the following command that gives you the list of users:
    wbinfo -u

    In case of any problem, restart samba and winbind before googleing.


    Now that your server is joined to your AD domain, we can configure squid.

    First, test the ntlm authentication:
    sudo /usr/bin/ntlm_auth --helper-protocol=squid-2.5-basic
    Directly after, enter a valid domain user and the corresponding password separated by a space:
    username password
    The answer should be:
    OK
    Hit CTRL+D to exit.

    Edit the file /etc/squid/squid.conf.
    Add or edit the following:
    auth_param ntlm program /usr/bin/ntlm_auth --helper-protocol=squid-2.5-ntlmssp
    auth_param ntlm children 5
    auth_param basic program /usr/bin/ntlm_auth --helper-protocol=squid-2.5-basic
    auth_param basic children 5
    auth_param basic realm YOURDOMAIN.COM
    auth_param basic credentialsttl 2 hours
    acl ntlm proxy_auth REQUIRED
    http_access allow ntlm
    append_domain .yourdomain.com
    cache_effective_group winbindd_priv


    Restart squid : sudo service squid restart

    Enjoy !

    #1 #2 #3 #4 #5 #5