Skip to main content
1-Visitor
November 15, 2018
Question

Subscription not working

  • November 15, 2018
  • 1 reply
  • 1494 views

Hi,

I wrote a subscription that triggers the stored procedure whenever any data change in Kepware.

But it doesnt work. 

Please help me in resolving this.

 

StoredProcedure: execute UpdateStation_RunningStatus @StationName = [[StationName]], @statusName= '' ,
@machVal = [[StageValue]], @timeStamp=[[timeStampStatus]];

 

Subscription: 

var params = {
StationName: 'Station 01' /* STRING */,
timeStampStatus: eventTime /* DATETIME */,
StatusName: '' /* STRING */,
StageValue: Things["Navistar_Stage1Op_KepTag"].NAVISTAR_STATION1_Stage1Operating_Monitor /* STRING */
};

// result: INTEGER
var result = Things["Navistar_DB_Access"].Execute_DownTime_Stage1Operating(params);

 

Thanks,

Shalini V.

1 reply

22-Sapphire I
November 15, 2018

What isn't working?

What errors are you receiving?

Community Manager
December 5, 2018

Hi @svisveswaraiya_285988.

 

Just following up to see if you have found a solution to your problem.  If so, we would love for you to post it here and mark it as the Accepted Solution for the benefit of others with the same issue.

 

Thank you for using our Community.

 

Regards.

 

--Sharon