Tag: import

Sql Error Message ID 3013 & 4305 for Standby / Read-Only database that we use for import data heavily

Sorry. I am not a DBA, but a SQL Developer, so I am trying to get some general support/feedback on my case (and when I Googled the issue, remedy seems so scattered so I decided to post here).

I got this error message on SQL Server Agent for one of "Standby / Read-Only" databases.

enter image description here

SQL Server Error 3013 and 4305.

Bottom is some of error messages:

6_Exec SQL Nightly_StandByReporting_Run0235AM_PST,Error,1, BNSQL2\PCCDAILY,6_Exec SQL Nightly_StandByReporting_Run0235AM_PST,Exec,,Executed as user:  BNSQL2\JDoh. ...0000001<c/>  which is too recent to apply to the database.  An earlier log backup that includes LSN 201999000000891200001 can be restored.  [SQLSTATE 42000] (Error 4305)  RESTORE LOG is terminating abnormally.  [SQLSTATE 42000] (Error 3013)  The log in this backup set begins at LSN  203741000000458400001<c/>  which is too recent to apply to the database. An earlier log backup that includes LSN  201999000000891200001 can be restored.  [SQLSTATE 42000] (Error 4305)  RESTORE LOG is terminating abnormally.  [SQLSTATE 42000] (Error 3013)  The log in this backup set begins at LSN  203744000000476800001<c/>  which is too recent to apply to the database. An earlier log backup that includes LSN  201999000000891200001 can be restored.  [SQLSTATE 42000] (Error 4305)  RESTORE LOG is terminating abnormally.  [SQLSTATE 42000] (Error 3013)  The log in this backup set begins at LSN  203749000000381600001<c/> which is too recent to apply to the database.  An earlier log backup that includes LSN 201999000000891200001 can be restored.  [SQLSTATE 42000] (Error 4305) RESTORE LOG is terminating abnormally.  [SQLSTATE 42000] (Error 3013) The log in this backup set begins at LSN  203788000000038400001<c/> which is too recent to apply to the database.

When I Googled, this is brief reason. "BACKUP DATABASE is terminating abnormally"

I am not sure why this happened, but I can only guess that this happened due to some type of memory or hardware issues because we use this database heavily to import data (into other database).

When I searched more for remedies, following are given (from this site):

  • Check Security Permission for user
  • Delete the Previous Backup
  • Perform Full Backup Restoration

I am not sure how to apply for "Standby / Read-Only" database though.

I would appreciate for any help to fix the issue.

Pai Memberships Pro Import OK but no membership assigned

I have created a csv file with the following information:

user_login,user_email,first_name,last_name,display_name,role,membership_id,membership_initial_payment,membership_billing_amount,membership_cycle_number,membership_cycle_period,membership_status,membership_startdate,membership_enddate

The CSV plugin does not show any error messages and claims the import was OK. But when I check the user in WordPress -> All Users there is no membership level assigned. Also under members in PMPRO the transaction does not appear.

The only data that’s imported is the name,email,username and userrole. I am using PMPRO and their suggested CSV Import plugin.

What am I doing wrong?

Database maximum size when import bacpac file using sql package

Can be specify Database maximum size when import bacpac file using sql package? Maximum size 32GB is auto sizing but my actual DB size is over 35GB. originally: DatabaseMaximumSize=(INT32).

eg. import parameter /p:DatabaseEdition=GeneralPurpose /p:DatabaseServiceObjective=GP_Gen5_2 /p:DatabaseMaximumSize=(INT60)

AAD users lose access to database after import

I googled for the last few days but I got a bit confused and I do not know how to proceed further. Also, I’m not a DBA and I was just faced with this situation for the first time. Using sqlpackage.exe I’m exporting a bacpac from a PRD DB and import it on another server to refresh the lower environments. The original database is contained. After I’m importing the new database, the contained database users and the AAD external ones lose access to the new database. I’m fixing the contained database user by updating its password with

ALTER USER [RandomUser] WITH PASSWORD='randomPassword'

but I am not sure what to do with the AAD users. They have an external user created for them (the aad users are placed inside a group). So far my option is to drop the said user and recreate it

CREATE USER [sthRandom] FROM EXTERNAL PROVIDER

but in order to do this, you have to be connected with an AAD user

Principal 'sthRandom' could not be created. Only connections established with Active Directory accounts can create other Active Directory users.

I have to automate this whole process so I could use a service principal like this. I’m creating the service principal inside all the databases, but after refresh the user won’t exist anymore, or I create it in the PRD database too, but I can not use it to login anymore.

What other options do I have? Thanks

Import from CSV formatting issue

I have two lists of data here: dm and dmHalo (see attached image). Theses are the same lists, the only difference is that dm was exported to a csv file and then reimported, while dmHalo was generated in the notebook session.

When I go to run an interpolation on the data set the interpolation does not recognize the csv imported data, as seen in the error message. I assume this is due to a change in formatting, but I am at a loss at how to revert to the native format.

Does anyone have an idea of how to do this?

Thanks you for your help!

enter image description here

Import from other projects not working properly

@Sven I have four projects set up that I use to clean lists.

Each project is creating verified’s from one of four sold SER lists.

Then, I create a new project for whatever I want to link to.

In the past, when I import verified from other projects all the links would be moved to my new project to build on those targets.

Now SER is filtering or something and not all those links are being brought over.

For example, I have 2400 verified links from today’s cleaning.

But when I import from those projects into the new project, only 408 are copied over.

What’s going on that’s causing that?

Settings to import list

Hi, how are you?
I have a list of sites that I just scraped with scrapebox, and I want to add them to my campaign that is currently running in GSA. And I want GSA to go through those sites and be able to get some links.
Currently the GSA is configured to harvest on google.
My question is:
1. The configuration is correct to import list Or is it necessary to click on a section? View image:

2. If I import the URLs using this method, see the following image.
GSA will automatically start using the imported sites to see if it is possible to verify some or is it necessary to check any option?

3. If I use this method, see the following image:
Gsa will start visiting those sites or is it necessary to mark another option?

Blender->Unity Import Animation Failing by Overlapping Mesh Objects

I’m new to both Unity and Blender. I created this penguin 3d model, rigged it up and animated it in Blender and all looked good.

When I imported it into Unity, I noticed that this idle animation did not appear to be working correctly. As the body moves, the body mesh overlaps the belly mesh and covers a portion of it.

enter image description here

This is not the case when viewing the animation from blender 2.9.

enter image description here

The belly uses a shrinkwrap modifier with the body as a target.

Is this a problem with Unity import, or how I modeled this penguin in Blender? Can anyone see what I have done wrong here? Any help is much appreciated!