weird intermittent 207 error
I've got a weird 207 error (invalid column name) from a complicated procedure
The procedure is creating a temporary table from a template table, like this: select * into #temptable from template_table
Then doing an insert in the temp table and calling other procs to do further processing
This procedure is running every minute and most of the time everything is ok.
But sometimes the proc throws the 207 error. After a while it's running fine again...
We've already recompiled the proc and checked the tables and all columns involved.
I don't have a repro, it just happens intermittently in production.
It's on 15.0.3, so don't have much hopes for an investigation of a shared memory dump for this error
I've got a case open with support, but without a repro it will be quite difficult to get anywhere.
What I noticed is that the temporary table is very wide, has 70+ columns
Server version is 15.0.3 ESD #4.1, configured with opt goal allrows_mix, options ase_current and traceflag 299
(Yes, we will upgrade at some point to 15.7, but that's not possible right now)
Anybody any suggestions?