Who's Online
1 registered (Chris Abraham), 2 Guests and 7 Spiders online.
Key: Admin, Global Mod, Mod
Recent Posts
P11d's
by Chris Abraham
0 seconds ago
Oracle eBsuiness HRMS Trusted Recon Query Help
by CT
Today at 02:24 PM
Concurrent Request - running slow
by CT
Today at 12:48 PM
Pension Auto Enrolment
by delboy
Today at 12:13 PM
Oracle eBsuiness HRMS Trusted Reconcilaition Help
by Mani
Today at 07:35 AM
Element to recover value in balance on leaving
by jkavia
Yesterday at 11:04 AM
Assignment EIT not displaying in Self Service
by CT
Yesterday at 06:45 AM
Vehicle Mileage Setup
by Chris Abraham
21/05/12 12:24 PM
In which table is external learning data stored
by DMC
21/05/12 08:45 AM
Oracle Payroll and Cash Management
by Gus
20/05/12 11:27 AM
Top Posters (30 Days)
CT 40
delboy 39
Vigneswar Battu 15
pat.woodall 10
Mani 6
Gus 4
bcooper 4
Ryan 3
Jan 3
DMC 3
(Views)Popular Topics
Family Pack K issues thread 20170
CREATE_GRADE api returns:PLS-00306: wrong number o 15200
Still trying to locate... 13855
Creating hr jobs ORA-20001: HR_289477_JOB_GROUP_ID 11907
Viewing Output of another user 10324
HR_PF.K RUP4 10298
Review of my Release 12 laptop 9747
Enhanced Retro & Release 12 9402
Adding a taskflow button to a form 9140
Family Pack K 7910
Topic Options
Rate This Topic
#6355 - 07/02/11 07:56 AM Web ADI, API error on Mass upload
Corbon262 Offline
regular

Registered: 14/10/09
Posts: 21
Loc: South Yorkshire
Got a strange problem when doing mass upload in Web ADI

I've created a Web ADI template to call the PER_QUALIFICATIONS_API.create_qualification API. It works fine until try and create thousands of records. It then returns the attached error in the dialog box. I've not seen errors in dialog box before and no error's show on spreadsheet. I've run the same records through in batches of 100 and all upload fine. Need to upload 50000 records

Any one seen this problem before?


Attachments
qualifications error.doc (43 downloads)


Top
#6357 - 08/02/11 11:46 AM Re: Web ADI, API error on Mass upload [Re: Corbon262]
bcooper Offline

Guru
*****

Registered: 11/03/05
Posts: 1112
Loc: Earth, Europe, England, here
I have seen "odd" errors occur before for other API's that worked when run in smaller batches.

It could be something as simple as a buffer cache issue, in that the size of the data file being processed is too big to do in one hit.

From a sheer manageability point of view, i'd not run in a single batch of 50k records in one hit anyway. I'd always break it down into smaller chunks to process in Web ADI.

Regards

Barry
_________________________
HCM Aces is for sale! Please contact me if you are interested.
Also my random musings courtesy of Twitter

Top



Moderator:  bcooper, CT 
Forum Stats
792 Members
48 Forums
1584 Topics
7663 Posts

Max Online: 67 @ 14/04/12 05:38 PM
Today's Birthdays
No Birthdays
Recent vacancies
Top Posters
CT 1188
bcooper 1112
delboy 597
Geoff Dixon 369
SBi 356
vkumar 223
kp_rapolu 213
cbrookes 197
Gavin Harris 163
Gus 146
May
Su M Tu W Th F Sa
1 2 3 4 5
6 7 8 9 10 11 12
13 14 15 16 17 18 19
20 21 22 23 24 25 26
27 28 29 30 31