The application use C#, MVC, NHibernate with Oracle show me msg:
Table or viw doesn’t exists.
But if i update (simple update) the web.config, the problem is solved.
I set IIS pool of application to restart 3 times at day, but not solved.
Can help me?
IIS VERSION: 10.0
nhibernate version: 4.0.0.4000
<?xml version="1.0" encoding="utf-8"?>
<!--
For more information on how to configure your ASP.NET application, please visit
http://go.microsoft.com/fwlink/?LinkId=301880
-->
<configuration>
<configSections>
<section name="log4net" type="log4net.Config.Log4NetConfigurationSectionHandler,log4net" />
</configSections>
<connectionStrings>
<add name="LUA" connectionString="Data Source=PROD; User Id=***;Password=***; Min Pool Size=0; Max Pool Size=400; Pooling=true;" />
<add name="ESI" connectionString="Data Source=PROD; User Id=***;Password=***; Min Pool Size=0; Max Pool Size=400; Pooling=true;" />
<add name="SEG" connectionString="Data Source=PROD; User Id=***;Password=***; Min Pool Size=0; Max Pool Size=400; Pooling=true;" />
<add name="SOL" connectionString="Data Source=PROD; User Id=***;Password=***; Min Pool Size=0; Max Pool Size=400; Pooling=true;" />
</connectionStrings>
<appSettings>
<add key="emailDefault" value="****" />
<add key="webpages:Version" value="3.0.0.0" />
<add key="webpages:Enabled" value="false" />
<add key="ClientValidationEnabled" value="true" />
<add key="UnobtrusiveJavaScriptEnabled" value="true" />
<add key="LogAtivo" value="false" />
<add key="pathAD" value="LDAP://base-pdc" />
<add key="pathADAlt" value="LDAP://base-mea" />
<add key="domain" value="lider" />
<add key="strconn_sgq" value="DATA SOURCE=***;PASSWORD=***;PERSIST SECURITY INFO=True;USER ID=SHAREPOINT" />
<add key="Versao_Jornada" value="6.1.0" />
<add key="ENDERECO_DBDIGITAL_FILES" value="\***" />
<add key="Ambiente" value="DSV" />
<add key="LinkExterno" value="***.com.br" />
<add key="API_ASSINATURA_RDV" value="***" />
<add key="Versao" value="1.2.0"/>
<add key="ENDERECO_VERSAO_GIOPE" value="***" />
<add key="ENDERECO_EXISTE_NOVA_VERSAO_GIOPE" value="***" />
<add key="ENDERECO_LISTAR_VERSAO_GIOPE" value="***" />
<add key="ENDERECO_CONFIRMAR_LEITURA_GIOPE" value="***" />
<add key="ENDERECO_RETORNAR_VERSOES" value="***" />
<!--ALERTA COVID - JORNADA-->
<add key="USUARIO_ALERTA_COVID" value="***" />
<add key="USUARIO_EMAIL_ALERTA_COVID" value="***" />
<add key="SENHA_ALERTA_COVID" value="***" />
<add key="DESTINATARIOS_ALERTA_COVID" value="***" />
</appSettings>
<system.webServer>
<handlers>
<remove name="ExtensionlessUrlHandler-Integrated-4.0" />
<remove name="OPTIONSVerbHandler" />
<remove name="TRACEVerbHandler" />
<add name="ExtensionlessUrlHandler-Integrated-4.0" path="*." verb="*" type="System.Web.Handlers.TransferRequestHandler" preCondition="integratedMode,runtimeVersionv4.0" />
</handlers>
<security>
<requestFiltering>
<requestLimits maxQueryString="1000000" />
</requestFiltering>
</security>
<httpProtocol>
<customHeaders>
<add name="Access-Control-Allow-Credentials" value="true" />
<add name="Access-Control-Allow-Headers" value="accept,authorization,content-type" />
<add name="Access-Control-Allow-Methods" value="GET,HEAD,POST,DEBUG,PUT,DELETE,PATCH,OPTIONS" />
<add name="Access-Control-Allow-Origin" value="*" />
</customHeaders>
</httpProtocol>
</system.webServer>
<system.web>
<customErrors mode="Off" />
<compilation debug="true" targetFramework="4.5" />
<httpRuntime maxQueryStringLength="1000000" maxUrlLength="1000000" maxRequestLength="1048576" targetFramework="4.5" />
<globalization culture="pt-BR" uiCulture="pt-BR" />
<authentication mode="None" />
<sessionState timeout="120"></sessionState>
</system.web>
<system.web.extensions>
<scripting>
<webServices>
<jsonSerialization maxJsonLength="500000000" />
</webServices>
</scripting>
</system.web.extensions>
<runtime>
<assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1">
<dependentAssembly>
<assemblyIdentity name="System.Web.Optimization" publicKeyToken="31bf3856ad364e35" />
<bindingRedirect oldVersion="1.0.0.0-1.1.0.0" newVersion="1.1.0.0" />
</dependentAssembly>
<dependentAssembly>
<assemblyIdentity name="WebGrease" publicKeyToken="31bf3856ad364e35" />
<bindingRedirect oldVersion="0.0.0.0-1.5.2.14234" newVersion="1.5.2.14234" />
</dependentAssembly>
<dependentAssembly>
<assemblyIdentity name="itextsharp" publicKeyToken="8354ae6d2174ddca" culture="neutral" />
<bindingRedirect oldVersion="0.0.0.0-5.0.5.0" newVersion="5.0.5.0" />
</dependentAssembly>
<dependentAssembly>
<assemblyIdentity name="System.Web.Helpers" publicKeyToken="31bf3856ad364e35" />
<bindingRedirect oldVersion="1.0.0.0-3.0.0.0" newVersion="3.0.0.0" />
</dependentAssembly>
<dependentAssembly>
<assemblyIdentity name="System.Web.WebPages" publicKeyToken="31bf3856ad364e35" />
<bindingRedirect oldVersion="1.0.0.0-3.0.0.0" newVersion="3.0.0.0" />
</dependentAssembly>
<dependentAssembly>
<assemblyIdentity name="System.Web.Mvc" publicKeyToken="31bf3856ad364e35" />
<bindingRedirect oldVersion="0.0.0.0-5.2.3.0" newVersion="5.2.3.0" />
</dependentAssembly>
<dependentAssembly>
<assemblyIdentity name="Newtonsoft.Json" publicKeyToken="30ad4fe6b2a6aeed" culture="neutral" />
<bindingRedirect oldVersion="0.0.0.0-9.0.0.0" newVersion="9.0.0.0" />
</dependentAssembly>
<dependentAssembly>
<assemblyIdentity name="System.Web.Http" publicKeyToken="31bf3856ad364e35" culture="neutral" />
<bindingRedirect oldVersion="0.0.0.0-5.2.3.0" newVersion="5.2.3.0" />
</dependentAssembly>
<dependentAssembly>
<assemblyIdentity name="System.Net.Http.Formatting" publicKeyToken="31bf3856ad364e35" culture="neutral" />
<bindingRedirect oldVersion="0.0.0.0-5.2.3.0" newVersion="5.2.3.0" />
</dependentAssembly>
</assemblyBinding>
</runtime>
</configuration>
When update the web.config, the problem is solved.
New contributor
Herbert Freitas is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.