I’ve updated the data source connection in our predictive analytics dashboard from a static dataset to a live database connection. The dashboard widgets display data initially, but the auto-refresh functionality stopped working after the change.
The data binding configuration points to the new ODBC connection, and I’ve verified the connection string is correct. The widget auto-refresh property is still set to 5-minute intervals in the dashboard XML:
<Widget id="forecast_chart" refreshInterval="300">
<DataSource type="live" connection="PredictiveDB"/>
</Widget>
The dashboard loads fine on first access, but subsequent refreshes show stale data. Manual refresh works, but automatic refresh doesn’t trigger. Is there a specific setting for live data source support that I’m missing in Crystal Reports 2016?
Found it in the logs - there were silent authentication failures every 5 minutes. The issue was with session persistence for the live connection.
The XML configuration looks correct, but there’s a known limitation with predictive analytics widgets in 2016. They sometimes cache the data model even when refresh is configured. Try adding the forceReload attribute and ensure your connection type is explicitly set to streaming mode. Also check if there are any client-side caching headers being sent that override server refresh settings.
This is a classic data binding configuration issue with live sources in predictive analytics dashboards. Let me address all three critical areas:
Data Binding Configuration:
The problem is that predictive analytics widgets in Crystal Reports 2016 require a persistent authentication context for live connections. Your XML configuration is correct, but you need to add session binding to maintain credentials across refresh cycles. Update your connection definition:
<DataSource type="live" connection="PredictiveDB"
authMode="session" persistCredentials="true"/>
Widget Auto-Refresh Property:
The refresh interval needs to be coordinated with the server-side refresh scheduler. In CMC, navigate to Dashboard Services > Refresh Settings and ensure “Enable Scheduled Refresh for Live Connections” is checked. Set the minimum refresh interval to match or be lower than your widget setting (300 seconds).
Live Data Source Support:
Crystal Reports 2016 requires the Real-Time Data Adapter to be installed and configured for predictive widgets. Install it via the BI Platform installer, then in CMC enable it under Servers > Dashboard Service > Properties. Add this to your dashboard properties:
<Dashboard enableRealTimeAdapter="true"
dataStreamingMode="push"/>
After making these changes, restart the Dashboard Service. The auto-refresh should work consistently. For production environments, also configure connection pooling with keepAlive enabled to prevent authentication timeouts during refresh cycles.
The key insight is that predictive analytics widgets treat live connections differently than standard report widgets - they require explicit session management and streaming mode configuration to maintain the refresh cycle.
Good point on permissions. I verified the database user has full SELECT access and tested queries directly - they execute in under 2 seconds. The connection pool settings look normal (max 50 connections, currently using 8). The timeout is set to 30 seconds. Still no automatic refresh happening though.
Have you checked the dashboard logs? In my experience, silent failures in auto-refresh are usually logged but not surfaced to the UI. Look in the BI Platform logs under Dashboard Service logs. You might find connection errors or timeout issues that explain why the refresh trigger isn’t firing. Also, what’s your browser? Some older browsers had issues with the refresh mechanism in 2016.
Check if your live connection has query timeout settings that might be interfering. Also, Crystal Reports 2016 sometimes requires explicit refresh triggers in the connection properties. Have you verified the database user has SELECT permissions and the connection pool isn’t exhausted?
I’ve seen this issue before with predictive analytics dashboards. The problem is often that Crystal Reports 2016 doesn’t fully support auto-refresh for certain live connection types in predictive widgets. You might need to enable the real-time data adapter in the server configuration. Check your CMC settings under Dashboard Services - there’s a specific flag for enabling live refresh on predictive components.