Error Progress Error

[Manikandan Gnanakumar]

Hi,

When I get the following progress error, what all things that needs to be checked to fix the issue. I have checked for mismatch in the parameters but that was not the reason. Kindly help.

"Parameter number 2 (table temp_act) mismatch. Has 172 fields - client schema has 173 fields. (8030)"

Regards
Mani

 

[RealHeavyDude]

Most likely you did not re-compile both involved procedures.

Heavy Regards, RealHeavyDude.

 

[Cringer]

The message is telling you that the table temp_act has 172 fields in one piece of code, and 173 fields in another. As RHD says, the most likely cause is that not everything has been compiled. That is assuming the definitions are shared across code. If you have separate definitions (why would you?!), then the two are not in line. Try recompiling all the code and try again.

 

[Manikandan Gnanakumar]

Thanks Cringer & RHD, the problem was because of compilation as you both suggested. Now the problem is solved.