Symantec IGA

For a very brief summary of the problem / solution, please watch this 3 min video[color]. [size]

If you'd just like to solve your problem without understanding it, simply download this zip file, copy the contents to your report server desktop and run Simplify.vbs out cmd prompt launched as administrator.[color]. [size]

The fact that the IdM tools directory publishes the 32 bit version of the registry manipulation ONLY, which is required for the report server regardless of the platform chosen, generates a plethora of support issues that could easily be avoided.

A VB scripted solution has been published onto MyCA communities forum in order to try to mitigate incoming volume on this topic until a more permanent solution is deployed. (possibly simply deploying the attached script into the ReportServerTools directory of IM, which would replace the existing registry scripts that don’t work on 64bit platform)

If you're getting an invalid database connection error when trying to view reports, I suggest you run the attached WSH script (as local Administrator on the Report Server) to correct your problem.

'Christopher Ryan Thomas; Unify and Simplify registry deployment for IdM report server. Set WshShell = CreateObject("WScript.Shell") OsType = WshShell.RegRead("HKLM\SYSTEM\CurrentControlSet\Control\Session Manager\Environment\PROCESSOR_ARCHITECTURE") If OsType = "x86" then wscript.echo "Windows 32bit system detected... Applying 32bit reg key value pair" WSHShell.RegWrite "HKLM\SOFTWARE\Business Objects\Suite 12.0\Crystal Reports\DatabaseOptions\MergeConnectionProperties", "Yes" elseif OsType = "AMD64" then wscript.echo "Windows 64bit system detected... Applying 64bit reg key value pair" WSHShell.RegWrite "HKLM\SOFTWARE\Wow6432Node\Business Objects\Suite 12.0\Crystal Reports\DatabaseOptions\MergeConnectionProperties", "Yes" end if 

Documentation is also incorrect!

@HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Business Objects\Suite 12.0\Crystal Reports

The above line should also include DatabaseOptions after Crystal Reports. Putting the MergeConnectionsProperties in the wrong location will result in the failure to view reports because it's unable to communicate with the database.

[color=#f30808][font=Comic Sans]If you're getting an invalid database connection error when trying to view reports, I suggest you run the attached WSH script (as local Administrator on the Report Server) to correct your problem.[size=11][color][size][font]

Please post with any questions or concerns.
Thank you.
Regards,

Chris Thomas
CA Technologies
Principal Support Engineer
IdentityMinder Reporting Expert
Tel: +1-631-342-4360
Chris.Thomas@ca.com

'Christopher Ryan Thomas
'https://communities.ca.com/web/chris_thomas/myca
'Unify and Simplify registry deployment for IdM report server. 

dim WshShell, installDir
Set WshShell = CreateObject("WScript.Shell")
OsType = WshShell.RegRead("HKLM\SYSTEM\CurrentControlSet\Control\Session Manager\Environment\PROCESSOR_ARCHITECTURE")
If OsType = "x86" then 

wscript.echo "Windows 32bit system detected... Applying 32bit reg key value pair"

WSHShell.RegWrite "HKLM\SOFTWARE\Business Objects\Suite 12.0\Crystal Reports\DatabaseOptions\MergeConnectionProperties", "Yes"

installDir = WshShell.RegRead("HKLM\SOFTWARE\Business Objects\Suite 12.0\Shared\SuiteInstallDir")
elseif OsType = "AMD64" then

wscript.echo "Windows 64bit system detected... Applying 64bit reg key value pair"

WSHShell.RegWrite "HKLM\SOFTWARE\Wow6432Node\Business Objects\Suite 12.0\Crystal Reports\DatabaseOptions\MergeConnectionProperties", "Yes"

installDir = WshShell.RegRead("HKLM\SOFTWARE\Wow6432Node\Business Objects\Suite 12.0\Shared\SuiteInstallDir")
end if 

dim fso, libs
Set fso = CreateObject("Scripting.FileSystemObject")
libs = installDir & "common\4.0\java\lib\"
fso.CopyFile ".\*.jar", libs,TRUE

Const ForReading=1
Const ForWriting=2
dim folder, filePath, myFile, myTemp, myLen, myString, newSize
folder = installDir & "\common\4.0\java\"
filePath = folder & "CRConfig.xml"
Set myFile = fso.OpenTextFile(filePath, ForReading, True)
Set myTemp= fso.OpenTextFile(filePath & ".tmp", ForWriting, True)
Do While Not myFile.AtEndofStream
 myLine = myFile.ReadLine
 If InStr(myLine, "<Classpath>") Then

 myLen = Len(myLine)

 newSize = myLen - 15

 myString = Right(myLine, newSize)

 myLine = "<Classpath>" & libs & "sqljdbc.jar;" & libs & "ojdbc14.jar;" & myString
 End If

 myTemp.WriteLine myLine
Loop
myFile.Close
myTemp.Close
fso.DeleteFile(filePath)
fso.MoveFile filePath&".tmp", filePath

strComputerName = wshShell.ExpandEnvironmentStrings( "%COMPUTERNAME%" )
Dim strService
' Values set
strService = " BOE120SIA" & strComputerName

'Option Explicit
Dim intShortSleep, intLongSleep

' Values set
strService = " BOE120SIA" & strComputerName
intShortSleep = 2000
intLongSleep = 9900

' Cmd prompt opened 
WshShell.Run "cmd" 
Wscript.Sleep intShortSleep

' Service stopped with 'Net' command
WshShell.SendKeys "net stop" & strService 
Wscript.Sleep intShortSleep
WshShell.SendKeys "{Enter}"
Wscript.Sleep intLongSleep

' Service started with 'Net' command
WshShell.SendKeys "net start" & strService 
Wscript.Sleep intShortSleep
WshShell.SendKeys "{Enter}"
Wscript.Sleep intLongSleep

' Cmd prompt exited
WshShell.SendKeys "Exit"
Wscript.Sleep intShortSleep
WshShell.SendKeys "{Enter}"

Wscript.Echo strService & " service restarted "
WScript.Quit

If you receive registry key not found, please make sure you're running the simplify.vbs from a cmd shell, which was "Run As Administrator"

This is really a helpful tip, I had similar issue on the Linux server fixed it for me. Below are the steps for Linux servers:

Integrated Documents