Friday, February 17, 2012

Common Issues in ADI

1.    TNS could not Resolve Service Name or any TNS entry related error during ADI logon.
Check the TNSNAMES.ora file in the network/ADMIN and NET80/ADMIN folders of the ADI Oracle Home. The TNS file should have one entry for DB instance and once for the file server. Below are the sample TNS entries for DB and File Server. Just make sure that DB and File server entries should have different port numbers.

DB
XYZ =  (DESCRIPTION =    (ADDRESS_LIST =  (ADDRESS = (PROTOCOL = TCP)(HOST = orxyz01.abc.com)(PORT = 1555)))    (CONNECT_DATA = (SERVICE_NAME = XYZ11) )  )

File Server
FNDFS_XYZ =  (DESCRIPTION =    (ADDRESS_LIST =  (ADDRESS = (PROTOCOL = TCP)(HOST = orxyz01.abc.com)(PORT = 1666)))    (CONNECT_DATA = (SERVICE_NAME = XYZ11) )  )
Also user should have full access on the TNSNAMES.ora files in the network/ADMIN and NET80/ADMIN folders of the ADI Oracle Home.

2.    Unable to Publish Output of the report.
You are able to run the report in ADI but when you try to publish the output you get the error "File Server Failed to Initialize". This error is because the ADI application is not able to connect to the file server. Check if the file server port is open and you are able to connect to the port. File server port is the port number in the File Server entry in the TNSNAMES.ora.

3.    Unable to upload through ADI
If you are not able to upload Journals or Budgets through ADI and getting error "File Server Failed to Initialize"  the issue is because the ADI application is not able to connect to the file server. Check if the file server port is open and you are able to connect to the port. File server port is the port number in the File Server entry in the TNSNAMES.ora.

4.    Macros related error in ADI upload
You get error "The macros in this project are disabled" during upload through ADI. The reason for this issue is because the Tools > Macro > Security is set to high. As ADI macros are unsigned they cannot be added to the Trusted Sources. Solution is to set the Tools > Macro > Security to Medium and accept Enable Macros when the template (Existing Worksheet) is opened if the template is from a known source.