Home > Troubleshooting

Troubleshooting

Data Connection Troubleshooting

The following are common reasons that a Data Connection is not functioning.

• The server storing the data is down - check connectivity can be established to the server.
• Network problems are occurring - check that the network is functioning normally.
• Network security is preventing the data from being accessed - check with your System Administrator that you have the necessary privileges on the network.
• Connection Timeouts are occurring - click here for more details on dealing with connection Timeouts.

Data Container Troubleshooting

The following are common reasons that a Data Container is not functioning.

• The Data Containers parent Data Connection is not functioning. See Data Connection Troubleshooting.

• The Data Container is based on a SQL Join and the syntax for the join is incorrect. Valid join syntax is usually of the form : [TABLE_A], [TABLE_B] WHERE [TABLE_A].[KEYFIELD_1] = [TABLE_B].[KEYFIELD_1] AND [TABLE_A].[KEYFIELD_2] = [TABLE_B].[KEYFIELD_2]

  Note: this may vary depending on the SQL standards of the underlying data System). For more information on using joins see Joining Tables.

• The Data Container is based on a SQL Join but the Container Type property is set to TABLE or VIEW. You will need to set the Data Container Type to JOIN.

Report Troubleshooting

The following are common reasons that a Report is not functioning.

• The underlying Data Source is unavailable or inaccessible. Check with your System Administrator.
• The Report is using a Template which is conflicting with the way in which Sage Accpac Intelligence works.  Sage Accpac Intelligence always expects the first sheet in a workbook to be the sheet that is available for the report data to be placed in. If the Report has the option "Parameters on Second Sheet" set, then Sage Accpac Intelligence expects that the second sheet of the workbook is available for these too.
• Report returns no data. This may not be a problem but may just reflect that the combination of filters and parameters that are being used result in no data being returned.