HFM - USERPARAMS table - BLOBDATA column

3590471

Hello,

Does anyone know how to decipher the "BlobData" column in the USERPARAMS table from an HFM database?

It looks like hexadecimal numbers or character codes but I have no idea what they mean. I would think that field carries information such as dates but probably more.

Any help appreciated :-)

Thank you very much in advance.

Alexis

SureshM-Oracle

Hi Alexis,

See if this KM helps to understand how "BLOBDATA" appeared in UserParams table:

In Consolidation User Preferences the Default Langauge For Descriptions display 0. (Doc ID 953168.1)

Regards,

Suresh.

Jeo123

You're correct, they're hex character codes.

There are free online tools you can use to convert them easily.

https://www.rapidtables.com/convert/number/hex-to-ascii.html

So:

3C003F0078006D006C002000760065007200730069006F006E003D00220031002E0030002200200065006E0063006F00640069006E0067003D0022005500540046002D00310036004C004500220020007300740061006E00640061006C006F006E0065003D0022006E006F0022003F003E003C004100500050005F00530045005400540049004E00470053003E003C005500490043006F006D0070006F006E0065006E00740020006E0061006D0065003D00220072006F00770046006500740063006800530069007A00650022003E00350030003C002F005500490043006F006D0070006F006E0065006E0074003E003C005500490043006F006D0070006F006E0065006E00740020006E0061006D0065003D002200530069006E0067006C00650043006C00690063006B0054006F00450064006900740022003E0074007200750065003C002F005500490043006F006D0070006F006E0065006E0074003E003C005500490043006F006D0070006F006E0065006E00740020006E0061006D0065003D00220063006F006C0046006500740063006800530069007A00650022003E00350030003C002F005500490043006F006D0070006F006E0065006E0074003E003C002F004100500050005F00530045005400540049004E00470053003E00

Converts down to this:

<?xml version="1.0" encoding="UTF-16LE" standalone="no"?><APP_SETTINGS><UIComponent name="rowFetchSize">50</UIComponent><UIComponent name="SingleClickToEdit">true</UIComponent><UIComponent name="colFetchSize">50</UIComponent></APP_SETTINGS>

3590471

Jeo123, thank you for your response!

Actually found some built-in function in SQL to convert to ACSII.

Syntax below:

select utl_raw.cast_to_varchar2(dbms_lob.substr(BLOBDATA))

from HYP_HFM.UBRHFM_USERPARAMS

Best,

Alexis