Subscription not working

[svisveswaraiya]

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.

[PaiChung]

What isn't working?

What errors are you receiving?

[slangley]

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