0325096 发表于 2013-1-15 14:46:15

关联回访报错求助问题原因

//Correlation comment - Do not change!Original value='' Name ='CorrelationParameter_1'
        web_set_max_html_param_len("999999");
        web_reg_save_param_ex(
                "ParamName=CorrelationParameter_1",
                "LB=ALLOCATIONDETAILSID>",
                "RB=</ALLOCATIONDETAILSID",
                SEARCH_FILTERS,
                "Scope=All",
                "RequestUrl=*/sqlquery.do*",
                LAST);
        //lr_message({CorrelationParameter_1});
        web_custom_request("sqlquery.do_181",
                "URL=http://localhost:8080/fluxWmsV3Serv/sqlquery.do?reqvar=query",
                "Method=POST",
                "Resource=0",
                "RecContentType=text/html",
                "Referer=",
                "Snapshot=t283.inf",
                "Mode=HTTP",
                "EncType=text/xml; charset=GBK",
                "Body=<?xml version=\"1.0\" encoding=\"GBK\"?>\r\n"
                "<ROOT-INFUT>\r\n"
                " <FUNCTIONNAME>getRecord</FUNCTIONNAME>\r\n"
                " <ENCODING>GBK</ENCODING>\r\n"
                " <OPERATIONNAME />\r\n"
                " <USERID>qujing</USERID>\r\n"
                " <LOGIN-LANGUAGE>CN</LOGIN-LANGUAGE>\r\n"
                " <DBID>GOODBABY</DBID>\r\n"
                " <SERVLETNAME>sqlquery</SERVLETNAME>\r\n"
                " <METHOD-NAME>query</METHOD-NAME>\r\n"
                " <BUSINESS-DATA>\r\n"
                "<SQL-ITEM />\r\n"
                " </BUSINESS-DATA>\r\n"
                " <EXTEND>\r\n"
                "<SQL>selectACT_Allocation_Details.AllocationDetailsIDfrom ACT_Allocation_Details ACT_Allocation_Detailsleft join view_uom b on ACT_Allocation_Details.uom = b.uom and ACT_Allocation_Details.packid = b.packidleft join view_uom b1 on b1.uom = 'EA' and ACT_Allocation_Details.packid = b1.packidleft join INV_LOT_ATT INV_LOT_ATTon INV_LOT_ATT.LOTNUM = ACT_Allocation_Details.LOTNUMleft join BAS_SKU bas_skuon bas_sku.sku = ACT_Allocation_Details.sku and bas_sku.customerid = ACT_Allocation_Details.customeridleft join BAS_Package BAS_Package on BAS_Package.PackID = ACT_Allocation_Details.PackIDleft join doc_order_details doc_order_details on doc_order_details.orderno=ACT_Allocation_Details.ORDERNO and doc_order_details.ORDERLINENO=ACT_Allocation_Details.ORDERLINENOwhere ACT_Allocation_Details.OrderNo='SO121130018'</SQL>\r\n"
                "<SQL-WHERE />\r\n"
                "<RETURN-COLUMN-NAMES />\r\n"
                "<PAGEINDEX />\r\n"
                "<PAGESIZE />\r\n"
                "<SQL2 />\r\n"
                "<MAINKEY />\r\n"
                "<ORDERBYLIST />\r\n"
                " </EXTEND>\r\n"
                "</ROOT-INFUT>\r\n"
                "\r\n",
                LAST);

        //lr_rendezvous("HD1");

        web_custom_request("order.do_62",
                "URL=http://localhost:8080/fluxWmsV3Serv/order.do?reqvar=excuteSPSO_DeAllocation",
                "Method=POST",
                "Resource=0",
                "RecContentType=text/html",
                "Referer=",
                "Snapshot=t275.inf",
                "Mode=HTTP",
                "EncType=text/xml; charset=GBK",
                "Body=<?xml version=\"1.0\" encoding=\"GBK\"?>\r\n"
                "<ROOT-INFUT>\r\n"
                " <FUNCTIONNAME>excuteProcedure</FUNCTIONNAME>\r\n"
                " <ENCODING>GBK</ENCODING>\r\n"
                " <OPERATIONNAME />\r\n"
                " <USERID>qujing</USERID>\r\n"
                " <LOGIN-LANGUAGE>CN</LOGIN-LANGUAGE>\r\n"
                " <DBID>GOODBABY</DBID>\r\n"
                " <SERVLETNAME>order</SERVLETNAME>\r\n"
                " <METHOD-NAME>excuteSPSO_DeAllocation</METHOD-NAME>\r\n"
                " <BUSINESS-DATA>\r\n"
                "<SQL-ITEM>\r\n"
                "   <ORDERLINENO>1</ORDERLINENO>\r\n"
                "   <WAVENO />\r\n"
                "   <PROCESSBY>By AllocationDetailsID</PROCESSBY>\r\n"
                "   <ORDERNO>SO121130018</ORDERNO>\r\n"
                "   <AllocationDetailsID>{CorrelationParameter_1}</AllocationDetailsID>\r\n"
                "</SQL-ITEM>\r\n"
                " </BUSINESS-DATA>\r\n"
                " <EXTEND>\r\n"
                "<SQL />\r\n"
                "<SQL-WHERE />\r\n"
                "<RETURN-COLUMN-NAMES />\r\n"
                "<PAGEINDEX />\r\n"
                "<PAGESIZE />\r\n"
                "<SQL2 />\r\n"
                "<MAINKEY />\r\n"
                "<ORDERBYLIST />\r\n"
                " </EXTEND>\r\n"
                "</ROOT-INFUT>\r\n"
                "\r\n",
                LAST);
错误日志:
Starting action Action.
Action.c(46): web_set_max_html_param_len was successful       
Action.c(47): Registering web_reg_save_param_ex was successful       
Action.c(56): Error -35061: No match found for the requested parameter "CorrelationParameter_1". Check whether the requested boundaries exist in the response data. Also, if the data you want to save exceeds 999999 bytes, use web_set_max_html_param_len to increase the parameter size       
Action.c(56): web_custom_request("sqlquery.do_181") highest severity level was "ERROR", 584 body bytes, 219 header bytes       

0325096 发表于 2013-1-15 15:18:51



Starting action Action.
Action.c(8): web_set_max_html_param_len started       
Action.c(8): web_set_max_html_param_len was successful       
Action.c(9): web_reg_save_param_ex started       
Action.c(9): Registering web_reg_save_param_ex was successful       
Action.c(20): web_custom_request("sqlquery.do_35") started       
Action.c(20): t=477ms: Connecting to host 127.0.0.1:8080       
Action.c(20): t=481ms: Connected socket from 127.0.0.1:2207 to 127.0.0.1:8080 in 0 ms       
Action.c(20): t=485ms: 291-byte request headers for "http://localhost:8080/fluxWmsV3Serv/sqlquery.do?reqvar=query" (RelFrameId=1, Internal ID=1)
Action.c(20):   POST /fluxWmsV3Serv/sqlquery.do?reqvar=query HTTP/1.1\r\n
Action.c(20):   Content-Type: text/xml; charset=GBK\r\n
Action.c(20):   Cache-Control: no-cache\r\n
Action.c(20):   User-Agent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT)\r\n
Action.c(20):   Accept-Encoding: gzip, deflate\r\n
Action.c(20):   Accept: */*\r\n
Action.c(20):   Connection: Keep-Alive\r\n
Action.c(20):   Host: localhost:8080\r\n
Action.c(20):   Content-Length: 558\r\n
Action.c(20):   \r\n
Action.c(20): t=544ms: 558-byte request body for "http://localhost:8080/fluxWmsV3Serv/sqlquery.do?reqvar=query" (RelFrameId=1, Internal ID=1)
Action.c(20):   <?xml version="1.0" encoding="GBK"?>\r\n
Action.c(20):   <ROOT-INFUT>\r\n
Action.c(20):      <FUNCTIONNAME>getRecord</FUNCTIONNAME>\r\n
Action.c(20):      <ENCODING>GBK</ENCODING>\r\n
Action.c(20):      <OPERATIONNAME />\r\n
Action.c(20):      <USERID>wpsadmin</USERID>\r\n
Action.c(20):      <LOGIN-LANGUAGE>CN</LOGIN-LANGUAGE>\r\n
Action.c(20):      <DBID>WMS</DBID>\r\n
Action.c(20):      <SERVLETNAME>sqlquery</SERVLETNAME>\r\n
Action.c(20):      <METHOD-NAME>query</METHOD-NAME>\r\n
Action.c(20):      <BUSINESS-DATA>\r\n
Action.c(20):       <SQL-ITEM />\r\n
Action.c(20):      </BUSINESS-DATA>\r\n
Action.c(20):      <EXTEND>\r\n
Action.c(20):       <SQL>select qty from view_uom a   </SQL>\r\n
Action.c(20):       <SQL-WHERE />\r\n
Action.c(20):       <RETURN-COLUMN-NAMES />\r\n
Action.c(20):       <PAGEINDEX />\r\n
Action.c(20):       <PAGESIZE />\r\n
Action.c(20):       <SQL2 />\r\n
Action.c(20):       <MAINKEY />\r\n
Action.c(20):       <ORDERBYLIST />\r\n
Action.c(20):      </EXTEND>\r\n
Action.c(20):   </ROOT-INFUT>\r\n
Action.c(20):   \r\n
Action.c(20): t=681ms: 219-byte response headers for "http://localhost:8080/fluxWmsV3Serv/sqlquery.do?reqvar=query" (RelFrameId=1, Internal ID=1)
Action.c(20):   HTTP/1.1 200 OK\r\n
Action.c(20):   Server: Apache-Coyote/1.1\r\n
Action.c(20):   Set-Cookie: JSESSIONID=5C58E4A709770A198621546A735450E4; Path=/fluxWmsV3Serv\r\n
Action.c(20):   RESULT: 10\r\n
Action.c(20):   Content-Type: text/html\r\n
Action.c(20):   Content-Length: 620\r\n
Action.c(20):   Date: Tue, 15 Jan 2013 07:14:37 GMT\r\n
Action.c(20):   \r\n
Action.c(20): t=727ms: 620-byte response body for "http://localhost:8080/fluxWmsV3Serv/sqlquery.do?reqvar=query" (RelFrameId=1, Internal ID=1)
Action.c(20):   <?xml version="1.0" encoding="GBK"?>\r\n
Action.c(20):   <ROOT-OUT>\r\n
Action.c(20):       <RETURN-DATA DATA-SIZE="1">\r\n
Action.c(20):         <DATA-ITEM>\r\n
Action.c(20):         <QTY>1</QTY>\r\n
Action.c(20):         </DATA-ITEM>\r\n
Action.c(20):       </RETURN-DATA>\r\n
Action.c(20):       <RETURN-MESSAGE>\r\n
Action.c(20):         <MESSAGE-ITEM>0000Get Record Success,Return 1 Records.</MESSAGE-ITEM>\r\n
Action.c(20):         <MESSAGE-CODE>0000</MESSAGE-CODE>\r\n
Action.c(20):         <MESSAGE-MESSAGE>0000Get Record Success,Return 1 Records.</MESSAGE-MESSAGE>\r\n
Action.c(20):         <MESSAGE-SQL />\r\n
Action.c(20):         <MESSAGE-TOTALCOUNT>1</MESSAGE-TOTALCOUNT>\r\n
Action.c(20):         <MESSAGE-PAGEINDEX>1</MESSAGE-PAGEINDEX>\r\n
Action.c(20):         <MESSAGE-PAGESIZE>100</MESSAGE-PAGESIZE>\r\n
Action.c(20):         <MESSAGE-MAINKEY />\r\n
Action.c(20):         <MESSAGE-ORDERBYLIST />\r\n
Action.c(20):       </RETURN-MESSAGE>\r\n
Action.c(20):   </ROOT-OUT>\r\n
Action.c(20):   \r\n
Action.c(20): t=851ms: Request done "http://localhost:8080/fluxWmsV3Serv/sqlquery.do?reqvar=query"       
Action.c(20): Error -35061: No match found for the requested parameter "CorrelationParameter_1". Check whether the requested boundaries exist in the response data. Also, if the data you want to save exceeds 9999999 bytes, use web_set_max_html_param_len to increase the parameter size       
Action.c(20): web_custom_request("sqlquery.do_35") highest severity level was "ERROR", 620 body bytes, 219 header bytes       
Ending action Action.
Ending iteration 1.


关联左右边界应该没问题
页: [1]
查看完整版本: 关联回访报错求助问题原因