Calculated Column and Date Time Formats

After much searching I found some formats that work, but have not found a good reference document.

To modify the format of a date or time, convert the column to text and apply these formats as needed.

 

Month m, mm
Day d, dd
Year yy, yyyy
Hour h, hh
Minute m, mm
Second s, ss
AM/PM AM/PM

Of course you need to go into SharePoint Designer and do a nowrap=”true” on the <td> if the date renders on 2 lines.

 

VirtualBox – Windows is shutting down…. forever!

I’ve run into a bug with VirtualBox and at least Windows XP where trying to reboot or shutdown the VM causes the shutdown process to hang at the screen displaying: Windows is shutting down. This problem has to do with mouse pointer integration.

To fix the problem:

  1. Start the VM
  2. Machine > Disable Mouse Integration
  3. Machine > Close > Save the machine state
  4. Start the VM

At this point shutting down or restarting the VM should not hang. Thanks to this post for pointing me in the right direction.

Setting the XenServer Default Storage Repository

To set the default Storage Repository (SR) in XenServer:

  1. Bring up the console
  2. Find the UUID of the pool
    1. xe pool-list
  3. Set the default SR
    1. xe pool-param-set uuid=<pool-uuid> default-SR=<sr-uuid>

You can also right click on the Storage in XenCenter and select Set as Default.

In either case, this is helpful if your default SR is the smallest disk on the server, and you are doing P2V operations.

XenDesktop and Windows XP

After enough struggling, I have learned enough to get Windows XP working within XenDesktop.

After much wrestling,
there is much rejoicing.

Here are the steps I’ve taken and the errors I’ve faced as well as the solutions to those errors:

  1. Build a Master image of XP
    1. Make sure it has enough disk on C:
  2.  Join the domain
    1. Sometimes you have to move it to a workgroup, then back to the domain, before the VM will acknowledge that it belongs to a domain.
  3. Install WinRM 2.0 which you can download from Microsoft.
  4. Install the Virtual Desktop Agent
    1. If you don’t, you will receive this error: “a duplicate name exists on the network” after running Machine Creation Services and viewing the console the created desktops in XenCenter.
  5. Make sure the storage your master image is on has enough room to be snapshot. Otherwise you will receive this misleading error:
    1. “The Catalog could not be loaded due to the following errors:
      There are no master images associated with this Catalog”
    2. To move the master image
      1. Use XenCenter to move your VM
        1. Select your VM
        2. Right click > Move VM
        3. Select a storage repository that has enough room.
  6. Use Desktop Studio to create new Catalogs and Assignments.

XenConvert Source Machine Prep

Before using XenConvert on a physical source machine, there are a couple preparations:

  1. Enable Windows Automount on Windows Server operating systems
  2. Disable Windows Autoplay
  3. Remove any virtualization software
  4. Verify adequate free space exists on the destination
  5. Remove any network interface team

Windows Automount

Use the MOUNTVOL /E command in a cmd window to enable Windows Automount

Disable Windows Autoplay

This article describes disabling Windows Autoplay (Autorun): http://support.microsoft.com/kb/967715

On Windows Server 2003 change this registry key value to FF:

HKEY_CURRENT_USERSoftwareMicrosoftWindowsCurrentVersionpoliciesExplorerNoDriveTypeAutorun

On one server, the key didn’t exist. I ignored disabling autoplay on that server and the export worked out anyway.

Remove Any Virtualization Software and Verify Adequate Space

These are obvious, uninstall VMWare, VirtualPC, VirtualBox, etc. Find a spot to drop the OVF or VHD package.

Remove Any Network Interface Team

We weren’t doing anything fancy with our interfaces, so I ignored this. I figure if you are using a Network Interface Team, you would know it. Feel free to shoot me a comment on this if you have any insight.

 

Some XenConvert Experiences

I currently have the opportunity to use the XenConvert tool to move some physical servers to our customer’s XenServer environment. I have finished moving the first server, but I had to take a couple passes before finding a successful p2v plan.

OVA to XenServer

My first plan was to export an OVA file, transfer it to an existing VM on XenServer. Then use XenCenter to import the .ova file. Using the .ova approach is done by selecting Open Virtualization Format (OVF) Package and ticking the Create Open Virtual Appliance checkbox in the XenConvert workload screen.

XenConvert OVA Options
XenConvert OVA Options

Well the XenConvert to .ova finished successfully. But importing the .ova file using XenCenter failed. It kept failing on the EULA which wasn’t defined, nor necessary to define when exporting.

This initial error using XenCenter led me to try importing with XenConvert. It was a good idea, but reality didn’t play out, and I received an error again.

VHD to XenServer

My second plan was to just export the VHD. Again using XenConvert, I select the To: XenServer Virtual Hard Disk (VHD) in the initial workload screen. Again this conversion to a .vhd file completed successfully. After transferring to the existing VM on XenServer, I immediately went to XenConvert instead of XenCenter.

In XenConvert on the initial workload screen, I selected From: Microsoft Virtual Hard Disk (VHD) and To: XenServer. Selected the .vhd file from the file system. And filled in the Hostname, User name, Password and Workspace values in the XenServer connection parameters screen:

XenConvert Connection Parms Screen
XenConvert Connection Parms Screen

This worked.

OVF to XenServer

My third plan was to export an OVF package.

XenConvert Workload
XenConvert Workload

This was never executed because the VHD approach worked. I will try this approach for the second server I am moving, so watch for updates on this post.

I have successfully imported the 3rd server using an OVF and XenConvert. I found that if the OVF fails, then the VHD method will likely fail as well. It boils down to having enough disk space to do the convert. I didn’t see much advantage to using the OVF. The OVF did allocate more RAM up front, but only provided 1 VCPU. I still had to manually configure dynamic RAM and allocate more VCPU after installing Xen Tools.

Experience

  1. Disk space, disk space, disk space. XenServer needs lots of disk in order to restore. For example, restoring a 64gb VHD required 300gb of available disk.
  2. Changing the default Storage Repository is possible with some xe commands, see this.
  3. Using OVF only allocates the correct amount of maximum RAM after the convert. User still has to manually configure dynamic memory and specify the correct number of VCPUs.

Installing BPC 7.5 NetWeaver Support Packages

Installing BPC NetWeaver Support Packages are a bit more involved than for the MS version. There are 2 parts to address: the ABAP SP and the BPC SP.

Before beginning, document the current install by making screen shots of the Server Manager screens into WordPad.

ABAP SP

For the ABAP SP retrieve the .SAR file from the SAP Marketplace

NOTE: ABAP BPC Support Packages are NOT cumulative, so download all the SPs between your current version and the latest.

  1. Software Downloads > Support Packages and Patches > A – Z Index > B
  2. SAP BPC FOR SAP NETWEAVER > SBOP PC 7.5 FOR SAP NW
  3. Comprised Software Component Versions > SAP CPM BPC ABAP 7.5 > Support Packages
  4. Check the box for the SP and click Add to Download Basket.
  5. At this point, the SP is in the Approval List tab of your Download Basket and needs to be approved for download by SAP.
  6. Submit a ticket to the XX-SER-SAPSMP-SDM component asking them to approve the download.
  7. Once it is approved you may download it.

NOTE with Solution Manager, you can retreive the SP directly thru NetWeaver.

Load the Support Package into NetWeaver

  1. On the NetWeaver server, logon to client 000 as Admin
  2. Run the SPAM transaction
  3. Go to the Support Packages menu
  4. Click Load Packages > From Front End
  5. Browse to the .SAR file location
  6. Click Open
  7. Click Decompress
  8. Repeat steps 1 thru 7 for all ABAP SP files.

Transport SP into the system

  1. On the main SPAM display ensure ‘New Support Packages’ is selected under ‘Directory’
  2. Click Display
  3. Click the SP in the list
  4. Right click on the package and choose Define Queue
  5. Click the green checkmark
  6. Click No to Adding Modification Adjustment Transports to the queue
  7. The window should close and in the main SPAM window, the Queue should display your SP
  8. Click the red truck button to transport the update
  9. Click the green checkmark to start the transport of the update into the system
  10. Once the transport finishes, ‘Confirm the Queue’ by clicking the green checkmark with a pencil.
  11. Repeat steps 1 thru 10 for all ABAP SP files.


BPC .NET SP

For the BPC SP retrieve the .exe file from the SAP Marketplace

NOTE: BPC .NET Support Packages are cumulative, so only download the latest.

  1. Software Downloads > Support Packages and Patches > A – Z Index > B
  2. SAP BPC FOR SAP NETWEAVER > SBOP PC 7.5 FOR SAP NW
  3. Comprised Software Component Versions > SAP CPM BPC 7.5 for NW > Win32
  4. Check the box for the SP and click Add to Download Basket.
  5. At this point, the SP is in the Download Basket tab of your Download Basket, download it locally by right clicking the file and selecting Save Target As…


Install the SP

    1. Reboot the server
    2. Uninstall the existing .NET Server application.
    3. Reboot the server
    4. Start the install program
    5. Locate XceedZip.dll and AntiXSSlibrary.dll. NOTE: SP06 requires version 3.1 of AntiXSS which requires .NET 3.5
    6. Specify user name and company
    7. Enter ADBPCSysAdmin
    8. Select authentication method, we use CMS
    9. Enter these values by referring to the WordPad document created at the beginning.
  1. Site Port
  2. Message Queue
  3. Message Server
  4. System ID
  5. Client
  6. Language
  7. System Number
  • There are 3 ABAP service users: bpcsysadmin, bpc_admin and bpc_user. Enter their credentials.
  • Click Install
  • When the install completes, click Finish

Processing Application: Cannot find the object ApShellExtra.dbo.Audit…

While testing a new installation of BPC, I encounter an error processing an Application:

Cannot find the object “ApShellExtra.dbo.AuditActivityHdrApShell” because it does not exist or you do not have permissions.

Sure enough SQL Server Management Studio shows the table is not there. On a whim I restart the Admin client and try processing the Application again; it works!?

Turns out, after the install I always modify security to allow the BPCSysAdmin account to have full control over ApShell. Apparently those security changes weren’t completely applied until I restarted.

BPC 7.0 Management Console ‘User does not exist’

After installing BPC 7.0 MS the Management Console wouldn’t let me view logging. The ‘User does not exist’ error would appear. This was a Windows Server 2003 R2 dual server environment. Using Fiddler I was seeing a 500 error, with something like ‘cannot resolve server name vmw2317’. Hmmm… vmw seems like VMWare, but I was dealing with physical servers.

Looking at the web.config file, I discovered several appSettings with vmw2317 and vmw2315; these were left over by SAP during development. Changed the names to our real server names, saved the file and everything works!