cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - Did you get called away in the middle of writing a post? Don't worry you can find your unfinished post later in the Drafts section of your profile page. X

Subscription not working

svisveswaraiya
17-Peridot

Subscription not working

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.

2 REPLIES 2

What isn't working?

What errors are you receiving?

slangley
23-Emerald II
(To:PaiChung)

Hi @svisveswaraiya.

 

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

Announcements


Top Tags