11-24-2007 5:31 AM
Hi Gurus,
I am trying to extract a set of data from cdhdr and cdpos into a custom table.
Basically, what I did is the transform/aggregate data from cdpos and cdhdr is stored in an internal tables and later the data is inserted into a custom table. The purpose of doing so is to enable fast retrieval of records when the user view the report.
The program works fine in Development and QAS box. Records were inserted. But in Production, no record was inserted.
Any idea on why this happen? Is is due to the size of the records fetched into internal table? Something to do with buffers and memory?
11-24-2007 5:33 AM
In Production, put the break point and try to debug the program. You will understand what is going wrong.
Regards,
Naimesh Patel
11-24-2007 5:37 AM
Whenever I did so, the timeout error occur.
But I know that in Dev, the records were inserted into internal table.
11-24-2007 5:42 AM
Oh.. it is because of the lots of the data and you are trying to manipulate and insert the data in Z table.
So, try to schedule the job in the Background.
Like: Run the report .. on the selection screen press F9 to execute the program in background. This will schedule a job in SM37. The TIME_OUT problem doesn't occur in the background job.
Regards,
Naimesh Patel
11-24-2007 5:47 AM
You know...this is even stranger because I did exactly that - background job and it showed successful upon completion but...no data is inserted.
11-24-2007 5:49 AM
Oh... than it is really a wired.
What you can do it restrict the selection which can provide you only small amount of the data. So, you can run the program online and try to debug it.
Regards,
Naimesh Patel
11-24-2007 5:59 AM
Hello,
what kind of program is "Inserting/modifying" the custom Z table ? a standard program ? specific program ? in a user exit ?
Is the DB update of the the custom Z table made using "IN UPDATE TASK" ?
Cordialement.