Start Bitcoin Core with the command line switch -zapwallettxs to remove the transaction from local storage. The blockchain will subsequently be rescanned for all txns related to your wallet, and you will be able to continue using your wallet. You only need to run it with -zapwallettxs once.