 |
 |
Archives of the TeradataForum
Message Posted: Wed, 01 Mar 2006 @ 13:56:01 GMT
| Subj: | | Re: Getting 3916 errocode |
| |
| From: | | Victor Sokovin |
| | What I found in this query very strange is the fact that "Group by" is being done on only first 3 columns. Quite surprisingly its
workingexcept giving 3916 errorcode sometimes. | |
| | Ideally group by clause should be done on 1,2,3,4,and 6. Is this the culprit? | |
I don't think so. The GROUP BY looks fine.
Do you (re)create some source tables (or perhaps the target table itself) just before executing the INSERT INTO? If you do, there might be some
latency in the dictionary: the new object is created but the dictionary is not yet quite "ready" to provide information on it.
What you could try is add the following command just before your INSERT INTO:
.HANG 1
It will instruct bteq to pause for 1 sec (perhaps a couple of seconds is safer?) before proceeding with the INSERT INTO. This does not
cure the problem but will perhaps reduce the number of errors and give you the time to think about the source of the problem. I'm afraid that's
the only suggestion I can come up with right now.
Regards,
Victor
| |
