on 2011 Sep 19 1:34 PM
Hi,
I've upgraded to v12 and am encountering a strange problem.
I run a watcom sp which loads about 30 text files into local temp tables and processes the data before adding it to the database. All temp tables are declared "not transactional".
I'm now getting random "Table '%1' not found" errors at random places in the code. The procedure hasn't been changed. It does call an external DLL but it's not failing at this point, only on a select into the temp.
I'm at a loss!
TC
Request clarification before answering.
There were some recent changes to made to the logic that encompasses stored procedure execution in order to correct a defect related to the inlining of SELECT statements within procedures and SQL user-defined functions. It is possible that your issue may be related, but we'll need more information (preferably a repro, which it sounds like you have) in order to diagnose the problem.
Do you have a support plan?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Sorry for the late reply but have been doing a lot of testing.
I've been running the routine every 30 mins using an event and finding that it fails 2 times out of 6 on accessing different local temp tables.
I've also found that if I substitute an external CLR DLL which loads a file the fault clears.
Neither the DLL, or the call to the DLL is failing; it seems to fail randomly thoughout the SP but only when accessing a temp tabel.
We don't have a support plan.
User | Count |
---|---|
61 | |
8 | |
7 | |
6 | |
6 | |
4 | |
4 | |
4 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.