Skip to Content
0
Oct 21, 2015 at 02:28 PM

weird intermittent 207 error

45 Views

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?