while using OnEachRow it not rollback entries from second table if database error occur

[krishantalwar]

if their error comes it rollback the entries from the first table. but it does not roll back the entries from the second table.

Can anyone guide how it is possible?

what my case.

if their error comes it rollback the entries from the agent table. but it does not roll back the entries from the payment table.

To create this error I hardcoded the value for the third row and set the status value to null. but status only takes an integer value why it creates the error.

it gives an error Incorrect integer value: '' for column 'status'
but it rollback entries form agent table but not from payment table

class noteImport implements OnEachRow {

    public function onRow(Row $row){
        $row = $row->toArray();
        
            $Option = [
            "firstpay" => 1,
            "amount" => 1,
            "payment_type" => 1,
            "info" => "1",
            "enter_date" => date('y/m/d'),
            "recieve_date" => date('y/m/d'),
            "status" => $row['srno'] != 3 ? 1 : "",     
            ];

            $agent = Agent::create([
            "agent_code" => "1",
            "name" => "1",
            "address" => "1",
            "phone" => 454,
            "password" => "asd",
            "upload" => "1",
            "status" => 1,
            ]);

        $agent->payment()->create($Option);
    }
}