Bug 49865

Summary:	Regression: remove_s4_rejected.py aborts with traceback
Product:	UCS	Reporter:	Arvid Requate <requate>
Component:	S4 Connector	Assignee:	Julia Bremer <bremer>
Status:	CLOSED FIXED	QA Contact:	Florian Best <best>
Severity:	normal
Priority:	P5	CC:	best, bremer
Version:	UCS 4.4
Target Milestone:	UCS 4.4-1-errata
Hardware:	Other
OS:	Linux
What kind of report is it?:	Development Internal	What type of bug is this?:	---
Who will be affected by this bug?:	---	How will those affected feel about the bug?:	---
User Pain:		Enterprise Customer affected?:
School Customer affected?:		ISV affected?:
Waiting Support:		Flags outvoted (downgraded) after PO Review:
Ticket number:		Bug group (optional):
Max CVSS v3 score:
Bug Depends on:	49445
Bug Blocks:
Attachments:	regression.patch

Description Arvid Requate

2019-07-17 13:57:18 CEST

Created attachment 10124 [details]
regression.patch

This looks like a regression of Bug #49445:

root@master10:~# /usr/share/univention-s4-connector/remove_ucs_rejected.py 'uid=user1,dc=ar41i1,dc=qa'
Traceback (most recent call last):
  File "/usr/share/univention-s4-connector/remove_ucs_rejected.py", line 71, in <module>
    remove_ucs_rejected(ucs_dn)
  File "/usr/share/univention-s4-connector/remove_ucs_rejected.py", line 47, in remove_ucs_rejected
    c.execute("SELECT key FROM 'UCS rejected' WHERE value=?" % [unicode(ucs_dn)])
sqlite3.ProgrammingError: Incorrect number of bindings supplied. The current statement uses 1, and there are 0 supplied.

root@master10:~# lsb_release -r
Release:        4.4-0 errata186

The attached patch fixes the trivial bug.

Comment 1 Florian Best

2019-07-17 14:02:21 CEST

Oh yes.

Comment 2 Julia Bremer

2019-07-25 14:25:04 CEST

366628ac55 Bug #49865: Yaml
a242f01062 Bug #49865: Fix typo


Successful build
Package: univention-s4-connector
Version: 13.0.2-20A~4.4.0.201907251408
Branch: ucs_4.4-0
Scope: errata4.4-1
User: jbremer

Comment 3 Florian Best

2019-07-25 16:09:03 CEST

OK: fixed
OK: YAML

Comment 4 Arvid Requate

2019-08-22 15:30:09 CEST

<http://errata.software-univention.de/ucs/4.4/239.html>