Error: “Could not insert records into temporary table”
This error generally means that there is data inside the report that is causing the report to fail, usually relates to dates.
Ways to find the issue:
- Open the Report Queue
- find the report that failed with this error
- right click on the report in the report queue
- select properties
- the customer ID is listed there under contact ID.
- Open the customer account
- Select reports on the jump to menu
- Select the report in the list
- Check the dates for the time frame that the report is running for. (to/from dates on the first screen)
For example:
- We have seen this being dates years in the past, which is causing the report to not run correctly.
- Also have seen this be a "weekly" report, but the time frame it is ran for is for a month.
