1 Reply Latest reply on Sep 13, 2013 7:32 PM by Sobers

    Issue in 4.0, query will not run but runs in Sqldevelper 3.1.

    Sobers

      I have a query that against the same instance will not run in 4.0 but will run in 3.1 on windows 7, 64 bit.  In the result set I get: Protocol violation: [5] 

      Below is the output when ran as a script:

       

       

      Error starting at line : 1 in command -

      select p.PRJCT_SEQ_NUM

        ,max(decode(Q.QSTN_CODE,'QDAS0131',a.ANSWR_TEXT,null)) PROJECT_OVERVIEW

        ,max(decode(Q.QSTN_CODE,'QDAS0131',a.ANSWR_TEXT,null)) RFP_ISSUES

        ,max(decode(Q.QSTN_CODE,'QDAS0064',a.ANSWR_TEXT,null)) LEGAL_ISSUES

        ,max(decode(Q.QSTN_CODE,'QDAS0135',a.ANSWR_TEXT,null)) MARKET

        ,max(decode(Q.QSTN_CODE,'QDAS0136',a.ANSWR_TEXT,null)) STEALTHING

        ,max(decode(Q.QSTN_CODE,'QDAS0137',a.ANSWR_TEXT,null)) COST_RISKS

        ,max(decode(Q.QSTN_CODE,'QDAS0138',a.ANSWR_TEXT,null)) SCHEDULING_RISKS

        ,max(decode(Q.QSTN_CODE,'QDAS0139',a.ANSWR_TEXT,null)) EXPECTED_START_QUARTER

        ,max(decode(Q.QSTN_CODE,'QDAS0140',a.ANSWR_TEXT,null)) EXPECTED_END_QUARTER

        ,max(decode(Q.QSTN_CODE,'QDAS0079',a.ANSWR_TEXT,null)) MAINTENANCE

        ,max(decode(Q.QSTN_CODE,'QDAS0080',a.ANSWR_TEXT,null)) SLA

        ,max(decode(Q.QSTN_CODE,'QDAS0081',a.ANSWR_TEXT,null)) OTHER_ISSUES

        ,max(decode(Q.QSTN_CODE,'QDAS0236',a.ANSWR_TEXT,null)) AGREEMENTS_NEEDED

        ,max(decode(Q.QSTN_CODE,'QDAS1114',a.ANSWR_TEXT,null)) CONTEMPLATED_UTILITIES

        ,max(decode(Q.QSTN_CODE,'QDAS0237',a.ANSWR_TEXT,null)) TIMELINE_UTILITIES

        ,max(decode(Q.QSTN_CODE,'QDAS0238',a.ANSWR_TEXT,null)) NONINVESTOR_OWNED_UTILITIES

        ,max(decode(Q.QSTN_CODE,'QDAS1164',a.ANSWR_TEXT,null)) FIBER_OPEX_UTILITIES

        ,max(decode(Q.QSTN_CODE,'QDAS1165',a.ANSWR_TEXT,null)) FIBER_CAPEX_UTILITIES

        ,max(decode(Q.QSTN_CODE,'QDAS1166',a.ANSWR_TEXT,null)) NODE_OPEX_UTILITIES

        ,max(decode(Q.QSTN_CODE,'QDAS1167',a.ANSWR_TEXT,null)) NODE_CAPEX_UTILITIES

        ,max(decode(Q.QSTN_CODE,'QDAS0239',a.ANSWR_TEXT,null)) RISKS_UTILITIES

        ,max(decode(Q.QSTN_CODE,'QDAS0231',a.ANSWR_TEXT,null)) FRANCHISE_AUTHORIZATION

        ,max(decode(Q.QSTN_CODE,'QDAS0233',a.ANSWR_TEXT,null)) ZONING_PERMITS_NEEDED

        ,max(decode(Q.QSTN_CODE,'QDAS1110',a.ANSWR_TEXT,null)) CONTEMPLATED_JURISDICTIONS

        ,max(decode(Q.QSTN_CODE,'QDAS1112',a.ANSWR_TEXT,null)) NONPUBLIC_RO_JURISDICTIONS

        ,max(decode(Q.QSTN_CODE,'QDAS0234',a.ANSWR_TEXT,null)) TIMELINE

        ,max(decode(Q.QSTN_CODE,'QDAS1160',a.ANSWR_TEXT,null)) FIBER_OPEX_JURISDICTION

        ,max(decode(Q.QSTN_CODE,'QDAS1161',a.ANSWR_TEXT,null)) FIBER_CAPEX_JURISDICTION

        ,max(decode(Q.QSTN_CODE,'QDAS1162',a.ANSWR_TEXT,null)) NODE_OPEX_JURISDICTION

        ,max(decode(Q.QSTN_CODE,'QDAS1163',a.ANSWR_TEXT,null)) NODE_CAPEX_JURISDICTION

        ,max(decode(Q.QSTN_CODE,'QDAS0235',a.ANSWR_TEXT,null)) RISKS_JURISDICTION

        ,max(decode(Q.QSTN_CODE,'QDAS0067',a.ANSWR_TEXT,null)) CAPACITY_OR_COVERAGE

        ,max(decode(Q.QSTN_CODE,'QDAS0068',a.ANSWR_TEXT,null)) TECHNOLOGY

        ,max(decode(Q.QSTN_CODE,'QDAS0069',a.ANSWR_TEXT,null)) FREQUENCY_BANDS

        ,max(decode(Q.QSTN_CODE,'QDAS0070',a.ANSWR_TEXT,null)) RF_DESIGN_SSUES

        ,max(decode(Q.QSTN_CODE,'QDAS0073',a.ANSWR_TEXT,null)) ANTENNA_VENDOR_MODEL

        ,max(decode(Q.QSTN_CODE,'QDAS1100',a.ANSWR_TEXT,null)) HW_PROVIDER_LKUP

        ,max(decode(Q.QSTN_CODE,'QDAS0074',a.ANSWR_TEXT,null)) DAS_SMALLCELL_VENDOR_MODEL

        ,max(decode(Q.QSTN_CODE,'QDAS0075',a.ANSWR_TEXT,null)) COLOCATION_CHANGES_REQUIRED

        ,max(decode(Q.QSTN_CODE,'QDAS0076',a.ANSWR_TEXT,null)) EQUIPMENT_SUPPORTED

        ,max(decode(Q.QSTN_CODE,'QDAS0077',a.ANSWR_TEXT,null)) LEAD_TIME_AND_RISKS

        ,max(decode(Q.QSTN_CODE,'QDAS0116',a.ANSWR_TEXT,null)) TOTAL_FIBER_MILES

        ,max(decode(Q.QSTN_CODE,'QDAS0117',a.ANSWR_TEXT,null)) FIBER_PROFILE 

        ,max(decode(Q.QSTN_CODE,'QDAS0118',a.ANSWR_TEXT,null)) NODES_FIBER_MILES

        ,max(decode(Q.QSTN_CODE,'QDAS0119',a.ANSWR_TEXT,null)) FIBER_COST_NODE

        ,max(decode(Q.QSTN_CODE,'QDAS0120',a.ANSWR_TEXT,null)) FIBER_COST_MILE

        ,max(decode(Q.QSTN_CODE,'QDAS0133',a.ANSWR_TEXT,null)) FIBER_OWNERSHIP 

        ,max(decode(Q.QSTN_CODE,'QDAS0134',a.ANSWR_TEXT,null)) DARK_FIBER_OPPORTUNITY

      from WORK_TASK_QUESTION q, WORK_TASK_ANSWER a,work_task_project_xref p, work_task w

      where a.WORK_TASK_SEQ_NUM = p.WORK_TASK_SEQ_NUM

      and w.WORK_TASK_SEQ_NUM= p.WORK_TASK_SEQ_NUM

      and a.QSTN_CODE =q.QSTN_CODE

      and q.QSTN_CODE in

      ( 'QDAS0131' ,'QDAS0063' ,'QDAS0064' ,'QDAS0135' ,'QDAS0136' ,'QDAS0137' ,'QDAS0138' ,'QDAS0139'

      , 'QDAS0140' ,'QDAS0079' ,'QDAS0080' ,'QDAS0081' ,'QDAS0236' ,'QDAS1114' ,'QDAS0237' ,'QDAS0238'

      , 'QDAS1164' ,'QDAS1165' ,'QDAS1166' ,'QDAS1167' ,'QDAS0239' ,'QDAS0231' ,'QDAS0233' ,'QDAS1110'

      , 'QDAS1112' ,'QDAS0234' ,'QDAS1160' ,'QDAS1161' ,'QDAS1162' ,'QDAS1163' ,'QDAS0235' ,'QDAS0067'

      , 'QDAS0068' ,'QDAS0069' ,'QDAS0070' ,'QDAS0073' ,'QDAS1100' ,'QDAS0074' ,'QDAS0075' ,'QDAS0076'

      , 'QDAS0077' ,'QDAS0116' ,'QDAS0117' ,'QDAS0118' ,'QDAS0119' ,'QDAS0120' ,'QDAS0133' ,'QDAS0134' )

      group by p.prjct_seq_num

      order by 1

      Error at Command Line : 1 Column : 1

      Error report -

      SQL Error: Protocol violation: [1]