Romy121
Novice

EXCEL AS SMO SERVICE BROKER

Hi I Created this SO but when I try to run it I get this Error Message way ?
error_3602.jpg
error_3603.jpg
0 Kudos
Reply
5 Replies
Widson
Apprentice

Re: EXCEL AS SMO SERVICE BROKER

Hi  @Romy121;


 


Have you used or are you aware of this tool?(https://community.k2.com/t5/General-K2-Utilities/EXCEL-AS-SMO-SERVICE-BROKER/ba-p/86040?nobounce).


 


Regards;


Widson.

0 Kudos
Reply
Romy121
Novice

Re: EXCEL AS SMO SERVICE BROKER

yes I install this broker
0 Kudos
Reply
Dumisani
Apprentice

Re: EXCEL AS SMO SERVICE BROKER

Good day Romy,


 


In my experience, this usually can occur when the K2 Service Account doesn't have proper permissions on the database the SQL Service Instance is built off of.


Would you please try granting the K2 Service Account DB Owner permissions and then refresh the service instance.


 


In addition to the information that was provided by  @Widson  you can also have a look at the following community post:


https://community.k2.com/t5/K2-blackpearl/Excel-Import-Service-Broker/ba-p/65814?nobounce


which discusses the "Excel Import Service Broker"


 


Please let me know if this is of help


Thank you and


kind regards,


Dumisani


  


 

0 Kudos
Reply
Widson
Apprentice

Re: EXCEL AS SMO SERVICE BROKER

Hi,


 


Please see the deployment process as follows:-


 



  1. Stop the K2 service

  2. Open "<K2 Instillation Drive>:Program FilesK2 blackpearlServiceBrokerBrokerManagement.exe".

  3. Click on “Configure Services”

  4. Configure Service Type: Right click on services and select “Register New Service Type” and enter values for service name. Select Assembly path from your local path.

  5. Configure Service Instance: right click on just created Service Type and select “Register New Service Instance” to create New Service Instance.

  6. Service Instance Configuration: Press “Save” Button to continue to next step.( this is the configuration section , where you can change the configuration of service ex: Database connection, SharePoint url , log file path etc…)

  7. Enter service instance details and click “Ok” to create service instance.

  8. Restart the K2 service.


Also, if using SmartObjects it is important that the Service Instance GUIDs is the same in all environments. If this is not the same you will have runtime errors because processes use the GUID of the service instance. See the following post on how you can synchronize the GUIDs:

http://www.k2underground.com/blogs/pitchblack/archive/2008/07/16/keeping-your-service-guids-in-sync....


Also ensure that SQL has valid permission for a given account...


 


Kind regards;


Widson.

0 Kudos
Reply
lkimberly
Apprentice

Re: EXCEL AS SMO SERVICE BROKER

Hi  @Romy121 ,


 


First off, what version of K2 are you on? Have you tried refreshing the service instance where the SmartObject is created from? I will recommend that you enable SmartObject logging (https://help.k2.com/kb000298), execute the SmartObject again and when the error appears, check the log files as it may provide more information on the issue. 

0 Kudos
Reply