sql server – database migration failed with non-specific error

today I wanted to upgrade an application. But the database migration failed. The database is from 2007 and has been migrated to a higher version accordingly many times, so inconsistencies are likely.

I have now created a raw database for the same original version to find out where the problem is.

According to the software error message, it seems to be a rights problem.

What was also apparent is that the raw database has primary keys and foreign keys in the respective tables. In the database to be migrated, no primary keys and foreign keys are defined. Could this be the cause?

How would you proceed? Would you store the primary keys and foreign keys now afterwards, or rather move the content from the respective tables into the raw database? For this, however, I would have to deactivate the foreign key check, otherwise the insert would fail.

I am looking forward to your suggestions!

Andre

composer – Pipeline Job failed on blt validation command

I have blt project installed in my local. I pushed it to gitlab repo. And I define a pipeline file as below:
.gitlab-ci.yml–>

image: composer

variables:

BLT: ./vendor/bin/blt

validate:

script:

– $BLT validate

But it is failed.
output of pipeline is:

Running with gitlab-runner 14.1.0-rc1 (e9489c8a)
on docker-auto-scale 72989761
Preparing the “docker+machine” executor
00:13
Using Docker executor with image composer …
Pulling docker image composer …
Using docker image sha256:c69d012e5132ce7f7399f46f90ae3a2e4cdd271ec98c7a0ff3c8b7fd0c809d1c for composer with digest composer@sha256:3a9aa7b537bc468095177e787fb91d1f6f4542ad1b670607f66d1efabb91b875 …
Preparing environment
00:02
Running on runner-72989761-project-28332029-concurrent-0 via runner-72989761-srm-1627367246-9ae74144…
Getting source from Git repository
00:08
$ eval “$CI_PRE_CLONE_SCRIPT”
Fetching changes with git depth set to 50…
Initialized empty Git repository in /builds/cognizant49/drupal9/.git/
Created fresh repository.
Checking out ef40dcfc as master…
Skipping Git submodules setup
Executing “step_script” stage of the job script
00:01
Using docker image sha256:c69d012e5132ce7f7399f46f90ae3a2e4cdd271ec98c7a0ff3c8b7fd0c809d1c for composer with digest composer@sha256:3a9aa7b537bc468095177e787fb91d1f6f4542ad1b670607f66d1efabb91b875 …
$ $BLT validate
/bin/bash: line 117: ./vendor/bin/blt: No such file or directory
Cleaning up file based variables
00:00
ERROR: Job failed: exit code 1

But when I am doing ls, I am able to see ./vendor/bin/blt

SharePoint Spfx CDN failed to load 406 (Not Acceptable) Error

Web part is not loading, its not able to load files from public SharePoint cdn.
enter image description here

Console error:-
enter image description here

My finding on this issue :-

  1. I have checked with 3 users and one user user is getting this error.
  2. For me some times web part was not loading but on the same time it was loading in incognito mode.
  3. We have 3 web parts on the page, for one user web part 2 was not loading and on next day webpart 2 was loading and web part 3 was not loading.

2016 – Add Host to Service Bus Farm’ Failed & Service Bus Message Broker Service stuck on Starting mode

when I install & Configure WF Farm in one of SP 2016 APP Server I am facing issue, I created new Farm and WF Manager Configuration wizard fails at ‘Add Host to Service Bus Farm’
I enabled TlS 1.0,1.1,1.2 already before starting the wizard.
and Service Bus Message Broker Service in Starting state.

enter image description here

In Event Viewer below errors:

Faulting application name: Microsoft.ServiceBus.MessageBroker.exe, version: 2.0.50926.9, time stamp: 0x5a0a1de1
Faulting module name: unknown, version: 0.0.0.0, time stamp: 0x00000000
Exception code: 0x80131623
Fault offset: 0x00007ff955393102
Faulting process id: 0x2074
Faulting application start time: 0x01d7815c0d76f752
Faulting application path: C:Program FilesService Bus1.1Microsoft.ServiceBus.MessageBroker.exe
Faulting module path: unknown
Report Id: 16a5f355-4152-4727-8e9a-29f4498210e6
Faulting package full name:
Faulting package-relative application ID:

Application: Microsoft.ServiceBus.MessageBroker.exe
Framework Version: v4.0.30319
Description: The application requested process termination through System.Environment.FailFast(string message).
Message: Failed to start Service Bus Broker Service.
Stack:
at System.Environment.FailFast(System.String, System.Exception)
at Microsoft.ServiceBus.MessageBroker.Backend.OnStart(System.String())
at System.ServiceProcess.ServiceBase.ServiceQueuedMainCallback(System.Object)
at System.Threading.ExecutionContext.RunInternal(System.Threading.ExecutionContext, System.Threading.ContextCallback, System.Object, Boolean)
at System.Threading.ExecutionContext.Run(System.Threading.ExecutionContext, System.Threading.ContextCallback, System.Object, Boolean)
at System.Threading.QueueUserWorkItemCallback.System.Threading.IThreadPoolWorkItem.ExecuteWorkItem()
at System.Threading.ThreadPoolWorkQueue.Dispatch()

Intellij – Erro Java – Gradle sync failed: Cannot convert relative path ~/GRADLE_HOME/daemon/6.8 to an absolute file

Boa noite pessoal.

O problema esta aparecendo sempre que tento rodar o programa, e as packages do programa não aparecem também. Abri o mesmo projeto pelo VSCode e funcionou normalmente por la, só não esta funcionando pelo Intellij.

Reset failed decrypts counter Android 10

Hi everyone!

I have a locked phone (forgotten PIN). And due to many incorrect attempts, the gatekeeper timeout or cooldown period is stuck at 480s.

Is there anyway to reset this failed decrypts counter, so that brute forcing could be done feasibly?

debian – Using a software raid array after os failed

So I have a debian home server that has a 4 disk software RAID 5 array. My OS runs only on a normal nvme SSD. I know thats not secure, but it is a home server, so I didn’t really care when I installed it and now it is too late to change it. I was wondering what would happen to my software RAID when the OS failed (or the SSD).
How could I resync (I don’t know what the correct term for it is) the array to use it after I bought a new ssd and installed a new OS?

I found something regarding the mdadm config, but mine is empty…
Just for clarification: this is just something I thought about to be prepared when it happens (I don’t want to loose all my data)

Thanks for your answers in advance

sql server – How do I identify the database a “A system assertion check has failed” error has occured in

Last night I got two alerts about errors from the SQL Server (2019 Enterprise):

One with Severity 020:

DESCRIPTION: A system assertion check has failed. Check the SQL Server
error log for details. Typically, an assertion failure is caused by a
software bug or data corruption. To check for database corruption,
consider running DBCC CHECKDB. If you agreed to send dumps to
Microsoft during setup, a mini dump will be sent to Microsoft. An
update might be available from Microsoft in the latest Service Pack or
in a Hotfix from Technical Support.

Another (at the same timestamp) with severity 016:

DESCRIPTION: SQL Server Assertion: File: <“bpjoin.cpp”>, line=3448
Failed Assertion = ‘S_OK == hr || DB_S_ENDOFROWSET == hr’. This error
may be timing-related. If the error persists after rerunning the
statement, use DBCC CHECKDB to check the database for structural
integrity, or restart the server to ensure in-memory data structures
are not corrupted.

I would like to run the DBCC CHECKDB as suggested, but I can’t find anywhere in the error messages or in the SQL Server Error log what database this occured in.
Any suggestions on how to determine the database with the problem (none of them are marked as suspect).

Is it safe to do a reboot of the server, or should I first do the DBCC CHECKDB?

Snowflake: Failed to get query execution status on db reconnection

We are using snowflake JDBC to execute unload queries on the snowflake. As unload queries potentially take more time to complete, we are periodically checking if query execution is completed by checking with query id. It is all working well if query execution and status check happen in the same session. Due to any reason, if the service restarts and creates a new connection, it is not able to get the execution status of the query executed before restarting the service.

creating snowflake connection

private Properties getProperties() {
    Properties properties = new Properties();
    properties.put("user", snowflakeConfig.getUsername());
    properties.put("password", snowflakeConfig.getPassword());
    properties.put("CLIENT_SESSION_KEEP_ALIVE", "true");
    return properties;
}
private Connection getConnection() throws SQLException {
    return DriverManager.getConnection(snowflakeConfig.getUrl(), getProperties());
}

Executing unload query :

resultSet = statement.unwrap(SnowflakeStatement.class).executeAsyncQuery(sql_command);
queryID = resultSet.unwrap(SnowflakeResultSet.class).getQueryID();

Get query status with query ID returned in above step:

resultSet = connection.unwrap(SnowflakeConnection.class).createResultSet(queryID);
queryStatus = resultSet.unwrap(SnowflakeResultSet.class).getStatus();

Can someone help me to do it in right way.

debugging – How to print local variable when assertion failed

Given the following code:

func[i_] := Module[{k}, k = i; Assert[k > 0, k]];
func[-1]

The output is:

Assert::asrtfe: Assertion k$250998>0 in Assert[k$250998>0,k$250998] failed.

How to let Mathematica output Assert[k$250998>0,-1] instead of Assert[k$250998>0,k$250998]?

Thanks.