Results 1 to 4 of 4

Thread: Unable to upload 1000 rows to F0902Z1 table

  1. #1

    Question Unable to upload 1000 rows to F0902Z1 table

    I have an Excel spreadsheet with 2180 rows. My users are used to uploading 1000 rows at a time and the GridImportRowLimit is set to 1000. Importing the 1000 rows works fine in P0902Z1. But, when the user hits save, the "Work With Batch Account Balances" form used to post the data to F0902Z1 is blank. The 1000 rows are not being loaded. For some reason the user has only been able to do 200 at a time. I was able to do 237 and it stops working after that.

    We recently did a server/database upgrade for our JDE 9.1 installation. Now running on Windows Server 2012 R2 and SQL Server 2014. The configs have all been confirmed to be the same as the old installation and I'm at a loss for why this is now broken for them. Any advice on where to look?

    Thanks,
    Jim (E1 Novice)

  2. #2
    Did you guys upgrade weblogic / reinstall? There's a parameter that needs to be set to allow more data to flow through as a security precaution. Search oracle support for E1: MaxRequestParameterCount on how to change it.

  3. #3

    Thumbs Up

    TFZ, you were right on the money. Thanks so much. We upgraded WebLogic from 11 to 12 with this server/database upgrade and didn't catch that new parameter. Set MaxRequestParameterCount to 500,000 as recommended in a couple of other articles and everything loads perfectly now.

  4. #4
    Right on the money! Thanks. This solved my problem. We upgraded from WebLogic 11 to 12 with a fresh install and didn't know about the parameter.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
The legal restrictions and terms of use applicable to this site are available here.
Use of this site signifies your agreement to the terms of use.
JDELIST is NOT affiliated with JD Edwards® & Company, Oracle or Peoplesoft. Contents of this site are neither endorsed nor approved by JD Edwards® & Company and, or Oracle.