Submitting forms on the support site are temporary unavailable for schedule maintenance. If you need immediate assistance please contact technical support. We apologize for the inconvenience.
Snapshot gets published but empties itself after a refresh
설명
When running a query in Toad Data Point and publishing it as a snapshot to Toad Intelligence Central, the snapshot gets published correctly the first time but the data gets emptied after refreshing it.
There are no error messages, the issue occurs when refreshing the published snapshot from TDP or with the Admin Console. The refresh shows a successful but the data is not present.
원인
This is caused in some cases when the query contains a date with an unspecified format i.g:
WHERE (emp.”table” < ‘01/01/1970’)
해결 방안
RESOLUTION
Specify the date format in the query. In the example above, the correct query would be:
WHERE (emp.”table” < to_date('01/01/1970'dd/mm/yyyy'))
