3 Replies Latest reply: Nov 30, 2012 4:59 AM by 977212 RSS

    Foms err while trying the upload the images for the second time.pls assist

    977212
      ORA-01403: no data found
      ORA-06512: at "MCP_AGENT.MCP_IMAGE_NEW", line 370
      ORA-06512: at line 31

      DAD name: mcparts_ctct
      PROCEDURE : MCP_IMAGE_NEW.INSERT_NEW_PHOTO
      URL : http://cidcssdapp010.cidc.cummins.com:7777/mcparts_ctct/MCP_IMAGE_NEW.INSERT_NEW_PHOTO
      PARAMETERS :
      ===========
      new_description:

      entry_id:
      bks8vxt
      new_photo:
      F27962/ppn_his.bmp

      ENVIRONMENT:
      ============
      PLSQL_GATEWAY=WebDb
      GATEWAY_IVERSION=2
      SERVER_SOFTWARE=Oracle-Application-Server-10g/10.1.2.2.0 Oracle-HTTP-Server
      GATEWAY_INTERFACE=CGI/1.1
      SERVER_PORT=7777
      SERVER_NAME=cidcssdapp010.cidc.cummins.com
      REQUEST_METHOD=POST
      QUERY_STRING=
      PATH_INFO=/MCP_IMAGE_NEW.INSERT_NEW_PHOTO
      SCRIPT_NAME=/mcparts_ctct
      REMOTE_HOST=
      REMOTE_ADDR=157.227.6.51
      SERVER_PROTOCOL=HTTP/1.1
      REQUEST_PROTOCOL=HTTP
      REMOTE_USER=mcp_agent
      ORACLE_SSO_USER=
      OSSO_IDLE_TIMEOUT_EXCEEDED=
      OSSO_USER_GUID=
      HTTP_CONTENT_LENGTH=3686859
      HTTP_CONTENT_TYPE=multipart/form-data; boundary=---------------------------7dc22039cb115e
      HTTP_USER_AGENT=Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; Trident/4.0; AskTbORJ/5.15.4.23821)
      HTTP_HOST=cidcssdapp010.cidc.cummins.com:7777
      HTTP_ACCEPT=*/*
      HTTP_ACCEPT_ENCODING=
      HTTP_ACCEPT_LANGUAGE=en-us
      HTTP_ACCEPT_CHARSET=
      HTTP_COOKIE=
      HTTP_IF_MODIFIED_SINCE=
      HTTP_REFERER=http://cidcssdapp010.cidc.cummins.com:7777/mcparts_ctct/mcp_image.view_upload_form?entry_id=bks8vxt
      HTTP_SOAPACTION=
      HTTP_ORACLE_ECID=93988733700,1
      HTTP_ORACLE_CACHE_VERSION=10.1.2
      HTTP_AUTHORIZATION=
      WEB_AUTHENT_PREFIX=
      DAD_NAME=mcparts_ctct
      DOC_ACCESS_PATH=docs
      DOCUMENT_TABLE=photos_upload
      PATH_ALIAS=
      REQUEST_CHARSET=WE8ISO8859P1
      REQUEST_IANA_CHARSET=ISO-8859-1
      SCRIPT_PREFIX=
      HTTP_IF_MATCH=
      HTTP_CACHE_CONTROL=
      SOAP_BODY=
      HTTP_X_ORACLE_DEVICE_CLASS=
      HTTP_X_ORACLE_DEVICE_ORIENTATION=
      HTTP_X_ORACLE_DEVICE_MAXDOCSIZE=
      HTTP_X_ORACLE_DEVICE=
      HTTP_X_ORACLE_ORIG_ACCEPT=
      HTTP_X_ORACLE_ORIG_USER_AGENT=
      HTTP_X_ORACLE_USER_LOCALE=
      HTTP_X_ORACLE_USER_NAME=
      HTTP_X_ORACLE_USER_DISPLAYNAME=
      HTTP_X_ORACLE_USER_USERKIND=
      HTTP_X_ORACLE_USER_AUTHKIND=
      HTTP_X_ORACLE_USER_DEVICEID=
      HTTP_X_ORACLE_USER_LOCATION_ADDRESSLINE1=
      HTTP_X_ORACLE_USER_LOCATION_ADDRESSLINE2=
      HTTP_X_ORACLE_USER_LOCATION_ADDRESSLASTLINE=
      HTTP_X_ORACLE_USER_LOCATION_BLOCK=
      HTTP_X_ORACLE_USER_LOCATION_CITY=
      HTTP_X_ORACLE_USER_LOCATION_COMPANYNAME=
      HTTP_X_ORACLE_USER_LOCATION_COUNTY=
      HTTP_X_ORACLE_USER_LOCATION_STATE=
      HTTP_X_ORACLE_USER_LOCATION_POSTALCODE=
      HTTP_X_ORACLE_USER_LOCATION_POSTALCODEEXT=
      HTTP_X_ORACLE_USER_LOCATION_COUNTRY=
      HTTP_X_ORACLE_USER_LOCATION_TYPE=
      HTTP_X_ORACLE_USER_LOCATION_X=
      HTTP_X_ORACLE_USER_LOCATION_Y=
      HTTP_X_ORACLE_SERVICE_HOME_URL=
      HTTP_X_ORACLE_SERVICE_PARENT_URL=
      HTTP_X_ORACLE_HOME_URL=
      HTTP_X_ORACLE_MODULE_CALLBACK_URL=
      HTTP_X_ORACLE_MODULE_CALLBACK_LABEL=
      HTTP_X_ORACLE_CACHE_USER=
      HTTP_X_ORACLE_CACHE_SUBID=
      HTTP_X_ORACLE_CACHE_AUTH=
      HTTP_X_ORACLE_CACHE_DEVICE=
      HTTP_X_ORACLE_CACHE_LANG=
      HTTP_X_ORACLE_CACHE_ENCRYPT=
      HTTP_X_ORACLE_ASSERT_USER=