8 Replies Latest reply on Jul 26, 2012 10:27 PM by Hussein Sawwan-Oracle

    Error trying to check whether the job will be importing

    bharat-oracle
      Hi,

      I am getting the below message error when I try to upload the data through webADI,is there any limit for loading the records that we can upload using web ADI? we tried to load near to 10,000 records and it's giving me an error on window and gets stuck without actually displaying the error message, when I check the Bne log I see the below message.

      BneAsyncUploadPage.renderPage Error trying to check whether the job will be importing.
      BneAsyncUploadPage.renderPage Parameter value is not a Boolean.

      Note: When I tried to upload 1000 records , it's working good.

      Thanks,
      Bharat
        • 1. Re: Error trying to check whether the job will be importing
          Hussein Sawwan-Oracle
          Please see these docs.

          How to Create a BNE Log For Web Adi Issues and Errors? [ID 817023.1]
          Error While Uploading Report Manager Templates: A System Error Has Occured. Have Your System Administrator View The Bne.log File [ID 797297.1]
          The Connection To The Server Is Unavailable When Uploading Journals From WebADI [ID 361944.1]

          Thanks,
          Hussein
          • 2. Re: Error trying to check whether the job will be importing
            Ashish_Apps
            Try increasing record count to 5000 and see if error occurs
            • 3. Re: Error trying to check whether the job will be importing
              bharat-oracle
              Its working okay until (around) 7000 records, but when we have to load 9000 records we are getting error on a window without actually displaying the error message.
              • 4. Re: Error trying to check whether the job will be importing
                Hussein Sawwan-Oracle
                940534 wrote:
                Its working okay until (around) 7000 records, but when we have to load 9000 records we are getting error on a window without actually displaying the error message.
                Please post the complete error message from the BNE.log file.

                Thanks,
                Hussein
                • 5. Re: Error trying to check whether the job will be importing
                  bharat-oracle
                  7/26/12 11:55 AM AJPRequestHandler-HTTPThreadGroup-3 TRACE BneAsyncUploadPageParameters:processEvent() Start
                  7/26/12 11:55 AM AJPRequestHandler-HTTPThreadGroup-3 TRACE BneUIMessages:clearAll() errors.size = 0 infos.size = 0 warnings.size = 0 confirms.size = 0
                  7/26/12 11:55 AM AJPRequestHandler-HTTPThreadGroup-3 TRACE BneWebAppsContext:getValidContext() Start.
                  7/26/12 11:55 AM AJPRequestHandler-HTTPThreadGroup-3 TRACE BneOracleWebAppsContext.getUserId() End, userId = 79087
                  7/26/12 11:55 AM AJPRequestHandler-HTTPThreadGroup-3 TRACE Profile: BNE_ALLOW_SET_PARAMETERS = Y
                  7/26/12 11:55 AM AJPRequestHandler-HTTPThreadGroup-3 TRACE BneOracleWebAppsContext.getUserId() End, userId = 79087
                  7/26/12 11:55 AM AJPRequestHandler-HTTPThreadGroup-3 TRACE BneOracleWebAppsContext.getExtraJDBCConnection assigned connection oracle.jdbc.driver.T4CConnection@e46a2
                  7/26/12 11:55 AM AJPRequestHandler-HTTPThreadGroup-3 TRACE BneAsyncUploadPageBean.allowSetParameters true
                  7/26/12 11:55 AM AJPRequestHandler-HTTPThreadGroup-3 TRACE BneOracleWebAppsContext.isUPSCustomization start
                  7/26/12 11:55 AM AJPRequestHandler-HTTPThreadGroup-3 TRACE BneOracleWebAppsContext.getUserId() End, userId = 79087
                  7/26/12 11:55 AM AJPRequestHandler-HTTPThreadGroup-3 TRACE BneOracleWebAppsContext.getUserId() End, userId = 79087
                  7/26/12 11:55 AM AJPRequestHandler-HTTPThreadGroup-3 TRACE BneOracleWebAppsContext.getUserId() End, userId = 79087
                  7/26/12 11:55 AM AJPRequestHandler-HTTPThreadGroup-3 TRACE BneOracleWebAppsContext.getUserId() End, userId = 79087
                  7/26/12 11:55 AM AJPRequestHandler-HTTPThreadGroup-3 TRACE BneOracleWebAppsContext.getUserId() End, userId = 79087
                  7/26/12 11:55 AM AJPRequestHandler-HTTPThreadGroup-3 TRACE BneOracleWebAppsContext.getUserId() End, userId = 79087
                  7/26/12 11:55 AM AJPRequestHandler-HTTPThreadGroup-3 TRACE BneOracleWebAppsContext.getUserId() End, userId = 79087
                  7/26/12 11:55 AM AJPRequestHandler-HTTPThreadGroup-3 TRACE BneOracleWebAppsContext.getUserId() End, userId = 79087
                  7/26/12 11:55 AM AJPRequestHandler-HTTPThreadGroup-3 TRACE BneOracleWebAppsContext.getUserId() End, userId = 79087
                  7/26/12 11:55 AM AJPRequestHandler-HTTPThreadGroup-3 TRACE BneOracleWebAppsContext.getUserId() End, userId = 79087
                  7/26/12 11:55 AM AJPRequestHandler-HTTPThreadGroup-3 TRACE BneOracleWebAppsContext.getUserId() End, userId = 79087
                  7/26/12 11:55 AM AJPRequestHandler-HTTPThreadGroup-3 TRACE BneOracleWebAppsContext.getUserId() End, userId = 79087
                  7/26/12 11:55 AM AJPRequestHandler-HTTPThreadGroup-3 TRACE BneAsyncUploadPageParameters:processEvent() End
                  7/26/12 11:55 AM AJPRequestHandler-HTTPThreadGroup-3 TRACE BneBasePageController.processPageEvent() end.
                  7/26/12 11:55 AM AJPRequestHandler-HTTPThreadGroup-3 TRACE BneAsyncUploadPage.renderPage Start.
                  7/26/12 11:55 AM AJPRequestHandler-HTTPThreadGroup-3 TRACE BneWebAppsContext:getValidContext() Start.
                  7/26/12 11:55 AM AJPRequestHandler-HTTPThreadGroup-3 TRACE BneOracleWebAppsContext.getUserId() End, userId = 79087
                  7/26/12 11:55 AM AJPRequestHandler-HTTPThreadGroup-3 TRACE Profile: BNE_DOCUMENT_LIFETIME =
                  7/26/12 11:55 AM AJPRequestHandler-HTTPThreadGroup-3 TRACE BneSecurity.checkAccess(): checking access for INTEGRATOR: 20003:GENERAL_62_INTG
                  7/26/12 11:55 AM AJPRequestHandler-HTTPThreadGroup-3 TRACE BneWebAppsContext:getValidContext() Start.
                  7/26/12 11:55 AM AJPRequestHandler-HTTPThreadGroup-3 TRACE BneOracleWebAppsContext.getUserId() End, userId = 79087
                  7/26/12 11:55 AM AJPRequestHandler-HTTPThreadGroup-3 TRACE BneSecurity.checkAccess(): a system administrator. return true
                  7/26/12 11:55 AM AJPRequestHandler-HTTPThreadGroup-3 ERROR BneAsyncUploadPage.renderPage Error trying to check whether the job will be importing.
                  7/26/12 11:55 AM AJPRequestHandler-HTTPThreadGroup-3 ERROR BneAsyncUploadPage.renderPage Parameter value is not a Boolean.
                  7/26/12 11:55 AM AJPRequestHandler-HTTPThreadGroup-3 TRACE BneOracleWebAppsContext.getUserId() End, userId = 79087
                  7/26/12 11:55 AM AJPRequestHandler-HTTPThreadGroup-3 TRACE BneOracleWebAppsContext.getUserId() End, userId = 79087
                  7/26/12 11:55 AM AJPRequestHandler-HTTPThreadGroup-3 TRACE BneOracleWebAppsContext.getUserId() End, userId = 79087
                  7/26/12 11:55 AM AJPRequestHandler-HTTPThreadGroup-3 TRACE BneOracleWebAppsContext.getUserId() End, userId = 79087
                  7/26/12 11:55 AM AJPRequestHandler-HTTPThreadGroup-3 TRACE BneOracleWebAppsContext.getUserId() End, userId = 79087
                  7/26/12 11:55 AM AJPRequestHandler-HTTPThreadGroup-3 TRACE BneOracleWebAppsContext.getUserId() End, userId = 79087
                  7/26/12 11:55 AM AJPRequestHandler-HTTPThreadGroup-3 TRACE BneJDBCUtils.commit() current connection: oracle.jdbc.driver.T4CConnection@e46a2
                  7/26/12 11:55 AM AJPRequestHandler-HTTPThreadGroup-3 TRACE BneDateUtils.getSYSDATE() Start
                  7/26/12 11:55 AM AJPRequestHandler-HTTPThreadGroup-3 TRACE BneDateUtils.getSYSDATE() Start
                  7/26/12 11:55 AM AJPRequestHandler-HTTPThreadGroup-3 TRACE BneOracleWebAppsContext.getUserId() End, userId = 79087
                  7/26/12 11:55 AM AJPRequestHandler-HTTPThreadGroup-3 TRACE BneOracleWebAppsContext.getUserId() End, userId = 79087
                  7/26/12 11:55 AM AJPRequestHandler-HTTPThreadGroup-3 TRACE BneOracleWebAppsContext.getUserId() End, userId = 79087
                  7/26/12 11:55 AM AJPRequestHandler-HTTPThreadGroup-3 TRACE BneOracleWebAppsContext.getUserId() End, userId = 79087
                  7/26/12 11:55 AM AJPRequestHandler-HTTPThreadGroup-3 TRACE BneOracleWebAppsContext.getUserId() End, userId = 79087
                  7/26/12 11:55 AM AJPRequestHandler-HTTPThreadGroup-3 TRACE BneOracleWebAppsContext.getUserId() End, userId = 79087
                  7/26/12 11:55 AM AJPRequestHandler-HTTPThreadGroup-3 TRACE BneJDBCUtils.commit() current connection: oracle.jdbc.driver.T4CConnection@e46a2
                  7/26/12 11:55 AM AJPRequestHandler-HTTPThreadGroup-3 TRACE BneBasePageController:getPage() Start
                  7/26/12 11:55 AM AJPRequestHandler-HTTPThreadGroup-3 TRACE BneBasePageController:getPage() Creating a page reference, for page = oracle.apps.bne.webui.pageflow.BneAsyncUploadPageSend
                  7/26/12 11:55 AM AJPRequestHandler-HTTPThreadGroup-3 TRACE BneBasePageController:getPage() class detail, name = oracle.apps.bne.webui.pageflow.BneAsyncUploadPageSend
                  7/26/12 11:55 AM AJPRequestHandler-HTTPThreadGroup-3 TRACE BneBasePageController:getPage() End
                  7/26/12 11:55 AM AJPRequestHandler-HTTPThreadGroup-3 TRACE BneAsyncUploadPageSend:createPage() Start
                  7/26/12 11:55 AM AJPRequestHandler-HTTPThreadGroup-3 TRACE BneOracleWebAppsContext.getUserId() End, userId = 79087
                  7/26/12 11:55 AM AJPRequestHandler-HTTPThreadGroup-3 TRACE BneAsyncUploadPageSend:createPage() End
                  7/26/12 11:55 AM AJPRequestHandler-HTTPThreadGroup-3 TRACE BneBasePageController.createPageBody() End.
                  7/26/12 11:55 AM AJPRequestHandler-HTTPThreadGroup-3 TRACE BneBasePageController.handlePageHead() start.
                  7/26/12 11:55 AM AJPRequestHandler-HTTPThreadGroup-3 TRACE BneBasePageController.handlePageHead() end.
                  7/26/12 11:55 AM AJPRequestHandler-HTTPThreadGroup-3 TRACE BneBasePageController.handlePage() Done
                  7/26/12 11:55 AM AJPRequestHandler-HTTPThreadGroup-3 TRACE BneBajaServlet.setupResponse() Start
                  7/26/12 11:55 AM AJPRequestHandler-HTTPThreadGroup-3 TRACE BneWebAppsContext:getValidContext() Start.
                  7/26/12 11:55 AM AJPRequestHandler-HTTPThreadGroup-3 TRACE BneOracleWebAppsContext.getUserId() End, userId = 79087
                  7/26/12 11:55 AM AJPRequestHandler-HTTPThreadGroup-3 TRACE Profile: ICX_CLIENT_IANA_ENCODING = UTF-8
                  7/26/12 11:55 AM AJPRequestHandler-HTTPThreadGroup-3 TRACE BneBajaServlet.getRenderingContext() Response.setContentType = text/html; charset=UTF-8
                  7/26/12 11:55 AM AJPRequestHandler-HTTPThreadGroup-3 TRACE BneOracleWebAppsContext.getUserId() End, userId = 79087
                  7/26/12 11:55 AM AJPRequestHandler-HTTPThreadGroup-3 TRACE BnePerformanceStatistics - Wrote 0 of 3 statistics in 0 Milliseconds.
                  7/26/12 11:55 AM AJPRequestHandler-HTTPThreadGroup-3 TRACE BneJDBCUtils.commit() current connection: oracle.jdbc.driver.T4CConnection@b3ea0f
                  7/26/12 11:55 AM AJPRequestHandler-HTTPThreadGroup-3 TRACE BneJDBCUtils.commit() current connection: oracle.jdbc.driver.T4CConnection@e46a2
                  7/26/12 11:55 AM AJPRequestHandler-HTTPThreadGroup-3 TRACE BneOracleWebAppsContext.releaseContext() Web Event Duration = 0.083(s)
                  7/26/12 11:55 AM AJPRequestHandler-HTTPThreadGroup-3 TRACE Exit BneApplicationService.handleRequest()
                  7/26/12 12:00 PM Web ADI Cache Sweeper TRACE BneCache.cacheSweeper: sweep starting ...
                  7/26/12 12:00 PM Web ADI Cache Sweeper TRACE Cache Summary
                  Cache Region: Default Cache , Size: 0 , hitRatio: 0 /0 , puts: 0 , removes: 0 , cleared: 0 , swept: 0 , hashCode: 0
                  Cache Region: Generic SQL Statements , Size: 0 , hitRatio: 0 /0 , puts: 0 , removes: 0 , cleared: 0 , swept: 0 , hashCode: 0
                  Cache Region: Web ADI Repository Objects , Size: 36 , hitRatio: 289 /310 , puts: 36 , removes: 0 , cleared: 0 , swept: 0 , hashCode: -144528918
                  Cache Region: Web ADI Parameter Lists , Size: 12 , hitRatio: 15 /27 , puts: 12 , removes: 0 , cleared: 0 , swept: 0 , hashCode: 376128196
                  Cache Region: Web ADI Parameter Definitions , Size: 28 , hitRatio: 69 /97 , puts: 28 , removes: 0 , cleared: 0 , swept: 0 , hashCode: -1860472108
                  7/26/12 12:00 PM Web ADI Cache Sweeper TRACE BneWebAppsContext:getValidContext() Start.
                  7/26/12 12:00 PM Web ADI Cache Sweeper TRACE BneContext:getBneDbcFilename() Start.
                  7/26/12 12:00 PM Web ADI Cache Sweeper TRACE BneContext:getBneDbcFilename() Done, filename = /applmgr/ebsuat/inst/apps/ebsuat_ebs121v/appl/fnd/12.0.0/secure/ebsuat.dbc
                  7/26/12 12:00 PM Web ADI Cache Sweeper TRACE BneWebAppsContext:getValidContext() Start.
                  7/26/12 12:00 PM Web ADI Cache Sweeper TRACE BneJDBCUtils.commit() current connection: oracle.jdbc.driver.T4CConnection@e46a2
                  7/26/12 12:00 PM Web ADI Cache Sweeper TRACE BneCache.cacheSweeper: Default Cache : 0 cleared, time: 0 mSecs
                  7/26/12 12:00 PM Web ADI Cache Sweeper TRACE BneCache.cacheSweeper: Generic SQL Statements : 0 cleared, time: 0 mSecs
                  7/26/12 12:00 PM Web ADI Cache Sweeper TRACE BneCache.cacheSweeper: Web ADI Repository Objects : 0 cleared, time: 0 mSecs
                  7/26/12 12:00 PM Web ADI Cache Sweeper TRACE BneCache.cacheSweeper: Web ADI Parameter Lists : 0 cleared, time: 0 mSecs
                  7/26/12 12:00 PM Web ADI Cache Sweeper TRACE BneCache.cacheSweeper: Web ADI Parameter Definitions : 0 cleared, time: 0 mSecs
                  7/26/12 12:00 PM Web ADI Cache Sweeper TRACE BneCache.cacheSweeper: sweep done in 5 mSecs
                  7/26/12 12:00 PM Web ADI Cache Sweeper TRACE Cache Summary
                  Cache Region: Default Cache , Size: 0 , hitRatio: 0 /0 , puts: 0 , removes: 0 , cleared: 0 , swept: 0 , hashCode: 0
                  Cache Region: Generic SQL Statements , Size: 0 , hitRatio: 0 /0 , puts: 0 , removes: 0 , cleared: 0 , swept: 0 , hashCode: 0
                  Cache Region: Web ADI Repository Objects , Size: 36 , hitRatio: 289 /310 , puts: 36 , removes: 0 , cleared: 0 , swept: 0 , hashCode: -144528918
                  Cache Region: Web ADI Parameter Lists , Size: 12 , hitRatio: 15 /27 , puts: 12 , removes: 0 , cleared: 0 , swept: 0 , hashCode: 376128196
                  Cache Region: Web ADI Parameter Definitions , Size: 28 , hitRatio: 69 /97 , puts: 28 , removes: 0 , cleared: 0 , swept: 0 , hashCode: -1860472108
                  • 6. Re: Error trying to check whether the job will be importing
                    Hussein Sawwan-Oracle
                    I do not see any errors in those entries. Can you rename the log file, reproduce the issue and check the contents of the log file then?

                    Can you find any errors in the database log file?

                    What is the value of (BNE_TRANSACTION_MANAGEMENT/Web ADI upload transaction management) profile option? Is this issue happening to all users or specific ones only?

                    Thanks,
                    Hussein
                    • 7. Re: Error trying to check whether the job will be importing
                      bharat-oracle
                      Hi Hussein,

                      The value for Web ADI upload transaction management is N, this issue is for all the users, I tried to change the log file and I still get the same log info, for the database log do I need to check the alert.log? if yes then I have the below log message at that time

                      ALTER SYSTEM ARCHIVE LOG
                      Incremental checkpoint up to RBA [0x72.9487b.0], current log tail at RBA [0x72.94bb8.0]


                      Thanks,
                      Bharat
                      • 8. Re: Error trying to check whether the job will be importing
                        Hussein Sawwan-Oracle
                        I do not see any errors in the log file. If none of the docs referenced above help then please log a SR.

                        Thanks,
                        Hussein