FDM application 11.1.2+

                             How to create FDM application in 11.1.2.1+

1.       FDM works on 32-bit mode only even if you have installed on 64-bit machine.

2.       Create schema on oracle database with below::

Privileges::

CREATE SESSION,CREATE VIEW,CREATE TYPE,CREATE TABLE,CREATE CLUSTER,CREATE TRIGGER,CREATE SEQUENCE,CREATE INDEXTYPE,CREATE PROCEDURE,CREATE ANY SYNONYM,DROP ANY SYNONYM,UNLIMITED TABLESPACE

Roles: Connect, Resource and DBA.

3. We can check connect of FDM schema connectivity using udl32 file.

• Create a text file and save as with udl32 extension.
• Launch a command prompt.
• Execute the following command like below::

C:\WINDOWS\SysWOW64\Rundll32.exe "c:\Program Files (x86)\Common Files\System\Ole DB\oledb32.dll",OpenDSLFile c:\testconn.udl32

4. Udl32 file will open now. You can check connectivity.

5. Create FDM application with same schema details.

6. Check the upsLBMgr.exe process in Task Manager which shows the application creation progress

7. If you get “Object variable or with block variable not set”

• Check FDM service account has permissions.
• If you are giving UNC path (if it is load balance), check folder permissions and try / and \
• If you are UNC Path, try with drive name while creating application later you can change to UNC path.
• If FDM version 11.1.2.1, we need to apply patch. Patch number—12795642
• If FDM 11.1.1.4 version, we need to apply patch. Patch number--13336220 (PSU 102)

Thanks,

Mady