Categories
User Help

OneDrive Screw Up (How to Repair)

Long, weird, story. We ordered a laptop. It has a short: shocks us, completely crashes, and reboots. We’re sending it back. We ordered an AIO as a replacement. Works fine. Wife had stuff on the laptop. She hand moved most of it to the AIO. OneDrive synced everything it had from the problem laptop to […]

Categories
User Help

Windows process not allowing file removal/transfer

My question would be: How would you remove files such as the GameDVR folder located at "C:\Users\Example\AppData\Local\Microsoft"? The only file in that folder is a "KnownGameList.bin" file. I do not use the computer for gaming, and I have already tried stopping and disabling Game Bar. It gives me an error that it is "being used […]

Categories
Database Development

row lock cause dead lock in MySQL 5.7

Today my app tell me encount a dead lock, error like this: rror querying database. Cause: com.mysql.cj.jdbc.exceptions.MySQLTransactionRollbackException: Deadlock found when trying to get lock; try restarting transaction 2020-09-25T02:10:41.962926578Z ### The error may exist in class path resource [mybatis/mapper/room/RoomSeatCustomMapper.xml] 2020-09-25T02:10:41.962930571Z ### The error may involve com.sportswin.soa.room.dao.RoomSeatCustomMapper.updateForFreeSeat-Inline 2020-09-25T02:10:41.962934646Z ### The error occurred while setting parameters 2020-09-25T02:10:41.96294191Z ### […]

Categories
Mastering Development

Refreshing the fragment after deleting a row from a list view

I’ve managed to created a custom list view and added a delete button to every row. The delete button is working well, when I click on the button the row gets deleted from the db. The problem is that when I delete a row it remains in the list until I refresh the fragment by […]

Categories
User Help

Outlook 2016, Windows 10, Outlook email in Explorer

Trying to do this in Outlook Email session on Explorer: but also I have the Application Outlook on Desktop. Really unfamiliar with how to operate the App, so please be specific in steps if it can be done there easier than in Explorer. THANKS! In Outlook 2016, w Windows 10 OS, how do I move […]

Categories
Mastering Development

Get count of records(stats) using in memory SSIS pipelines from flat files

I have two flat files previous version and current version, i need to compare and get the number of new records inserted, modified, deleted, duplicate records count and there details in another flat file. How should we get using inmemory pipeline and without using sql connection

Categories
Mastering Development

How to apply timeout in below powershell script, to stop processing of script after timeout elapsed

How to apply timeout in below powershell script, to stop processing of script after timeout elapsed. I am executing this powershell script using a tool, but even after timeout is done from the tool. The powershell script keeps on executing on the server even after that. param($IPAddress, $AffectedDrive, $ScriptFunction) (Get-Host).UI.RawUI.BufferSize = new-object System.Management.Automation.Host.Size 9999,9999 ################################################################################################################################### […]

Categories
Apple User Help

Moving files (manually in Finder, via terminal MV, or via script) appears to leave a ‘ghost’ file in search results that cannot be deleted

Scenario: I use plex with a DVR and torrents to download tv shows and the accompanying files. The DVR files save to DRIVE_1, and the permanent storage for PLEX is DRIVE_2. Issue: When the files are moved, it appears that many (some, not all) files are ‘ghosted’. Essentially, the files that have been moved still […]

Categories
Mastering Development System & Network

GKE: The cluster is in a stuck state

Unfortunately since yesterday our GKE cluster is stuck in a error state. I can connect with Kubectl fine but I cannot edit the cluster directly. When I try and edit the cluster I get the following Cluster is currently being created, deleted, updated or repaired and cannot be updated I can’t see anything in the […]

Categories
Database Development

quoted identifiers on filtered indices

I´ve 2 questions. I am using a T-SQL Server 2014. When creating a table with a filtered index on a T-SQL server, it is a must-have to set QUOTED_IDENTIFIER to ON. Why is this so? I´ve some SPs which have set quoted_identifiers to OFF, my question is, if I call the SP with QUOTED_IDENTIFIER ON, […]