Test connection error.

I'm getting this error when I try to connect to the database. Actuate Birt Designer Pro. Version 4.2.3 build id v20131216. DB team says it is a front end issue and that actuate will have to come to solve it. Any ideas what has to be done? It's been this since last Friday and not getting any answers.
we have the older version 11.0.4 build id 20121023 which connects to same db without issues.

Find more posts tagged with

Comments

Matthew L.

What operating system (OS) are you using?
If its Vista/7/8+/10 then did you install the designer into the "C:\Actuate\BRDPro3\" folder structure?
If you installed it into the "Program Files" folder (or another Windows protected folder) this issue can happen unless you launch the designer by Right Clicking the Launch Icon and selecting "Run as administrator".

shamo

Windows 7 enterprise. Running as admin didn't help.
It's installed on diff folder not on the c:\Actuate\Brdpro\path

Matthew L.

Typically I've seen this issue due to access permissions on the file system (protected windows folders such as the Program Files folder, or network shared/mapped folders) or a corrupt install (or install over top of an older version).
I've also seen virus scanners cause issues with the designer at times, however not this specific issue before, but it could be worth seeing if your virus scanner is blocking access to that driver file.
 
As a possible fix, I would suggest uninstalling the product, removing any leftover folder/files from the install folder, installing the product again by using the "Run as administrator" option (to ensure all files are written to the file system without issue) to the "C:\Actuate\BRDPro3\" folder to see if this corrects the issue.

shamo

Thank you. I've spokes to the administrators and they will be coming to do as you have suggested. unfortunately, These have to be done by another department.

shamo

I followed your suggestion reinstalled and followed the path as you suggested. This is the error that I'm getting now

Matthew L.

This message could appear due to not specifying the Oracle Advanced Security (OAS) parameter values in the connection URL.
According to Data Direct's (the DD in [ActuateDD]) documentation (<a data-ipb='nomediaparse' href='http://media.datadirect.com/download/docs/jdbc/alljdbc/help.html#page/userguide/rfi1359986124087.html#'>http://media.datadirect.com/download/docs/jdbc/alljdbc/help.html#page/userguide/rfi1359986124087.html#</a>) the "DataIntegrityLevel" and "EncryptionLevel" have 3 levels "accepted", "requested", or "required".
However I believe they also need the "EncryptionTypes" and "DataIntegrityTypes" properties in order to function correctly.
You should ask your Database Administrator (DBA) which values you should use for these parameter values per your database configurations.
 
An example of the connection URL should look similar to this:
jdbc:actuate:oracle://SERVERADDRESS:1531;ServiceName=THEDBSERVICENAME;EncryptionLevel=required;EncryptionTypes=3DES168;DataIntegrityLevel=required;DataIntegrityTypes=MD5