2013-10-16

Stupid LCM Error EPMIE-25014

When loading groups.csv into Hyperion Shared Services (HSS) using Lifecycle Manager (LCM), you may see these errors:

Importing Artifact - Groups.
error /Native Directory/Groups - EPMIE-25014: Failed to import all of the membership info for group [group name1].
error /Native Directory/Groups - EPMIE-25014: Failed to import all of the membership info for group [group name2].
...
Migration Status - Completed with failures.

Basically, LCM couldn't find the member(s) (i.e. user or another group) referenced by some groups in its directory. To find the missing member, you have to look for the common missing member in the groups reported in the errors.

This is a stupid error message because LCM must know which member is missing but doesn't include it in the error message!

2013-10-02

UTC using WMI

I wanted to get the current time in UTC (i.e. time without any offset) but there doesn't seem to be a timezone-style function in VBA / VBScript. Here's a function using WMI (Windows Management Instrumentation) to get time in UTC and a hack to pad the numbers so that they always have two digits. The output has this format: yyyy/mm/dd hh:mm:ss

'VBA References
'1. Microsoft WMI Scripting 1.2 Library

Function Utc() As String
  Dim ws As WbemScripting.SWbemServices, colItem As WbemScripting.SWbemObjectSet, objItem As WbemScripting.SWbemObject

  Set ws = GetObject("winmgmts:\\localhost\root\CIMV2")
  Set colItem = ws.ExecQuery("SELECT * FROM Win32_UTCTime")
  For Each objItem In colItem
    Utc = objItem.Year & "/" & Right("00" & objItem.Month, 2) & "/" & Right("00" & objItem.Day, 2) _
      & " " & Right("00" & objItem.Hour, 2) & ":" & Right("00" & objItem.Minute, 2) & ":" & Right("00" & objItem.Second, 2)
  Next

End Function

2013-09-30

Claiming Myki Reimbursement

Here is a procedure for quickly claiming a Myki reimbursement if you are clearly overcharged. Myki is the smartcard system used for public transport fares in Melbourne.

Assumptions: Your Myki card(s) is registered on the PTV site so that you can check your trip and charges, and you know your account PIN.

  1. Wait 48 hours after the overcharged trip before contacting the PTV service centre. (You can call the PTV earlier but the operators won't do anything until 48 hours have passed.)
  2. Ensure you know the trip details (route, time, date and stops).
  3. Ensure you know your Myki card number.
  4. Call PTV call centre on 1800 800 007 then press 1 and 6.
  5. When an operator responds, explain that you have been overcharged for some Myki trips.
  6. Give the operator your PIN to confirm your identity.
  7. Give the operator the relevant Myki card number and trip details.
  8. Let the operator confirm that your claim is valid. The operator has to check the route, stops and zones. After confirming your claim, the operator should give you a trouble ticket number for your record.
  9. PTV should send you a confirmation by e-mail within a day or two.
  10. Your Myki card should be credited when you touch on again.

2013-09-27

Vim configuration

My Vim configuration. Probably the only non-obvious thing is to use list to show whitespaces and listchars to display each tab as ">-". See Vim Wikia Highlight unwanted spaces for more information.

set guifont=Consolas:h10:cANSI
set ignorecase
set list
set listchars=tab:>-
set nobackup
set nowritebackup
set printfont=Courier:h8
set shiftwidth=2
set tabstop=2