Announcement

**azuniga** · 10 Apr 2012, 08:18

Originally posted by Isomorphic

This is just a warning and the system appears to have guessed correctly what you want anyway. However if you want to get rid of the warning, make sure the field names are all correct (they are case sensitive) and that the foreignKey declaration is in the correct DataSource (the "many" side of "many-to-one").

Are you still having any difficulty aside from this warning?

I am still unable to upload the file. I am now using a trial version of 3.0 EE. Our purchase of 3.0 Power is processing on our side, so that will take a while. I can't use 2.5 power that we have b/c my code is 3.0 dependant on some API's, specifically SQLDataSource. Here is the dev console server logs:

Code:

=== 2012-04-10 16:02:11,850 [ng)'] INFO  Compression - /MyApplication/MyApplication/sc/IDACall: 149487 -> 8680 bytes
=== 2012-04-10 16:02:18,305 [ng)'] INFO  RequestContext - URL: '/MyApplication/MyApplication/clientLoggerService', User-Agent: 'Mozilla/5.0 (X11; Linux i686 on x86_64; rv:8.0.1) Gecko/20100101 Firefox/8.0.1': Moz (Gecko) with Accept-Encoding header
=== 2012-04-10 16:02:23,125 [ng)'] INFO  RequestContext - URL: '/MyApplication/MyApplication/sc/IDACall', User-Agent: 'Mozilla/5.0 (X11; Linux i686 on x86_64; rv:8.0.1) Gecko/20100101 Firefox/8.0.1': Moz (Gecko) with Accept-Encoding header
=== 2012-04-10 16:02:23,139 [ng)'] INFO  Compression - /MyApplication/MyApplication/sc/IDACall: 149517 -> 8704 bytes
=== 2012-04-10 16:02:34,985 [ng)'] INFO  Download - Returning 304: Not modified on conditional get of: /opt/oracle/middleware/user_projects/domains/MYAPP_MyApplication/servers/AdminServer-MYAPP_MyApplication/tmp/_WL_user/MyApplication/tzo134/war/MyApplication/sc/skins/Enterprise/images/button/button_Over_stretch.png
=== 2012-04-10 16:02:34,985 [ng)'] INFO  Download - Returning 304: Not modified on conditional get of: /opt/oracle/middleware/user_projects/domains/MYAPP_MyApplication/servers/AdminServer-MYAPP_MyApplication/tmp/_WL_user/MyApplication/tzo134/war/MyApplication/sc/skins/Enterprise/images/button/button_Over_end.png
=== 2012-04-10 16:02:34,988 [ng)'] INFO  Download - Returning 304: Not modified on conditional get of: /opt/oracle/middleware/user_projects/domains/MYAPP_MyApplication/servers/AdminServer-MYAPP_MyApplication/tmp/_WL_user/MyApplication/tzo134/war/MyApplication/sc/skins/Enterprise/images/button/button_Over_start.png
=== 2012-04-10 16:02:35,218 [ng)'] INFO  Download - Returning 304: Not modified on conditional get of: /opt/oracle/middleware/user_projects/domains/MYAPP_MyApplication/servers/AdminServer-MYAPP_MyApplication/tmp/_WL_user/MyApplication/tzo134/war/MyApplication/sc/skins/Enterprise/images/button/button_Down_start.png
=== 2012-04-10 16:02:35,223 [ng)'] INFO  Download - Returning 304: Not modified on conditional get of: /opt/oracle/middleware/user_projects/domains/MYAPP_MyApplication/servers/AdminServer-MYAPP_MyApplication/tmp/_WL_user/MyApplication/tzo134/war/MyApplication/sc/skins/Enterprise/images/button/button_Down_stretch.png
=== 2012-04-10 16:02:35,223 [ng)'] INFO  Download - Returning 304: Not modified on conditional get of: /opt/oracle/middleware/user_projects/domains/MYAPP_MyApplication/servers/AdminServer-MYAPP_MyApplication/tmp/_WL_user/MyApplication/tzo134/war/MyApplication/sc/skins/Enterprise/images/button/button_Down_end.png
=== 2012-04-10 16:02:35,382 [ng)'] INFO  Download - Returning 304: Not modified on conditional get of: /opt/oracle/middleware/user_projects/domains/MYAPP_MyApplication/servers/AdminServer-MYAPP_MyApplication/tmp/_WL_user/MyApplication/tzo134/war/MyApplication/sc/skins/Enterprise/images/button/button_end.png
=== 2012-04-10 16:02:35,382 [ng)'] INFO  Download - Returning 304: Not modified on conditional get of: /opt/oracle/middleware/user_projects/domains/MYAPP_MyApplication/servers/AdminServer-MYAPP_MyApplication/tmp/_WL_user/MyApplication/tzo134/war/MyApplication/sc/skins/Enterprise/images/button/button_start.png
=== 2012-04-10 16:02:35,382 [ng)'] INFO  Download - Returning 304: Not modified on conditional get of: /opt/oracle/middleware/user_projects/domains/MYAPP_MyApplication/servers/AdminServer-MYAPP_MyApplication/tmp/_WL_user/MyApplication/tzo134/war/MyApplication/sc/skins/Enterprise/images/button/button_stretch.png
=== 2012-04-10 16:02:35,411 [ng)'] INFO  RequestContext - URL: '/MyApplication/MyApplication/sc/IDACall', User-Agent: 'Mozilla/5.0 (X11; Linux i686 on x86_64; rv:8.0.1) Gecko/20100101 Firefox/8.0.1': Moz (Gecko) with Accept-Encoding header
=== 2012-04-10 16:02:35,413 [ng)'] DEBUG XML - Parsed XML from (in memory stream): 1ms
=== 2012-04-10 16:02:35,414 [ng)'] DEBUG RPCManager - Processing 1 requests.
=== 2012-04-10 16:02:35,415 [ng)'] DEBUG RPCManager - Request #1 (DSRequest) payload: {
    values:{
        attachment_contents:"azuniga-Table.pdf",
        ATTACHMENT_ID:11004,
        attachment_name:"azuniga8",
        _transaction:null
    },
    operationConfig:{
        dataSource:"ReportattachmentDataSource",
        operationType:"add"
    },
    componentId:"isc_DynamicForm_6",
    appID:"builtinApplication",
    operation:"ReportattachmentDataSource_add",
    oldValues:{
    },
    criteria:{
    }
}
=== 2012-04-10 16:02:35,415 [ng)'] INFO  IDACall - Performing 1 operation(s)
=== 2012-04-10 16:02:35,415 [ng)'] DEBUG AppBase - [builtinApplication.ReportattachmentDataSource_add] No userTypes defined, allowing anyone access to all operations for this application
=== 2012-04-10 16:02:35,415 [ng)'] DEBUG AppBase - [builtinApplication.ReportattachmentDataSource_add] No public zero-argument method named '_ReportattachmentDataSource_add' found, performing generic datasource operation
=== 2012-04-10 16:02:35,415 [ng)'] INFO  SQLDataSource - [builtinApplication.ReportattachmentDataSource_add] Performing add operation with
	criteria: {attachment_contents:"azuniga-Table.pdf",ATTACHMENT_ID:11004,attachment_name:"azuniga8",_transaction:null}	values: {attachment_contents:"azuniga-Table.pdf",ATTACHMENT_ID:11004,attachment_name:"azuniga8",_transaction:null}
=== 2012-04-10 16:02:35,415 [ng)'] INFO  SQLValuesClause - [builtinApplication.ReportattachmentDataSource_add] Ignored data for non-existent or included columns: [_transaction]
=== 2012-04-10 16:02:35,415 [ng)'] DEBUG SQLValuesClause - [builtinApplication.ReportattachmentDataSource_add] Sequences: {}
=== 2012-04-10 16:02:35,416 [ng)'] DEBUG PoolableSQLConnectionFactory - [builtinApplication.ReportattachmentDataSource_add] Returning pooled Connection
=== 2012-04-10 16:02:35,416 [ng)'] DEBUG SQLTransaction - [builtinApplication.ReportattachmentDataSource_add] Started new Oracle transaction "127"
=== 2012-04-10 16:02:35,416 [ng)'] INFO  SQLDriver - [builtinApplication.ReportattachmentDataSource_add] Executing SQL update on 'Oracle': INSERT INTO REPORT_attachment (ATTACHMENT_ID, attachment_contents, attachment_name) VALUES (11004, ?, 'azuniga8')
=== 2012-04-10 16:02:35,417 [ng)'] WARN  RequestContext - dsRequest.execute() failed: 
=== 2012-04-10 16:02:35,417 [ng)'] DEBUG RPCManager - Content type for RPC transaction: text/html; charset=UTF-8
=== 2012-04-10 16:02:35,417 [ng)'] DEBUG SQLTransaction - Rolling back Oracle transaction "127"
=== 2012-04-10 16:02:35,417 [ng)'] DEBUG RPCManager - non-DMI response, dropExtraFields: false
=== 2012-04-10 16:02:35,418 [ng)'] DEBUG SQLTransaction - Ending Oracle transaction "127"
=== 2012-04-10 16:02:35,418 [ng)'] INFO  Compression - /MyApplication/MyApplication/sc/IDACall: 593 -> 370 bytes
=== 2012-04-10 16:02:35,753 [ng)'] INFO  Download - Returning 304: Not modified on conditional get of: /opt/oracle/middleware/user_projects/domains/MYAPP_MyApplication/servers/AdminServer-MYAPP_MyApplication/tmp/_WL_user/MyApplication/tzo134/war/MyApplication/sc/skins/Enterprise/images/Dialog/warn.png
=== 2012-04-10 16:02:35,776 [ng)'] INFO  Download - Returning 304: Not modified on conditional get of: /opt/oracle/middleware/user_projects/domains/MYAPP_MyApplication/servers/AdminServer-MYAPP_MyApplication/tmp/_WL_user/MyApplication/tzo134/war/MyApplication/sc/skins/Enterprise/images/Window/window_T.png
=== 2012-04-10 16:02:35,776 [ng)'] INFO  Download - Returning 304: Not modified on conditional get of: /opt/oracle/middleware/user_projects/domains/MYAPP_MyApplication/servers/AdminServer-MYAPP_MyApplication/tmp/_WL_user/MyApplication/tzo134/war/MyApplication/sc/skins/Enterprise/images/blank.gif
=== 2012-04-10 16:02:35,776 [ng)'] INFO  Download - Returning 304: Not modified on conditional get of: /opt/oracle/middleware/user_projects/domains/MYAPP_MyApplication/servers/AdminServer-MYAPP_MyApplication/tmp/_WL_user/MyApplication/tzo134/war/MyApplication/sc/skins/Enterprise/images/Window/window_TL.png
=== 2012-04-10 16:02:35,777 [ng)'] INFO  Download - Returning 304: Not modified on conditional get of: /opt/oracle/middleware/user_projects/domains/MYAPP_MyApplication/servers/AdminServer-MYAPP_MyApplication/tmp/_WL_user/MyApplication/tzo134/war/MyApplication/sc/skins/Enterprise/images/Window/window_BL.png
=== 2012-04-10 16:02:35,777 [ng)'] INFO  Download - Returning 304: Not modified on conditional get of: /opt/oracle/middleware/user_projects/domains/MYAPP_MyApplication/servers/AdminServer-MYAPP_MyApplication/tmp/_WL_user/MyApplication/tzo134/war/MyApplication/sc/skins/Enterprise/images/Window/window_TR.png
=== 2012-04-10 16:02:35,777 [ng)'] INFO  Download - Returning 304: Not modified on conditional get of: /opt/oracle/middleware/user_projects/domains/MYAPP_MyApplication/servers/AdminServer-MYAPP_MyApplication/tmp/_WL_user/MyApplication/tzo134/war/MyApplication/sc/skins/Enterprise/images/Window/window_B.png
=== 2012-04-10 16:02:35,777 [ng)'] INFO  Download - Returning 304: Not modified on conditional get of: /opt/oracle/middleware/user_projects/domains/MYAPP_MyApplication/servers/AdminServer-MYAPP_MyApplication/tmp/_WL_user/MyApplication/tzo134/war/MyApplication/sc/skins/Enterprise/images/Window/window_R.png
=== 2012-04-10 16:02:35,778 [ng)'] INFO  Download - Returning 304: Not modified on conditional get of: /opt/oracle/middleware/user_projects/domains/MYAPP_MyApplication/servers/AdminServer-MYAPP_MyApplication/tmp/_WL_user/MyApplication/tzo134/war/MyApplication/sc/skins/Enterprise/images/Window/window_BR.png
=== 2012-04-10 16:02:35,778 [ng)'] INFO  Download - Returning 304: Not modified on conditional get of: /opt/oracle/middleware/user_projects/domains/MYAPP_MyApplication/servers/AdminServer-MYAPP_MyApplication/tmp/_WL_user/MyApplication/tzo134/war/MyApplication/sc/skins/Enterprise/images/Window/window_L.png
=== 2012-04-10 16:02:39,350 [ng)'] INFO  RequestContext - URL: '/MyApplication/MyApplication/sc/IDACall', User-Agent: 'Mozilla/5.0 (X11; Linux i686 on x86_64; rv:8.0.1) Gecko/20100101 Firefox/8.0.1': Moz (Gecko) with Accept-Encoding header

I get a warning popup message that says Missing IN or OUT parameter at index:: 1. My next step is to try your Firebug suggestion.

**azuniga** · 10 Apr 2012, 09:07

Originally posted by Isomorphic

The error is poorly reported server side because the Oracle JDBC driver throws some exceptions where exception.toString() is blank (amazing but true). But what appears to be happening is that no file has actually arrived at the server.

Note the warning toward the top - you have mixed versions and need to fix this first. This could be the issue.

If that's not the problem, check with Firebug's "Net" panel to verify that a file is actually send to the server. If it is, check for any servlet filters that you've installed in front of IDACall - some such filters are known to extract and remove the file before it reaches IDACAll (Struts and Spring in some modes will both do this).

It seems like the file is being sent. Here is the information from the Firebug "Net" panel.

Code:

Request URL:
    http://my.server:6004/MyApplication/myapplication/sc/IDACall?isc_rpc=1&isc_v=v8.2p_2012-03-27&isc_tnum=19
  
  
    Request Method:
    POST
  
  
    Status Code:
    HTTP/1.1 200 OK
  



  
    Request Headers
    16:35:12.902
  
  Accept:text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8Accept-Charset:ISO-8859-1,utf-8;q=0.7,*;q=0.7Accept-Encoding:gzip, deflateAccept-Language:en-us,en;q=0.5Connection:keep-aliveDNT:1Host:g1-mrsa033:6004Referer:http://g1-mrsa033:6004/ProductAnalysisInterface/ProductAnalysisInterface.htmlUser-Agent:Mozilla/5.0 (X11; Linux i686 on x86_64; rv:8.0.1) Gecko/20100101 Firefox/8.0.1

  
    Sent Cookie
    ADMINCONSOLESESSION:xXJhPGpBY69nJLpfKndQv5phX9vzpLJsn51hr22cVblYTNhhPDB2!-1038130282GLog:%7B%0D%20%20%20%20left%3A0%2C%20%0D%20%20%20%20top%3A27%2C%20%0D%20%20%20%20width%3A1662%2C%20%0D%20%20%20%20height%3A884%2C%20%0D%20%20%20%20priorityDefaults%3A%7B%0D%20%20%20%20%20%20%20%20Log%3A4%0D%20%20%20%20%7D%2C%20%0D%20%20%20%20defaultPriority%3A3%2C%20%0D%20%20%20%20trackRPC%3Atrue%0D%7DJSESSIONID:b4SRPGYXRhh2Q8pGGWDZFb7GhvVyvn2VYvB3lkXJ7QPhKSmwhg35!-1038130282isc_cState:ready

Request Body
    Content-Type: multipart/form-data; boundary=---------------------------188675418457997281942769045

Content-Length: 3380



-----------------------------188675418457997281942769045

Content-Disposition: form-data; name="attachment_contents"; filename="azuniga-Table.pdf"

Content-Type: application/pdf



%PDF-1.5
%����
4 0 obj
<</Length 490/Filter/FlateDecode>>stream
x�*�[o�@���W�#Hh��]��KA �J�%�M���d��n�{fk��B�"y2���9#瑽)�����r�nJ�`�Lx �q]=��5]٩�����~u�N���r�p��Σ*�а����]��ŧ�!_��B��6泗�N�bǤ�����V��Ci����m��f`^Ū)�' �y7�
�]m�	��C���s�(M|NUL�J����F�l!��!^��6�r9��m��P/<p4N��9�;���V;��\�z
J�Α�w�D����݇��z�Q�֡5�y�2�Mn<�t��[_dۻ��\!��$�@��X�R�|ݦ0��o���.�@��=�~��Htt�F)A�� �p�&��QgF�yJq[�&MY��7���)
�����-����N��~��P�|�,FI��R��LU�mފ�+��H�r2O�XcaQ�i��H�F�E�6Ͷ����v rA�Nw�Tj���gՏ͡��ף M
endstream
endobj
10 0 obj
<</Names 9 0 R/Type/Catalog/PageMode/UseNone/Pages 5 0 R>>
endobj
11 0 obj
<</Creator(BIRT Report Engine /myapplication/war/WEB-INF/lib/org.eclipse.birt.runtime_3.7.1.v20110913-1734.jar using iText /myapplication/war/WEB-INF/lib/org.eclipse.birt.runtime_3.7.1.v20110913-1734.jar.)/Producer(iText 2.1.7 by 1T3XT)/Title(Anomalous Report)/ModDate(D:20120112145557Z)/CreationDate(D:20120112145557Z)>>
endobj
6 0 obj
<</Type/ObjStm/N 7/Length 331/First 40/Filter/FlateDecode>>stream
x��RMo�@�+s�����hbH�k�6DHjK�Yab��KX0��;��=�Խ�G޼�ov-0�Χ`wl�`q�
�`;���N`>g�Z���Z�P�EĖx.2ܬ|��RW�F�]=��]���P��J�ݗ=I(�6�U[g��:�Ua	��/
���`�-.nq�c����t@j�
L�����Q��ao��W�� �����x�y�X=v���-K����Cci��;V����"����,3���>
�$u�SG���P�$�?�}U��d[��x����}��T�nZڼ�^�\���.N���n�W�x�qg>����鑦ò�᳥�
endstream
endobj
12 0 obj
<</Type/XRef/W[1 2 2]/Root 10 0 R/Index[0 13]/ID [<4f57f5ed3cad6d1e92b114c0e86da52c><0cdbe14f9c08d3d29c1b63e545c2afac>]/Length 50/Info 11 0 R/Size 13/Filter/FlateDecode>>stream
x�%ʱ

I don't know anything about servlet filters so I'll have to look into your next suggestion.

**azuniga** · 10 Apr 2012, 09:43

It now seems like the file is not being sent. I can no longer see the request body in the "Net" tab. Here is what I now see.

Code:

Request URL:
    http://myurl/MyApplication/MyApplication/sc/IDACall?isc_rpc=1&isc_v=v8.2p_2012-03-27&isc_tnum=11
  
  
    Request Method:
    POST
  
  
    Status Code:
    HTTP/1.1 200 OK
  



  
    Request Headers
    17:18:27.221
  
  Accept:text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8Accept-Charset:ISO-8859-1,utf-8;q=0.7,*;q=0.7Accept-Encoding:gzip, deflateAccept-Language:en-us,en;q=0.5Connection:keep-aliveDNT:1Host:myurlReferer:http://myurl/MyApplication/MyApplication.htmlUser-Agent:Mozilla/5.0 (X11; Linux i686 on x86_64; rv:8.0.1) Gecko/20100101 Firefox/8.0.1

  
    Sent Cookie
    ADMINCONSOLESESSION:xXJhPGpBY69nJLpfKndQv5phX9vzpLJsn51hr22cVblYTNhhPDB2!-1038130282GLog:%7B%0D%20%20%20%20left%3A0%2C%20%0D%20%20%20%20top%3A27%2C%20%0D%20%20%20%20width%3A1662%2C%20%0D%20%20%20%20height%3A884%2C%20%0D%20%20%20%20priorityDefaults%3A%7B%0D%20%20%20%20%20%20%20%20Log%3A4%0D%20%20%20%20%7D%2C%20%0D%20%20%20%20defaultPriority%3A3%2C%20%0D%20%20%20%20trackRPC%3Atrue%0D%7DJSESSIONID:b4SRPGYXRhh2Q8pGGWDZFb7GhvVyvn2VYvB3lkXJ7QPhKSmwhg35!-1038130282isc_cState:ready
  

  
  



  
    Response Headers
    Δ15ms
  
  Cache-Control:no-cacheContent-Encoding:gzipContent-Length:369Content-Type:text/html; charset=UTF-8Date:Tue, 10 Apr 2012 17:18:27 GMTExpires:Tue, 10 Apr 2012 17:18:27 GMTPragma:no-cacheX-Included-Test:trueX-Included-Test2:trueX-Powered-By:Servlet/3.0 JSP/2.2

  
    
      Response Body
      Δ0ms
    
    <HTML>
<BODY ONLOAD='var results = document.formResults.results.value;while (!window.isc && document.domain.indexOf(".") != -1) {try { parent.isc; break} catch (e) {document.domain = document.domain.replace(/.*?\./, "")}}parent.isc.Comm.hiddenFrameReply(11,results)'><BR><BR><BR><BR><BR><BR><BR><BR><BR><BR><BR><BR><BR><BR><BR><BR><BR><BR><FORM name='formResults'><TEXTAREA readonly name='results'>
//isc_RPCResponseStart-->[{data:"Missing IN or OUT parameter at index:: 1",invalidateCache:false,isDSResponse:true,queueStatus:-1,status:-1}]//isc_RPCResponseEnd</TEXTAREA></FORM>
</BODY></HTML>

What is this message about missing in out parameter?

**Isomorphic** · 10 Apr 2012, 10:47

The error message is Oracle saying that it received a SQL statement that involved a parameter but the parameter was not provided (because the file never made it to the server, which is still the root cause here).

**azuniga** · 10 Apr 2012, 11:36

Originally posted by Isomorphic

The error message is Oracle saying that it received a SQL statement that involved a parameter but the parameter was not provided (because the file never made it to the server, which is still the root cause here).

The behavior of Firebug is weird. The first instance that a file is sent to the server I am able to see the Request Body, then it won't show it again, which is what lead me to believe the file wasn't being sent. When I tried in Dev Mode, the request body was not being shown but the file was still uploaded to the server. I think the file is being sent to the server. Something is happening on the server that the file is not part of the SQL insert. Back to looking into the servlet filters research.

**azuniga** · 10 Apr 2012, 11:47

The problem seems to be with WebLogic 12C. Is SmartClient compatible with 12C? I deployed my application to WebLogic 11g and the file uploads A OK. Not the same with 12C. Is there a known issue with 12C before I start investigating anything?

**Isomorphic** · 10 Apr 2012, 11:50

No, there's no known issue, although a quick Google for "file upload broken weblogic 12" hits a thread where someone seems to be having a similar problem.

**azuniga** · 12 Apr 2012, 06:07

Originally posted by Isomorphic

No, there's no known issue, although a quick Google for "file upload broken weblogic 12" hits a thread where someone seems to be having a similar problem.

We installed a patch from WebLogic and are now able to upload files. Thank you for your help.

**Isomorphic** · 19 Apr 2012, 08:57

To help us improve the error reporting in this area, could you please share your exact Oracle version, and that of the JDBC driver you are using?

**susanpemble** · 13 Jun 2012, 07:18

I work with AZ and can provide the info you requested:
We use WebLogic Server version 12.1.1.0 with Oracle Instant client driver v11.2.0.20a (ojdbc6)

**Isomorphic** · 13 Jun 2012, 07:36

Thanks for letting us know.

We ended up putting in some generic error handling that will print as much information as we can get when a driver does something ridiculous like throw an exception with no error message.

**Arka79** · 2 Aug 2012, 04:34

Hi, we have very similar issue. Issue have raised after migrating system from glassfish 3.1 to glassfish 3.1.2.
What was the fix with weblogic 12c?

**azuniga** · 2 Aug 2012, 04:36

Our server folks applied the patches released by WebLogic. That solved the issue for us. I can't speak as to which patches they were b/c I don't know, however I can say there is nothing else that we did to make this work.

**Arka79** · 2 Aug 2012, 10:37

Originally posted by Arka79 View Post

Hi, we have very similar issue. Issue have raised after migrating system from glassfish 3.1 to glassfish 3.1.2.
What was the fix with weblogic 12c?

The same as with weblogic 12c. There is a bug and a patch in glassfish 3.1.2 web-core.jar:
http://java.net/jira/browse/GLASSFISH-18444

Announcement

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment