Data source connection issue, user not able to connect to data source.

Scenario: We create a datasource with SQL Server 2012 and user in Jasper. For first few days this combinations works nice, after few days this connection goes into loop.
I have few suspects 
1. Jasper Server version upgrade
2.Active Directory synching(Issue occurs when active directory synchs).
3.LInux Kernal upgrade
 Please help me to trace this issue.

Dev: Windows 7 , Jasper Server 6.3, Data Source SQL Server 2012.

Test: RHEL 6 , Jasper Server 6.3, Data Source SQL Server 2012.
Production: RHEL 6, Jasper Server 6.1, Data Source SQL Server 2012.


In Dev we are able to connect to datasource consistently
In Test we are able to connect to datasource cosistently.
In Production it will connect to Data Source for first few days, later when we try to connect with the same user it will go into loop and it neither gives nor connects.
Please help me ASAP.

jog_1's picture
Joined: Mar 23 2015 - 4:16am
Last seen: 6 years 1 month ago

2 Answers:

Probably may be connections exhausted for server bd.

Check out the logs for exceptions.


mlopez_1's picture
Joined: Oct 21 2013 - 8:08am
Last seen: 5 hours 28 min ago

If it's alright in Dev and Test, the chance of it being the JasperReports Server version seems high. I mean, why are using using 6.3 in dev and test when the production is using 6.1?

hozawa's picture
Joined: Apr 24 2010 - 4:31pm
Last seen: 4 years 3 months ago