Home > Troubleshooting > Connector Troubleshooting

Connector 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