Error executing 'BA...
 
Notifications
Clear all

Error executing 'BACKUP' task. Value cannot be null. Parameter name: path1

29 Posts
4 Users
0 Likes
3,974 Views
Squazz
Posts: 24
Topic starter
(@squazz)
Eminent Member
Joined: 2 years ago

Hi there @trobinson

Did you get my reply? 🙂

Reply
Trevor Robinson
Posts: 1444
Admin
(@trobinson)
Noble Member
Joined: 7 years ago

Hello,

The error suggests there is an issue with getting the home folder for the user. You can try run the [dbo].[GetServiceItems] stored procedure on your SolidCP Database.

The options you can get such as PackageID from the URL for the others use:

@ItemTypeName = N'SolidCP.Providers.OS.HomeFolder, SolidCP.Providers.Base',
@GroupName = N'OS',

Regards,

Trevor

Reply
1 Reply
Squazz
(@squazz)
Joined: 2 years ago

Eminent Member
Posts: 24

@trobinson I think there's something that I missed. From what URL is it that I should be able to get ActorId & PackageID?
I looked at the following two endpoints:

Default.aspx?pid=SpaceMsSql2019&mid=152&ctl=edit_item&ItemID=3&SpaceID=6
Default.aspx?pid=SpaceFileManager&SpaceID=6

Reply
indexebusiness
Posts: 34
(@indexebusiness)
Eminent Member
Joined: 6 years ago

Hi Guys

We are also having this problem as well with v1.4.7. Our SQL Server and Web Servers are physically separate servers and the OS for the User is on the Web Server. We can upload files using file manager (which go to the web server) but we cannot backup SQL to the Hosting Space.

Initially, we didn't have an OS defined on the SQL Server so we tried adding that but it still errors out.  Our Virtual Server only has the Web Server OS, will it also need the SQL Server OS adding as well?

And if the answer is yes, does this mean that the users will be able to upload files to the SQL Server?

Thanks

Mark Donne

Reply
1 Reply
Marco Tiggelaar
Admin
(@m-tiggelaar)
Joined: 7 years ago

Noble Member
Posts: 1958

@indexebusiness OS is always required to anything space/ bandwidth related (it normally is equal to the Web / FTP server if you have one, if you do not have a Web / FTP server it can be anything else to your chosing).

If you add it after the space is created already it will normally not automatically work correctly due to saved ServiceID's on space creation, it should then however work for any new space.

Any old space would need to be adjusted in the PackageServices and ServiceItems tables (out the top of my head).

Regards,

Marco

Reply
Squazz
Posts: 24
Topic starter
(@squazz)
Eminent Member
Joined: 2 years ago

@trobinson I think there's something that I missed. From what URL is it that I should be able to get ActorId & PackageID?
I looked at the following two endpoints:

Default.aspx?pid=SpaceMsSql2019&mid=152&ctl=edit_item&ItemID=3&SpaceID=6
Default.aspx?pid=SpaceFileManager&SpaceID=6

Reply
1 Reply
Trevor Robinson
Admin
(@trobinson)
Joined: 7 years ago

Noble Member
Posts: 1444

@squazz

 

ActorID is your userID from the Users table which is runnung the query (or logged into the panel). For Serveradmin this is always 1.

 

PackageID can be found from the SpaceID in the URL.

Reply
Squazz
Posts: 24
Topic starter
(@squazz)
Eminent Member
Joined: 2 years ago

@trobinson sorry for the late reply.

I tried executing the below stored procedure, and I got nothing back

I got a return_value of "0"

I've tried with serveral different ActorIDs, to see if that was the reason I got nothing back

USE [SolidCP]
GO

DECLARE @return_value int

EXEC @return_value = [dbo].[GetServiceItems]
@ActorID = 1,
@PackageID = 6,
@ItemTypeName = N'SolidCP.Providers.OS.HomeFolder, SolidCP.Providers.Base',
@GroupName = N'OS',
@Recursive = 0

SELECT 'Return Value' = @return_value

GO

Reply
Page 3 / 5
Share: