Erro grave na minha aplicação

Alguem pode ajudar?
Seguinte na minha aplicação de formulario na opção SQL eu coloquei uma where rebendo uma variabel global
exemplo: "beneficiario_id_beneficiario = ‘[getbeneficiario]’ " , definimos esta variavel como entrada (GET E POST).

No ambiente de desenvolvimento do scriptcase funciona legal, porem quando publico na produção ele nao esta executando o where da aplicação. tentei ate setar manualmente um id no lugar do getbeneficiario, em ambiente de desenvolvimento do scriptcase funciona na aplicação ele nao chama a clausula where…

Algum bug… me ajudem

Att
Vinicius

BUG não é pois funciona em desenvolvimento.

A aplicação chamadora passa parâmetros para essa app formulário? Como você alimenta a global?
A meu ver ele deveria ser var de sessão e de entrada.

Seguinte

Olha que estranho

acessa este link
http://scriptcase.neoprojsistemas.com.br:8090/scriptcase/app/NeoClinicNovo/form_dependentes/
e agora acessa a mesma aplicação publicada
http://www.neoprojsistemas.com.br/medvale/form_dependentes/

fiz um formulario comum sem regras… o formulario fica em branco.

Coloquei em modo debug, vai ver que no ambiente de desenvolvimento executa o sql

“(pdo-mysql): SELECT id_dependente, nm_dependente, dt_nascimento, tp_sexo, nm_mae, nm_pai, nr_rg, nr_cpf, nr_fone_cel, beneficiario_id_beneficiario, ativo, dt_cadastro, gparentesco from dependente order by id_dependente, nm_dependente, nr_cpf LIMIT 0,1”

no ambiente de produção publicado não !!

o erro que estou encontrando é esse!!

ja conferimos a conexao com banco no _lib/prod/ etc… ta tudo certo …

executa essa instrução no banco de dados de produção (direto no banco):

INSERT INTO sc_log (inserted_date, username, application, creator, ip_user, action, description) VALUES (‘2019-01-04 14:55:26’, ‘’, ‘form_dependentes’, ‘Scriptcase’, ‘66.249.85.49’, ‘access’, ‘’)

veja se dá erro.

Funciona…

O problema é que a mesma aplicação publica não executa o select …

Veja que em uma traz o nome do dependente e na outra nao …

Você executou a instrução no banco de produção?

Pois acredito que esteja dando erro nessa instrução por isso as próximas não são executadas.

é o mesmo banco que a plataforma de desenvolvimento.
executei em produção.
estou vendo que o select que esta no formulario que nao executa.

Ao navegar apareceu esse erro:

var res = '{“empty_filter”:"",“result”:“SET”,“ajaxRequest”:“navigate_form”,“fldList”:[{“row”:"",“keyVal”:"",“fldName”:“id_dependente”,“fldType”:“label”,“numLinha”:"",“valList”:[{“value”:“0”}]},{“row”:"",“keyVal”:"",“fldName”:“nm_dependente”,“fldType”:“label”,“numLinha”:"",“valList”:[{“value”:""}]},{“row”:"",“fldName”:“dt_nascimento”,“fldType”:“text”,“numLinha”:"",“valList”:[{“value”:""}]},{“row”:"",“fldName”:“tp_sexo”,“fldType”:“select”,“numLinha”:"",“valList”:[{“label”:"",“value”:""}]},{“row”:"",“fldName”:“nm_mae”,“fldType”:“text”,“numLinha”:"",“valList”:[{“value”:""}]},{“row”:"",“fldName”:“nm_pai”,“fldType”:“text”,“numLinha”:"",“valList”:[{“value”:""}]},{“row”:"",“fldName”:“nr_rg”,“fldType”:“text”,“numLinha”:"",“valList”:[{“value”:""}]},{“row”:"",“keyVal”:"",“fldName”:“nr_cpf”,“fldType”:“label”,“numLinha”:"",“valList”:[{“value”:""}]},{“row”:"",“fldName”:“nr_fone_cel”,“fldType”:“text”,“numLinha”:"",“valList”:[{“value”:""}]},{“row”:"",“fldName”:“beneficiario_id_beneficiario”,“fldType”:“select”,“numLinha”:"",“valList”:[{“label”:"",“value”:""}],“optList”:“1<\/option>2<\/option>3<\/option>4<\/option>5<\/option>6<\/option>7<\/option>8<\/option>9<\/option>10<\/option>11<\/option>12<\/option>13<\/option>14<\/option>15<\/option>16<\/option>17<\/option>18<\/option>19<\/option>20<\/option>21<\/option>22<\/option>23<\/option>24<\/option>25<\/option>26<\/option>27<\/option>28<\/option>29<\/option>30<\/option>31<\/option>32<\/option>33<\/option>34<\/option>35<\/option>36<\/option>37<\/option>38<\/option>39<\/option>40<\/option>41<\/option>42<\/option>43<\/option>44<\/option>45<\/option>46<\/option>47<\/option>48<\/option>49<\/option>50<\/option>51<\/option>52<\/option>53<\/option>54<\/option>55<\/option>56<\/option>57<\/option>58<\/option>59<\/option>60<\/option>61<\/option>62<\/option>63<\/option>64<\/option>65<\/option>66<\/option>67<\/option>68<\/option>69<\/option>70<\/option>71<\/option>72<\/option>73<\/option>74<\/option>75<\/option>76<\/option>77<\/option>78<\/option>79<\/option>80<\/option>81<\/option>82<\/option>83<\/option>84<\/option>85<\/option>86<\/option>87<\/option>88<\/option>89<\/option>90<\/option>91<\/option>92<\/option>93<\/option>94<\/option>95<\/option>96<\/option>97<\/option>98<\/option>99<\/option>100<\/option>101<\/option>102<\/option>103<\/option>104<\/option>105<\/option>106<\/option>107<\/option>108<\/option>109<\/option>110<\/option>111<\/option>112<\/option>113<\/option>114<\/option>115<\/option>116<\/option>117<\/option>118<\/option>119<\/option>120<\/option>121<\/option>122<\/option>123<\/option>124<\/option>125<\/option>126<\/option>127<\/option>128<\/option>129<\/option>130<\/option>131<\/option>132<\/option>133<\/option>134<\/option>135<\/option>136<\/option>137<\/option>138<\/option>139<\/option>140<\/option>141<\/option>142<\/option>143<\/option>144<\/option>145<\/option>146<\/option>147<\/option>148<\/option>149<\/option>150<\/option>151<\/option>152<\/option>153<\/option>154<\/option>155<\/option>156<\/option>157<\/option>158<\/option>159<\/option>160<\/option>161<\/option>162<\/option>163<\/option>164<\/option>165<\/option>166<\/option>167<\/option>168<\/option>169<\/option>170<\/option>171<\/option>172<\/option>173<\/option>174<\/option>175<\/option>176<\/option>177<\/option>178<\/option>179<\/option>180<\/option>181<\/option>182<\/option>183<\/option>184<\/option>185<\/option>186<\/option>187<\/option>188<\/option>189<\/option>190<\/option>191<\/option>192<\/option>193<\/option>194<\/option>195<\/option>196<\/option>197<\/option>198<\/option>199<\/option>200<\/option>201<\/option>202<\/option>203<\/option>204<\/option>205<\/option>206<\/option>207<\/option>208<\/option>209<\/option>210<\/option>211<\/option>212<\/option>213<\/option>214<\/option>215<\/option>216<\/option>217<\/option>218<\/option>219<\/option>220<\/option>221<\/option>222<\/option>223<\/option>224<\/option>225<\/option>226<\/option>227<\/option>228<\/option>229<\/option>230<\/option>231<\/option>232<\/option>233<\/option>234<\/option>235<\/option>236<\/option>237<\/option>238<\/option>239<\/option>240<\/option>241<\/option>242<\/option>243<\/option>244<\/option>245<\/option>246<\/option>247<\/option>248<\/option>249<\/option>250<\/option>251<\/option>252<\/option>253<\/option>254<\/option>255<\/option>256<\/option>257<\/option>258<\/option>259<\/option>260<\/option>261<\/option>262<\/option>263<\/option>264<\/option>265<\/option>266<\/option>267<\/option>268<\/option>269<\/option>270<\/option>271<\/option>272<\/option>273<\/option>274<\/option>275<\/option>276<\/option>277<\/option>278<\/option>279<\/option>280<\/option>281<\/option>282<\/option>283<\/option>284<\/option>285<\/option>286<\/option>287<\/option>288<\/option>289<\/option>290<\/option>291<\/option>292<\/option>293<\/option>294<\/option>295<\/option>296<\/option>297<\/option>298<\/option>299<\/option>300<\/option>301<\/option>302<\/option>303<\/option>304<\/option>305<\/option>306<\/option>307<\/option>308<\/option>309<\/option>310<\/option>311<\/option>312<\/option>313<\/option>314<\/option>315<\/option>316<\/option>317<\/option>318<\/option>319<\/option>320<\/option>321<\/option>322<\/option>323<\/option>324<\/option>325<\/option>326<\/option>327<\/option>328<\/option>329<\/option>330<\/option>331<\/option>332<\/option>333<\/option>334<\/option>335<\/option>336<\/option>337<\/option>338<\/option>339<\/option>340<\/option>341<\/option>342<\/option>343<\/option>344<\/option>345<\/option>346<\/option>347<\/option>348<\/option>349<\/option>350<\/option>351<\/option>352<\/option>353<\/option>354<\/option>355<\/option>356<\/option>357<\/option>358<\/option>359<\/option>360<\/option>361<\/option>362<\/option>363<\/option>364<\/option>365<\/option>366<\/option>367<\/option>368<\/option>369<\/option>370<\/option>371<\/option>372<\/option>373<\/option>374<\/option>375<\/option>376<\/option>377<\/option>378<\/option>379<\/option>380<\/option>381<\/option>382<\/option>383<\/option>384<\/option>385<\/option>386<\/option>387<\/option>388<\/option>389<\/option>390<\/option>391<\/option>392<\/option>393<\/option>394<\/option>395<\/option>396<\/option>397<\/option>398<\/option>399<\/option>400<\/option>401<\/option>402<\/option>403<\/option>404<\/option>405<\/option>406<\/option>407<\/option>408<\/option>409<\/option>410<\/option>411<\/option>412<\/option>413<\/option>414<\/option>415<\/option>416<\/option>417<\/option>418<\/option>419<\/option>420<\/option>421<\/option>422<\/option>423<\/option>424<\/option>425<\/option>426<\/option>427<\/option>428<\/option>429<\/option>430<\/option>431<\/option>432<\/option>433<\/option>434<\/option>435<\/option>436<\/option>437<\/option>438<\/option>439<\/option>440<\/option>441<\/option>442<\/option>443<\/option>444<\/option>445<\/option>446<\/option>447<\/option>448<\/option>449<\/option>450<\/option>451<\/option>452<\/option>453<\/option>454<\/option>455<\/option>456<\/option>457<\/option>458<\/option>459<\/option>460<\/option>461<\/option>462<\/option>463<\/option>464<\/option>465<\/option>466<\/option>467<\/option>468<\/option>469<\/option>470<\/option>471<\/option>472<\/option>473<\/option>474<\/option>475<\/option>476<\/option>477<\/option>478<\/option>479<\/option>480<\/option>481<\/option>482<\/option>483<\/option>484<\/option>485<\/option>486<\/option>487<\/option>488<\/option>489<\/option>490<\/option>491<\/option>492<\/option>493<\/option>494<\/option>495<\/option>496<\/option>497<\/option>498<\/option>499<\/option>500<\/option>501<\/option>502<\/option>503<\/option>504<\/option>505<\/option>506<\/option>507<\/option>508<\/option>509<\/option>510<\/option>511<\/option>512<\/option>513<\/option>514<\/option>515<\/option>516<\/option>517<\/option>518<\/option>519<\/option>520<\/option>521<\/option>522<\/option>523<\/option>524<\/option>525<\/option>526<\/option>527<\/option>528<\/option>529<\/option>530<\/option>531<\/option>532<\/option>533<\/option>534<\/option>535<\/option>536<\/option>537<\/option>538<\/option>539<\/option>540<\/option>541<\/option>542<\/option>543<\/option>544<\/option>545<\/option>546<\/option>547<\/option>548<\/option>549<\/option>550<\/option>551<\/option>552<\/option>553<\/option>554<\/option>555<\/option>556<\/option>557<\/option>558<\/option>559<\/option>560<\/option>561<\/option>562<\/option>563<\/option>564<\/option>565<\/option>566<\/option>567<\/option>568<\/option>569<\/option>570<\/option>571<\/option>572<\/option>573<\/option>574<\/option>575<\/option>576<\/option>577<\/option>578<\/option>579<\/option>580<\/option>581<\/option>582<\/option>583<\/option>584<\/option>585<\/option>586<\/option>587<\/option>588<\/option>589<\/option>590<\/option>591<\/option>592<\/option>593<\/option>594<\/option>595<\/option>596<\/option>597<\/option>598<\/option>599<\/option>600<\/option>601<\/option>602<\/option>603<\/option>604<\/option>605<\/option>606<\/option>607<\/option>608<\/option>609<\/option>610<\/option>611<\/option>612<\/option>613<\/option>614<\/option>615<\/option>616<\/option>617<\/option>618<\/option>619<\/option>620<\/option>621<\/option>622<\/option>623<\/option>624<\/option>625<\/option>626<\/option>627<\/option>628<\/option>629<\/option>630<\/option>631<\/option>632<\/option>633<\/option>634<\/option>635<\/option>636<\/option>637<\/option>638<\/option>639<\/option>640<\/option>641<\/option>642<\/option>643<\/option>644<\/option>645<\/option>646<\/option>647<\/option>648<\/option>649<\/option>650<\/option>651<\/option>652<\/option>653<\/option>”},{“row”:"",“fldName”:“ativo”,“fldType”:“select”,“numLinha”:"",“valList”:[{“label”:"",“value”:""}]},{“row”:"",“fldName”:“dt_cadastro”,“fldType”:“text”,“numLinha”:"",“valList”:[{“value”:" “}]},{“row”:”",“fldName”:“gparentesco”,“fldType”:“text”,“numLinha”:"",“valList”:[{“value”:""}]}],“msgDisplay”:{“msgText”:"",“numLinha”:""},“closeLine”:“N”,“clearUpload”:“S”,“navStatus”:{“ret”:“S”,“ava”:“S”},“navPage”:[],“quickSearchRes”:“N”,“eventField”:"__SC_NO_FIELD",“htmOutput”:"\r\n\r\n\r\n\r\n

Sugiro, excluir a pasta da aplicação em produção e publica-la novamente.

encontrei o erro. estava no evento afterupdate. mais engrcado que em desenvolvimento estava funcionando.
só comentei o script…

Vlw amigo.

Coloca como resolvido e apresenta o código que causava o erro para avaliarmos porque esse erro não apresentava em desenvolvimento.