9 Replies Latest reply on Jul 11, 2017 7:03 AM by Alessandro Ghezzi

    FP v11.6 Database Error 203 when trying to add an attachment

      Share This:

      Hi there,

       

      An agent was trying to add an attachment to a ticket, however, a 'Database Error 203' message appears and the log shows the following:

       

      Database Error 203

       

      mrAttach error: DBD::ODBC::st execute failed: [Oracle][ODBC][Ora]ORA-12899: value too large for column "FP"."MASTER2"."MRATTACHMENTS" (actual: 2020, maximum: 2000)

      (SQL-HY000) at E:\Footprints\\cgi\SUBS\mrAttach.pl line 192, <ATTACHFILE> line 17.

      <BR><BR>

      UPDATE MASTER2 SET mrATTACHMENTS=? WHERE (mrID=40168) <BR><BR>

       

      STDERR output:

       

      DBI/DBD Error: mrAttach error:

      DBD::ODBC::st execute failed: [Oracle][ODBC][Ora]ORA-12899: value too large for column "FP"."MASTER2"."MRATTACHMENTS" (actual: 2020, maximum: 2000)

      (SQL-HY000) at E:\Footprints\\cgi\SUBS\mrAttach.pl line 192, <ATTACHFILE> line 17.

       

      UPDATE MASTER2 SET mrATTACHMENTS=? WHERE (mrID=40168)

       

      ORACLE_HOME: E:\Footprints\bin\OracleClient

      LD_LIBRARY_PATH: E:\Footprints\bin\OracleClient

      ORACLE_SID: FPRINT

      more

       

      Stack trace:

      file:E:\Footprints\cgi\MRdirectEdit2.pl, line:1708, sub:MRdirectEdit2::AddAttachments

      file:E:\Footprints\cgi\MRdirectEdit2.pl, line:3187, sub:FP::mrAttach

      file:E:\Footprints\\cgi\SUBS\mrAttach.pl, line:221, sub:FP::errorExit

      file:E:/Footprints/cgi/mrDatabaseLib.pl, line:589, sub:FP::Errorpage

      file:E:\Footprints\\cgi\SUBS\Errorpage.pl, line:426, sub:FP::LogErrorpage

      file:E:\Footprints\\cgi\SUBS\Errorpage.pl, line:1565, sub:FP::WriteLog

      file:E:\Footprints\\cgi\SUBS\WriteLog.pl, line:163, sub:FP::printStackTrace

       

      Environment:

      ABMASTER:E:\Footprints\db\ABMASTER1

      ABNAME:-TEXTREPLACED-

      ALLUSERSPROFILE:C:\ProgramData

      APPDATA:C:\Windows\system32\config\systemprofile\AppData\Roaming

      APP_POOL_ID:DefaultAppPool

      AUTH_PASSWORD:

      AUTH_TYPE:

      AUTH_USER:

      CERT_COOKIE:

      CERT_FLAGS:

      CERT_ISSUER:

      CERT_SERIALNUMBER:

      CERT_SUBJECT:

      CMI:E:\Footprints\

      CMMASTER:E:\Footprints\db\MASTER2

      COMMONPROGRAMFILES:C:\Program Files\Common Files

      COMMONPROGRAMFILES(X86):C:\Program Files (x86)\Common Files

      COMMONPROGRAMW6432:C:\Program Files\Common Files

      COMPUTERNAME:-TEXTREPLACED-

      COMSPEC:E:\Footprints\\bin\cmd.exe

      CONTENT_LENGTH:9128

      CONTENT_TYPE:application/x-www-form-urlencoded

      FP_NO_HOST_CHECK:NO

      GATEWAY_INTERFACE:CGI/1.1

      HTTPS:on

      HTTPS_KEYSIZE:256

      HTTPS_SECRETKEYSIZE:2048

      HTTPS_SERVER_ISSUER:C=US, O="Entrust, Inc.", OU=See www.entrust.net/legal-terms, OU="(c) 2012 Entrust, Inc. - for authorized use only", CN=Entrust Certification Authority - L1K

      HTTPS_SERVER_SUBJECT:C=-TEXTREPLACED-, S=-TEXTREPLACED-, L=-TEXTREPLACED-, O="-TEXTREPLACED-)", CN=footprints.-TEXTREPLACED-.com

      HTTP_ACCEPT:text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,image/apng,*/*;q=0.8

      HTTP_ACCEPT_ENCODING:gzip, deflate, br

      HTTP_ACCEPT_LANGUAGE:en-GB,en-US;q=0.8,en;q=0.6

      HTTP_CACHE_CONTROL:max-age=0

      HTTP_CONNECTION:keep-alive

      HTTP_CONTENT_LENGTH:9128

      HTTP_CONTENT_TYPE:application/x-www-form-urlencoded

      HTTP_COOKIE:popupBlockerDisabled=true; TinyMCE_curdesc_size=cw%3D836%26ch%3D407; TinyMCE_descrpt_size=cw%3D836%26ch%3D135; __qca=P0-1214481079-1452249113091; calltrk_referrer=direct; calltrk_landing=https%3A//www.-TEXTREPLACED-.com/; calltrk_session_id_684719830=bafdfddf-f384-4c3d-9105-8098727a649e; s_lv=1489486471235; _vis_opt_exp_24_exclude=1; _mkto_trk=id:512-JJP-615&token:_mch--TEXTREPLACED-.com-1492700691934-23649; _vis_opt_s=9%7C; _vwo_uuid_v2=E2FD6ABE665E6A3D0B8AC2D16E0DC85A|257884ed29b2865b9ded79f24e6d4572; visid_incap_1154146=RPULQkPPQGK7bHdc81XbAyfDFVkAAAAAQkIPAAAAAADyUFqRX81N4AUaewjWwsKE; visid_incap_1154132=kVUNcGK2TZO/vVemwjg4Oj+yGlkAAAAAQUIPAAAAAAAxcbedgzm6zGvkoVLXXswz; __utma=223448334.1011917871.1452249117.1489486453.1494921791.11; __utmz=223448334.1486377541.9.1.utmcsr=(direct)|utmccn=(direct)|utmcmd=(none); SSESSe03879e89105b08285cd13dbfa8e65bc=TZw90EDXlfPhsjTUeMg5_2R9X-9uVUJaSVA0w92ahFA; _ga=GA1.2.1011917871.1452249117; session_key=388dca8e440248d20a575861142db393973ec308178bbe1f4b84b143c3c76591; ys-homepageGrid--TEXTREPLACED--1=o%3Acolumns%3De%3A1%5Esort%3Do%253Afield%253Ds%25253Apriority%255Edirection%253Ds%25253AASC%5Efilters%3Do%253A; DocumentWidth=1800

      HTTP_HOST:footprints.-TEXTREPLACED-.com

      HTTP_ORIGIN:https://footprints.-TEXTREPLACED-.com

      HTTP_REFERER:https://footprints.-TEXTREPLACED-.com/MRcgi/MRTicketPage.pl

      HTTP_UPGRADE_INSECURE_REQUESTS:1

      HTTP_USER_AGENT:Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/59.0.3071.115 Safari/537.36

      INSTANCE_ID:1

      LD_LIBRARY_PATH:E:\Footprints\bin\OracleClient:E:\Footprints\bin\OracleClient

      LOCALAPPDATA:C:\Windows\system32\config\systemprofile\AppData\Local

      LOCAL_ADDR:-TEXTREPLACED-

      LOGON_USER:

      MRT:2017-07-04 03:28:12

      MRTZ:-TEXTREPLACED-

      MRU:-TEXTREPLACED-

      MRWEB:1

      NUMBER_OF_PROCESSORS:6

      ORACLE_HOME:E:\Footprints\bin\OracleClient

      ORACLE_SID:FPRINT

      OS:Windows_NT

      PATH:E:\Footprints\bin;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Program Files\System Center Operations Manager 2007\;C:\Program Files\Microsoft\Web Platform Installer\;E:\Footprints\bin\OracleClient;E:\Footprints\bin\Perl\bin;;E:\Footprints\bin\perl\bin

      PATHEXT:.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC

      PATH_INFO:/MRcgi/MRdirectEdit2.pl

      PATH_TRANSLATED:E:\Footprints\cgi\MRdirectEdit2.pl

      PERL_LWP_SSL_VERIFY_HOSTNAME:0

      PROCESSOR_ARCHITECTURE:AMD64

      PROCESSOR_IDENTIFIER:Intel64 Family 6 Model 37 Stepping 1, GenuineIntel

      PROCESSOR_LEVEL:6

      PROCESSOR_REVISION:2501

      PROGRAMDATA:C:\ProgramData

      PROGRAMFILES:C:\Program Files

      PROGRAMFILES(X86):C:\Program Files (x86)

      PROGRAMW6432:C:\Program Files

      PROJECT_NAME:Technology Application Development

      PSMODULEPATH:C:\Windows\system32\WindowsPowerShell\v1.0\Modules\;C:\Program Files\Microsoft Monitoring Agent\Agent\PowerShell\

      PUBLIC:C:\Users\Public

      QUERY_STRING:

      REMOTE_ADDR:10.128.20.118

      REMOTE_HOST:10.128.20.118

      REMOTE_USER:

      REQUEST_METHOD:POST

      SCRIPT_NAME:/MRcgi/MRdirectEdit2.pl

      SERVER_NAME:footprints.-TEXTREPLACED-.com

      SERVER_PORT:443

      SERVER_PORT_SECURE:1

      SERVER_PROTOCOL:HTTP/1.1

      SERVER_SOFTWARE:Microsoft-IIS/7.5

      SQLPATH:E:\Footprints\bin\OracleClient

      SYSTEMDRIVE:C:

      SYSTEMROOT:C:\Windows

      TEMP:E:\Footprints\temp

      TMP:E:\Footprints\temp

      TMPDIR:E:\Footprints\temp

      TNS_ADMIN:E:\Footprints\bin\OracleClient

      UATDATA:C:\Windows\CCM\UATData\D9F8C395-CAB8-491d-B8AC-179A1FE1BE77

      UNMAPPED_REMOTE_USER:

      USERDOMAIN:-TEXTREPLACED-

      USERNAME:-TEXTREPLACED-

      USERPROFILE:C:\Windows\system32\config\systemprofile

      WINDIR:C:\Windows

       

      There are seven attachments currently on the ticket and nine attachments have been removed as well. The agent is trying to add at least another 2 attachments, which are well below the size limit set for attachments.

       

      Can anyone help with this issue please? Will there need to be downtime to resolve this or can it be done on the fly after a backup of the database?

       

      Thanks in advance

       

      Ste