6 Replies Latest reply on May 7, 2014 3:26 AM by 2619112

Getting FDM User Name in FDMEE VBS

2619112 Apr 25, 2014 6:43 AM

Hi,

I want to get FDM user name in FDM EE 11.1.2.3 VBS event script .. In previous version (FDQM) , we can get that using : strUserID = API.DataWindow.Connection.PstrUserID

But in this version FDM API doesn't have PstrUserID method present .. Also I didn't find any other method/property to get it .. There are few properties to get DB user name and OS user name , but didn't get anything for FDM user name ..

Kindly help ..

Thanks !!

1. Re: Getting FDM User Name in FDMEE VBS

Francisco Amores Apr 25, 2014 8:35 AM (in response to 2619112)

Hi,

all vbs scripts get LOADID as 1st parameter:

************************************************************************************
'REVIEW INPUT PARAMETERS
'************************************************************************************
If WScript.Arguments.Count <> 5 Then
Wscript.Echo "You must supply 5 runtime variables." & vbNewLine & "Usage:
HFM_LOAD.vbs LoadID CSS_Token OracleInstancePath JavaHomePath OLE_DB_PROVIDER"
WSCript.Quit -1
Else
LoadID = Wscript.Arguments.Item(0)
CSSToken = WScript.Arguments.Item(1)
OracleInstancePath = WScript.Arguments.Item(2)
JavaHomePath = WScript.Arguments.Item(3)
Provider = WScript.Arguments.Item(4)
End If
........

You can then run a SQL query to get user id from FDMEE tables. For example: AIF_PROCESSES
SELECT LAST_UPDATED_BY FROM AIF_PROCESSES WHERE PROCESS_ID = Load_ID

Hope that helps
Like Show 0 Likes(0)

Actions
2. Re: Getting FDM User Name in FDMEE VBS

2619112 Apr 30, 2014 2:24 AM (in response to Francisco Amores)

Thanks! ..

I also raised an enhancement request with Oracle for this (ER Bug 18680729) ... In future version we can expect this as an inbuilt VBS function ..
Like Show 0 Likes(0)

Actions
3. Re: Getting FDM User Name in FDMEE VBS

Francisco Amores Apr 30, 2014 8:14 AM (in response to 2619112)

In future I would expect no more VBS API available :-)
Like Show 0 Likes(0)

Actions
4. Re: Getting FDM User Name in FDMEE VBS

2619112 May 6, 2014 9:42 AM (in response to 2619112)

Hi Frnacois,

I tried to use SELECT LAST_UPDATED_BY FROM AIF_PROCESSES WHERE PROCESS_ID = Load_ID to get FDM user name .. But it is giving me data type mismatch error . LoadID tracked in FDM is in Varchar and PRocess_Id is Decimal .. I am unable to do conversion as well .... Do you know if this query has some work-around or I am making some silly mistake ?
Like Show 0 Likes(0)

Actions
5. Re: Getting FDM User Name in FDMEE VBS

Francisco Amores May 6, 2014 9:54 AM (in response to 2619112)

You need to cast it.
If you are using VB you can try CDbl
Can you paste your script?

Have you tried:
strSQL = "SELECT LAST_UPDATED_BY FROM AIF_PROCESSES WHERE PROCESS_ID = " & CDbl(Load_ID) ?
1 person found this helpful
Like Show 0 Likes(0)

Actions
6. Re: Getting FDM User Name in FDMEE VBS

2619112 May 7, 2014 3:26 AM (in response to Francisco Amores)

Thanks Francois .. Using Cdbl worked well .. I was using Cint before ..
Like Show 0 Likes(0)

Actions

Go to original post

Join the world’s largest interactive community dedicated to Oracle technologies.