I am getting below error while creating domain by using JSON data source.

[shruti.kale]

I am creating JSON datasource as I pass API url to create datasource.

Datasource is created successfully but while creating domain by using that datasource getting error as "datasource connection is failed".

Below error showing in jasperserver.log file

 

2019-10-29 03:44:52,285 ERROR SecureExceptionHandlerImpl,http-nio-8080-exec-10:116 - There was an error on the server. Try again or contact site administrators. (Error UID: d7befe72-db8e-489f-a1c4-cd131a60a501)
2019-10-29 05:08:21,770 ERROR SecureExceptionHandlerImpl,http-nio-8080-exec-2:116 - There was an error on the server. Try again or contact site administrators. (Error UID: 1595610c-ae38-45ac-a3a9-850844c9aa3e)
2019-10-29 05:09:31,585 ERROR SecureExceptionHandlerImpl,http-nio-8080-exec-7:116 - There was an error on the server. Try again or contact site administrators. (Error UID: e12b4888-54d5-4f30-ad02-4cc742678f44)
2019-10-29 05:20:14,636 ERROR SecureExceptionHandlerImpl,http-nio-8080-exec-5:116 - There was an error on the server. Try again or contact site administrators. (Error UID: 2c83ce31-e5c3-422e-964c-f74c247a2f6b)

Please suggest . Is any configuration is required to create domain by using JSON datasource.

 

[vanitha.r]

I have the same error while trying to add a datasource 

[felded53]

I have absolutely identical error as described above.

[bazlen]

We have the same error but a different context (JDBC Oracle data source).

[brinito]

I am getting the exac same error on adding a SQL Server data source con Jasper Server 7.2 and 7.5
I installed the driver as indicated in the documentation

[danoldenkampgmail.com]

Same error when adding new SQL Server data source to local host SQL Server 2019 using JDBC driver added via data source download /add.

ERROR SecureExceptionHandlerImpl,http-nio-8080-exec-2:116 - There was an error on the server. Try again or contact site administrators. 

Error implies something with the SecureExceptionHandler ?   

[castrogeneris]

Hi have you encounter any solution on this, I having same problem.

[suleklarisa]

I'm having the same problem, did you find a solution??

thank you

[majdoleen]

Have you solved this issue? I am facing the same error when it comes to json URL datasource

[emes2601]

I resolved the issue 🙂
 

On the server with Jasper Server installed, I created a Wallet directory, and there the file tnsnames.ora 

In tnsnames.ora I put this:

MYDB = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = IPADDR)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = XEPDB1))) 

Then, when adding a new data source, in the URL field (required), I included this:

jdbc:oracle:thin:@mydb?TNS_ADMIN=/your/path/to/Wallet/

And it works !