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

Community Tip - Learn all about PTC Community Badges. Engage with PTC and see how many you can earn! 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

Top Tags