[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.

[Can we make REST api call in Scriptlets ?]

There is some information about the user in XYZ server.

Which we can access through rest api, can we do rest api call and get info in scriptlet ?

[Can we change user's Organization ?]

User 'xyz' belongs to organization_1 and user 'abc' belongs to organization_2. 

After few days user abc has been transffered to organization_1 and xyz to organization_2. 

Is there any way we can change organizations of these users. 

[hide a subreport]

Hi medayed1990,

Post jrxml file 

 

[Java.math.BigDecimal cannot be cast to java.lang.String error when running Jasper iReport]

Hi reggiereg,

I had to face these kind of errors a while ago, i had fixed it with adding blank string to the String variable passing. Somthing like below.

BigDecimal testNum = new BigDecimal("29.87");

String str = testNum + "";

 

Hope this will help, if not provide full jrxml for debugging.

[Java.math.BigDecimal cannot be cast to java.lang.String error when running Jasper iReport]

Hi reggiereg,

I had to face these kind of errors a while ago, i had fixed it with adding blank string to the String variable passing. Somthing like below.

BigDecimal testNum = new BigDecimal("29.87");

String str = testNum + "";

 

Hope this will help, if not provide full jrxml for debugging.