Having issues with recipe retrieval via WinCC 7.4 and SQL.  On the floor I have a HMI A TP1500. When the button is pushed it activates a bit on the PLC which the WinCC 7.4 server monitors when set it calls a VB script which will calls a stored procedure on a SQL server (generates recipe) and read the results and forwards it to the PLC. Up until the other day we were bringing in only a partial recipe due to a missing parameter. I worked with IT and the generated a script to add the missing value. After making the change on SQL if I do a query for the recipe I see the full recipe for the WO on SQL. When I do a recipe request I receive the wrong information now. It brings in the same information for all fields no matter the recipe and it's the incorrect data. It's not what is in the recipe. The one that stands out the most is are the following

Borer3_Rec_Bor
Borer3_Rec_Lgt
Borer3_Rec_Spd
Borer3_Rec_Fd

which all turn to a value of 125

Borer3_Rec_Qty

turns to 1

Borer3_Rec_Dia

changes to 472

The original problem was that there wasn't a value for Borer3_Rec_Bor so it would never calculate the Spd and Fd. It does now and the SQL recipe is correct. Now that the recipe is correct now it brings in all the wrong data and it is consistent amongst all machines. Each machine runs it's own script.

I tried a WO not in the system and I get the same results. It should change the WO field to a 9 according to the script. It does not and get the same results.

I am awaiting a chance to reboot the WinCC server to see if that fixes the problem. If it does not I am at a loss of what the issue is.

It appears to be an issue with the:

On Error Resume Next