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

Subscription not working

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

Re: Subscription not working

What isn't working?

What errors are you receiving?

Highlighted

Re: Subscription not working

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

Thingworx Navigate content has a new home! Click here to access the new Thingworx Navigate forum! ______________________________