I'm trying to insert multiple records in an RBDMS table but receive the error

```
Error in insert operation..rollback

```

Could anyone help me fix the problem? Below is the code for adding multiple records and creating the table itself

```
# Insert multiple records in table DAY_CARE

qry="insert into DAY_CARE (dayCareID, dayCareWebsite, dayCareAddress, dayCarePhone, dayCareBills, clientID, clientBookingID, staffHead) values (?,?,?,?,?,?,?,?);"
daycarelist=[('day care','www.eddc.co.uk','Exeter Doggy Day Care, Stoker Rd, Exeter, EX4 4PY', 1392661000, 100, 1, 1, 'Bob Smith'),
           ('day care','www.eddc.co.uk','Exeter Doggy Day Care, Stoker Rd, Exeter, EX4 4PY', 1392661000, 100 , 2, 2, 'Bob Smith'),
           ('day care','www.eddc.co.uk','Exeter Doggy Day Care, Stoker Rd, Exeter, EX4 4PY', 1392661000, 100, 3, 3, 'Bob Smith'),
           ('day care','www.eddc.co.uk','Exeter Doggy Day Care, Stoker Rd, Exeter, EX4 4PY', 1392661000, 100, 4, 4, 'Bob Smith'),
           ('day care','www.eddc.co.uk','Exeter Doggy Day Care, Stoker Rd, Exeter, EX4 4PY', 1392661000, 100, 5, 5, 'Bob Smith'),
           ('day care','www.eddc.co.uk','Exeter Doggy Day Care, Stoker Rd, Exeter, EX4 4PY', 1392661000, 100, 6, 6, 'Bob Smith'),
           ('day care','www.eddc.co.uk','Exeter Doggy Day Care, Stoker Rd, Exeter, EX4 4PY', 1392661000, 100, 7, 7, 'Bob Smith'),
           ('day care','www.eddc.co.uk','Exeter Doggy Day Care, Stoker Rd, Exeter, EX4 4PY', 1392661000, 100, 8, 8, 'Bob Smith'),
           ('day care','www.eddc.co.uk','Exeter Doggy Day Care, Stoker Rd, Exeter, EX4 4PY', 1392661000, 100, 9, 9, 'Bob Smith'),
           ('day care','www.eddc.co.uk','Exeter Doggy Day Care, Stoker Rd, Exeter, EX4 4PY', 1392661000, 100, 10, 10, 'Bob Smith')]

try:
        cur.executemany(qry, daycarelist)
        conn.commit()
        print ('Records inserted successfully..committed')
except:
        print ('Error in insert operation..rollback')
        conn.rollback()

```

Here is the successfully created DAY\_CARE table.

```
# Day Care Table
qry='''

CREATE TABLE DAY_CARE (
        dayCareID INTEGER PRIMARY KEY,
        dayCareWebsite TEXT (40),
        dayCareAddress TEXT (50),
        dayCarePhone INTEGER (11),
        dayCareBills INTEGER (6),
        clientID INTEGER (50),
        clientBookingID INTEGER (50),
        staffHead TEXT (50) 

 );

'''
try:
        cur.execute(qry)
        print ('Table created successfully')
except:
# If table already exists then use the SQLite console to connect to the database and then use the drop table command.
# .. Altenatively, use the SQLiteStudio GUI to delete table ECC_DEPARTMENT and execute this code block again.
        print ('Error in creating table')  

```