Import Resources no...
 
Notifications
Clear all

Import Resources not working

8 Posts
2 Users
0 Reactions
1,659 Views
Posts: 1509
Admin
(@trobinson)
Noble Member
Joined: 9 years ago

Hello,
I am not aware of any issues and am unable to recreate the issue. You are going to need to check each server which is part of the plan to see if SolidCP Server has any errors.
You can also try run the following SQL query:

DECLARE @return_value int
EXEC @return_value = [dbo].[GetServiceItemTypes]
SELECT 'Return Value' = @return_value
GO

If you can screenshot the results to make sure that only SolidCP appears in TypeName.

Thanks,
Trevor

Reply
Posts: 22
Topic starter
(@web_hosting)
Eminent Member
Joined: 9 years ago

Hi

The stored procedure requires to input values

Msg 201, Level 16, State 4, Procedure GetServiceItem, Line 0 [Batch Start Line 3]
Procedure or function 'GetServiceItem' expects parameter '@ActorID', which was not supplied.

if we use null it return no results

DECLARE @return_value int

EXEC @return_value = [dbo].[GetServiceItem]
@ActorID = NULL,
@ItemID = NULL

SELECT 'Return Value' = @return_value

Thanks,

Reply
Posts: 1509
Admin
(@trobinson)
Noble Member
Joined: 9 years ago

Hello,

Can you try ActorID = 1?

Thanks,

Trevor Robinson

Reply
Page 2 / 2
Share: