K2 smart objects and Dynamic Sql Service

Reply

rpichaimani Posted: Tue, Jun 30 2009 7:31 AM

rated by 0 users

Hi all

First of all, I am new to K2. I have a production setup k2 server with workspace. I am in the process of creating a development environment.

I took the production copy and working on creating development environment.

I am using 'Dynamic Sql Service' and smart objects.

My question is Where do I need to update the 'GUID'?

Eventhough, the smart objects are now pointing to DEV, after I submit my form, the records are getting updated in production db.  But I want the records to be getting updated in DEV db.

Please help me if you came accross the same situation.

Thanks in advance.

Ravi

Reply

jan replied on Tue, Jun 30 2009 9:10 AM

rated by 0 users

Hi,

The GUID need to be updated at the service object instance level. This can be done when you are declaring the new instance using the Broker Management Console (%K2 blackpearl installation directory%\ServiceBroker\)... you can't set your own GUID when you are declaring a new instance using the K2 Workspace interface.

In the Broker Management Console, you can get your GUID looking at the Service Instance XMl Definition. 

Now, if you need to update the GUID of existing Service Object instance, you can delete your instance and re-create it with the borker management console setting your required GUID or you can use the "Service Instance Synchronizer Utility"... which it, you can view and update GUID very easily (without deleting).

HTH

PS: in your case, you need to create in your dev environnement an instance of your Dynamic SQL Service pointing on your TEST DB... and to facilitate the moving between TEST and PROD environment you need to have the same GUID on the 2 plateforms.

Reply

rpichaimani replied on Wed, Jul 1 2009 2:03 PM

rated by 0 users

Hi

First of all, thanks for your reply. When I run the "broker management.exe", I am able to see the services,  There are about 10 services like workflow service, sharepoint service etc with guids..

Example : servicetype name = "k2.blackpearl.ukeu.serviceobjects.dynamicsql.servicebroker" guid ="dc97........."

My question here is, do i need to create one guid for each and every one for my development setup?

If yes, how do I have to create one?

Please let me know.

Reply

jan replied on Thu, Jul 2 2009 1:06 AM

rated by 0 users

Hi Ravi,

Did you install yourself the DynamicSQL Service?

You have 2 concepts to know :

1. first the service (type), it is the reference of a DLL (and this dll is the K2 Service Object, for example the "DynamicSQL Service", and this appear in the list you talk). If you want to add another service type, you certainly have to follow the documentation gave with the service you downloaded.
2. Then you have instance(s) for the service you want use (in our example, the instance will refer to the Database we want to use with our service)... you can add several instances for your service, and you can do this by a right-clic on your service in the broker management console - here you can set your GUID during the creation of the instance.

What you need in your case: you need to check that in your dev environment and in your prod environment, you have the same services available and the service instance you use need to have the same GUID.

I hope this makes sense.

Reply

rpichaimani replied on Thu, Jul 2 2009 8:37 AM

rated by 0 users

Hi Jan

Thanks for your help.

I did install DyanmicSQLService. (I copied from production). Is it OK or I have to install.?

When I open the 'brokermanagement.exe', I see the services.

Under dynamicsqlservice (The guids are different in prod and dev)

When I checked in prod, I was able to see the guid in .sodx file name through visual studio.

But In dev, I am trying to look at the guid in .sodx file, I am not able to view in XML format like below. I am seeing only the the screen with smartobject methods and smart object properties..

In prod, I am able to see like below.

<Guid>66a8d309-5337-4067-8314-471bea74b5c3</Guid>

<Name>ContractsJSL</Name>

<Metadata Type="SourceCode.SmartObjects.Authoring.MetaDataDefinition" Assembly="SourceCode.SmartObjects.Authoring, Version=4.0.0.0, Culture=neutral, PublicKeyToken=16a2c5aaaa1b130d">

<Guid>81644ca6-9771-45c9-bc4f-5d2531ebcd08</Guid>

<DisplayName>ContractsJSL</DisplayName>

<Description>ITT AES Contracts JSL SmartObject</Description>

<ServiceElements>

<ServiceElementDefinition>

<Guid>479f9d61-3703-49cf-aaaf-da883aacff9f</Guid>

<Name>deploymentcategory</Name>

<Value>ITT.AES.Contracts.BP.SO</Value>

</ServiceElementDefinition>

</ServiceElements>

</Metadata>

=========================

I want to see the same in DEV also.

What do I need to do..

I checked the smartobject services through k2workspace and it looks ok.

Thanks and please let me know.

Ravi