2 Cireson SQL Jobs fail
In our SQL Server Job Activity Monitor I saw, that 2 of our Cireson jobs fail every day:
- Cireson Insert New Incidents: There is already an object named 'tempTable_Incident' in the database. [SQLSTATE 42S01] (Error 2714). The step failed.
- Cireson Update Existing Changes: There is already an object named 'tempTable_Change' in the database. [SQLSTATE 42S01] (Error 2714). The step failed.
I thought the "IF NOT EXISTS(SELECT [name] FROM tempdb.sys.tables WHERE [name] like 'tempTable_Change%')
BEGIN" checks if the temp table already exists? How could I solve that?
Best Answer
-
Geoff_Ross Cireson Consultant O.G.
Hi Simon,
That's a new job since v 11.2. Can you please log an Incident with our support team on this? Do you know how?
Geoff
0
Answers
Hi Simon, can you confirm the Portal version you are running?
Hello Geoff,
our Portal version is 11.2.2.2016.
In our productive system (Version 9) this does not happen, but I also checked the job and the step with the custom field is not even there in this version ;)
Hi Simon,
That's a new job since v 11.2. Can you please log an Incident with our support team on this? Do you know how?
Geoff
Hello Geoff, yes I know how do that , thank you :)