Ошибка pyodbc.Error: ('HY000', 'The driver did not supply an error!')
Из 7-8 попыток запроса, 1-2 раза выдает ошибку pyodbc.Error: ('HY000', 'The driver did not supply an error!')
Код в котором выполняются запросы:
def GetIdleData(self, request, tpaIndex):
idleData = []
cursor = connections['DB_Name'].execute(f''' SELECT [Idle].[Oid],[RepairObject],[Наименование],[IdleType],[CreateDate],[StartDate],
[EndDate],[Cause],[Note],[Creator],[PressForm],[Ordinance]
FROM [DB_Name].[dbo].[Table_Name] AS [Idle],[DB_Name].[dbo].[Table_Name] AS [OBR]
WHERE [Idle].[Oid] = '{tpaIndex}' AND [Idle].[RepairObject] = [OBR].[Oid] ''')
columns = [column[0] for column in cursor.description]
for row in cursor.fetchall():
idleData.append(dict(zip(columns, row)))
defectList = self.GetDefectList()
malfunctionDescription = self.GetMalfunctionDescription()
takenMeasures = self.GetTakenMeasures()
return idleData, defectList, malfunctionDescription, takenMeasures
def GetDefectList(self):
defectList = []
cursor = connections['DB_Name'].execute(f''' SELECT [Oid],[Код]
FROM [DB_Name].[dbo].[Table_Name] ''')
columns = [column[0] for column in cursor.description]
for row in cursor.fetchall():
defectList.append(dict(zip(columns, row)))
return defectList
def GetMalfunctionDescription(self):
malfunctionDescription = []
cursor = connections['DB_Name'].execute(f''' SELECT [Oid],[Код]
FROM [DB_Name].[dbo].[Table_Name]''')
columns = [column[0] for column in cursor.description]
for row in cursor.fetchall():
malfunctionDescription.append(dict(zip(columns, row)))
return malfunctionDescription
def GetTakenMeasures(self):
takenMeasures = []
cursor = connections['DB_Name'].execute(f''' SELECT [Oid],[Код],[Наименование],[СтатусОбъекта]
FROM [DB_Name].[dbo].[Table_Name]
WHERE [GCRecord] IS NULL
AND [СтатусОбъекта] = '1'
ORDER BY [Наименование] ''')
columns = [column[0] for column in cursor.description]
for row in cursor.fetchall():
takenMeasures.append(dict(zip(columns, row)))
return takenMeasures