topic Re: Problem in User_Addr in Application Development and Automation Discussions

Problem in User_Addr

Former Member — Thu, 28 Apr 2005 11:46:08 GMT

Hi All,

The view USer_Addr when executed to see the entries is giving a Dump in one of the Qulaity servers .The dump is time_out.But the same view is working fine in Development server.The possible entries in Quality server would be not more than 5000 , so can it still pose a problem in this much entries or there could be some other problem.

plz help

Re: Problem in User_Addr

Former Member — Thu, 28 Apr 2005 11:58:45 GMT

Hi Umang,

At out place (with 12.000 users and the ADRC table with millions of addresses) it works fine, so this puzzles me a bit.

However an explanation for this could be that the field PERSNUMBER in table USR21 is not filled. This would cause the join statement to sequentially search through the joined ADRP and ADCP tables.

If this is the case, then you should build your own view (or not use this one and program the dataselection yourselve).

Regards,

Rob.

Re: Problem in User_Addr

Former Member — Thu, 28 Apr 2005 12:54:34 GMT

Hi Rob,

Thaks for the reply but field PERSNUMBER in table USR21 is correctly populated, and also the tables ADRP and ADCP.

But still the view USER_addr is not functionaing properly.

I am knocked out because of this.

any more suggestions

Re: Problem in User_Addr

Former Member — Thu, 28 Apr 2005 13:07:08 GMT

Hi Umang,

I think the problem is not in USER_ADDR Database View. In your quality server, the Tables USR21,ADRC,ADRP and ADCP may be having More amount of Data. Thats why the Time Out Exception has come. Please check your Database Tables.

Regards,

Jeyakumar

Re: Problem in User_Addr

Former Member — Thu, 28 Apr 2005 14:04:49 GMT

Hi Umang,

I think in this case that Jeyakumar is right.

Please check the following:

Is table ADCP active AND created on the database?

Is table ADRC active AND created on the database?

Is table ADRP active AND created on the database?

Please check also the indexes via transaction SE14 if the really do exist on the database. Specific you need to check the tables ADCP and ADRP.

To find out the problem, you could first use transaction SE11 (fill in the viewname and display it). Then press the contents button (or press CtrlShiftF10) and simply execute an empty screen with maximum number of hits slowly rising.

Regards,

Rob.