Thursday, June 29, 2017

Teradata Tools and Utilites (TTU) 15.10


First crack looked fine until the SQL Assistant crashed on launch.  Much head scratching until the realization that the shortcut was pointing to startup.exe but the actual process was SQLA.EXE.  Launching SQLA.EXE in the bubble worked fine, so the shortcut was successfully changed from startup.exe to SQLA.EXE.  startup.exe must be some kind of launcher stub used for unknown reasons and incompatible with App-V 5.

ODBC DSNs may be required so watch out for those.

While troubleshooting, launching during sequencing or use of the PVAD caused this error during the save operation:

The group or resource is not in the correct state to perform the requested operation. (Exception from HRESULT: 0x8007139F

This was tracked down to the TTUProductList shortcut with an invalid path to its icon file.  Correct the icon path to point to a valid file resource and check that the file resources do not have a bad path to the original icon file.  The path seen in the sequencer window had an invalid  ..  (2dots)  in the tree which looked like it could cause trouble.

Tuesday, June 13, 2017

Inmagic DBTextWorks 13 needs PVAD


Inmagic DBTextWorks 13 needs to have the PVAD for a successful sequence.  Using the defaults and sequencing to the VFS results in an error.  During launch the application checks for the presence of critical files and throws an error if it does not find them.  A similar error with a normal path could be generated on a conventional install by renaming the dbtext32.cmx file.  The error from the application showing the strange path led to the idea that the PVAD might correct the problem.













https://lucidea.com/inmagic/dbtextworks/

PVAD


Captain! She's breaking up.  ENGAGE PVAD !

Launch the sequencer with the -EnablePVADControl parameter

http://www.tmurgent.com/TmBlog/?p=2264

Wednesday, May 24, 2017

Creating Volume Licensed App-V Office 2016 package using ODT


Although MS have withdrawn the option to create a Volume Licensed version of Office 2016 it is still possible to do by the power of the internet :)

Near the bottom of this article is a post by Robert Gijsen on Monday, April 10, 2017.  I have tested his instructions successfully.
https://social.technet.microsoft.com/Forums/office/en-US/367938d8-9210-4c8f-aa5e-c8de41c0a7ca/odt-2016-invalid-product-proplusvolume-specified?forum=Office2016setupdeploy

Robert has provided the older ODT version for download here:  THANK YOU !
https://1drv.ms/u/s!ApkCUv0wQm8UgwFgwRzJXD4N3H-R

Getting this done was not easy.  I would advise keeping the paths as short and simple as possible. Also I did seem to get success by making sure that HKCU\Software\Microsoft\Office\ClickToRun had been deleted or renamed after a run attempt.

Here is my ODT setup.exe configuration file:

<Configuration>

  <Add OfficeClientEdition="32" Channel="Current">
    <Product ID="ProPlusVolume">
      <Language ID="en-us" />
    </Product>
    <Product ID="VisioProXVolume">
      <Language ID="en-us" />
    </Product>
    <Product ID="ProjectProXVolume">
      <Language ID="en-us" />
    </Product>
  </Add>

  <!-- Updates disabled while an update folder location is decided. -->
  <Updates Enabled="FALSE" Channel="Current" /> -->

  <!-- Install Mode Settings -->
  <Display Level="None" AcceptEULA="TRUE" />
  <Logging Level="Standard" Path="%windir%\custom\installlogs" />

  <!-- Packager Mode Settings - Sets the App-V Package GUID -->
  <Property Name="PACKAGEGUID" Value="PutYourGUIDHERE"/>
 
</Configuration>

Run
setup /download <FullPathToXMLConfigFile>

Create the folder where the App-V package will be output to.

Then
setup /packager <FullPathToXMLConfigFile> <App-VPackageOutputFolderPath>

if that fails then you can do the magic command posted here by Trausti Sigurbjörnsson
A failure results in HKCU\Software\Microsoft\Office\ClickToRun\LastScerarioResult = Failure

browse to C:\Users\<user>\Appdata\Local\Temp and Copy "Microsoft Office" folder to "C:\Temp" and then rename it to MSO

After That run following command:
C:\Temp\MSO\root\flattener\flattener.exe /Source:"C:\Temp\MSO" /Dest:"C:\Temp\Office 2016 AppV" /Version:"16.0.8067.2115" /ProductReleaseIDs:"ProPlusVolume,VisioProXVolume,ProjectProXVolume" /Cultures:"en-US,x-none" /Platform:"x86"

For the above command you can determine the version number by checking in the registry for the versions written during the OfficeClickToRun.exe phase.

HKCU\Software\Microsoft\Office\ClickToRun\ProductReleaseIDs\2601BB9E-AEBE-441E-A166-5652BF9B61C3\ProjectProXVolume.16\en-us\Version


Error Code Meanings
error 0-1010 (0)  - check your XML in the XML config file.

The App-V package requires the App-V Client setting EnablePackageScripts = 1.  This is because there are scripts coded into the AppVXManifest.xml file within the .appv package file.  MSI installers are being called to install integration components such as the KMS server licensing items.

Monday, May 8, 2017

Globally Unique Identifiers (GUIDs) How Unique are they?


GUIDs are used as identification tags to identify and track things.  The clue is in the name.  They are unique, however because each one is a id within a defined set, it is theoretically possible to get a duplicate GUID. How possible? - well as "unique" suggests, it is nearly impossible.

What is a GUID?
A GUID is a set of 32 characters each of which has a hexadecimal value (0-f).  The are arranged in the format
21EC2020-3AEA-4069-A2DD-08002B30309D
They are typically randomly generated.

Each of the 32 characters is made up of 4 bits so the number of bits in the GUID is 4x32=128

6 of the bits are reserved to designate that GUID is random.

The remaining 122 bits (128-6=122) can either be 1 or 0.  This means there are 2 to the power 122 (2^122) combinations.

How many possible GUIDs are there?

2^122 which is approximately 5.3×1036
At this point it becomes a waste of time and space to use long hand notation.  These types of numbers are generally referred to in science as large numbers.  What? You'd still like to see the actual number? Oh OK its
5,316,911,983,139,663,491,615,228,241,121,400,000

So at this point you need something to compare that with to get a feel for how big that number is.  Here's a few numbers in order of size to get an idea.

In ascending order then:
The mass of planet earth in Kilograms
6 x 1024

Number of atoms in the average human body.
7 x 1027

The mass of the Earths Sun in Kilograms
2 x 1030

The number of water molecules in an olympic size swimming pool
1.34 x 1032

Number of possible GUIDs
 5.3×1036

Number of atoms that make up the planet earth.
1 x 1050


http://physicsoftheuniverse.com/numbers.html

http://mrdee.blogspot.co.uk/2005/11/how-many-guid-combinations-are-there.html