Difference between revisions of "Report Execution Error Pastel Xpress Version 18"

From Sage Intelligence Knowledgebase
Jump to: navigation, search
(Created page with "'''Issue: ''' You will experience a Report Execution error when running reports from report manager. The reason that these reports run into errors is that the “auto conne...")
 
Line 4: Line 4:
  
 
You will experience a Report Execution error when running reports from report manager. The reason that these reports run into errors is that the “auto connect” feature is checked for our demo DataBase.
 
You will experience a Report Execution error when running reports from report manager. The reason that these reports run into errors is that the “auto connect” feature is checked for our demo DataBase.
 +
[[File:Report error execution.png|framed|left]]
  
  
<gallery>
 
File:Report_error_execution.png
 
</gallery>
 
  
  
'''Resolution:'''
 
  
  
Launching the Connector and unchecking “Use auto connection system” on “ODBC Driver for Access”, then pointing it to RKL Trading DB will resolve the issue.
+
 
 +
 
 +
 
 +
 
 +
 
 +
 
 +
 
 +
 
 +
 
 +
 
 +
 
 +
 
 +
 
 +
 
 +
 
 +
 
 +
 
 +
 
 +
 
 +
 
 +
 
 +
 
 +
 
 +
 
 +
 
 +
 
 +
 
 +
 
 +
 
 +
 
 +
 
 +
 
 +
'''Resolution:
 +
 
 +
 
 +
Launch the Connector. Then you need to expand the enterprise tree on the left column. Look for a subtree called ODBC Driver for Access. Double click on it to expand the tree. You will then see the connection name called RKL Trading Demo. Click on RKL Trading Demo to open the properties for the connection. On the right hand side of the screen you will see a check box for Use Auto Connection System. By default this is activated with a tick switched on. You would need to remove the tick by clicking once on the tick. Tehn you can click the the apply button on the extreme right to save the change. Then you can close the connector. Launch report manager and run out your reports as normal. The error should not appear any longer.
  
  
Line 20: Line 52:
  
  
<gallery>
+
[[File:Before.png|framed|left]]
File:Before.png
+
 
</gallery>
+
 
 +
 
 +
 
 +
 
 +
 
 +
 
 +
 
 +
 
 +
 
 +
 
 +
 
 +
 
 +
 
 +
 
 +
 
 +
 
 +
 
 +
 
 +
 
 +
 
 +
 
 +
 
 +
 
 +
 
 +
 
 +
 
 +
 
 +
 
 +
 
 +
 
 +
 
 +
 
 +
 
 +
 
 +
 
  
  
Line 28: Line 94:
  
  
<gallery>
+
[[File:After.png|framed|left]]
File:After.png
+
</gallery>
+

Revision as of 05:00, 19 October 2017

Issue:


You will experience a Report Execution error when running reports from report manager. The reason that these reports run into errors is that the “auto connect” feature is checked for our demo DataBase.

Report error execution.png




















Resolution:


Launch the Connector. Then you need to expand the enterprise tree on the left column. Look for a subtree called ODBC Driver for Access. Double click on it to expand the tree. You will then see the connection name called RKL Trading Demo. Click on RKL Trading Demo to open the properties for the connection. On the right hand side of the screen you will see a check box for Use Auto Connection System. By default this is activated with a tick switched on. You would need to remove the tick by clicking once on the tick. Tehn you can click the the apply button on the extreme right to save the change. Then you can close the connector. Launch report manager and run out your reports as normal. The error should not appear any longer.


Connector setting before change:


Before.png




















Connector setting after change:


After.png