Posts

Showing posts from 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.

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

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</EventReco

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

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

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: Run the Power Shell as Administrator (right click > Run as administrator) 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')

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

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

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

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.

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

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

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

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

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

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

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.

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...

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: [glo